| smpid |
int(11)
|
|
|
|
| smpdate |
date
|
|
|
|
| smpfabcode |
varchar(20)
|
latin1_swedish_ci
|
|
|
| smpiomno |
varchar(20)
|
latin1_swedish_ci
|
|
|
| smpcustomer |
varchar(50)
|
latin1_swedish_ci
|
|
|
| smpconstruction |
varchar(50)
|
latin1_swedish_ci
|
|
|
| smpcomposition |
varchar(100)
|
latin1_swedish_ci
|
|
|
| smpfabrictype |
varchar(50)
|
latin1_swedish_ci
|
|
|
| smpweave |
varchar(20)
|
latin1_swedish_ci
|
|
|
| smpgsm |
varchar(20)
|
latin1_swedish_ci
|
|
|
| smpoz |
varchar(20)
|
latin1_swedish_ci
|
|
|
| smpcolor |
varchar(50)
|
latin1_swedish_ci
|
|
|
| smpprocess |
varchar(100)
|
latin1_swedish_ci
|
|
|
| smpfinish |
varchar(20)
|
latin1_swedish_ci
|
|
|
| smprcvqty |
decimal(12,2)
|
|
|
|
| smpdlvqty |
decimal(12,2)
|
|
|
|
| smpbalqty |
decimal(12,2)
|
|
|
|
| smpsalfno |
varchar(20)
|
latin1_swedish_ci
|
|
|
| smpday |
varchar(20)
|
latin1_swedish_ci
|
|
|
| smpremarks |
varchar(255)
|
latin1_swedish_ci
|
|
|
| smprebook |
varchar(255)
|
latin1_swedish_ci
|
|
|
| smpactivity |
enum('A', 'H', 'C')
|
latin1_swedish_ci
|
|
|
