SA_SaleOrder 数据库表名:销售订单DTO

字段名称 字段说明 字段长度 字段类型 是否唯一
ID 主键 -1 ID 0
Code 编号 30 String 0
Name 名称 200 String 0
DeliveryDate 交货日期 -1 DateTime 0
DiscountRate 整单折扣率 -1 Decimal 0
DiscountAmount 整单折扣本币金额 -1 Decimal 0
OrigDiscountAmount 整单折扣原币金额 -1 Decimal 0
ExchangeRate 汇率 -1 Decimal 0
DeliveryMode 运输方式 -1 Enum 0
Address 送货地址 200 String 0
LinkMan 联系人 50 String 0
ReciveType 收款方式 -1 Enum 0
ContractCode 合同号 30 String 0
OrigEarnestMoney 订金原币金额 -1 Decimal 0
EarnestMoney 订金本币金额 -1 Decimal 0
VoucherState 状态 -1 Enum 0
Memo 备注 200 String 0
OrigAmount 原币金额 -1 Decimal 0
Amount 本币金额 -1 Decimal 0
OrigTaxAmount 原币含税金额 -1 Decimal 0
TaxAmount 本币含税金额 -1 Decimal 0
ContactPhone 联系电话 100 String 0
IsSaleOut 出库状态 -1 Enum 0
IsCancel 核销状态 -1 Enum 0
IsSaleDelivery 销货状态 -1 Enum 0
VoucherDate VoucherDate -1 DateTime 0
IsAutoGenerateSaleOrderBOM 自动生成订单BOM -1 Bool 0
IsAutoGenerateRouting 自动生成工艺路线 -1 Bool 0
Maker Maker 50 String 0
MadeDate MadeDate -1 DateTime 0
SourceVoucherId 来源单ID -1 ID 0
SourceVoucherCode 来源单Code 50 String 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
idclerk idclerk 0 ID 0
IsCarriedForwardIn 是否结转来的单据 -1 Bool 0
IsModifiedCode 是否手工修改过单据号 -1 Bool 0
DocNo docNo 36 String 0
idcurrency idcurrency 0 ID 0
DocClass docClass 36 String 0
AccountingPeriod accountingPeriod -1 Int 0
idcustomer idcustomer 0 ID 0
DocId docId 36 String 0
iddepartment iddepartment 0 ID 0
AccountingYear accountingYear -1 Int 0
CreatedTime CreatedTime -1 DateTime 0
SequenceNumber 顺序号 -1 Int 0
Ts 分布时间戳 -1 TimeStamp 0
idbusinessType idbusinessType 0 ID 0
Updated 更新时间 32 DateTime 0
UpdatedBy 更新者 32 String 0
Clerk Clerk 0 DTO 0
Currency Currency 0 DTO 0
Customer Customer 0 DTO 0
Department Department 0 DTO 0
Subscriptions Subscriptions 0 DTOCollection 0
BusinessType BusinessType 0 DTO 0
idwarehouse idwarehouse 0 ID 0
SaleOrderDetails SaleOrderDetails 0 DTOCollection 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
idsourceVoucherType idsourceVoucherType 0 ID 0
idmarketingOrgan idmarketingOrgan 0 ID 0
SourceVoucherType SourceVoucherType 0 DTO 0
priuserdefnvc4 字符专用自定义项4 60 String 0
priuserdefdecm4 数值专用自定义项4 100 Decimal 0
idproject idproject 0 ID 0
Project Project 0 DTO 0
priuserdefnvc5 字符专用自定义项5 60 String 0
priuserdefdecm5 数值专用自定义项5 100 Decimal 0
idsettleCustomer idsettleCustomer 0 ID 0
SettleCustomer SettleCustomer 0 DTO 0
priuserdefnvc6 字符专用自定义项6 60 String 0
priuserdefdecm6 数值专用自定义项6 100 Decimal 0
IsNoModify 不可以修改标记 1000 String 0
pubuserdefnvc1 字符公用自定义项1 60 String 0
Warehouse Warehouse 0 DTO 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
MarketingOrgan MarketingOrgan 0 DTO 0
pubuserdefnvc6 字符公用自定义项6 60 String 0
pubuserdefdecm6 数值公用自定义项6 100 Decimal 0
ChangeDate ChangeDate -1 DateTime 0
Changer Changer 50 String 0
DataSource DataSource -1 Enum 0