字段名称 | 字段说明 | 字段长度 | 字段类型 | 是否唯一 |
---|---|---|---|---|
ID | 主键 | -1 | ID | 0 |
Code | 编号 | 30 | String | 0 |
Name | 名称 | 200 | String | 0 |
IsNoModify | 不可以修改标记 | 1000 | String | 0 |
Quantity | 数量 | -1 | Decimal | 0 |
Quantity2 | 数量2 | -1 | Decimal | 0 |
UnitExchangeRate | 换算率 | -1 | Decimal | 0 |
BaseQuantity | 主计量数量 | -1 | Decimal | 0 |
Retailprice | 零售价 | -1 | Decimal | 0 |
DistributionQuantity | 配货数量 | -1 | Decimal | 0 |
DistributionQuantity2 | 配货数量2 | -1 | Decimal | 0 |
SubQuantity | 辅计量数量 | -1 | Decimal | 0 |
CompositionQuantity | 组合计量数量 | 100 | String | 0 |
OrigPrice | 原币报价 | -1 | Decimal | 0 |
Price | 本币报价 | -1 | Decimal | 0 |
BasePrice | 主计量本币报价 | -1 | Decimal | 0 |
DiscountRate | 折扣率 | -1 | Decimal | 0 |
OrigDiscountPrice | 原币单价 | -1 | Decimal | 0 |
DiscountPrice | 本币单价 | -1 | Decimal | 0 |
BaseDiscountPrice | 主计量本币单价 | -1 | Decimal | 0 |
TaxRate | 税率 | -1 | Decimal | 0 |
OrigTaxPrice | 原币含税单价 | -1 | Decimal | 0 |
TaxPrice | 本币含税单价 | -1 | Decimal | 0 |
BaseTaxPrice | 主计量本币含税单价 | -1 | Decimal | 0 |
OrigDiscountAmount | 原币金额 | -1 | Decimal | 0 |
DiscountAmount | 本币金额 | -1 | Decimal | 0 |
OrigTax | 原币税额 | -1 | Decimal | 0 |
Tax | 本币税额 | -1 | Decimal | 0 |
OrigTaxAmount | 原币含税金额 | -1 | Decimal | 0 |
TaxAmount | 本币含税金额 | -1 | Decimal | 0 |
OrigDiscount | 原币折扣额 | -1 | Decimal | 0 |
Discount | 折扣额 | -1 | Decimal | 0 |
CostPrice | 成本价 | -1 | Decimal | 0 |
CostAmount | 成本金额 | -1 | Decimal | 0 |
ReceiveVoucherCode | 入库单号 | 50 | String | 0 |
ReceiveVoucherId | 入库单ID | -1 | ID | 0 |
ReceiveVoucherDetailId | 入库单明细Id | -1 | ID | 0 |
SaleOrderId | 销售订单Id | -1 | ID | 0 |
SaleOrderCode | 销售订单号 | 30 | String | 0 |
SaleOrderDetailId | 销售订单明细Id | -1 | ID | 0 |
Batch | 批号 | 50 | String | 0 |
AdjustAmount | 调差金额 | -1 | Decimal | 0 |
ExpiryDate | 失效日期 | -1 | DateTime | 0 |
DeliveryDate | 交货日期 | -1 | DateTime | 0 |
IsPresent | 是否赠品 | -1 | Bool | 0 |
BoxNumber | 箱号 | 50 | String | 0 |
SourceVoucherId | 来源单据ID | -1 | ID | 0 |
SourceVoucherDetailId | 来源单据明细ID | -1 | ID | 0 |
CounteractQuntity | 冲抵销货数量 | -1 | Decimal | 0 |
CounteractQuntity2 | 冲抵销货数量2 | -1 | Decimal | 0 |
ReturnQuntity | 退货数量 | -1 | Decimal | 0 |
ReturnQuntity2 | 退货数量2 | -1 | Decimal | 0 |
SaleOutQuantity2 | 出库数量2 | -1 | Decimal | 0 |
PartnerInventoryName | 客户存货名称 | 200 | String | 0 |
idsaleDeliveryDTO | idsaleDeliveryDTO | 0 | ID | 0 |
SaleOutQuantity | 出库数量 | -1 | Decimal | 0 |
idwarehouse | idwarehouse | 0 | ID | 0 |
InvoiceQuantity2 | 开票数量2 | -1 | Decimal | 0 |
InvoiceQuantity | 开票数量 | -1 | Decimal | 0 |
SettleAmount | 累计收款金额 | -1 | Decimal | 0 |
idinventory | idinventory | 0 | ID | 0 |
OrigSettleAmount | 累计收款金额原币 | -1 | Decimal | 0 |
IsCancel | 结算状态 | -1 | Enum | 0 |
OrigExpenseAmount | 费用分摊金额原币 | -1 | Decimal | 0 |
ExpenseAmount | 费用分摊金额本币 | -1 | Decimal | 0 |
IsSaleOut | 出库状态 | -1 | Enum | 0 |
idunit2 | idunit2 | 0 | ID | 0 |
InventoryLocation | 货位 | 50 | String | 0 |
SourceVoucherCode | 来源单据号 | 50 | String | 0 |
idbaseUnit | idbaseUnit | 0 | ID | 0 |
TaxFlag | 含税标记 | -1 | Bool | 0 |
IsManualCost | 是否手工确定成本 | -1 | Bool | 0 |
idunit | idunit | 0 | ID | 0 |
LastModifiedField | 最后一次被修改的单价金额 | 50 | String | 0 |
idsubUnit | idsubUnit | 0 | ID | 0 |
SourceVoucherTs | 来源单据头时间戳 | 1000 | String | 0 |
SourceVoucherDetailTs | 来源单据明细时间戳 | 1000 | String | 0 |
InventoryBarCode | 条形码 | 200 | String | 0 |
PartnerInventoryCode | 客户存货编码 | 50 | String | 0 |
AvailableQuantity | 可用量 | -1 | Decimal | 0 |
ExistingQuantity | 现存量 | -1 | Decimal | 0 |
CreatedTime | CreatedTime | -1 | DateTime | 0 |
SequenceNumber | 顺序号 | -1 | Int | 0 |
Ts | 分布时间戳 | -1 | TimeStamp | 0 |
Updated | 更新时间 | 32 | DateTime | 0 |
UpdatedBy | 更新者 | 32 | String | 0 |
idsourceVoucherType | idsourceVoucherType | 0 | ID | 0 |
SaleDelivery | SaleDelivery | 0 | DTO | 0 |
Warehouse | Warehouse | 0 | DTO | 0 |
Inventory | Inventory | 0 | DTO | 0 |
SaleDeliverySourceRelations | SaleDeliverySourceRelations | 0 | DTOCollection | 0 |
Unit2 | Unit2 | 0 | DTO | 0 |
BaseUnit | BaseUnit | 0 | DTO | 0 |
freeItem0 | 自由项1 | 100 | Enum | 0 |
Unit | Unit | 0 | DTO | 0 |
freeItem1 | 自由项2 | 100 | Enum | 0 |
freeItem2 | 自由项3 | 100 | Enum | 0 |
SubUnit | SubUnit | 0 | DTO | 0 |
freeItem3 | 自由项4 | 100 | Enum | 0 |
InventoryLocations | InventoryLocations | 0 | DTOCollection | 0 |
SourceVoucherType | SourceVoucherType | 0 | DTO | 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 |
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 |
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 |
SaleDeliveryTraceDetails | SaleDeliveryTraceDetails | 0 | DTOCollection | 0 |
idproject | idproject | 0 | ID | 0 |
Project | Project | 0 | DTO | 0 |
DocId | 期末成本结转时的凭证ID | 0 | ID | 0 |
VirtualBaseQuantity | 虚拟结转数量 | -1 | Decimal | 0 |
VirtualBaseAmount | 虚拟结转金额 | -1 | Decimal | 0 |
BackSentAmount | 回冲发出商品金额 | -1 | Decimal | 0 |
BackSentQuantity | 回冲发出商品数量 | -1 | Decimal | 0 |
SentBaseAmountAssociated | 关联销售出库单发出商品金额汇总 | -1 | Decimal | 0 |
SentBaseQuantityAssociated | 关联销售出库单发出商品数量汇总 | -1 | Decimal | 0 |
AssociatedDocIDs | 关联销售出库单的凭证 | 400 | String | 0 |