Summary

资产附属设备DTO

Remark

资产卡片的子表，存储资产个各个附属设备信息

Columns

	Column Name	Description	Datatype	Length	Allow Nulls
	pubuserdefnvc1 (T+12.1)	字符公用自定义项1	nvarchar	500	True
	priuserdefnvc1 (T+12.1)	字符专用自定义项1	nvarchar	500	True
	pubuserdefnvc5 (T+12.1)	字符公用自定义项5	nvarchar	500	True
	ts (T+12.1)	分布时间戳	timestamp	8	False
	pubuserdefnvc4 (T+12.1)	字符公用自定义项4	nvarchar	500	True
	pubuserdefnvc3 (T+12.1)	字符公用自定义项3	nvarchar	500	True
	priuserdefnvc6 (T+12.1)	字符专用自定义项6	nvarchar	500	True
	priuserdefdecm2 (T+12.1)	数值专用自定义项2	decimal	13	True
	spec (T+12.1)	规格	nvarchar	50	True
	pubuserdefnvc2 (T+12.1)	字符公用自定义项2	nvarchar	500	True
	pubuserdefdecm6 (T+12.1)	数值公用自定义项6	decimal	13	True
	priuserdefnvc3 (T+12.1)	字符专用自定义项3	nvarchar	500	True
	priuserdefdecm5 (T+12.1)	数值自定义项5	decimal	13	True
	priuserdefnvc2 (T+12.1)	字符专用自定义项2	nvarchar	500	True
	priuserdefdecm6 (T+12.1)	数值专用自定义项6	decimal	13	True
	name (T+12.1)	名称	nvarchar	200	True
	pubuserdefnvc6 (T+12.1)	字符公用自定义项6	nvarchar	500	True
	pubuserdefdecm5 (T+12.1)	数值公用自定义项5	decimal	13	True
	memo (T+12.1)	备注	nvarchar	50	True
	pubuserdefdecm2 (T+12.1)	数值公用自定义项2	decimal	13	True
	qty (T+12.1)	数量	decimal	13	True
	priuserdefdecm4 (T+12.1)	数值自定义项4	decimal	13	True
	amount (T+12.1)	金额	decimal	13	True
	priuserdefnvc4 (T+12.1)	字符专用自定义项4	nvarchar	500	True
	code (T+12.1)	编号	nvarchar	30	True
	priuserdefdecm1 (T+12.1)	数值专用自定义项1	decimal	13	True
	priuserdefnvc5 (T+12.1)	字符专用自定义项5	nvarchar	500	True
	priuserdefdecm3 (T+12.1)	数值自定义项3	decimal	13	True
	idUnit (T+12.1)	idunit	int	4	True
	idAssetDTO (T+12.1)	idassetDTO	int	4	True
	pubuserdefdecm3 (T+12.1)	数值公用自定义项3	decimal	13	True
	pubuserdefdecm4 (T+12.1)	数值公用自定义项4	decimal	13	True
	pubuserdefdecm1 (T+12.1)	数值公用自定义项1	decimal	13	True
	id (T+12.1)	主键	int	4	False

---

Send feedback

Copyright 2019 Chanjet Inc.