Table Istorie_InvDetails
Purpose
Field definitions in table Istorie_InvDetails
| 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(100) | 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 | TransactionType | VARCHAR(50) | N | ||
| 19 | TransferStockCodeID | VARCHAR(25) | N | ||
| 20 | CustomsCode | VARCHAR(50) | N | ||
| 21 | DateTimeID | VARCHAR(50) | N | ||
| 22 | RSystemDate | TIMESTAMP | N | ||
| 23 | SugestedLocationRet | VARCHAR(50) | N | ||
| 24 | ReturnType | VARCHAR(50) | N | ||
| 25 | ID | INT | N | ||
| 26 | RecordClosed | VARCHAR(1) | N | ||
| 27 | CalcExpiryDate | TIMESTAMP | N | ||
| 28 | CalcExpiryYear | VARCHAR(10) | N | ||
| 29 | CalcExpiryDays | VARCHAR(10) | N | ||
| 30 | OriginalImpRow | VARCHAR(200) | N | ||
| 31 | ReturnReason | VARCHAR(50) | N | ||
| 32 | ReturnReasonID | VARCHAR(50) | N | ||
| 33 | ReturnOriginalOrderNumber | VARCHAR(50) | N |