Ì i 2
main
[account]
*(B)BQC[bz]
Field Name Len Dat Typ J DPM Offset/Local/VAL
account 44 URN L BAR.PAT bz
balance 10 MONEY R *(B)BQC[bz]|0
by.period 1 YN L
cd.screen 15 FREE L MIS.SCREEN VAL=@BAR.RT.GROUP.cd.screen[@group]
fiduciary.adr1 30 FREE L *(B)BQC[bz]F|1
fiduciary.adr2 30 FREE L *(B)BQC[bz]F|2
fiduciary.bus.phone 18 PHONE L *(B)BQC[bz]F|7
fiduciary.city 20 FREE L *(B)BQC[bz]F|3
fiduciary.home.phone 18 PHONE L *(B)BQC[bz]F|6
fiduciary.last.updated 9 DATE L *(B)BQC[bz]F|9
fiduciary.last.user 10 FREE L MIS.USER *(B)BQC[bz]F|10
fiduciary.name 30 NAME L *(B)BQC[bz]F|0
fiduciary.relation 10 FREE L MIS.RELAT *(B)BQC[bz]F|8
fiduciary.state 2 FREE L *(B)BQC[bz]F|4
fiduciary.zip 10 ZIP.POST L *(B)BQC[bz]F|5
period 10 FREE L MIS.GL.PERIOD
print.cd.screen 0 FREE L VAL=IF{@rt.cds^CDS %BAR.RT.PAT.fiduciary.list.M.cds(CD
VAL=S,^@cust.def.screen),""}
rpt.sort.key 20 FREE L
rt.cds 15 FREE L MIS.SCREEN *(B)BQC[bz]RTMN|0
status 6 CHOICE L *(B)BQC[bz]|1
temp.cd.screen 0 FREE L VAL=c.temp.cd.screen
trans.acct 44 URN L BAR.PAT *(B)BQC[bz]|2
Ì € i 2
assets
[account, asset.queue]
*(B)BQC[bz]A[bqcaq]
Field Name Len Dat Typ J DPM Offset/Local/VAL
asset.queue 3 PINT R bqcaq
asset.amt 9 SMONEY R *(B)BQC[bz]A[bqcaq]|1
asset.as.of 8 DATE L *(B)BQC[bz]A[bqcaq]|3
asset.comment 30 FREE L *(B)BQC[bz]A[bqcaq]|2
asset.type 30 FREE L *(B)BQC[bz]A[bqcaq]|0
Ì € i 2
cust.def.queries
[account, cd.query]
*(B)BQC[bz]F["CDS",ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cd.query 10 FREE L MIS.QUERY ggv
cd.response 75 FREE L *(B)BQC[bz]F["CDS",ggv]|0
Ì € i 2
groups
[account, group]
*(B)BQC[bz]GR[bqg]
Field Name Len Dat Typ J DPM Offset/Local/VAL
group 15 URN L BAR.RT.GROUP bqg
group.txn 1 PINT R *(B)BQC[bz]GR[bqg]|0
Ì € i 2
expenses
[account,group, expense.queue]
*(B)BQC[bz]GR[bqg]E[bqceq]
Field Name Len Dat Typ J DPM Offset/Local/VAL
expense.queue 3 PINT R bqceq
expense.amt 8 SMONEY R *(B)BQC[bz]GR[bqg]E[bqceq]|1
expense.auto.batch 1 YN L *(B)BQC[bz]GR[bqg]E[bqceq]|9
expense.business.day 5 CHOICE L *(B)BQC[bz]GR[bqg]E[bqceq]|7
expense.date 8 DATE L *(B)BQC[bz]GR[bqg]E[bqceq]|4
expense.day 3 FREE L *(B)BQC[bz]GR[bqg]E[bqceq]|3
expense.frequency 1 CHOICE L *(B)BQC[bz]GR[bqg]E[bqceq]|8
expense.payee 15 FREE L *(B)BQC[bz]GR[bqg]E[bqceq]|0
expense.week.of.month 4 FREE L *(B)BQC[bz]GR[bqg]E[bqceq]|6
expense.weekday 3 DAY L *(B)BQC[bz]GR[bqg]E[bqceq]|5
expense.wth.code 10 FREE L BAR.RT.CODE *(B)BQC[bz]GR[bqg]E[bqceq]|2
Ì € i 2
income
[account,group, income.q]
*(B)BQC[bz]GR[bqg]I[bqciq]
Field Name Len Dat Typ J DPM Offset/Local/VAL
income.q 3 PINT R bqciq
income.amt 8 MONEY R *(B)BQC[bz]GR[bqg]I[bqciq]|1
income.auto.batch 1 YN L *(B)BQC[bz]GR[bqg]I[bqciq]|2
income.business.day 5 CHOICE L *(B)BQC[bz]GR[bqg]I[bqciq]|8
income.date 8 DATE L *(B)BQC[bz]GR[bqg]I[bqciq]|5
income.day 3 FREE L *(B)BQC[bz]GR[bqg]I[bqciq]|4
income.dep.code 10 FREE L BAR.RT.CODE *(B)BQC[bz]GR[bqg]I[bqciq]|3
income.frequency 1 CHOICE L *(B)BQC[bz]GR[bqg]I[bqciq]|9
income.source 15 FREE L *(B)BQC[bz]GR[bqg]I[bqciq]|0
income.week.of.month 4 FREE L *(B)BQC[bz]GR[bqg]I[bqciq]|7
income.weekday 3 DAY L *(B)BQC[bz]GR[bqg]I[bqciq]|6
Ì € i 2
rt.groups
[account, rt.group]
*(B)BQC[bz]RT.GPS[bqg]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rt.group 15 URN L BAR.RT.GROUP bqg
rt.group.balance 10 MONEY R *(B)BQC[bz]RT.GPS[bqg]|0
rt.group.cd.screen 15 FREE L MIS.SCREEN VAL=@BAR.RT.GROUP.cd.screen[@group]
rt.group.print.screen 0 FREE L VAL=IF{@rt.group.cd.screen^CDS %BAR.RT.PAT.fiduciary.l
VAL=ist.M.cds(CDS,^@rt.group.cus.def.scrn),""}
rt.group.temp.screen 0 FREE L VAL=c.rt.group.temp.screen
Ì € i 2
rt.group.cus.def.quer
[account,rt.group, rt.group.cd.query]
*(B)BQC[bz]RT.GPS[bqg]RTGCDS["RTGCDQ",ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rt.group.cd.query 10 FREE L MIS.QUERY ggv
rt.group.cd.response 75 FREE L *(B)BQC[bz]RT.GPS[bqg]RTGCDS["RTGCDQ",ggv]|0
Ì € i 2
rt.group.gl
[account,rt.group, rt.group.gl.period]
*(B)BQC[bz]RT.GPS[bqg]RTG.GL[bqcGLP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rt.group.gl.period 8 DATE L bqcGLP
rt.group.gl.balance 12 SMONEY R *(B)BQC[bz]RT.GPS[bqg]RTG.GL[bqcGLP]|0
Ì € i 2
rt.group.txn.dates
[account,rt.group, rt.group.txn.date]
*(B)BQC[bz]RT.GPS[bqg]RTG.TD[bqcTD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rt.group.txn.date 8 DATE L bqcTD
rt.group.txn.balance 12 SMONEY R *(B)BQC[bz]RT.GPS[bqg]RTG.TD[bqcTD]|0
Ì € i 2
transaction.dates
[account, txn.date]
*(B)BQC[bz]TD[bqcTD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.date 8 DATE L bqcTD
txn.date.balance 12 SMONEY R *(B)BQC[bz]TD[bqcTD]|0
Ì € i 2
transactions
[account,txn.date, txn.q]
*(B)BQC[bz]TD[bqcTD]T[bqcTQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.q 2 PINT R bqcTQ
txn.amount 12 SMONEY R *(B)BQC[bz]TD[bqcTD]T[bqcTQ]|3
txn.bch.date 8 DATE L *(B)BQC[bz]TD[bqcTD]T[bqcTQ]|4
txn.bch.entry 4 PINT R *(B)BQC[bz]TD[bqcTD]T[bqcTQ]|6
txn.bch.number 3 PINT R *(B)BQC[bz]TD[bqcTD]T[bqcTQ]|5
txn.bch.txn 4 PINT R *(B)BQC[bz]TD[bqcTD]T[bqcTQ]|7
txn.code 10 FREE L BAR.RT.CODE *(B)BQC[bz]TD[bqcTD]T[bqcTQ]|1
txn.comment 30 FREE L *(B)BQC[bz]TD[bqcTD]T[bqcTQ]|2
txn.type 3 CHOICE L *(B)BQC[bz]TD[bqcTD]T[bqcTQ]|0
Index Files Subscripts/Physical Base
deposit.date.x [income.date,account,income.q]
?(B)BQCDDX[bqcid,bz,bqciq]
group.x [group,account]
?(B)BQGX[bqg,bz]
pmt.date.x [expense.date,account,expense.queue]
?(B)BQCPDX[bqced,bz,bqceq]
rt.deposit.date.x [income.date,account,group,income.q]
?(B)BQC.DDX[bqcid,bz,bqg,bqciq]
rt.group.rpt.x [rpt.sort.key,account,group]
/BQCZ.Ir[bqcSK,bz,bqg]
rt.pmt.date.x [expense.date,account,group,expense.queue]
?(B)RT.PDX[bqced,bz,bqg,bqceq]
rt.post.date.x [txn.bch.date,account,txn.date,txn.q]
?(B)RT.PSDX[bqcTBD,bz,bqcTD,bqcTQ]
|
|
| | | | | | | | | | |