Table InvDetailsOp
Purpose
Used in scanner and XML processing
Field definitions in table InvDetailsOp
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | INVOICE | VARCHAR(50) | Y | ||
| 2 | ARTCODE | VARCHAR(50) | Y | ||
| 3 | QTYIN | DOUBLE | N | ||
| 4 | QTY | DOUBLE | N | ||
| 5 | N | AMBALAJ | VARCHAR(20) | N | No longer used |
| 6 | LOCATION | VARCHAR(50) | N | ||
| 7 | COMENTS | VARCHAR(50) | N | ||
| 8 | N | COLOR | VARCHAR(50) | N | No longer used. |
| 9 | SUPPLIER | VARCHAR(50) | N | ||
| 10 | STOCKCODE | VARCHAR(50) | Y | ||
| 11 | PCNAME | VARCHAR(50) | N | ||
| 12 | FILLDATE | TIMESTAMP | N | ||
| 13 | COLNO | VARCHAR(20) | N | ||
| 14 | COLNO1 | VARCHAR(20) | N | ||
| 15 | INVOICEGROUP | VARCHAR(50) | N | ||
| 16 | ExpiryDate | TIMESTAMP | N | ||
| 17 | LotNo | VARCHAR(50) | N | ||
| 18 | ID | NUMERIC(0,10) | N |