qbfdecn.cbk-cballoc

Cash book allocations

Table details

Order	Field Name	x	Label	Datatype	Format	Initial
70	acct-cde	X	Account Code	character	x(4)
75	acct-type	X	Account Type	character	x(2)
80	alloc-amt	X	Alloc Amount	decimal-2	>>>,>>>,>>9.99-	0
46	alloc-ind	X	Alloc Ind	logical	Yes/No	NO
30	alloc-ln	X	Alloc Line	integer	999	0
20	alloc-no	X	Alloc No	character	x(12)
10	alloc-type	X	Alloc Type	character	x(2)
50	area-cde	X	Area Code	character	x(3)
118	claim-ind	X	Claim Ind	logical	Yes/No	NO
160	commit-ind	X	Commit Ind	logical	Yes/No	No
60	cost-cde	X	Cost Code	character	x(4)
90	disc-amt	X	Discount Amount	decimal-2	>>>,>>>,>>9.99-	0
45	dt-cr-no	X	Dt/Cr No	character	xxxxxx-xx-x
115	inv-ref-no	X	Invoice Ref No	character	x(15)	0
150	post-ind	X	Post Ind	logical	Yes/No	no
110	tax-amt	X	Tax Amount	decimal-2	>,>>>,>>9.99-	0
95	tax-cat	X	Tax Category	character	X(2)
100	tax-cde	X	Tax Code	character	x(2)	0
105	tax-rate	X	Tax Rate	decimal-2	>9.99	0
120	trn-date	X	Transaction date	date	99/99/9999	?
40	trn-type	X	Trans Type	character	x(3)

Order	Field Name	x	Label	Datatype	Format	Initial
10	alloc-type	X	Alloc Type	character	x(2)
20	alloc-no	X	Alloc No	character	x(12)
30	alloc-ln	X	Alloc Line	integer	999	0
40	trn-type	X	Trans Type	character	x(3)
45	dt-cr-no	X	Dt/Cr No	character	xxxxxx-xx-x
46	alloc-ind	X	Alloc Ind	logical	Yes/No	NO
50	area-cde	X	Area Code	character	x(3)
60	cost-cde	X	Cost Code	character	x(4)
70	acct-cde	X	Account Code	character	x(4)
75	acct-type	X	Account Type	character	x(2)
80	alloc-amt	X	Alloc Amount	decimal-2	>>>,>>>,>>9.99-	0
90	disc-amt	X	Discount Amount	decimal-2	>>>,>>>,>>9.99-	0
95	tax-cat	X	Tax Category	character	X(2)
100	tax-cde	X	Tax Code	character	x(2)	0
105	tax-rate	X	Tax Rate	decimal-2	>9.99	0
110	tax-amt	X	Tax Amount	decimal-2	>,>>>,>>9.99-	0
115	inv-ref-no	X	Invoice Ref No	character	x(15)	0
118	claim-ind	X	Claim Ind	logical	Yes/No	NO
120	trn-date	X	Transaction date	date	99/99/9999	?
150	post-ind	X	Post Ind	logical	Yes/No	no
160	commit-ind	X	Commit Ind	logical	Yes/No	No

Index name	Flags	Fields	Datatype
alloc-type	P U	alloc-type (+)	character
		alloc-no (+)	character
		alloc-ln (+)	integer
acct-cde		acct-cde (+)	character
alloc-ind		alloc-ind (+)	logical
alloc-no		alloc-no (+)	character
area-cde		area-cde (+)	character
		cost-cde (+)	character
dt-cr-no		dt-cr-no (+)	character
post-ind		post-ind (+)	logical
trn-date		trn-date (+)	date
trn-type		trn-type (+)	character

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Parent tables
glr-costcent glr-mainacct icc-taxtyp sys-trntype

generated 24-6-2026 08:23