Table PickTable
Purpose
Temp table for temporary storage of picking locations
Field definitions in table PickTable
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | PKLOCATION | VARCHAR(50) | Y | Location code |
| 2 | Y | PKStockCode | VARCHAR(50) | Y | Stock code |
| 3 | Y | PKExpiryDate | TIMESTAMP | Y | Expiry date of article |
| 4 | Y | PKLotNo | VARCHAR(50) | Y | Lot number |
| 5 | Y | PKUserName | VARCHAR(50) | Y | User creating the order (job control) |
| 5 | Y | jobID | Integer | Y | job ID (new field, to be made.) |