| Name | Description | Type | Additional information |
|---|---|---|---|
| billnum |
单号 char(20) |
string |
Required Max length: 20 |
| depotid |
仓库ID char(4) |
string |
Required Max length: 4 |
| happentdate |
送修日期 char(8) |
string |
Max length: 8 |
| happenttime |
送修时间 char(6) |
string |
Max length: 6 |
| userloginname |
送修用户/完成维修用户 char(20) |
string |
Required Max length: 20 |
| company |
维修单位 varchar(100) |
string |
Max length: 100 |
| equipmentid |
装备ID |
integer |
Required |
| equipmentuniqueid |
装备唯一ID varchar(10) |
string |
Max length: 10 |
| equipmentuniquecode |
装备唯一码 varchar(20) |
string |
Max length: 20 |
| equipmentname |
装备名称 varchar(50) |
string |
Max length: 50 |
| equipmenttype |
装备类型 char(1) |
string |
Required Max length: 1 |
| categorycode |
装备类别 char(6) |
string |
Required |
| categoryname |
装备类别名称 varchar(50) |
string |
Max length: 50 |
| unit |
单位 varchar(10) |
string |
Max length: 10 |
| managementmode |
管理方式 char(1) |
string |
Required Max length: 1 |
| barcodes |
条码 varchar(20) |
string |
Max length: 20 |
| specs |
规格 varchar(50) |
string |
Max length: 50 |
| producingareas |
产地 varchar(50) |
string |
Max length: 50 |
| qualitystandards |
质量标准 varchar(200) |
string |
Max length: 200 |
| amount |
数量 int |
integer |
Required |