vsifile_servout_finout

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
ctrid int8 19 √ null
cteid int8 19 √ null
ctsid int8 19 √ null
ciid int8 19 √ null
clientinvoice.ciid Implied Constraint R
ctetype varchar 10 √ null
ctedirection varchar 10 √ null
ctecategory varchar 10 √ null
ctedescription varchar 250 √ null
priid int8 19 √ null
parpricing.priid Implied Constraint R
prilabel text 2147483647 √ null
ctreference varchar 2147483647 √ null
tpidclient int8 19 √ null
tpidsupplier int8 19 √ null
tpname varchar 100 √ null
assetid int8 19 √ null
finasset.assetid Implied Constraint R
assetreference varchar 2147483647 √ null
assetlabel text 2147483647 √ null
ctsamortizedamount float8 17,17 √ null
ctsinterestamount float8 17,17 √ null
ctsrentalamount float8 17,17 √ null
ctsorder int4 10 √ null
ctsstartdate date 13 √ null
ctsenddate date 13 √ null
ctsduedate date 13 √ null
taxcode varchar 10 √ null
partax.taxcode Implied Constraint R
sfid int8 19 √ null
suppinvoicefile.sfid Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views