Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
invoice_code | varchar | 20 | √ | null |
|
|
||||
dated | date | 13 | √ | null |
|
|
||||
net_amount | numeric | 20,4 | √ | 0 |
|
|
||||
tl_currency | int4 | 10 | √ | 1 |
|
|
||||
details | varchar | 100 | √ | null |
|
|
||||
trans_number | varchar | 50 | √ | null |
|
|
||||
alternate_reference | varchar | 50 | √ | null |
|
|
||||
account_reference | varchar | 50 | √ | null |
|
|
||||
account_name | varchar | 100 | √ | null |
|
|
||||
reference | varchar | 50 | √ | null |
|
|
||||
nominal_account | varchar | 50 | √ | null |
|
|
||||
vat_code | varchar | 50 | √ | null |
|
|
||||
comment | text | 2147483647 | √ | null |
|
|
||||
cost_centre | varchar | 100 | √ | null |
|
|
||||
folio | int8 | 19 | √ | null |
|
|
||||
line_position | int8 | 19 | √ | null |
|
|
||||
legacy_cambridge | bool | 1 | √ | false |
|
|
||||
doc_type | int2 | 5 | √ | null |
|
|