Ì 2
main
[id,fiscal.year,account]
*(L)LW[lwW,lwY,ga]
Field Name Len Dat Typ J DPM Offset/Local/VAL
id 8 FREE L lwW
fiscal.year 4 PINT R lwY
account 25 FREE L MIS.GL.ACCOUNT ga
annual.budget 12 SDEC R *(L)LW[lwW,lwY,ga]|0
distribution 8 FREE L MIS.GL.BUD.DIST*(L)LW[lwW,lwY,ga]|1
Ì € 2
periods
[id,fiscal.year,account, period]
*(L)LW[lwW,lwY,ga]P[lwP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
period 10 GLPERIOD L lwP
budget 12 SDEC2 R *(L)LW[lwW,lwY,ga]P[lwP]|0
budget.ytd 12 SDEC2 R *(L)LW[lwW,lwY,ga]P[lwP]|1
Ì 2
rev.history
[rev.id,rev.fiscal.year]
*(L)LWR[lwW,lwY]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rev.id 8 FREE L lwW
rev.fiscal.year 4 FREE L lwY
Ì € 2
rev.notes
[rev.id,rev.fiscal.year, rn.seq.no]
*(L)LWR[lwW,lwY]N[lwN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rn.seq.no 4 PINT R lwN
rn.audit 1 YN L *(L)LWR[lwW,lwY]N[lwN]|4
rn.date.created 8 DATE L *(L)LWR[lwW,lwY]N[lwN]|0
rn.date.edited 8 DATE L *(L)LWR[lwW,lwY]N[lwN]|2
rn.date.last.edit 8 DATE L VAL=IF{@rn.date.edited;@rn.date.created}
rn.user.created 10 FREE L MIS.USER *(L)LWR[lwW,lwY]N[lwN]|1
rn.user.edited 10 FREE L MIS.USER *(L)LWR[lwW,lwY]N[lwN]|3
rn.user.last.edit 10 FREE L MIS.USER VAL=IF{@rn.user.edited;@rn.user.created}
Ì € 2
rev.note
[rev.id,rev.fiscal.year,rn.seq.no, rn.line.no]
*(L)LWR[lwW,lwY]N[lwN]L[lwNL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rn.line.no 3 PINT R lwNL
rn.line.text 79 TEXT L *(L)LWR[lwW,lwY]N[lwN]L[lwNL]
Ì 2
status.file
[status.id,status.fiscal.year]
*(L)LW[lwW,lwY]
Field Name Len Dat Typ J DPM Offset/Local/VAL
status.id 8 FREE L lwW
status.fiscal.year 4 PINT R lwY
status 10 FREE L *(L)LW[lwW,lwY]|0
status.date 8 DATE L *(L)LW[lwW,lwY]|1
status.user 10 FREE L MIS.USER *(L)LW[lwW,lwY]|2
Ì 2
user.top
[id.top]
*(L)LWU[lwW]
Field Name Len Dat Typ J DPM Offset/Local/VAL
id.top 8 FREE L GL.BUDGET lwW
Ì € 2
users
[id.top, user]
*(L)LWU[lwW]U[gu]
Field Name Len Dat Typ J DPM Offset/Local/VAL
user 10 FREE L MIS.USER gu
|
|
| | | | | |