vassetschedule

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
psid int8 19 √ null
assetid int8 19 √ null
finasset.assetid Implied Constraint R
assetreference varchar 30 √ null
psorder int4 10 √ null
paytype varchar 10 √ null
assetstatus varchar 10 √ null
paymentdelaycode varchar 10 √ null
previsionalduedate date 13 √ null
assetorderreference varchar 30 √ null
assetorderdate date 13 √ null
assetdeliveryreference varchar 30 √ null
assetdeliverydate date 13 √ null
assetmulticomponents bool 1 √ null
paypercentage float8 17,17 √ null
payamount float8 17,17 √ null
assetlabel varchar 250 √ null
ctreference varchar 30 √ null
ctrid int8 19 √ null
clientname text 2147483647 √ null
clientreference varchar 30 √ null
tpidclient int8 19 √ null
suppliername varchar 100 √ null
refsupplier varchar 30 √ null
holdbackpercentage float8 17,17 √ null
holdbackamount float8 17,17 √ null
holdbackprevreleasedate date 13 √ null
holdbackreleasedate date 13 √ null
dueamount float8 17,17 √ null
payduedate date 13 √ null
paydate date 13 √ null
paystatus varchar 10 √ null
currcode varchar 10 √ null
parcurrency.currcode Implied Constraint R
cteid int8 19 √ null
tpidsupplier int8 19 √ null
taxcode varchar 10 √ null
partax.taxcode Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views