qbfdecn.cbk-elecpmnt

Elect Payments


Table details

Area FinData
Dumpname elecpmnt
Label Elect Payments
Val.exp ?
Val.msg

Fields

Order Field Name x Label Datatype Format Initial Mand Description
70 acct-no-cr X Credit Acct No character x(12)
50 acct-no-dt X Account No Debit character x(10)
135 bank-acct-id X Bank Account Id integer >>9 0
130 bank-date X Bank Date date 99/99/9999 ?
140 bank-trn-no X Bank Trn No character x(8)
80 branch-no-cr X Branch No Credit character x(8)
60 branch-no-dt X Branch No Debit character x(8)
120 due-date X Due Date date 99/99/9999 ?
10 req-no X Request no character x(8)
40 trnf-amt X Transfer Amount decimal-2 >>>,>>>,>>9.99 0
90 trnf-date X Transfer Date date 99/99/9999 ?
20 trnf-no X Transfer No character x(8)
30 trnf-stat X Transfer Status character x(2)
150 upd-date X Updated date 99/99/9999 ?
160 upd-time X At integer 99999 0
170 upd-user-id X By character x(12) D: User ID.

Indexes

Index name Flags Fields Datatype
trnf-no P U trnf-no (+) character
acct-no-cr acct-no-cr (+) character
    branch-no-cr (+) character
acct-no-dt acct-no-dt (+) character
    branch-no-dt (+) character
bank-acct-id bank-acct-id (+) integer
bank-trn-no bank-trn-no (+) character
due-date due-date (+) date
req-no U req-no (+) character
trnf-date trnf-date (+) date
trnf-stat trnf-stat (+) character
+ = Ascending - = Descending P = Primary U = Unique I = Inactive W = Wordindex

Related tables

Parent tables
acs-payreq   inv-combocom   inv-comboitem  


generated 18-9-2026 10:01