Table InventoryDet
Purpose
Details of inventory.
Field definitions in table InventoryDet
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | IDNO | NUMERIC(0,18) | N | Reference to inventory |
| 2 | Y | ARTCODE | VARCHAR(50) | N | Article code |
| 3 | Y | LOCATION | VARCHAR(50) | N | Location code |
| 4 | Y | STOCKCODE | VARCHAR(50) | N | Stock code |
| 5 | Y | QTY | DOUBLE | N | Quantity |
| 6 | CRDATE | TIMESTAMP | N | ||
| 7 | CRTIME | VARCHAR(50) | N | ||
| 8 | Y | MYOPERATOR | VARCHAR(50) | N | User that created the record |
| 9 | Y | COMMENTS | VARCHAR(50) | N | Comments. |
| 10 | TransactionType | VARCHAR(50) | N | ||
| 11 | Y | SUPPLIER | VARCHAR(50) | N | Supplier |
| 12 | Y | ID | NUMERIC(0,18) | N | Unique record ID |