vinvoicingpopulationvarious

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
assetdescription varchar 250 √ null
assetid int8 19 √ null
finasset.assetid Implied Constraint R
assetorderreference text 2147483647 √ null
ctdescription varchar 255 √ null
ctreference varchar 30 √ null
ctrid int8 19 √ null
prcode varchar 10 √ null
parproduct.prcode Implied Constraint R
tpidclient int8 19 √ null
cteid int4 10 √ null
ctecategory varchar 10 √ null
ctetype varchar 10 √ null
ctedescription text 2147483647 √ null
ctsamortizedamount float8 17,17 √ null
ctsduedate text 2147483647 √ null
ctsid int8 19 √ null
ctsinterestamount float8 17,17 √ null
ctsorder int4 10 √ null
ctsrentalamount float8 17,17 √ null
ctsstatus varchar 10 √ null
ctstype varchar 10 √ null
taxcode varchar 10 √ null
partax.taxcode Implied Constraint R
tpmainadrcity varchar 50 √ null
tpmainadrregion varchar 100 √ null
tpmainadrstreet1 varchar 250 √ null
tpmainadrstreet2 varchar 250 √ null
tpmainadrzipcode varchar 10 √ null
tpname varchar 100 √ null
tpsurname varchar 100 √ null
currcode varchar 10 √ null
parcurrency.currcode Implied Constraint R
ctpaymentmode varchar 2147483647 √ null
mgid int8 19 √ null
mgcompany.mgid Implied Constraint R
ctestatus varchar 10 √ null
ctstatus varchar 10 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views