| Name | Description | Type | Additional information |
|---|---|---|---|
| ProductId |
商品ID int NOT NULL. |
integer |
Required |
| ProductName |
商品名 Varchar(40) NOT NULL. |
string |
Required Max length: 40 |
| BarCode |
条码 Varchar(20) |
string |
Max length: 20 |
| BaseUnit |
基本单位 Varchar(8) NOT NULL. |
string |
Required Max length: 8 |
| ProductClassCode |
商品类别 Varchar(6) NOT NULL. |
string |
Required Max length: 6 |
| NormalRetailPrice |
一般零售价 Numeric(8,2) NN |
decimal number |
Required |
| NormalLowestRetailPrice |
一般零售底价 Numeric(8,2)NN |
decimal number |
Required |
| NormalPurchaePrice |
一般采购价 Numeric(8,2) NN |
decimal number |
Required |
| SellType |
商品销售特性 char(1) NN |
string |
Required Max length: 1 |
| ProductStatus |
状态 char(1) NN |
string |
Required Max length: 1 |
| Standard |
规格 Varchar(30) |
string |
Max length: 30 |
| ProducingArea |
产地 Varchar(20) |
string |
Max length: 20 |
| QualityLevel |
质量标准 Varchar(30) |
string |
Max length: 30 |
| Reserve1 |
保留一 Varchar(50) |
string |
Max length: 50 |
| Reserve2 |
保留二 Varchar(50) |
string |
Max length: 50 |
| LastUpdUser |
最后更新用户 Varchar(20) |
integer |
Required |