Table ScanIn
Purpose
Field definitions in table ScanIn
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | INVOICE | VARCHAR(50) | Y | ||
| 2 | ARTCODE | VARCHAR(50) | N | ||
| 3 | LOCATION | VARCHAR(50) | N | ||
| 4 | STOCKCODE | VARCHAR(50) | N | ||
| 5 | COLNO | VARCHAR(50) | N | ||
| 6 | QTY | INT | N | ||
| 7 | CREATIONDATE | TIMESTAMP | N | ||
| 8 | CREATIONTIME | VARCHAR(20) | N | ||
| 9 | MYOPERATOR | VARCHAR(50) | N | ||
| 10 | MOVEOPERATOR | VARCHAR(50) | N | ||
| 11 | MOVEDATE | TIMESTAMP | N | ||
| 12 | MOVETIME | VARCHAR(20) | N | ||
| 13 | LotNo | VARCHAR(50) | N | ||
| 14 | ExpiryDate | TIMESTAMP | N | ||
| 15 | ID | NUMERIC(0,10) | N |