Ì i 2
ml.by.gl.number
[ml.by.gl.number.date]
*(B3)BQBMG[bqbD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ml.by.gl.number.date 8 DATE L bqbD
ml.by.gl.number.comp.date 8 DATE L *(B3)BQBMG[bqbD]|0
ml.by.gl.number.comp.time 4 TIME L *(B3)BQBMG[bqbD]|1
ml.by.gl.number.final 1 YN L *(B3)BQBMG[bqbD]|2
Ì i 2
posting.stats
[posting.stats.urn]
*(B)BQBYS[bqb]
Field Name Len Dat Typ J DPM Offset/Local/VAL
posting.stats.urn 10 URN L BAR.RT.BCH bqb
Ì € i 2
posting.stats.corp
[posting.stats.urn, corp]
*(B)BQBYS[bqb,gvCN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
corp 4 FREE L MIS.GL.CORP gvCN
ls.adj 12 SMONEY R *(B)BQBYS[bqb,gvCN]L|3
ls.dep 12 SMONEY R *(B)BQBYS[bqb,gvCN]L|1
ls.int 12 SMONEY R *(B)BQBYS[bqb,gvCN]L|4
ls.total 12 SMONEY R *(B)BQBYS[bqb,gvCN]L|0
ls.wth 12 SMONEY R *(B)BQBYS[bqb,gvCN]L|2
Ì i 2
rt.batches
[rt.batch.urn]
*(B)BQBRT.BCH[zlBQB]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rt.batch.urn 4 PINT R zlBQB
rt.batch.create.date 8 DATE L *(B)BQBRT.BCH[zlBQB]|0
rt.batch.create.user 10 FREE L MIS.USER *(B)BQBRT.BCH[zlBQB]|1
rt.batch.edit.amount 1 YN L *(B)BQBRT.BCH[zlBQB]|4
rt.batch.edit.code 1 YN L *(B)BQBRT.BCH[zlBQB]|3
rt.batch.name 30 FREE L *(B)BQBRT.BCH[zlBQB]|5
rt.batch.service.date 8 DATE L *(B)BQBRT.BCH[zlBQB]|2
rt.dft.item.amount 10 SMONEY R *(B)BQBRT.BCH[zlBQB]RT.DFTS|1
rt.dft.item.comment 30 FREE L *(B)BQBRT.BCH[zlBQB]RT.DFTS|2
rt.dft.txn.code 10 FREE L BAR.RT.CODE *(B)BQBRT.BCH[zlBQB]RT.DFTS|0
Ì € i 2
rt.batches.data
[rt.batch.urn, rt.batch.account.urn]
*(B)BQBRT.BCH[zlBQB]RT.D[zlBZN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rt.batch.account.urn 4 FREE L zlBZN
rt.batch.account 44 URN L BAR.PAT *(B)BQBRT.BCH[zlBQB]RT.D[zlBZN]|0
rt.batch.account.disp 44 FREE L *(B)BQBRT.BCH[zlBQB]RT.D[zlBZN]|5
rt.txn.amount 10 SMONEY R *(B)BQBRT.BCH[zlBQB]RT.D[zlBZN]|2
rt.txn.code 10 FREE L BAR.RT.CODE *(B)BQBRT.BCH[zlBQB]RT.D[zlBZN]|1
rt.txn.comment 30 FREE L *(B)BQBRT.BCH[zlBQB]RT.D[zlBZN]|3
rt.txn.type 3 CHOICE L *(B)BQBRT.BCH[zlBQB]RT.D[zlBZN]|4
Ì i 2
rt.process
[rt.process.urn]
/BQBRT.PRO[zlURN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rt.process.urn 3 URN L zlURN
rt.process.account 44 FREE L /BQBRT.PRO[zlURN]|0
rt.process.acct.int 20 FREE L /BQBRT.PRO[zlURN]|5
rt.process.code.desc 30 FREE L /BQBRT.PRO[zlURN]|4
rt.process.group 15 URN L BAR.RT.GROUP /BQBRT.PRO[zlURN]|6
rt.process.group.bal 10 MONEY R /BQBRT.PRO[zlURN]|7
rt.process.txn.amt 9 MONEY R /BQBRT.PRO[zlURN]|3
rt.process.txn.code 10 FREE L BAR.RT.CODE /BQBRT.PRO[zlURN]|2
rt.process.txn.date 8 DATE L /BQBRT.PRO[zlURN]|1
Ì € i 2
statuses
?(B)BQBS
Field Name Len Dat Typ J DPM Offset/Local/VAL
last.interest.alloc.date 8 DATE L ?(B)BQBS|0
Ì € i 2
group.statuses
[status.group]
?(B)BQBS[bqg]
Field Name Len Dat Typ J DPM Offset/Local/VAL
status.group 15 URN L BAR.RT.GROUP bqg
grp.lst.interest.alloc.dt 8 DATE L ?(B)BQBS[bqg]|0
Ì i 2
top
[urn]
*(B)BQB[bqb]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 10 URN L bqb
adj.actual.amt 12 SMONEY R *(B)BQB[bqb]M|10
adj.control.amt 12 SMONEY R *(B)BQB[bqb]M|9
comment 60 FREE L *(B)BQB[bqb]M|3
create.date 8 DATE L *(B)BQB[bqb]M|14
create.time 4 HHMM L *(B)BQB[bqb]M|15
create.user 10 FREE L MIS.USER *(B)BQB[bqb]M|13
date 8 DATE L *(B)BQB[bqb]M|0
dep.actual.amt 12 SMONEY R *(B)BQB[bqb]M|6
dep.control.amt 12 SMONEY R *(B)BQB[bqb]M|5
dft.txn.date 8 DATE L *(B)BQB[bqb]M|4
id 10 URN L
int.actual.amt 12 SMONEY R *(B)BQB[bqb]M|12
int.control.amt 12 SMONEY R *(B)BQB[bqb]M|11
number 4 PINT R *(B)BQB[bqb]M|1
posted.date 8 DATE L *(B)BQB[bqb]M|17
posted.time 4 HHMM L *(B)BQB[bqb]M|18
posted.user 10 FREE L MIS.USER *(B)BQB[bqb]M|16
re.opened 12 PINT R *(B)BQB[bqb]M|19
status 10 CHOICE L *(B)BQB[bqb]M|2
wth.actual.amt 12 SMONEY R *(B)BQB[bqb]M|8
wth.control.amt 12 SMONEY R *(B)BQB[bqb]M|7
Ì € i 2
entries
[urn, ent.number]
*(B)BQB[bqb]E[bqbE]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ent.number 4 PINT R bqbE
ent.account 44 URN L BAR.PAT *(B)BQB[bqb]E[bqbE]|0
ent.posting.err.flag 1 YN L *(B)BQB[bqb]E[bqbE]|3
ent.txn.date 8 DATE L *(B)BQB[bqb]E[bqbE]|1
ent.user 10 FREE L MIS.USER *(B)BQB[bqb]E[bqbE]|2
Ì € i 2
transactions
[urn,ent.number, txn.urn]
*(B)BQB[bqb]E[bqbE]T[bqbT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.urn 3 URN L bqbT
txn.acct.xref.error.msg 20 FREE L *(B)BQB[bqb]E[bqbE]T[bqbT]|5
txn.acct.xref.txn 2 FREE L *(B)BQB[bqb]E[bqbE]T[bqbT]|4
txn.amount 10 SMONEY R *(B)BQB[bqb]E[bqbE]T[bqbT]|1
txn.code 10 FREE L BAR.RT.CODE *(B)BQB[bqb]E[bqbE]T[bqbT]|0
txn.comment 30 FREE L *(B)BQB[bqb]E[bqbE]T[bqbT]|2
txn.type 3 CHOICE L *(B)BQB[bqb]E[bqbE]T[bqbT]|3
Index Files Subscripts/Physical Base
ml.sort.by.gl.number [date,gl.number,txn.account.number,urn,ent.number,txn.urn]
*(B3)BQBMG[bqbD,ga,bzR,bqb,bqbE,bqbT]
number.x [date,number] = urn
?(B)BQBN[bqbD,bqbN]
|
|
| | | | | | | | | |