Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| NUM | VARCHAR | 30 |
|
|
|||||||
| ID | INT | 10 | 0 |
|
|
||||||
| VIEWID | VARCHAR | 14 | √ | null |
|
|
|||||
| DATESCHEDULEDFULFILLMENT | DATETIME | 26 | √ | null |
|
|
|||||
| QTYTOFULFILL | DECIMAL | 50,9 | √ | null |
|
|
|||||
| QTYFULFILLED | DECIMAL | 50,9 | √ | null |
|
|
|||||
| ORDERITEMUOMID | INT | 10 | √ | null |
|
|
|||||
| NOTE | LONGTEXT | 2147483647 | √ | null |
|
|
|||||
| PARTUOMID | INT | 10 | 0 |
|
|
||||||
| TYPEID | BIGINT | 19 | 0 |
|
|
||||||
| PARTID | INT | 10 | √ | null |
|
|
|||||
| LOCATIONGROUPID | INT | 10 | √ | null |
|
|
|||||
| ORDERSTATUSID | INT | 10 | 0 |
|
|
||||||
| ITEMSTATUSID | BIGINT | 19 | 0 |
|
|