vassetcomponentlist

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
compid int8 19 √ null
assetid int8 19 √ null
finasset.assetid Implied Constraint R
assetreference varchar 30 √ null
comptype varchar 10 √ null
compcategory varchar 10 √ null
assetstatus varchar 10 √ null
compnetamount float8 17,17 √ null
comptaxamount float8 17,17 √ null
compgrossamount float8 17,17 √ null
assetorderreference varchar 30 √ null
assetorderdate date 13 √ null
assetdeliveryreference varchar 30 √ null
assetdeliverydate date 13 √ null
assetmulticomponents bool 1 √ null
compdescription varchar 250 √ null
assetlabel varchar 250 √ null
ctreference varchar 30 √ null
ctrid int8 19 √ null
tpidsupplier int8 19 √ null
clientname text 2147483647 √ null
clientreference varchar 30 √ null
tpidclient int8 19 √ null
suppliername varchar 100 √ null
refsupplier varchar 30 √ null
taxcode varchar 10 √ null
partax.taxcode Implied Constraint R
flagholdback bool 1 √ null
holdbackpercentage float8 17,17 √ null
holdbackamount float8 17,17 √ null
holdbackbeleasenbdays int4 10 √ null
holdbackbeleasedate date 13 √ null
currcode varchar 10 √ null
parcurrency.currcode Implied Constraint R
comporiginalnetamount float8 17,17 √ null
compdiscountrate float8 17,17 √ null
compdiscountamount float8 17,17 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views