Table ReturDetGR
Purpose
Link to orginal invoices (Guthy Renker)
Field definitions in table ReturDetGR
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | RetNo | VARCHAR(50) | N | ID of retur record. |
| 2 | Y | ARTCODE | VARCHAR(50) | N | Article code |
| 3 | Y | QTY | INT | N | Quantity returned. |
| 4 | Y | STOCKCODE | VARCHAR(50) | N | Stock code |
| 5 | Y | CCODE | VARCHAR(50) | N | 25 (Duty free) or 99 (duty cleared, default) |
| 6 | Y | LOCATION | VARCHAR(50) | N | Location pointer |
| 7 | Y | CREATIONDATE | TIMESTAMP | N | Date record was created. |
| 8 | Y | PCNAME | VARCHAR(50) | N | User that created the record. |
| 9 | Y | ReturnDate | TIMESTAMP | N | Return date |
| 10 | Y | OriginalInvoiceNumber | VARCHAR(50) | N | GR original invoice. |
| 11 | Y | OriginalFileID | NUMERIC(0,18) | N | GR original file ID. |
| 12 | Y | Prepaid | VARCHAR(50) | N | Boolean prepaid or not |
| 13 | Y | ReturnReason | VARCHAR(50) | N | Returnreason from returnreason table |
| 14 | Y | SpecialInstructions | VARCHAR(200) | N | Special instructions entered by user |
| 15 | Y | RetSource | VARCHAR(50) | N | Invoice source (1 or 2: this or last year) |
| 16 | Y | ExportedDate | VARCHAR(50) | N | Date when written to GR return |
| 17 | Y | Transfered | VARCHAR(50) | N | Has line been transferred to stock |
| 18 | Y | TenantOrg | VARCHAR(50) | N | From guthy renker tenant. |
| 19 | Y | ItemStatus | VARCHAR(50) | N | Item status (D,Y or empty) |
| 20 | Y | ID | NUMERIC(0,18) | N | Unique numerical ID |