| ppid |
int(11)
|
|
|
|
| ppdate |
date
|
|
|
|
| piid |
int(11)
|
|
|
|
| buyid |
int(11)
|
|
|
|
| emarid |
int(11)
|
|
|
|
| gwid |
int(11)
|
|
|
|
| lsid |
int(11)
|
|
|
|
| testsid |
int(11)
|
|
|
|
| enduseid |
int(11)
|
|
|
|
| finsid |
int(11)
|
|
|
|
| ppdelvdate |
date
|
|
|
|
| wrapshrinkage |
decimal(6,2)
|
|
|
|
| weftshrinkage |
decimal(6,2)
|
|
|
|
| packing |
varchar(30)
|
latin1_swedish_ci
|
|
|
| ppsample |
int(11)
|
|
|
|
| poqty |
decimal(8,2)
|
|
|
|
| stid |
int(11)
|
|
|
|
| mmid |
int(11)
|
|
|
|
| mmdate |
date
|
|
|
|
| srmmid |
int(11)
|
|
|
|
| srmmdate |
date
|
|
|
|
| gmid |
int(11)
|
|
|
|
| gmdate |
date
|
|
|
|
| pprevno |
int(11)
|
|
|
|
| seclsid |
int(11)
|
|
|
|
| poinst |
text
|
latin1_swedish_ci
|
|
|
| porivdate |
date
|
|
|
|
| ppid_no |
varchar(25)
|
latin1_swedish_ci
|
|
|
| srkwid |
int(11)
|
|
|
|
| dyedlvdate |
date
|
|
|
|
| dyecomment |
varchar(255)
|
latin1_swedish_ci
|
|
|
| dyeuserid |
int(11)
|
|
|
|
| dyeappdate |
date
|
|
|
|
| graydlvdate |
date
|
|
|
|
| graycomment |
varchar(255)
|
latin1_swedish_ci
|
|
|
| grayuserid |
int(11)
|
|
|
|
| grayappdate |
date
|
|
|
|
| awgsm |
decimal(6,2)
|
|
|
|
| lcsts |
enum('Y', 'N')
|
latin1_swedish_ci
|
|
|
| lcappid |
int(11)
|
|
|
|
| lcappdate |
date
|
|
|
|
| unitid |
int(3)
|
|
|
|
| ownerid |
varchar(40)
|
latin1_swedish_ci
|
|
|
| acholder |
int(11)
|
|
|
 Browse foreign values
|
| rubbing_dry |
varchar(25)
|
latin1_swedish_ci
|
|
|
| rubbing_wet |
varchar(25)
|
latin1_swedish_ci
|
|
|
