Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ciid | int8 | 19 | √ | null |
|
|
|||||
| cireference | varchar | 30 | √ | null |
|
|
|||||
| mgid | int8 | 19 | √ | null |
|
|
|||||
| citype | varchar | 10 | √ | null |
|
|
|||||
| ciinvoicetype | varchar | 10 | √ | null |
|
|
|||||
| cistatus | varchar | 10 | √ | null |
|
|
|||||
| cidocdate | date | 13 | √ | null |
|
|
|||||
| tpreference | varchar | 30 | √ | null |
|
|
|||||
| clientname | varchar | 100 | √ | null |
|
|
|||||
| cidocreference | varchar | 30 | √ | null |
|
|
|||||
| ctreference | varchar | 30 | √ | null |
|
|
|||||
| cigrosstotal | float8 | 17,17 | √ | null |
|
|
|||||
| cidueamount | float8 | 17,17 | √ | null |
|
|
|||||
| ciidcreditnote | int8 | 19 | √ | null |
|
|
|||||
| currcode | varchar | 10 | √ | null |
|
|
|||||
| printid | int8 | 19 | √ | null |
|
|
|||||
| printidemail | int8 | 19 | √ | null |
|
|