ST_CheckVoucher 数据库表名:盘点单DTO

字段名称 字段说明 字段长度 字段类型 是否唯一
ID 主键 -1 ID 0
Code 编号 30 String 0
Name 名称 200 String 0
VoucherState 单据状态 -1 Enum 0
Memo 备注 200 String 0
IsLocked 是否锁盘 -1 Bool 0
VoucherDate VoucherDate -1 DateTime 0
VoucherDateInStock VoucherDateInStock -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
TotalBalanceAmount 盘亏金额 -1 Decimal 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
idreceiveStyle idreceiveStyle 0 ID 0
ReceiveStyle ReceiveStyle 0 DTO 0
iddispatchStyle iddispatchStyle 0 ID 0
DispatchStyle DispatchStyle 0 DTO 0
idwarehouse idwarehouse 0 ID 0
Warehouse Warehouse 0 DTO 0
idclerk idclerk 0 ID 0
Clerk Clerk 0 DTO 0
iddepartment iddepartment 0 ID 0
Department Department 0 DTO 0
CheckDetails CheckDetails 0 DTOCollection 0
idinvLocation idinvLocation 0 ID 0
InvLocation InvLocation 0 DTO 0
idvoucherType idvoucherType 0 ID 0
VoucherType VoucherType 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
pubuserdefdecm1 数值公用自定义项1 100 Decimal 0
pubuserdefnvc2 字符公用自定义项2 60 String 0
pubuserdefdecm2 数值公用自定义项2 100 Decimal 0
idproject idproject 0 ID 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
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
idmarketingOrgan idmarketingOrgan -1 ID 0
Project 项目 0 DTO 0
MarketingOrgan MarketingOrgan 0 DTO 0