vassetlistsearch

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
assetid int8 19 √ null
finasset.assetid Implied Constraint R
assetreference varchar 30 √ null
assettype varchar 10 √ null
assetcategory varchar 10 √ null
assetstatus varchar 10 √ null
assetnetamount float8 17,17 √ null
assettaxamount float8 17,17 √ null
assetgrossamount float8 17,17 √ null
assetorderreference varchar 30 √ null
assetorderdate date 13 √ null
assetdeliveryreference varchar 30 √ null
assetdeliverydate date 13 √ null
assetmulticomponents bool 1 √ null
assetdescription varchar 500 √ null
assetlabel varchar 250 √ null
ctreference varchar 30 √ null
propreference varchar 30 √ null
ctrid int8 19 √ null
tpidsupplier int8 19 √ null
clientname varchar 100 √ null
clientreference varchar 30 √ null
tpidclient int8 19 √ null
suppliername varchar 100 √ null
supplierreference varchar 30 √ null
assetfamily varchar 10 √ null
currcode varchar 10 √ null
parcurrency.currcode Implied Constraint R
mgid int8 19 √ null
mgcompany.mgid Implied Constraint R
kwhpower float8 17,17 √ null
kwhproduction float8 17,17 √ null
kwhdegradation float8 17,17 √ null
assetconstructor varchar 100 √ null
deliveryadrstreet1 varchar 100 √ null
deliveryadrstreet2 varchar 100 √ null
deliveryadrcity varchar 100 √ null
deliveryadrregion varchar 100 √ null
deliveryadrcountry varchar 10 √ null
catalogid int8 19 √ null
parassetcatalog.catalogid Implied Constraint R
assetmodel varchar 100 √ null
taxcode varchar 10 √ null
partax.taxcode Implied Constraint R
taxrate float8 17,17 √ null
deliveryadrzipcode varchar 15 √ null
finassetamountin float8 17,17 √ null
flagholdback bool 1 √ null
holdbackpercentage float8 17,17 √ null
holdbackamount float8 17,17 √ null
holdbackbeleasenbdays int4 10 √ null
holdbackbeleasedate date 13 √ null
assetsegment varchar 10 √ null
assetqty int4 10 √ null
tpidmanufacturer int8 19 √ null
manufacturername varchar 100 √ null
manufacturerreference varchar 10 √ null
assetstatusdate timestamp 29,6 √ null
assetvariant varchar 50 √ null
tpidbroker int8 19 √ null
age int4 10 √ null
balersize varchar 10 √ null
capacity float8 17,17 √ null
chassisno varchar 100 √ null
country varchar 10 √ null
engineno varchar 100 √ null
flagused bool 1 √ null
lift float8 17,17 √ null
nbcampaign int4 10 √ null
plateno varchar 100 √ null
power varchar 10 √ null
registrationno varchar 100 √ null
firstregistrationdate date 13 √ null
registrationcity varchar 50 √ null
registrationdate date 13 √ null
registrationname varchar 100 √ null
rotorhours int4 10 √ null
separatortype varchar 10 √ null
serialno varchar 100 √ null
tankcapacity float8 17,17 √ null
threshinghours int4 10 √ null
totalbalers int4 10 √ null
totalhours int4 10 √ null
transmission varchar 10 √ null
weight varchar 10 √ null
wheeldrive varchar 10 √ null
wheeltrack varchar 10 √ null
fiscalpower varchar 10 √ null
assetpictureurl varchar 100 √ null
assetclass varchar 10 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views