ST_AssemDetachVoucher 数据库表名:组装拆卸单DTO

字段名称 字段说明 字段长度 字段类型 是否唯一
ID 主键 -1 ID 0
Code 编号 30 String 0
Name 名称 200 String 0
Expense 费用金额 -1 Decimal 0
Memo 备注 200 String 0
VoucherState 单据状态 -1 Enum 0
Level 展开级次 12 String 0
VoucherDate VoucherDate -1 DateTime 0
Maker Maker 50 String 0
MadeDate MadeDate -1 DateTime 0
Auditor Auditor 50 String 0
MakerId MakerId -1 ID 0
AuditorId AuditorId -1 ID 0
Reviser reviser 50 String 0
AuditedDate auditedDate -1 DateTime 0
IsCarriedForwardOut 是否已结转 -1 Bool 0
IsCarriedForwardIn 是否结转来的单据 -1 Bool 0
IsModifiedCode 是否手工修改过单据号 -1 Bool 0
DocNo docNo 36 String 0
DocClass docClass 36 String 0
AccountingPeriod accountingPeriod -1 Int 0
DocId docId 36 String 0
AccountingYear accountingYear -1 Int 0
CreatedTime CreatedTime -1 DateTime 0
SequenceNumber 顺序号 -1 Int 0
Ts 分布时间戳 -1 TimeStamp 0
Updated 更新时间 32 DateTime 0
UpdatedBy 更新者 32 String 0
idclerk idclerk 0 ID 0
Clerk Clerk 0 DTO 0
iddepartment iddepartment 0 ID 0
Department Department 0 DTO 0
AssemDetachDetails AssemDetachDetails 0 DTOCollection 0
idreceiveStyle idreceiveStyle 0 ID 0
ReceiveStyle ReceiveStyle 0 DTO 0
iddispatchStyle iddispatchStyle 0 ID 0
DispatchStyle DispatchStyle 0 DTO 0
idbom idbom 0 ID 0
Bom Bom 0 DTO 0
idbusiType idbusiType 0 ID 0
BusiType BusiType 0 DTO 0
idvoucherType idvoucherType 0 ID 0
VoucherType VoucherType 0 DTO 0
idinventory idinventory 0 ID 0
Inventory Inventory 0 DTO 0
priuserdefnvc1 字符专用自定义项1 60 String 0
priuserdefdecm1 数值专用自定义项1 100 Decimal 0
priuserdefnvc2 字符专用自定义项2 60 String 0
priuserdefdecm2 数值专用自定义项2 100 Decimal 0
priuserdefnvc3 字符专用自定义项3 60 String 0
priuserdefdecm3 数值专用自定义项3 100 Decimal 0
priuserdefnvc4 字符专用自定义项4 60 String 0
priuserdefdecm4 数值专用自定义项4 100 Decimal 0
priuserdefnvc5 字符专用自定义项5 60 String 0
priuserdefdecm5 数值专用自定义项5 100 Decimal 0
priuserdefnvc6 字符专用自定义项6 60 String 0
priuserdefdecm6 数值专用自定义项6 100 Decimal 0
pubuserdefnvc1 字符公用自定义项1 60 String 0
idproject idproject 0 ID 0
pubuserdefdecm1 数值公用自定义项1 100 Decimal 0
pubuserdefnvc2 字符公用自定义项2 60 String 0
pubuserdefdecm2 数值公用自定义项2 100 Decimal 0
pubuserdefnvc3 字符公用自定义项3 60 String 0
pubuserdefdecm3 数值公用自定义项3 100 Decimal 0
pubuserdefnvc4 字符公用自定义项4 60 String 0
pubuserdefdecm4 数值公用自定义项4 100 Decimal 0
pubuserdefnvc5 字符公用自定义项5 60 String 0
pubuserdefdecm5 数值公用自定义项5 100 Decimal 0
pubuserdefnvc6 字符公用自定义项6 60 String 0
pubuserdefdecm6 数值公用自定义项6 100 Decimal 0
DiffAmount 差异金额 -1 Decimal 0
DocId2 DocId2 36 String 0
DocNo2 DocNo2 36 String 0
DocClass2 DocClass2 36 String 0
AccountingYear2 AccountingYear2 -1 Int 0
AccountingPeriod2 AccountingPeriod2 -1 Int 0
Project Project 0 DTO 0
SaleOrderId 销售订单ID -1 ID 0
SaleOrderCode 销售订单号 30 String 0
idmarketingOrgan idmarketingOrgan -1 ID 0
MarketingOrgan MarketingOrgan 0 DTO 0