| gdid |
int(11)
|
|
|
|
| gdjob |
varchar(60)
|
latin1_swedish_ci
|
|
|
| buyid |
int(11)
|
|
|
|
| buycontract |
varchar(50)
|
latin1_swedish_ci
|
|
|
| fabid |
int(11)
|
|
|
|
| gdprocess |
int(10)
|
|
|
|
| totalqty |
decimal(14,2)
|
|
|
|
| gddate |
date
|
|
|
|
| gdreqdate |
date
|
|
|
|
| gwidth |
decimal(6,2)
|
|
|
|
| fwidth |
decimal(6,2)
|
|
|
|
| cutwidth |
decimal(6,2)
|
|
|
|
| ggsm |
int(4)
|
|
|
|
| fgsm |
int(4)
|
|
|
|
| wrapyquality |
varchar(20)
|
latin1_swedish_ci
|
|
|
| weftyquality |
varchar(20)
|
latin1_swedish_ci
|
|
|
| warpcountprice |
decimal(6,2)
|
|
|
|
| weftcountprice |
decimal(6,2)
|
|
|
|
| market |
varchar(20)
|
latin1_swedish_ci
|
|
|
| gdinspsystem |
varchar(20)
|
latin1_swedish_ci
|
|
|
| gdnumbcolor |
int(11)
|
|
|
|
| spinst |
text
|
latin1_swedish_ci
|
|
|
| stid |
int(11)
|
|
|
|
| mmid |
int(11)
|
|
|
|
| mmdate |
date
|
|
|
|
| srmmid |
int(11)
|
|
|
|
| srmmdate |
date
|
|
|
|
| gmid |
int(11)
|
|
|
|
| gmdate |
date
|
|
|
|
| gdrevno |
int(11)
|
|
|
|
| enduseid |
int(11)
|
|
|
|
| addqty |
decimal(14,2)
|
|
|
|
| refno |
varchar(50)
|
latin1_swedish_ci
|
|
|
| refdate |
date
|
|
|
|
| pappid |
int(11)
|
|
|
|
| pappdate |
timestamp
|
|
|
|
| spappid |
int(11)
|
|
|
|
| spappdate |
date
|
|
|
|
| ttenwarp |
varchar(25)
|
latin1_swedish_ci
|
|
|
| ttenweft |
varchar(25)
|
latin1_swedish_ci
|
|
|
| yarncolorno |
int(4)
|
|
|
|
| costappid |
int(11)
|
|
|
|
| costappdate |
date
|
|
|
|
| iomref |
varchar(100)
|
latin1_swedish_ci
|
|
|
| unitid |
int(3)
|
|
|
|
| pisellprice |
varchar(100)
|
latin1_swedish_ci
|
|
|
| gdsid |
int(8)
|
|
|
|
| ownerid |
varchar(40)
|
latin1_swedish_ci
|
|
|
| acholder |
int(11)
|
|
|
 浏览不相关的值
|
| weft_yarnid |
int(11)
|
|
|
浏览不相关的值
|
| warp_yarnid |
int(11)
|
|
|
浏览不相关的值
|
| epi |
decimal(13,2)
|
|
|
|
| gepi |
decimal(13,2)
|
|
|
|
| ppi |
decimal(13,2)
|
|
|
|
| gdproceed_by |
int(11)
|
|
|
浏览不相关的值
|
| gd_proceed_date |
date
|
|
|
|
| ctnper |
decimal(13,2)
|
|
|
|
| subid |
int(11)
|
|
|
|
| sub_buyid |
int(11)
|
|
|
浏览不相关的值
|
| sub_brid |
int(11)
|
|
|
浏览不相关的值
|
| fab_cost |
decimal(13,2)
|
|
|
|
| emarid |
int(11)
|
|
|
|
| elongation |
varchar(25)
|
latin1_swedish_ci
|
|
|
| growth |
varchar(25)
|
latin1_swedish_ci
|
|
|
| recovery |
varchar(25)
|
latin1_swedish_ci
|
|
|
| tensile_warp |
varchar(25)
|
latin1_swedish_ci
|
|
|
| tensile_weft |
varchar(25)
|
latin1_swedish_ci
|
|
|
