vclientinvoiceschedulelist

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ciid int8 19 √ null
clientinvoice.ciid Implied Constraint R
cireference varchar 30 √ null
mgid int8 19 √ null
mgcompany.mgid Implied Constraint R
citype varchar 10 √ null
cistatus varchar 10 √ null
cidocdate date 13 √ null
tpreference varchar 30 √ null
clientname varchar 100 √ null
cidocreference varchar 30 √ null
ctreference varchar 30 √ null
cigrosstotal float8 17,17 √ null
cidueamount float8 17,17 √ null
ciidcreditnote int8 19 √ null
currcode varchar 10 √ null
parcurrency.currcode Implied Constraint R
cisid int8 19 √ null
clientinvoiceschedule.cisid Implied Constraint R
tpidpayer int8 19 √ null
cisstatus varchar 10 √ null
cisamount float8 17,17 √ null
cisdueamount float8 17,17 √ null
cisduedate date 13 √ null
cispaymentmode varchar 10 √ null
cistype varchar 10 √ null
cisorder int4 10 √ null
tpidclient int8 19 √ null
tpbkid int8 19 √ null
tpbankaccount.tpbkid Implied Constraint R
tppayerbankaccount varchar 300 √ null
mgbankaccount int8 19 √ null
ctrid int8 19 √ null
cirejecteddate date 13 √ null
cipaymentmode varchar 10 √ null
cipaymentdate date 13 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views