tbl_sales

30505 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
invoice_code varchar 20 √ null
dated date 13 √ null
exchequer_invoice varchar 50 √ null
details varchar 50 √ null
net_cost numeric 20,4 √ 0
account varchar 50 √ null
tl_currency int4 10 √ 1
tbl_currency.currency tbl_sales_tl_currency_fkeyR
total_amount numeric 20,4 √ null
tax numeric 20,4 √ null
gross numeric 20,4 √ null
varchar 50 √ null
cost_centre varchar 100 √ null
tbl_cost_centre.cost_centre tbl_sales_cost_centre_fkeyR
folio int8 19 null
tbl_sales_currency_translation.folio tbl_sales_currency_translation_folio_fkeyC
line_position int8 19 null
tbl_sales_currency_translation.line_position tbl_sales_currency_translation_folio_fkeyC
legacy_cambridge bool 1 √ false

Indexes

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

Relationships

Close relationships within degrees of separation