Table Inventory
Purpose
Inventory checking table.
Field definitions in table Inventory
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | ID | NUMERIC(0,18) | N | Unique ID for inventory |
| 2 | Y | InventoryType | VARCHAR(1) | N | One of F or L or N, default N |
| 3 | Y | IRow1 | VARCHAR(50) | N | Start row |
| 4 | Y | IRow2 | VARCHAR(50) | N | End row |
| 5 | Y | IPlace1 | VARCHAR(50) | N | Start place |
| 6 | Y | IPlace2 | VARCHAR(50) | N | End place |
| 7 | Y | ILevel1 | VARCHAR(50) | N | Start level |
| 8 | Y | ILevel2 | VARCHAR(50) | N | End level |
| 9 | Y | MyOperator | VARCHAR(50) | N | User that created the record |
| 10 | Y | CreationDate | TIMESTAMP | N | Creation time ofrexord |