vcontractlist

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ctrid int8 19 √ null
ctreference varchar 30 √ null
mgid int8 19 √ null
mgcompany.mgid Implied Constraint R
ctdescription varchar 500 √ null
ctphase varchar 10 √ null
ctstatus varchar 10 √ null
ctstatusdate date 13 √ null
tpidclient int8 19 √ null
prcode varchar 10 √ null
parproduct.prcode Implied Constraint R
brid int8 19 √ null
mgbranch.brid Implied Constraint R
ctorderdate date 13 √ null
ctdeliverydate date 13 √ null
ctactivationdate date 13 √ null
ctfinancedamount float8 17,17 √ null
tpreference varchar 30 √ null
clientname varchar 100 √ null
ctstage varchar 10 √ null
propreference varchar 30 √ null
tpidbroker int8 19 √ null
tprefbroker text 2147483647 √ null
brokername text 2147483647 √ null
ctnetworkcode varchar 10 √ null
mcid int8 19 √ null
parmarketing.mcid Implied Constraint R
offerid int8 19 √ null
paroffer.offerid Implied Constraint R
mfid int8 19 √ null
mfreference varchar 30 √ null
currcode varchar 10 √ null
parcurrency.currcode Implied Constraint R
ctcomment varchar 500 √ null
cteduration int4 10 √ null
cteupfrontamount float8 17,17 √ null
ctervamount float8 17,17 √ null
ctefirstpayment float8 17,17 √ null
cterentalamount float8 17,17 √ null
ctepartamount float8 17,17 √ null
ctegraceperiodduration int4 10 √ null
ctedescription varchar 250 √ null
catalogid int8 19 √ null
parassetcatalog.catalogid Implied Constraint R
assetpictureurl varchar 100 √ null
tpauthid int8 19 √ null
tpauthdetailid int8 19 √ null
mfusedamount float8 17,17 √ null
mfbookedamount float8 17,17 √ null
mfavailableamount float8 17,17 √ null
mfagreedamount float8 17,17 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views