tbl_invoice

131268 rows


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
tbl_currency.currency tbl_invoice_tl_currency_fkeyR
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
tbl_cost_centre.cost_centre tbl_invoice_cost_centre_fkeyR
folio int8 19 null
tbl_invoice_currency_translation.folio tbl_invoice_currency_translation_folio_fkeyC
line_position int8 19 null
tbl_invoice_currency_translation.line_position tbl_invoice_currency_translation_folio_fkeyC
legacy_cambridge bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
tbl_invoice_pkey Primary key Asc/Asc folio + line_position
idx_invoice_invoice_code Performance Asc invoice_code

Relationships

Close relationships within degrees of separation