| Name | Description | Type | Additional information |
|---|---|---|---|
| BillNum |
单据单号 BillNum Char(20) FK |
string |
Required |
| SellBillNum |
售货单号 SellBillNum Char(20) FK |
string |
Required |
| AutoId |
AutoId AutoId Bigint PK,AUTO INC |
integer |
None. |
| MerchantId |
商户ID MerchantId Int NN |
integer |
Required |
| ShopId |
门店ID ShopId Char(4) NN |
string |
Required |
| ProductId |
商品ID ProductId Int NN |
integer |
Required |
| BarCode |
商品条码 BarCode Varchar(20) |
string |
None. |
| SellType |
商品销售特性 SellType Char(1) NN |
string |
Required |
| ProductName |
商品名 ProductName Varchar(40) NN |
string |
Required |
| Standard |
规格 Standard Varchar(30) |
string |
None. |
| ProducingArea |
产地 ProducingArea Varchar(20) |
string |
None. |
| QualityLevel |
质量标准 QualityLevel Varchar(30) |
string |
None. |
| Unit |
单位 Unit Varchar(8) NN |
string |
Required |
| Amount |
数量 Amount Numeric(10,4) NN |
decimal number |
Required |
| ListingPrice |
挂牌价 ListingPrice Numeric(8,2) NN |
decimal number |
Required |
| RetailPrice |
售价 RetailPrice Numeric(8,2) NN |
decimal number |
Required |
| LowestRetailPrice |
底价 LowestRetailPrice Numeric(18,2) NN |
decimal number |
Required |
| CalPrice |
结算单价 CalPrice Numeric(18,2) NN |
decimal number |
Required |