字段名称 | 字段说明 | 字段长度 | 字段类型 | 是否唯一 |
---|---|---|---|---|
ID | 主键 | -1 | ID | 0 |
Code | 编号 | 30 | String | 0 |
Name | 名称 | 200 | String | 0 |
AccountYear | 年度 | -1 | Int | 0 |
AccountPeriod | 期间 | -1 | Int | 0 |
VoucherID | 单据ID | -1 | ID | 0 |
VoucherCode | 单据编码 | 30 | String | 0 |
VoucherDetailID | 明细ID | -1 | ID | 0 |
InQuantity | 入库数量 | -1 | Decimal | 0 |
InPrice | 入库单价 | -1 | Decimal | 0 |
InAmount | 入库金额 | -1 | Decimal | 0 |
OutQuantity | 出库数量 | -1 | Decimal | 0 |
OutPrice | 出库单价 | -1 | Decimal | 0 |
OutAmount | 出库金额 | -1 | Decimal | 0 |
Batch | 批次 | 50 | String | 0 |
AccountDate | 记账日期 | -1 | DateTime | 0 |
FinanceVoucherID | 凭证ID | 36 | String | 0 |
IsPeriodInit | 是否期初 | -1 | Bool | 0 |
IsInStock | 出入库标志 | -1 | Bool | 0 |
IndividualID | 出库对应的入库明细ID | -1 | ID | 0 |
IsManual | 是否手工指定成本(用于出库) | -1 | Bool | 0 |
InSubQuantity | 入库辅数量 | -1 | Decimal | 0 |
IsTrueAccount | 记账标志 | -1 | Bool | 0 |
IsRedVoucher | 红蓝单标志 | -1 | Bool | 0 |
PreAccountPrice | 记帐前单价 | -1 | Decimal | 0 |
PreAccountAmount | 记帐前金额 | -1 | Decimal | 0 |
AssistantDataID | 出库对应的计价辅助数据 | -1 | ID | 0 |
BackVoucher | 红兰字回冲单标志 | -1 | Int | 0 |
Memo | 备注 | 200 | String | 0 |
PurchaseSettleVoucherDetailID | 核算单明细ID | -1 | ID | 0 |
OutSubQuantity | 出库辅数量 | -1 | Decimal | 0 |
OrderNo | 顺序号 | -1 | Int | 0 |
VoucherCodeFlowUnite | 流程合并时单据号 | 50 | String | 0 |
VoucherIDFlowUnite | 流程合并时单据ID | -1 | ID | 0 |
VoucherDetailIDFlowUnite | 流程合并时单据明细ID | -1 | ID | 0 |
ExpiryDate | 失效日期 | -1 | DateTime | 0 |
IsAdjustVoucher | 调整单标志 | -1 | Bool | 0 |
PurchaseSettleVoucherID | 核算单ID | -1 | ID | 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 | 50 | String | 0 |
DocClass | docClass | 50 | String | 0 |
AccountingPeriod | accountingPeriod | -1 | Int | 0 |
DocId | docId | 50 | 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 |
idwarehouse | idwarehouse | 0 | ID | 0 |
Warehouse | Warehouse | 0 | DTO | 0 |
idinventory | idinventory | 0 | ID | 0 |
Inventory | Inventory | 0 | DTO | 0 |
idbaseUnit | idbaseUnit | 0 | ID | 0 |
BaseUnit | BaseUnit | 0 | DTO | 0 |
idsubUnit | idsubUnit | 0 | ID | 0 |
SubUnit | SubUnit | 0 | DTO | 0 |
idvoucherType | idvoucherType | 0 | ID | 0 |
VoucherType | VoucherType | 0 | DTO | 0 |
idbusiType | idbusiType | 0 | ID | 0 |
BusiType | BusiType | 0 | DTO | 0 |
idrdStyle | idrdStyle | 0 | ID | 0 |
RdStyle | RdStyle | 0 | DTO | 0 |
idpartner | idpartner | 0 | ID | 0 |
Partner | Partner | 0 | DTO | 0 |
idclerk | idclerk | 0 | ID | 0 |
Clerk | Clerk | 0 | DTO | 0 |
iddepartment | iddepartment | 0 | ID | 0 |
Department | Department | 0 | DTO | 0 |
idvoucherTypeFlowUnite | idvoucherTypeFlowUnite | 0 | ID | 0 |
VoucherTypeFlowUnite | VoucherTypeFlowUnite | 0 | DTO | 0 |
idbusiTypeFlowUnite | idbusiTypeFlowUnite | 0 | ID | 0 |
BusiTypeFlowUnite | BusiTypeFlowUnite | 0 | DTO | 0 |
freeItem0 | 自由项1 | 100 | Enum | 0 |
freeItem1 | 自由项2 | 100 | Enum | 0 |
freeItem2 | 自由项3 | 100 | Enum | 0 |
freeItem3 | 自由项4 | 100 | Enum | 0 |
freeItem4 | 自由项5 | 100 | Enum | 0 |
freeItem5 | 自由项6 | 100 | Enum | 0 |
freeItem6 | 自由项7 | 100 | Enum | 0 |
freeItem7 | 自由项8 | 100 | Enum | 0 |
freeItem8 | 自由项9 | 100 | Enum | 0 |
freeItem9 | 自由项10 | 100 | Enum | 0 |
AccountYearPeriod | 年度期间 | 6 | String | 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 |
bodypubuserdefnvc1 | 表体字符公用自定义项1 | 60 | String | 0 |
pubuserdefnvc5 | 字符公用自定义项5 | 60 | String | 0 |
bodypubuserdefnvc2 | 表体字符公用自定义项2 | 60 | String | 0 |
pubuserdefdecm5 | 数值公用自定义项5 | 100 | Decimal | 0 |
bodypubuserdefnvc3 | 表体字符公用自定义项3 | 60 | String | 0 |
pubuserdefnvc6 | 字符公用自定义项6 | 60 | String | 0 |
bodypubuserdefnvc4 | 表体字符公用自定义项4 | 60 | String | 0 |
pubuserdefdecm6 | 数值公用自定义项6 | 100 | Decimal | 0 |
bodypubuserdefdecm1 | 表体数值公用自定义项1 | 100 | Decimal | 0 |
bodypubuserdefdecm2 | 表体数值公用自定义项2 | 100 | Decimal | 0 |
bodypubuserdefdecm3 | 表体数值公用自定义项3 | 100 | Decimal | 0 |
bodypubuserdefdecm4 | 表体数值公用自定义项4 | 100 | Decimal | 0 |
SaleOrderCode | 销售订单号 | 30 | String | 0 |
idproject | 项目ID | 0 | ID | 0 |
project | 项目 | 0 | DTO | 0 |