PU_PurchaseInvoice 数据库表名:采购发票DTO

字段名称 字段说明 字段长度 字段类型 是否唯一
ID 主键 -1 ID 0
Code 编号 30 String 0
Name 名称 200 String 0
VoucherState 单据状态 -1 Enum 0
InvoiceType 发票类型 -1 Enum 0
PurchaseInvoiceNo 发票号 30 String 0
DiscountRate 整单折扣率 -1 Decimal 0
ExchangeRate 汇率 -1 Decimal 0
Memo 备注 200 String 0
TotalTaxAmount 发票含税本币总金额 -1 Decimal 0
OrigTotalTaxAmount 发票含税总金额 -1 Decimal 0
TotalAmount 发票本币总金额 -1 Decimal 0
OrigTotalAmount 发票总金额 -1 Decimal 0
SaleOrderId 销售订单ID -1 ID 0
SaleOrderCode 销售订单编号 30 String 0
IsNoModify 不可以修改 1000 String 0
VoucherDate VoucherDate -1 DateTime 0
PayType 付款方式 -1 Enum 0
PayDate 付款到期日 -1 DateTime 0
Maker Maker 50 String 0
MadeDate MadeDate -1 DateTime 0
OrigPaymentAmount 使用预付 -1 Decimal 0
PaymentAmount 使用预付(本币) -1 Decimal 0
Auditor Auditor 50 String 0
MakerId MakerId -1 ID 0
IsPriceCheck 进行价格跟踪 -1 Bool 0
SettleState 结算状态 -1 Enum 0
AuditorId AuditorId -1 ID 0
Reviser reviser 50 String 0
AccountState 核算状态 -1 Enum 0
SourceVoucherCode 来源单号 50 String 0
AuditedDate auditedDate -1 DateTime 0
IsCarriedForwardOut 是否已结转 -1 Bool 0
PaymentCashAmount 现结金额(本币) -1 Decimal 0
OrigPaymentCashAmount 现结金额 -1 Decimal 0
IsCarriedForwardIn 是否结转来的单据 -1 Bool 0
IsModifiedCode 是否手工修改过单据号 -1 Bool 0
SourceVoucherDate 来源单据日期 -1 DateTime 0
DocNo docNo 36 String 0
DocClass docClass 36 String 0
AccountingPeriod accountingPeriod -1 Int 0
DocId docId 36 String 0
IsNoArapBookkeeping 是否记账往来账 -1 Bool 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
iddepartment iddepartment 0 ID 0
Department Department 0 DTO 0
idclerk idclerk 0 ID 0
Clerk Clerk 0 DTO 0
idcurrency idcurrency 0 ID 0
Currency Currency 0 DTO 0
idwarehouse idwarehouse 0 ID 0
Warehouse Warehouse 0 DTO 0
idpartner idpartner 0 ID 0
Partner Partner 0 DTO 0
PurchaseInvoiceDetails PurchaseInvoiceDetails 0 DTOCollection 0
idsourceVoucherType idsourceVoucherType 0 ID 0
SourceVoucherType SourceVoucherType 0 DTO 0
idbusinessType idbusinessType 0 ID 0
BusinessType BusinessType 0 DTO 0
PurchaseInvoiceCollectionDTOs PurchaseInvoiceCollectionDTOs 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
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
PurchaseInvoiceMultiPayments PurchaseInvoiceMultiPayments 0 DTOCollection 0
PurchaseInvoiceMultiSettleDetails PurchaseInvoiceMultiSettleDetails 0 DTOCollection 0
idinvoicePartner idinvoicePartner 0 ID 0
InvoicePartner InvoicePartner 0 DTO 0
idproject idproject 0 ID 0
Project Project 0 DTO 0
idMarketingOrgan idMarketingOrgan 0 ID 0
MarketingOrgan MarketingOrgan 0 DTO 0