Table OutDetailsCC
Purpose
Customs out stock (similar to OutDetails)
Field definitions in table OutDetailsCC
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | AVIZNO | VARCHAR(50) | N | reference to table OUT (AVIZ) |
| 2 | Y | ARTCODE | VARCHAR(50) | N | reference to table Article (code) |
| 3 | Y | QTY | DOUBLE | N | Quantity in stock |
| 4 | Y | STOCKCODE | VARCHAR(50) | N | reference to stockcode |
| 5 | Y | OriginalSTOCKCODE | VARCHAR(50) | N | reference to stockcode |
| 6 | Y | SUPPLIER | VARCHAR(50) | N | Supplier. Reference to Suppliers |
| 7 | Y | PCNAME | VARCHAR(50) | N | User that created the record |
| 8 | Y | FILLDATE | TIMESTAMP | N | Fill date (Default now) |
| 9 | Y | COMMENTS | VARCHAR(100) | N | Comments |
| 10 | Y | TransactionType | VARCHAR(50) | N | One of the TransactionType strings. |
| 11 | Y | ID | NUMERIC(0,18) | N | Unique ID |