| piid_iom |
int(11)
|
|
|
|
| piissudate |
date
|
|
|
|
| pirevno |
varchar(50)
|
latin1_swedish_ci
|
|
|
| garid |
int(11)
|
|
|
|
| bankid |
int(11)
|
|
|
|
| fbfid |
int(11)
|
|
|
|
| totalqty |
decimal(14,2)
|
|
|
|
| unitid |
int(11)
|
|
|
|
| pivalidity |
int(11)
|
|
|
|
| pidelivery |
int(11)
|
|
|
|
| pideliverydate |
date
|
|
|
|
| fbpid |
int(11)
|
|
|
|
| cgsm |
int(11)
|
|
|
|
| commi |
decimal(6,2)
|
|
|
|
| picondition |
text
|
latin1_swedish_ci
|
|
|
| stid |
int(11)
|
|
|
|
| mmid |
int(11)
|
|
|
|
| mmdate |
date
|
|
|
|
| srmmid |
int(11)
|
|
|
|
| srmmdate |
date
|
|
|
|
| gmid |
int(11)
|
|
|
|
| gmdate |
date
|
|
|
|
| buyfabref |
varchar(100)
|
latin1_swedish_ci
|
|
|
| acholder |
int(11)
|
|
|
|
| piid_no |
varchar(25)
|
latin1_swedish_ci
|
|
|
| iopmid |
int(11)
|
|
|
|
| adid |
int(11)
|
|
|
|
| garconid |
int(11)
|
|
|
|
| hscode |
tinytext
|
latin1_swedish_ci
|
|
|
| ownerid |
varchar(40)
|
latin1_swedish_ci
|
|
|
| cost_app |
int(11)
|
|
|
|
| cost_app_date |
date
|
|
|
|
| net_wight |
decimal(10,2)
|
|
|
|
| gross_wight |
decimal(10,2)
|
|
|
|
| po_app |
int(11)
|
|
|
|
| po_app_date |
date
|
|
|
|
| dimensional_stability |
varchar(25)
|
latin1_swedish_ci
|
|
|
| warpshrinkage_pi |
varchar(15)
|
latin1_swedish_ci
|
|
|
| weftshrinkage_pi |
varchar(15)
|
latin1_swedish_ci
|
|
|
| buyid |
int(11)
|
|
|
 浏览不相关的值
|
| sub_buyid |
int(11)
|
|
|
浏览不相关的值
|
| sub_brid |
int(11)
|
|
|
浏览不相关的值
|
| sale_types |
varchar(25)
|
latin1_swedish_ci
|
|
|
| dollar_rate |
decimal(13,2)
|
|
|
|
| cutwidth |
decimal(6,2)
|
|
|
|
