Ì i 2
mis.gl.money.batch.file (top)
[urn]
:GB[gb]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 8 URN L gb
Ì € i 2
mis.gl.money.batch.accounts (distribution)
[urn, dis.acct]
:GB[gb]A[lbA]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dis.acct 25 FREE L MIS.GL.ACCOUNT lbA
dis.more.than.one.dr.cr VAL=(+@dis.debits[urn,dis.acct,""]'=-@dis.debits[urn,d
VAL=is.acct,""]!(+@dis.credits[urn,dis.acct,""]'=-@dis
VAL=.credits[urn,dis.acct,""]))
Ì € i 2
mis.gl.money.batch.acc.credits (dis.credits)
[urn,dis.acct, dis.cr.txn]
:GB[gb]A[lbA]CR[lbAC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dis.cr.txn 4 URN L lbAC
dis.cr.amount 12 MONEY R :GB[gb]A[lbA]CR[lbAC]
Ì € i 2
mis.gl.money.batch.acc.debits (dis.debits)
[urn,dis.acct, dis.dr.txn]
:GB[gb]A[lbA]DR[lbAD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dis.dr.txn 4 URN L lbAD
dis.dr.amount 12 MONEY R :GB[gb]A[lbA]DR[lbAD]
Ì € i 2
mis.gl.money.batch.txns (transactions)
[urn, txn.number]
:GB[gb]T[lbT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.number 4 URN R lbT
txn.active 1 YN L :GB[gb]T[lbT]|0
txn.description 50 FREE L :GB[gb]T[lbT]|1
txn.expand.desc 90 FREE L :GB[gb]T[lbT]|2
txn.more.than.one.dr.cr VAL=(+@debits[urn,txn.number,""]'=-@debits[urn,txn.num
VAL=ber,""]!(+@credits[urn,txn.number,""]'=-@credits[u
VAL=rn,txn.number,""]))
txn.posted 1 YN L VAL=IF{@status="POSTED" "Y";"N"}
Ì € i 2
mis.gl.money.batch.txn.credits (credits)
[urn,txn.number, cr.acct]
:GB[gb]T[lbT]CR[lbCR]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cr.acct 25 FREE L MIS.GL.ACCOUNT lbCR
cr.acct.desc 40 FREE L VAL=@MIS.GL.ACCOUNT.description[cr.acct]$40
cr.amount 12 SMONEY R :GB[gb]T[lbT]CR[lbCR]
Ì € i 2
mis.gl.money.batch.txn.debits (debits)
[urn,txn.number, dr.acct]
:GB[gb]T[lbT]DR[lbDR]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dr.acct 25 FREE L MIS.GL.ACCOUNT lbDR
dr.acct.desc 40 FREE L VAL=@MIS.GL.ACCOUNT.description[dr.acct]$40
dr.amount 12 SMONEY R :GB[gb]T[lbT]DR[lbDR]
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mis.gl.money.batch.id.x [date,journal,number] = urn
id.x :GBI[gbD,gj,gbN]
|
|
| | | | | |