erpjobupdate

erp任务更新表

• Rows (estimated): 0
• Data size: 16.0 KB
• Engine: InnoDB
• Collation: utf8mb3_general_ci
• Created: 2026-04-27 18:52:43
• Updated:

Columns

#	Name	Type	Null	Key	Default	Extra	Comment
1	iIncrement	int	NO	PRI		auto_increment	自增列
2	tCreateTime	datetime	NO	MUL			创建时间
3	tModifyTime	datetime	NO				修改时间
4	sJobId	varchar(35)	NO	UNI			任务唯一编号(P_JOB开头)
5	iStatusId	tinyint	NO		0		状态(0:未执行,1:执行成功,2:执行失败)
6	sFailException	text	YES				失败异常
7	iUpdateType	tinyint	NO				更新类型
8	sMainBillNo	varchar(100)	NO	MUL			主单据号

Indexes

Name	Unique	Type	Columns
ERP_JOB_UPDATE_IDX1		BTREE	tCreateTime
ERP_JOB_UPDATE_IDX2		BTREE	sMainBillNo, iUpdateType, iStatusId
ERP_JOB_UPDATE_UNQ1	✓	BTREE	sJobId
PRIMARY	✓	BTREE	iIncrement

Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.