|
OE Temporary Pre-Posting File: xxxOZaaa.DBF aaa = Batch# from AAA to ZZZ
|
Tag
|
Index
|
|
OEZTRAN
|
UPPER(OEZFISCAL) + STR(OEZTRANNUM) + UPPER(OEZGLACCT)
|
|
OEZACCT
|
UPPER(OEZFISCAL) + UPPER(OEZGLACCT) + IIF(OEZAMOUNT<0,'0','1')
|
|
OEZGLACCT
|
UPPER(OEZGLACCT) + DTOS(OEZTRNDATE) + IIF(OEZAMOUNT<0,'0','1') + UPPER(OEZTDESC)
|
|
##
|
Desc
|
Name
|
Type
|
Size
|
Condition
|
|
1.
|
Record Type (3) & Fiscal Period (2)
|
OEZFISCAL
|
CharCaps
|
5
|
|
|
2.
|
Posting Date
|
OEZTRNDATE
|
Date
|
|
R:any date->fiscal end
|
|
3.
|
Transaction Number
|
OEZTRANNUM
|
Numeric
|
5
|
|
|
4.
|
GL Account / AP Vendor #
Field Length for Fund
|
OEZGLACCT
|
CharCaps
|
30
45
|
|
|
5.
|
Amount to Post
|
OEZAMOUNT
|
Numeric
|
15
|
(11.2) R:+/-
|
|
6.
|
Tran Source: H=Header, D=Detail
|
OEZLEVEL
|
CharCaps
|
1
|
R:H or D
|
|
7.
|
Transaction Description
|
OEZTDESC
|
Character
|
30
|
|
|
8.
|
Detail Description
|
OEZDDESC
|
Character
|
40
|
|
|
9.
|
Status
|
OEZSTATUS
|
CharCaps
|
3
|
|
|
10.
|
GL Expense
Field Length for Fund
|
OEZGLEXP
|
Character
|
30
45
|
|
|
11.*
|
Application User ID
|
OEZUSERID
|
CharCaps
|
3
|
|
|
12.*
|
Transaction Batch Description
|
OEZBATNUM
|
CharCaps
|
15
|
|
| |
|
.jpg)
