vguarantylistsearch

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
guarid int8 19 √ null
guaranty.guarid Implied Constraint R
guarreference varchar 30 √ null
guardescription varchar 500 √ null
guarstatus varchar 10 √ null
guartype varchar 10 √ null
guarexternalref varchar 50 √ null
guarsignaturedate date 13 √ null
guaramount float8 17,17 √ null
guarremainamount float8 17,17 √ null
ctreference varchar 30 √ null
propreference varchar 30 √ null
ctrid int8 19 √ null
tpidguarantor int8 19 √ null
tpidbeneficiary int8 19 √ null
beneficiaryname varchar 100 √ null
beneficiaryreference varchar 30 √ null
guarantorname varchar 100 √ null
guarantorreference varchar 30 √ null
currcode varchar 10 √ null
parcurrency.currcode Implied Constraint R
guarcode varchar 10 √ null
parguaranty.guarcode Implied Constraint R
id int8 19 √ null
mgid int8 19 √ null
mgcompany.mgid Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views