字段名称 | 字段说明 | 字段长度 | 字段类型 | 是否唯一 |
---|---|---|---|---|
ID | 主键 | -1 | ID | 0 |
Code | 编号 | 30 | String | 0 |
Name | 名称 | 200 | String | 0 |
BaseTaxPrice | 主计量本币含税单价 | -1 | Decimal | 0 |
BaseDiscountPrice | 主计量本币单价 | -1 | Decimal | 0 |
BasePrice | 主计量本币报价 | -1 | Decimal | 0 |
Batch | 批号 | 50 | String | 0 |
ExpiryDate | 失效日期 | -1 | DateTime | 0 |
Quantity | 数量 | -1 | Decimal | 0 |
Quantity2 | 数量2 | -1 | Decimal | 0 |
UnitExchangeRate | 换算率 | -1 | Decimal | 0 |
CompositionQuantity | 组合计量数量 | 100 | String | 0 |
DiscountRate | 折扣 | -1 | Decimal | 0 |
OrigPrice | 报价 | -1 | Decimal | 0 |
OrigDiscountPrice | 单价 | -1 | Decimal | 0 |
TaxRate | 税率 | -1 | Decimal | 0 |
OrigTaxAmount | 含税金额 | -1 | Decimal | 0 |
OrigDiscountAmount | 金额 | -1 | Decimal | 0 |
OrigTaxPrice | 含税单价 | -1 | Decimal | 0 |
OrigTax | 税额 | -1 | Decimal | 0 |
OrigDiscount | 折扣金额 | -1 | Decimal | 0 |
DiscountPrice | 本币单价 | -1 | Decimal | 0 |
DiscountAmount | 本币金额 | -1 | Decimal | 0 |
Tax | 本币税额 | -1 | Decimal | 0 |
TaxPrice | 本币含税单价 | -1 | Decimal | 0 |
TaxAmount | 本币含税金额 | -1 | Decimal | 0 |
Discount | 本币折扣金额 | -1 | Decimal | 0 |
SourceVoucherId | 来源单据ID | -1 | ID | 0 |
SourceVoucherDetailId | 来源单据明细ID | -1 | ID | 0 |
SaleOrderDetailId | 销售订单明细Id | -1 | ID | 0 |
SaleOrderId | 销售订单ID | -1 | ID | 0 |
SaleOrderCode | 销售订单编号 | 30 | String | 0 |
TaxFlag | 报价含税标志 | -1 | Bool | 0 |
SourceVoucherCode | 来源单号 | 50 | String | 0 |
Price | 本币报价 | -1 | Decimal | 0 |
SubQuantity | 辅计量数量 | -1 | Decimal | 0 |
BaseQuantity | 主计量数量 | -1 | Decimal | 0 |
IsNoModify | 不可以修改 | 1000 | String | 0 |
LastModifiedField | 最后修改字段 | 50 | String | 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 |
PartnerInventoryName | 供应商存货名称 | 50 | String | 0 |
ShrinkageQuantity | 损耗数量 | -1 | Decimal | 0 |
SequenceNumber | 顺序号 | -1 | Int | 0 |
Ts | 分布时间戳 | -1 | TimeStamp | 0 |
ShrinkageBaseQuantity | 损耗数量(主计量) | -1 | Decimal | 0 |
ShrinkageSubQuantity | 损耗数量(辅计量) | -1 | Decimal | 0 |
Updated | 更新时间 | 32 | DateTime | 0 |
UpdatedBy | 更新者 | 32 | String | 0 |
TotalSettleBaseQuantity | 累计核算数量(主计量) | -1 | Decimal | 0 |
TotalSettleShrinkageBaseQuantity | 累计损耗核算数量(主计量) | -1 | Decimal | 0 |
idwarehouse | idwarehouse | 0 | ID | 0 |
Warehouse | Warehouse | 0 | DTO | 0 |
OrigSettleAmount | 累计结款金额 | -1 | Decimal | 0 |
SettleAmount | 累计结款金额(本币) | -1 | Decimal | 0 |
idinventory | idinventory | 0 | ID | 0 |
Inventory | Inventory | 0 | DTO | 0 |
ShrinkageQuantity2 | 损耗数量2 | -1 | Decimal | 0 |
IsPresent | 赠品 | -1 | Bool | 0 |
idunit | idunit | 0 | ID | 0 |
Unit | Unit | 0 | DTO | 0 |
CumAccountAmount | 本币累计核算金额 | -1 | Decimal | 0 |
idunit2 | idunit2 | 0 | ID | 0 |
Unit2 | Unit2 | 0 | DTO | 0 |
idinvLocation | idinvLocation | 0 | ID | 0 |
InvLocation | InvLocation | 0 | DTO | 0 |
idpurchaseInvoiceDTO | idpurchaseInvoiceDTO | 0 | ID | 0 |
PurchaseInvoice | PurchaseInvoice | 0 | DTO | 0 |
idsourceVoucherType | idsourceVoucherType | 0 | ID | 0 |
SourceVoucherType | SourceVoucherType | 0 | DTO | 0 |
idsubUnit | idsubUnit | 0 | ID | 0 |
SubUnit | SubUnit | 0 | DTO | 0 |
idbaseUnit | idbaseUnit | 0 | ID | 0 |
BaseUnit | BaseUnit | 0 | DTO | 0 |
SourceRelationDetails | SourceRelationDetails | 0 | DTOCollection | 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 |
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 |
TraceDetails | TraceDetails | 0 | DTOCollection | 0 |
idproject | idproject | 0 | ID | 0 |
Project | Project | 0 | DTO | 0 |
purchaseOrderCode | 采购订单号 | 50 | String | 0 |
RetailPrice | 零售价 | -1 | Decimal | 0 |