vpurchaseordersearch

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
poid int8 19 √ null
purchaseorder.poid Implied Constraint R
poreference varchar 30 √ null
potype varchar 10 √ null
podate varchar 500 √ null
poexpecteddeliverydate date 13 √ null
postatus varchar 10 √ null
ponetamount float8 17,17 √ null
potaxamount float8 17,17 √ null
pogrossamount float8 17,17 √ null
podescription varchar 500 √ null
poexternalref varchar 50 √ 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
refsupplier varchar 30 √ null
assetid int8 19 √ null
finasset.assetid Implied Constraint R
assetlabel varchar 2147483647 √ null
assetreference varchar 30 √ null
assetnetamount float8 17,17 √ null
currcode varchar 10 √ null
parcurrency.currcode Implied Constraint R
mgid int8 19 √ null
mgcompany.mgid Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views