Table InvDetailsCC
Purpose
Customs Cleared information for invoice details.
Field definitions in table InvDetailsCC
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | INVOICE | VARCHAR(50) | N | Invoice code |
| 2 | Y | ARTCODE | VARCHAR(50) | N | Article code |
| 3 | Y | QTY | DOUBLE | N | Quantity |
| 4 | Y | STOCKCODE | VARCHAR(50) | N | Stock code : 25 or 99 |
| 5 | Y | SUPPLIER | VARCHAR(50) | N | Name of supplier |
| 6 | Y | PCNAME | VARCHAR(50) | N | Name of active user |
| 7 | Y | FILLDATE | TIMESTAMP | N | Date when then record was made |
| 8 | Y | TransactionType | VARCHAR(50) | N | 'REC' |
| 9 | Y | COMMENTS | VARCHAR(100) | N | Comment for this line |
| 10 | Y | OriginalID | NUMERIC(0,18) | N | ID of INVDETAILS record to which this belongs. |
| 11 | N | DateTimeID | VARCHAR(50) | N | Unique stamp based on time ? |
| 12 | Y | ID | NUMERIC(0,18) | N | Unique ID |