Table Inv
Purpose
List of invoices
Field definitions in table Inv
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | INVOICE | VARCHAR(50) | Y | Unique invoice identifier (not numerical) |
| 2 | Y | DATA | TIMESTAMP | N | Date when the record is created. |
| 3 | Y | SUPPL | VARCHAR(50) | N | Supplier code |
| 4 | Y | PCNAME | VARCHAR(50) | N | User that created the record |
| 5 | Y | FILLDATE | TIMESTAMP | N | Default: Date when the record is created |
| 6 | Y | DEP | VARCHAR(50) | N | Department (RET/KIT/empty) |
| 7 | N | INVOICEGROUP | VARCHAR(50) | N | Always empty/null |
| 8 | Y | COMMENTS | VARCHAR(200) | N | Comment |
| 9 | N | RecType | VARCHAR(50) | N | Always REC |
| 10 | Y | INVOICEID | NUMERIC(0,18) | N | External invoice ID |
| 11 | Y | CFGenFileDate | TIMESTAMP | N | Confirmation file generation date |
| 12 | Y | CFGEN | VARCHAR(1) | N | Y/empty |
| 13 | Y | CFGenFile | VARCHAR(200) | N | Filename of confirmation file |
| 14 | N | ReferenceID | VARCHAR(50) | N | Always null |
| 15 | N | SupplierID | VARCHAR(50) | N | Null mostly |
| 16 | N | OriginalImpRow | VARCHAR(240) | N | Always null |