vsupplierinvoiceschedulelist

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
siid int8 19 √ null
sireference varchar 30 √ null
mgid int8 19 √ null
mgcompany.mgid Implied Constraint R
sitype varchar 10 √ null
sistatus varchar 10 √ null
sidocdate date 13 √ null
tprefsupplier varchar 30 √ null
suppliername varchar 100 √ null
tprefclient varchar 30 √ null
clientname text 2147483647 √ null
sidocreference varchar 30 √ null
ctreference varchar 2147483647 √ null
orderreference varchar 30 √ null
deliveryreference varchar 30 √ null
sigrosstotal float8 17,17 √ null
sidueamount float8 17,17 √ null
siidcreditnote int8 19 √ null
currcode varchar 10 √ null
parcurrency.currcode Implied Constraint R
sisid int8 19 √ null
sisorder int4 10 √ null
sistype varchar 10 √ null
sisamount float8 17,17 √ null
sisdueamount float8 17,17 √ null
sisstatus varchar 10 √ null
sispaymentmode varchar 10 √ null
sisduedate date 13 √ null
tpidbeneficiary int8 19 √ null
tpidsupplier int8 19 √ null
tpbeneficiarybankaccount varchar 300 √ null
mgbankaccount int8 19 √ null
ctrid int8 19 √ null
tpbkid int8 19 √ null
tpbankaccount.tpbkid Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views