tbl_exchequer_unpaid_invoices

122 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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
view_unpaid_invoices.thOurRef Implied ConstraintR
thCustSupp varchar 2147483647 √ null
currency int2 5 √ 1

Indexes

Constraint Name Type Sort Column(s)
unpaid_invoices_uniqueness Primary key Asc thOurRef

Relationships

Close relationships within degrees of separation