Ì i 2
main
[number]
*(L)LP[lp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
number 4 PINT R lp
abort.user 10 FREE L MIS.USER *(L)LP[lp]|9
del.date 8 DATE L *(L)LP[lp]|13
del.time 4 TIME L *(L)LP[lp]|14
del.user 10 FREE L MIS.USER *(L)LP[lp]|15
last.od.account 25 FREE L MIS.GL.ACCOUNT *(L)LP[lp]|11
last.od.date 8 DATE L *(L)LP[lp]|10
od.status 11 CHOICE L *(L)LP[lp]|12
re.arch.user 10 FREE L MIS.USER *(L)LP[lp]|16
start.date 8 DATE L *(L)LP[lp]|5
start.time 4 TIME L *(L)LP[lp]|6
status 11 CHOICE L *(L)LP[lp]|3
status.display 18 FREE L VAL=IF{@od.status="COMPLETE";@od.status_" (ARCH)"'=" (
VAL=ARCH)";@status}
stop.date 8 DATE L *(L)LP[lp]|7
stop.time 4 TIME L *(L)LP[lp]|8
storage.display 7 FREE L VAL=IF{@storage.type="MIS ARCH" "ARCHIVE";"NONE"}
storage.type 8 CHOICE L *(L)LP[lp]|0
structure.number 2 PINT R *(L)LP[lp]|1
thru.date 10 GLPERIOD L *(L)LP[lp]|2
user 10 FREE L MIS.USER *(L)LP[lp]|4
Ì € i 2
periods
[number, date]
*(L)LP[lp]P[lpD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
date 10 GLPERIOD L lpD
date.header 22 FREE L VAL=@MIS.GL.PERIOD.date.x[/rpt.date]^MIS.GL.PERIOD.per
VAL=iod_" (FY: "_@MIS.GL.PERIOD.fiscal.year_")"
Ì € i 2
accounts
[number,date, account]
*(L)LP[lp]P[lpD]A[ga]
Field Name Len Dat Typ J DPM Offset/Local/VAL
account 25 FREE L MIS.GL.ACCOUNT ga
acct.desc 45 FREE L *(L)LP[lp]P[lpD]A[ga]|9
acct.type 1 FREE L *(L)LP[lp]P[lpD]A[ga]|1
fiscal.year 4 PINT R *(L)LP[lp]P[lpD]A[ga]|8
num.txns.posted 5 PINT R *(L)LP[lp]P[lpD]A[ga]|5
num.txns.summarized 5 PINT R *(L)LP[lp]P[lpD]A[ga]|6
od.urn 10 FREE L *(L)LP[lp]P[lpD]A[ga]|0
period 10 FREE L MIS.GL.PERIOD *(L)LP[lp]P[lpD]A[ga]|7
tot.activity 12 SDEC2 R *(L)LP[lp]P[lpD]A[ga]|4
tot.credits 12 SMONEY R *(L)LP[lp]P[lpD]A[ga]|3
tot.debits 12 SMONEY R *(L)LP[lp]P[lpD]A[ga]|2
Ì € i 2
rem.batch.money
[number, rem.m.ptr]
*(L)LP[lp]R[lpLB]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rem.m.ptr 23 FREE L lpLB
rem.m.date 8 DATE L
rem.m.jnl 10 FREE L
rem.m.number 3 PINT R
rem.m.urn 8 FREE L *(L)LP[lp]R[lpLB]|0
Ì € i 2
rem.batch.stats
[number, rem.s.ptr]
*(L)LP[lp]S[lpLT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rem.s.ptr 24 FREE L lpLT
rem.s.date 8 DATE L
rem.s.jnl 10 FREE L
rem.s.number 4 PINT R
rem.s.urn 8 FREE L *(L)LP[lp]S[lpLT]|0
Ì i 2
od.top
[od.seq]
/(.OD)DATA[lpQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
od.seq 4 PINT R lpQ
od.account 25 FREE L /(.OD)DATA[lpQ]H|6
od.acct.desc 45 FREE L /(.OD)DATA[lpQ]H|9
od.acct.type 1 FREE L /(.OD)DATA[lpQ]H|11
od.date 8 DATE L /(.OD)DATA[lpQ]H|5
od.db 12 FREE L /(.OD)DATA[lpQ]H|3
od.dir 10 FREE L /(.OD)DATA[lpQ]H|1
od.fiscal.year 4 PINT R /(.OD)DATA[lpQ]H|8
od.mis 12 FREE L /(.OD)DATA[lpQ]H|2
od.num.txns.posted 5 PINT R /(.OD)DATA[lpQ]H|15
od.num.txns.summarized 5 PINT R /(.OD)DATA[lpQ]H|16
od.number 4 PINT R /(.OD)DATA[lpQ]H|4
od.od.urn 10 FREE L /(.OD)DATA[lpQ]H|10
od.period 10 FREE L /(.OD)DATA[lpQ]H|7
od.seg 10 FREE L /(.OD)DATA[lpQ]H|0
od.source.disp 50 FREE L VAL=@od.seg_": "_@od.dir_": "_@od.mis_": "_@od.db
od.tot.activity 12 SDEC2 R /(.OD)DATA[lpQ]H|14
od.tot.credits 12 SMONEY R /(.OD)DATA[lpQ]H|13
od.tot.debits 12 SMONEY R /(.OD)DATA[lpQ]H|12
Ì € i 2
od.txn.types
[od.seq, od.ret.txn.type]
/(.OD)DATA[lpQ]X[lpTT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
od.ret.txn.type 1 CHOICE L lpTT
od.ret.txn.type.ex 10 FREE L VAL=IF{od.ret.txn.type="P" "POSTED";od.ret.txn.type="S
VAL=" "SUMMARIZED"}
Ì € i 2
od.txns
[od.seq,od.ret.txn.type, od.ret.txn.num]
/(.OD)DATA[lpQ]X[lpTT,lpTN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
od.ret.txn.num 4 PINT R lpTN
od.txn.activity 12 SDEC2 R /(.OD)DATA[lpQ]X[lpTT,lpTN]|2
od.txn.bch.comment 50 FREE L /(.OD)DATA[lpQ]X[lpTT,lpTN]|8
od.txn.bch.date 8 DATE L /(.OD)DATA[lpQ]X[lpTT,lpTN]|3
od.txn.bch.db 12 FREE L /(.OD)DATA[lpQ]X[lpTT,lpTN]|7
od.txn.bch.jnl 10 FREE L /(.OD)DATA[lpQ]X[lpTT,lpTN]|4
od.txn.bch.num 4 FREE L /(.OD)DATA[lpQ]X[lpTT,lpTN]|5
od.txn.credit 12 SMONEY R /(.OD)DATA[lpQ]X[lpTT,lpTN]|1
od.txn.debit 12 SMONEY R /(.OD)DATA[lpQ]X[lpTT,lpTN]|0
od.txn.txn.desc 50 FREE L /(.OD)DATA[lpQ]X[lpTT,lpTN]|9
od.txn.txn.desc.disp 34 FREE L VAL=IF{L(@od.txn.txn.desc)>34 @od.txn.txn.desc$30_"
VAL= ...";@od.txn.txn.desc}
od.txn.txn.num 6 FREE L /(.OD)DATA[lpQ]X[lpTT,lpTN]|6
od.txn.txn.vendor.name 35 FREE L /(.OD)DATA[lpQ]X[lpTT,lpTN]|10
Index Files Subscripts/Physical Base
money.x [date,account,number]
?(L)LPMX[lpD,ga,lp]
stats.x [date,account,number]
?(L)LPSX[lpD,ga,lp]
|
|
| | | | | | |