SA_SaleQuotation 数据库表名:报价单DTO

字段名称 字段说明 字段长度 字段类型 是否唯一
ID 主键 -1 ID 0
Code 编号 30 String 0
Name 名称 200 String 0
ExchangeRate 汇率 -1 Decimal 0
ExpiryDate 失效日期 -1 DateTime 0
DiscountRate 整单折扣 -1 Decimal 0
TransactionFlag 成交标志 -1 Enum 0
SourceVoucherId 来源单据ID -1 ID 0
SourceVoucherCode 来源单号 50 String 0
SourceVoucherDate 来源单据日期 -1 DateTime 0
Memo 备注 200 String 0
OrigTaxAmount 整单原币含税总金额 -1 Decimal 0
OrigAmount 整单原币总金额 -1 Decimal 0
OrigDiscountAmount 整单折扣原币总金额 -1 Decimal 0
DiscountAmount 整单折扣本币总金额 -1 Decimal 0
Amount 整单本币总金额 -1 Decimal 0
TaxAmount 整单本币含税总金额 -1 Decimal 0
VoucherState VoucherState -1 Enum 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
idproject idproject 0 ID 0
Project Project 0 DTO 0
idcustomer idcustomer 0 ID 0
Customer Customer 0 DTO 0
iddepartment iddepartment 0 ID 0
Department Department 0 DTO 0
idcurrency idcurrency 0 ID 0
Currency Currency 0 DTO 0
SaleQuotationDetails SaleQuotationDetails 0 DTOCollection 0
idsourceVoucherType idsourceVoucherType 0 ID 0
SourceVoucherType SourceVoucherType 0 DTO 0
ReciveType 收款方式 -1 Enum 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
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
idmarketingOrgan idmarketingOrgan -1 ID 0
MarketingOrgan MarketingOrgan 0 DTO 0