Table Retur
Purpose
Returns of articles.
Field definitions in table Retur
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | CREATIONDATE | TIMESTAMP | N | Date when return was entered in system. |
| 2 | Y | CREATIONTIME | VARCHAR(50) | N | Time when return was entered in system. |
| 3 | Y | PCNAME | VARCHAR(50) | N | Person that created the return |
| 4 | Y | ID | NUMERIC(0,18) | N | Unique ID. |
| 5 | N | ReturnDate | TIMESTAMP | N | Date of the return. |
| 6 | N | OriginalInvoiceNumber | VARCHAR(50) | N | |
| 7 | Y | OriginalFileID | NUMERIC(0,18) | N | File for original order import |
| 8 | Y | Prepaid | VARCHAR(50) | N | Was the order prepaid |
| 9 | N | ReturnReason | VARCHAR(50) | N | |
| 10 | N | ExportedDate | VARCHAR(50) | N | |
| 11 | N | RetSource | VARCHAR(50) | N | |
| 12 | Y | OriginalOrderNumber | VARCHAR(50) | N | Original order number (see also returdetgr) |
| 13 | Y | Supplier | VARCHAR(50) | N | Supplier code |
| 14 | Y | SupplierID | VARCHAR(50) | N | Supplier ID |
| 15 | Y | Reason | VARCHAR(50) | N | Return reason text. (normal, from ReturnReasonList) |
| 16 | Y | ReasonID | VARCHAR(50) | N | Return reason ID. (normal, from ReturnReasonList) |