qbfdecn.acr-fund

Fund

Table details

Order	Field Name	x	Label	Datatype	Format	Initial
150	cap-year	X	Capitalised Year	integer	9999	0
80	create-date	X	Create Date	date	99/99/9999	?
60	ctrl-acct-cde	X	Control Account Code	character	x(4)
40	ctrl-area-cde	X	Control Area Code	character	x(3)
50	ctrl-cost-cde	X	Control Cost Code	character	x(4)
10	fund-cde	X	Fund Code	character	x(3)
20	fund-desc	X	Fund Description	character	x(20)
70	fund-stat	X	Fund Status	character	!
30	fund-type	X	Fund Type	character	!
140	int-rate	X	Interest Rate	decimal-2	>>9.99	0
120	max-prd	X	Maximum Period	integer	>>>9	0
110	min-deposit-perc	X	Minimum Deposit Perc	decimal-2	>,>>9.99-	0
90	no-of-shares	X	No Of Shares	integer	>,>>>,>>9	0
160	payout-term	X	Payout Term	integer	999	0
130	prd-freq	X	Period Frequency	logical	Monthly/Yearly	NO
190	prof-acct-cde	X	Profit Acct Cde	character	x(4)
170	prof-area-cde	X	Profit Area Code	character	x(3)
180	prof-cost-cde	X	Profit Cost Code	character	x(4)
100	tarif	X	Tariff	decimal-2	>,>>9.99	0
200	upd-date	X	Updated	date	99/99/9999	?
210	upd-time	X	At	integer	99999	0
220	upd-user-id	X	By	character	x(12)

Order	Field Name	x	Label	Datatype	Format	Initial
10	fund-cde	X	Fund Code	character	x(3)
20	fund-desc	X	Fund Description	character	x(20)
30	fund-type	X	Fund Type	character	!
40	ctrl-area-cde	X	Control Area Code	character	x(3)
50	ctrl-cost-cde	X	Control Cost Code	character	x(4)
60	ctrl-acct-cde	X	Control Account Code	character	x(4)
70	fund-stat	X	Fund Status	character	!
80	create-date	X	Create Date	date	99/99/9999	?
90	no-of-shares	X	No Of Shares	integer	>,>>>,>>9	0
100	tarif	X	Tariff	decimal-2	>,>>9.99	0
110	min-deposit-perc	X	Minimum Deposit Perc	decimal-2	>,>>9.99-	0
120	max-prd	X	Maximum Period	integer	>>>9	0
130	prd-freq	X	Period Frequency	logical	Monthly/Yearly	NO
140	int-rate	X	Interest Rate	decimal-2	>>9.99	0
150	cap-year	X	Capitalised Year	integer	9999	0
160	payout-term	X	Payout Term	integer	999	0
170	prof-area-cde	X	Profit Area Code	character	x(3)
180	prof-cost-cde	X	Profit Cost Code	character	x(4)
190	prof-acct-cde	X	Profit Acct Cde	character	x(4)
200	upd-date	X	Updated	date	99/99/9999	?
210	upd-time	X	At	integer	99999	0
220	upd-user-id	X	By	character	x(12)

Index name	Flags	Fields	Datatype
fund-cde	P U	fund-cde (+)	character
fund-type		fund-type (+)	character

+ = Ascending

- = Descending

P = Primary

U = Unique

I = Inactive

W = Wordindex

Parent tables
inv-combocom inv-comboitem

Child tables
acr-clientfund

generated 18-9-2026 10:01