Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| invoice_code | varchar | 20 | √ | null |
|
|
||||
| thAcCode | varchar | 2147483647 | √ | null |
|
|
||||
| acCompany | varchar | 2147483647 | √ | null |
|
|
||||
| thYear | varchar | 2147483647 | √ | null |
|
|
||||
| thPeriod | varchar | 2147483647 | √ | null |
|
|
||||
| Date | date | 13 | √ | null |
|
|
||||
| days | int4 | 10 | √ | null |
|
|
||||
| thYourRef | varchar | 2147483647 | √ | null |
|
|
||||
| total | numeric | 20,4 | √ | null |
|
|
||||
| thAmountSettled | numeric | 20,4 | √ | null |
|
|
||||
| outstanding | numeric | 20,4 | √ | null |
|
|
||||
| cost_centre | varchar | 2147483647 | √ | null |
|
|
||||
| thJobCode | varchar | 2147483647 | √ | null |
|
|
||||
| thOurRef | varchar | 2147483647 | √ | null |
|
|
||||
| thCustSupp | varchar | 2147483647 | √ | null |
|
|
||||
| currency | int2 | 5 | √ | null |
|
|
||||
| days_due | int4 | 10 | √ | null |
|
|
||||
| manager | text | 2147483647 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
