vpaymentlist

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
payid int8 19 √ null
payment.payid Implied Constraint R
payreference varchar 30 √ null
paydirection varchar 10 √ null
paytype varchar 10 √ null
paymode varchar 10 √ null
paystatus varchar 10 √ null
tpid int8 19 √ null
tpreference varchar 30 √ null
tpname text 2147483647 √ null
paydocreference varchar 100 √ null
paydocdate date 13 √ null
payamount float8 17,17 √ null
payremainingamount float8 17,17 √ null
payrejected bool 1 √ null
paynbrepresentation int8 19 √ null
ciid int8 19 √ null
clientinvoice.ciid Implied Constraint R
siid int8 19 √ null
ctreference text 2147483647 √ null
sireference text 2147483647 √ null
cireference text 2147483647 √ null
cisduedate date 13 √ null
paynetamount float8 17,17 √ null
currcode varchar 10 √ null
parcurrency.currcode Implied Constraint R
tpiban varchar 50 √ null
bkcode varchar 10 √ null
parbank.bkcode Implied Constraint R
bkbranchcode varchar 10 √ null
bkaccountkey varchar 10 √ null
bkaccountnum varchar 50 √ null
tpbankname varchar 100 √ null
tpbkid int8 19 √ null
tpbankaccount.tpbkid Implied Constraint R
mgid int8 19 √ null
mgcompany.mgid Implied Constraint R
payrejectreason varchar 10 √ null
paydate date 13 √ null
payduedate date 13 √ null
paymgbankaccount int8 19 √ null
pfdid int8 19 √ null
payfiledetail.pfdid Implied Constraint R
pfid int8 19 √ null
payfile.pfid Implied Constraint R
jobid int8 19 √ null
jobexecution.jobid Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views