vinvoicingpopulation

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
assetdescription text 2147483647 √ null
assetid int4 10 √ null
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 int8 19 √ null
ctecategory varchar 10 √ null
ctetype varchar 10 √ null
ctedescription varchar 250 √ 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
ctsstartdate date 13 √ null
ctsenddate date 13 √ null
cterateformula varchar 10 √ null
cteratetype varchar 10 √ null
calcstatus varchar 10 √ null
ctecalculationbasis varchar 10 √ null
cteratespread float8 17,17 √ null
ctsterm varchar 10 √ null
ctsstartamount float8 17,17 √ null
ctsoutstandingamount float8 17,17 √ null
ctsbasisamount float8 17,17 √ null
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