ST_RDRecord 数据库表名:出入库DTO

字段名称 字段说明 字段长度 字段类型 是否唯一
ID 主键 -1 ID 0
Code 编号 30 String 0
Name 名称 200 String 0
DispatchAddress 发货地址 200 String 0
TransportType 运输方式 -1 Enum 0
Contact 联系人 50 String 0
ContactPhone 联系电话 100 String 0
SourceVoucherId 来源单据ID -1 ID 0
ExchangeRate 汇率 -1 Decimal 0
ManufactureOrderCode 加工单号 50 String 0
DelegateDispatchCode 委外入库单号 50 String 0
SourceVoucherCode 来源单据号 50 String 0
SaleOrderId 销售订单ID -1 ID 0
SaleOrderCode 销售订单号 30 String 0
PurchaseArrivalId 关联进货单ID -1 ID 0
PurchaseArrivalCode 关联进货单号 50 String 0
ProductReceiveId 产成品入库单ID -1 ID 0
ProductReceiveCode 产成品入库单号 50 String 0
SaleDeliveryId 关联销货单ID -1 ID 0
SaleDeliveryCode 关联销货单号 50 String 0
VoucherState 单据状态 -1 Enum 0
SettleStatus 结算状态 -1 Enum 0
PrintTime 打印次数 -1 Int 0
Amount 总金额 -1 Decimal 0
TotalOrigTaxAmount 含税金额 -1 Decimal 0
TotalTaxAmount 本币含税金额 -1 Decimal 0
RdDirectionFlag 出入库方向 -1 Bool 0
DeliveryState 销货状态 -1 Enum 0
AccountState 核算状态 -1 Enum 0
IsCostAccount 是否参与成本核算 -1 Bool 0
IsMergedFlow 是否合并流程 -1 Bool 0
IsAutoGenerate 是否自动生成 -1 Bool 0
Memo 备注 200 String 0
IsNoModify 不可以修改标志 400 String 0
MaturityDate 收付款到期日 -1 DateTime 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
iddistrict iddistrict 0 ID 0
idclerk idclerk 0 ID 0
iddepartment iddepartment 0 ID 0
idpartner idpartner 0 ID 0
idproject idproject 0 ID 0
idsettleCustomer idsettleCustomer 0 ID 0
idbusiType idbusiType 0 ID 0
idvoucherType idvoucherType 0 ID 0
idsourceVoucherType idsourceVoucherType 0 ID 0
idwarehouse idwarehouse 0 ID 0
idrdStyle idrdStyle 0 ID 0
idqualityInspector idqualityInspector 0 ID 0
idcurrency idcurrency 0 ID 0
RDRecordDetails RDRecordDetails 0 DTOCollection 0
priuserdefnvc1 字符专用自定义项1 60 String 0
District District 0 DTO 0
Clerk Clerk 0 DTO 0
priuserdefdecm1 数值专用自定义项1 100 Decimal 0
priuserdefnvc2 字符专用自定义项2 60 String 0
Department Department 0 DTO 0
Partner Partner 0 DTO 0
priuserdefdecm2 数值专用自定义项2 100 Decimal 0
SettleCustomer SettleCustomer 0 DTO 0
Project Project 0 DTO 0
priuserdefnvc3 字符专用自定义项3 60 String 0
BusiType BusiType 0 DTO 0
VoucherType VoucherType 0 DTO 0
priuserdefdecm3 数值专用自定义项3 100 Decimal 0
priuserdefnvc4 字符专用自定义项4 60 String 0
SourceVoucherType SourceVoucherType 0 DTO 0
priuserdefdecm4 数值专用自定义项4 100 Decimal 0
Warehouse Warehouse 0 DTO 0
RdStyle RdStyle 0 DTO 0
priuserdefnvc5 字符专用自定义项5 60 String 0
priuserdefdecm5 数值专用自定义项5 100 Decimal 0
QualityInspector QualityInspector 0 DTO 0
priuserdefnvc6 字符专用自定义项6 60 String 0
Currency Currency 0 DTO 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
VoucherYear 单据日期所在的年度 -1 Int 0
VoucherPeriod 单据日期所在的期间 -1 Int 0
BeforeUpgrade 原始版本 100 String 0
IdStore IdStore -1 ID 0
IdMarketingOrgan IdMarketingOrgan -1 ID 0
SourceVoucherDate 来源单据日期 32 DateTime 0
DateOfDocGen 凭证生成时间 32 DateTime 0
Store Store 0 DTO 0
idinwarehouse 入库仓库ID -1 ID 0
MarketingOrgan MarketingOrgan 0 DTO 0
InWarehouse InWarehouse 0 DTO 0