qbfdecn.cbk-rdcheq

RD Cheques

Table details

Area	FinData
Dumpname	rdcheq
Label	RD Cheques
Val.exp	?
Val.msg

Fields

Order	Field Name	x	Label	Datatype	Format	Initial	Mand	Description
50	acct-no	X	Acct	character	xxxxxx-xx-x
40	bank-acct-no	X	Bank Account No	character	x(12)
30	bank-branch-no	X	Bank Branch No	character	x(8)
103	bank-date	X	Bank Date	date	99/99/9999	?
108	bank-trn-no	X	Bank Trn No	character	x(8)
70	chq-amt	X	Cheque Amount	decimal-2	>>>,>>>,>>9.99	0
80	chq-date	X	Cheque Date	date	99/99/9999	?
20	chq-no	X	Cheque No	integer	9999999999	0
100	chq-stat	X	Cheque Status	character	x(2)
10	rd-no	X	Return to draw No	character	x(8)
95	recpt-no	X	Receipt No	character	x(12)	0
60	recvd-name	X	Received Name	character	x(30)
90	teller-user-id	X	Teller User Id	character	x(8)
110	upd-date	X	Updated	date	99/99/9999	?
120	upd-time	X	At	integer	99999	0
130	upd-user-id	X	By	character	x(12)			D: User ID.

Indexes

Index name	Flags	Fields	Datatype
rd-no	P U	rd-no (+)	character
acct-no		acct-no (+)	character
bank-trn-no		bank-trn-no (+)	character
chq-date		chq-date (+)	date
chq-no		chq-no (+)	integer
		bank-acct-no (+)	character
		bank-branch-no (+)	character
chq-stat		chq-stat (+)	character
recpt-no		recpt-no (+)	character
recvd-name		recvd-name (+)	character
teller-user-id		teller-user-id (+)	character

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Related tables

Parent tables
acr-clntacct cbk-bnkacct cbk-receipt inv-combocom inv-comboitem

generated 24-6-2026 08:24