Table InvDetails
Purpose
List of articles on an invoice.
Field definitions in table InvDetails
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | INVOICE | VARCHAR(50) | Y | Reference to INV (INVOICE) |
| 2 | Y | ARTCODE | VARCHAR(50) | Y | Reference to ARTICLE (Code) |
| 3 | Y | QTYIN | DOUBLE | N | Requested quantity |
| 4 | Y | QTY | DOUBLE | N | Quantity of this article |
| 5 | N | AMBALAJ | VARCHAR(20) | N | No longer used |
| 6 | Y | LOCATION | VARCHAR(50) | N | Reference to LOCATION (code) |
| 7 | Y | COMENTS | VARCHAR(100) | N | Comment field |
| 8 | N | COLOR | VARCHAR(50) | N | No longer used |
| 9 | Y | SUPPLIER | VARCHAR(50) | N | Reference to SUPPLIER (code) |
| 10 | Y | STOCKCODE | VARCHAR(50) | Y | |
| 11 | Y | PCNAME | VARCHAR(50) | N | User that created the record |
| 12 | Y | FILLDATE | TIMESTAMP | N | Date of filling the parcel (default creation date) |
| 13 | Y | COLNO | VARCHAR(20) | N | Palette number for returned goods ? |
| 14 | Y | COLNO1 | VARCHAR(20) | N | Row number of CSV import line |
| 15 | N | INVOICEGROUP | VARCHAR(50) | N | Romanian forms only. |
| 16 | Y | ExpiryDate | TIMESTAMP | N | Expiry date for shipping (?) |
| 17 | Y | LotNo | VARCHAR(50) | N | Lot reference |
| 18 | Y | TransactionType | VARCHAR(50) | N | Transaction type, see enum. |
| 19 | N | TransferStockCodeID | VARCHAR(25) | N | Not used. |
| 20 | Y | CustomsCode | VARCHAR(50) | N | Return, Guthy Renker |
| 21 | Y | DateTimeID | VARCHAR(50) | N | Unique identifier using timestamp. Can be dropped ? |
| 22 | Y | RSystemDate | TIMESTAMP | N | ? |
| 23 | Y | SugestedLocationRet | VARCHAR(50) | N | Location to move to when processed as return |
| 24 | Y | ReturnType | VARCHAR(50) | N | ? (Numerical would be OK: 1,2) |
| 25 | Y | ID | INT | N | Unique ID |
| 26 | Y | RecordClosed | VARCHAR(1) | N | |
| 27 | N | CalcExpiryDate | TIMESTAMP | N | Expiry date. |
| 28 | N | CalcExpiryYear | VARCHAR(10) | N | Expiry year. Function to calculate is never used |
| 29 | N | CalcExpiryDays | VARCHAR(10) | N | Expiry month. Function to calculate is never used |
| 30 | N | OriginalImpRow | VARCHAR(200) | N | Originally used to store line from which data was imported ? |
| 31 | Y | ReturnReason | VARCHAR(50) | N | Transferred from return. |
| 32 | Y | ReturnReasonID | VARCHAR(50) | N | Transferred from return. |
| 33 | Y | ReturnOriginalOrderNumber | VARCHAR(50) | N | Transferred from return. |