Summary

物料清单

Columns

	Column Name	Description	Datatype	Length	Allow Nulls
	priuserdefdecm2 (T+12.1)	数值专用自定义项2	decimal	13	True
	ts (T+12.1)	分布时间戳	timestamp	8	True
	makerid (T+12.1)	制单人ID	int	4	True
	freeItem6 (T+12.1)	自由项7	nvarchar	300	True
	freeItem7 (T+12.1)	自由项7	nvarchar	300	True
	idunit2 (T+12.1)	idunit2	int	4	True
	customerName (T+12.1)	CustomerName	nvarchar	200	True
	producequantity2 (T+12.1)	生产数量2	decimal	13	True
	priuserdefdecm4 (T+12.1)	数值自定义项4	decimal	13	True
	customerCode (T+12.1)	CustomerCode	nvarchar	200	True
	voucherdate (T+12.1)	VoucherDate	datetime	8	True
	idunit (T+12.1)	idunit	int	4	True
	rationManHour (T+12.1)	定额工时	decimal	13	True
	iscostbom (T+12.1)	成本BOM	tinyint	1	True
	freeItem9 (T+12.1)	自由项10	nvarchar	300	True
	version (T+12.1)	Version	nvarchar	30	True
	freeItem4 (T+12.1)	自由项4	nvarchar	300	True
	pubuserdefdecm2 (T+12.1)	数值公用自定义项2	decimal	13	True
	pubuserdefdecm1 (T+12.1)	数值公用自定义项1	decimal	13	True
	produceQuantity (T+12.1)	生产数量	decimal	13	True
	bomDepth (T+12.1)	BOM层级	int	4	True
	priuserdefnvc1 (T+12.1)	字符专用自定义项1	nvarchar	500	True
	rateofexchange (T+12.1)	换算率	decimal	13	True
	maker (T+12.1)	制单人	nvarchar	50	True
	updatedBy (T+12.1)	更新者	nvarchar	32	True
	priuserdefdecm5 (T+12.1)	数值自定义项5	decimal	13	True
	id (T+12.1)	主键	int	4	False
	rationWage (T+12.1)	定额工资	decimal	13	True
	customerForShort (T+12.1)	CustomerForShort	nvarchar	200	True
	pubuserdefnvc4 (T+12.1)	字符公用自定义项4	nvarchar	500	True
	pubuserdefnvc5 (T+12.1)	字符公用自定义项5	nvarchar	500	True
	priuserdefnvc4 (T+12.1)	字符专用自定义项4	nvarchar	500	True
	code (T+12.1)	编号	nvarchar	32	True
	ReviserDate (T+12.1)	修改日期	datetime	8	True
	voucherstate (T+12.1)	单据状态	int	4	True
	priuserdefnvc3 (T+12.1)	字符专用自定义项3	nvarchar	500	True
	idinventory (T+12.1)	idInventory	int	4	True
	isDefaultBom (T+12.1)	是否默认BOM	tinyint	1	True
	freeItem5 (T+12.1)	自由项6	nvarchar	300	True
	freeItem3 (T+12.1)	自由项4	nvarchar	300	True
	rationCharge (T+12.1)	定额费用	decimal	13	True
	cost (T+12.1)	成本	decimal	13	True
	pubuserdefnvc3 (T+12.1)	字符公用自定义项3	nvarchar	500	True
	reviserid (T+12.1)	ReviserID	int	4	True
	pubuserdefdecm6 (T+12.1)	数值公用自定义项6	decimal	13	True
	createdtime (T+12.1)	CreatedTime	datetime	8	True
	auditeddate (T+12.1)	审核日期	datetime	8	True
	yieldrate (T+12.1)	成品率	decimal	13	True
	freeItem1 (T+12.1)	自由项2	nvarchar	300	True
	isorderbom (T+12.1)	是否订单BOM	tinyint	1	True
	reviser (T+12.1)	修改人	nvarchar	50	True
	PrintCount (T+13.0)	打印数量	int	4	True
	idmechiner (T+12.1)	idmechiner	int	4	True
	madeDate (T+12.1)	制单日期	datetime	8	True
	idwarehouse (T+12.1)	idwarehouse	int	4	True
	auditorid (T+12.1)	审核人ID	int	4	True
	freeItem8 (T+12.1)	自由项9	nvarchar	300	True
	disabled (T+12.1)	停用	tinyint	1	True
	priuserdefnvc6 (T+12.1)	字符专用自定义项6	nvarchar	500	True
	getbomchildunitmethod (T+12.1)	子件单价取值方式	int	4	True
	auditor (T+12.1)	Auditor	nvarchar	50	True
	rationmaterial (T+12.1)	定额材料	decimal	13	True
	idrouting (T+12.1)	idrouting	int	4	True
	priuserdefdecm1 (T+12.1)	数值专用自定义项1	decimal	13	True
	idsaleorder (T+12.1)	销售订单ID	nvarchar	50	True
	pubuserdefnvc2 (T+12.1)	字符公用自定义项2	nvarchar	500	True
	idBomRelationDTO (T+12.1)	idbomRelationDTO	int	4	True
	priuserdefnvc5 (T+12.1)	字符专用自定义项5	nvarchar	500	True
	freeItem0 (T+12.1)	自由项1	nvarchar	300	True
	produceType (T+12.1)	投产类型	int	4	True
	idmanufactureplant (T+12.1)	idmanufactureplant	int	4	True
	pubuserdefdecm3 (T+12.1)	数值公用自定义项3	decimal	13	True
	priuserdefnvc2 (T+12.1)	字符专用自定义项2	nvarchar	500	True
	priuserdefdecm6 (T+12.1)	数值专用自定义项6	decimal	13	True
	pubuserdefnvc6 (T+12.1)	字符公用自定义项6	nvarchar	500	True
	priuserdefdecm3 (T+12.1)	数值自定义项3	decimal	13	True
	rationcost (T+12.1)	定额成本	decimal	13	True
	pubuserdefdecm5 (T+12.1)	数值公用自定义项5	decimal	13	True
	pubuserdefnvc1 (T+12.1)	字符公用自定义项1	nvarchar	500	True
	pubuserdefdecm4 (T+12.1)	数值公用自定义项4	decimal	13	True
	name (T+12.1)	名称	nvarchar	200	True
	freeItem2 (T+12.1)	自由项3	nvarchar	300	True
	updated (T+12.1)	更新时间	datetime	8	True

---

Send feedback

Copyright 2019 Chanjet Inc.