BANK
|
Char
|
8
|
0
|
Bank Code
|
%-8N
|
1
|
RKEA
|
SERIAL
|
Long
|
4
|
0
|
Transaction Header Serial
|
|
2
|
RKEA
|
TRANSNUM
|
Decimal
|
5
|
0
|
Transaction Number
|
|
3
|
EA
|
SRCEAPP
|
Char
|
2
|
0
|
Source Application
|
%-2N
|
4
|
EA
|
TRANSTYPE
|
Int
|
2
|
0
|
Transaction Type
1 - Withdrawals 2 - Deposits |
|
5
|
EA
|
OLDSERIAL
|
Long
|
4
|
0
|
Old Serial Number
|
|
6
|
EA
|
ENTRYTYPE
|
Int
|
2
|
0
|
Entry Type
1 - Bank Entered 2 - Miscellaneous 3 - Subledger 4 - Transfer 5 - Returned Customer Check 6 - Alignment 7 - Non Negotiable |
|
7
|
EA
|
REFERENCE
|
Char
|
60
|
0
|
Transaction Reference
|
|
8
|
EA
|
DESC
|
Char
|
60
|
0
|
Transaction Description
|
|
9
|
EA
|
TRANSDATE
|
Date
|
5
|
0
|
Transaction Date
|
|
10
|
EA
|
FSCYEAR
|
Char
|
4
|
0
|
Fiscal Year
|
%04D
|
11
|
EA
|
FSCPERIOD
|
Int
|
2
|
0
|
Fiscal Period
1 - 1 2 - 2 3 - 3 4 - 4 5 - 5 6 - 6 7 - 7 8 - 8 9 - 9 10 - 10 11 - 11 12 - 12 |
|
12
|
EAP
|
PRINTED
|
Int
|
2
|
0
|
Transaction Slip Printed
0 - No 1 - Yes |
|
13
|
EA
|
TOTAMOUNT
|
Decimal
|
10
|
3
|
Transaction Total
|
|
14
|
CA
|
TOTBALAMT
|
Decimal
|
10
|
3
|
Transaction Total in Statement
|
|
15
|
CA
|
TOTCLEARED
|
Decimal
|
10
|
3
|
Fiscal Transaction Total
|
|
16
|
CA
|
NXTLINE
|
Long
|
4
|
0
|
Next Transaction Detail Line
|
|
17
|
CEA
|
LINES
|
Long
|
4
|
0
|
Lines
|
|
18
|
CEA
|
LINESPOST
|
Long
|
4
|
0
|
Lines Outstanding
|
|
19
|
CEA
|
LINESREC
|
Long
|
4
|
0
|
Lines Reconciled
|
|
20
|
CEA
|
STATUS
|
Int
|
2
|
0
|
Transaction Status
1 - Not posted 2 - Partially Outstanding 3 - Outstanding 4 - Partially Reconciled 5 - Reconciled 6 - Pending Journal 7 - Posted 8 - Purged |
|
21
|
CA
|
RECERR
|
Decimal
|
10
|
3
|
Reconciliation Error
|
|
22
|
CEA
|
RECERRPEND
|
Decimal
|
10
|
3
|
Reconciliation Error Pending
|
|
23
|
CEA
|
RECEXGAIN
|
Decimal
|
10
|
3
|
Reconciliation Exchange Gain
|
|
24
|
CEA
|
RECEXLOSS
|
Decimal
|
10
|
3
|
Reconciliation Exchange Loss
|
|
25
|
CEA
|
RECAMOUNT
|
Decimal
|
10
|
3
|
Reconciliation Amount
|
|
26
|
CEA
|
RECOUTSTND
|
Decimal
|
10
|
3
|
Reconciliation Outstanding Amt
|
|
27
|
CEA
|
SUMMARY
|
Int
|
2
|
0
|
Transaction Recorded in Summary
0 - Detail 1 - Summary 2 - Transfer 3 - Bank Error |
|
28
|
EA
|
RECCCC
|
Decimal
|
10
|
3
|
Reconciliation Credit Card Charg
|
|
29
|
CEA
|
RECCLEARED
|
Decimal
|
10
|
3
|
Amount Cleared
|
|
30
|
CEA
|
RECFUNCAMT
|
Decimal
|
10
|
3
|
Functional Transaction Amount
|
|
31
|
CEA
|
TOTFUNCAMT
|
Decimal
|
10
|
3
|
Functional Transaction Total
|
|
32
|
CA
|
TOCLEAR
|
Decimal
|
10
|
3
|
Reconciliation Cleared Amount
|
|
33
|
A
|
TOWRITEOFF
|
Decimal
|
10
|
3
|
Write-Off Amount
|
|
34
|
A
|
TOREMAIN
|
Decimal
|
10
|
3
|
Outstanding Amount
|
|
35
|
A
|
VARIANCE
|
Int
|
2
|
0
|
Variance Type
0 - None |
|
36
|
AP
|
LINESREVIN
|
Long
|
4
|
0
|
Lines Can Reverse Invoice
|
|
37
|
CA
|
POSTDATE
|
Date
|
5
|
0
|
Reconciliation Date
|
|
38
|
A
|
RECSTATUS
|
Int
|
2
|
0
|
Reconciliation Status
1 - Not Posted 2 - Void 9 - Printed 7 - Non-negotiable 8 - Continuation |
|
39
|
EAP
|
RECCOMMENT
|
Char
|
60
|
0
|
Reconciliation Description
|
|
40
|
A
|
LINESJOUR
|
Long
|
4
|
0
|
Lines Journalled
|
|
41
|
CA
|
LINESPUR
|
Long
|
4
|
0
|
Lines Purged
|
|
42
|
CA
|
LINESPROC
|
Long
|
4
|
0
|
Lines Processed
|
|
43
|
CA
|
TOCLEARF
|
Decimal
|
10
|
3
|
Clear To Future Period
|
|
44
|
A
|
RECFCLR
|
Decimal
|
10
|
3
|
Fiscal Cleared To Future
|
|
45
|
CEA
|
RECRCLR
|
Decimal
|
10
|
3
|
Fiscal Cleared To Current
|
|
46
|
CEA
|
COMPLETED
|
Int
|
2
|
0
|
Reconciled and Journaled Transac
0 - Not Completed 10 - Completed |
|
47
|
EA
|
PAYORNAME
|
Char
|
60
|
0
|
Payment Payee Name
|
|
48
|
CEA
|
VENDORNAME
|
Char
|
60
|
0
|
Payment Vendor Name
|
|
49
|
EA
|
ENTRYNBR
|
Char
|
22
|
0
|
Bank Entry/Transfer Number
|
%-22C
|
50
|
EA
|
LINESCCC
|
Long
|
4
|
0
|
Lines Credit Card
|
|
51
|
CEA
|
LINESEXCH
|
Long
|
4
|
0
|
Lines Exchange Difference
|
|
52
|
CEA
|
REVINVC
|
Int
|
2
|
0
|
Reverse Invoice
0 - No 1 - Yes |
|
53
|
A
|
AMTDTLREC
|
Decimal
|
10
|
3
|
Reconcile by Detail Reconciled
|
|
54
|
CEA
|
AMTDTLOUT
|
Decimal
|
10
|
3
|
Reconcile by Detail Outstanding
|
|
55
|
CEA
|
RECWOSUMR
|
Decimal
|
10
|
3
|
Current Period's Write-Off
|
|
114
|
CA
|
TOCLEARR
|
Decimal
|
10
|
3
|
Clear To Reconciliation Period
|
|
115
|
CA
|
RECRWOSUM
|
Decimal
|
10
|
3
|
Fiscal Write-Off To This Period
|
|
116
|
CEA
|
RECPREM
|
Decimal
|
10
|
3
|
Fiscal Remaining Outstanding
|
|
117
|
CEA
|
RECTWO
|
Decimal
|
10
|
3
|
Total Delta Write Offs
|
|
118
|
CEA
|
RECTERR
|
Decimal
|
10
|
3
|
Total Delta Bank Errors
|
|
119
|
CEA
|
RECTGAIN
|
Decimal
|
10
|
3
|
Total Delta Exchange Gain
|
|
120
|
CEA
|
RECTLOSS
|
Decimal
|
10
|
3
|
Total Delta Exchange Loss
|
|
121
|
CEA
|
RECTCCC
|
Decimal
|
10
|
3
|
Total Delta Credit Card Charge
|
|
122
|
CEA
|
RECTCLR
|
Decimal
|
10
|
3
|
Total Delta Cleared
|
|
123
|
CEA
|
RECTFUNAM
|
Decimal
|
10
|
3
|
Total Delta Functional Amount
|
|
124
|
CEA
|
CURFUNC
|
Char
|
3
|
0
|
Functional Currency
|
|
125
|
A
|
CURSTMT
|
Char
|
3
|
0
|
Statement Currency
|
|
126
|
A
|
RECWOSUM
|
Decimal
|
10
|
3
|
Reconciliation Write Off Sum
|
|
127
|
CA
|
POSTYEAR
|
Char
|
4
|
0
|
Reconciliation posting Year
|
%04D
|
128
|
EA
|
POSTPERIOD
|
Int
|
2
|
0
|
Reconciliation posting Period
|
|
129
|
EAP
|
SUMDEPOSIT
|
Decimal
|
10
|
3
|
Total Deposits
|
|
130
|
CA
|
RECINTRANS
|
Decimal
|
10
|
3
|
Deposits in Transit
|
|
131
|
CA
|
FUNDTAMT
|
Decimal
|
10
|
3
|
Deposit Functional Total
|
|
132
|
CA
|
RECDTWOSUM
|
Decimal
|
10
|
3
|
Sum of Deposit Total Write Offs
|
|
133
|
CA
|
RECDTERR
|
Decimal
|
10
|
3
|
Total Deposit Bank Errors
|
|
134
|
CA
|
RECDTGAIN
|
Decimal
|
10
|
3
|
Total Deposit Exchange Gain
|
|
135
|
CA
|
RECDTLOSS
|
Decimal
|
10
|
3
|
Total Deposit Exchange Loss
|
|
136
|
CA
|
RECDTCCC
|
Decimal
|
10
|
3
|
Total Deposit Credit Card Charge
|
|
137
|
CA
|
RECDTCLR
|
Decimal
|
10
|
3
|
Total Deposit Cleared
|
|
138
|
CA
|
RECDPWOSUM
|
Decimal
|
10
|
3
|
Fiscal Deposit Write-Off To This
|
|
139
|
CA
|
RECDPERR
|
Decimal
|
10
|
3
|
Fiscal Deposit Bank Errors
|
|
140
|
CA
|
RECDPGAIN
|
Decimal
|
10
|
3
|
Fiscal Deposit Exchange Gain
|
|
141
|
CA
|
RECDPLOSS
|
Decimal
|
10
|
3
|
Fiscal Deposit Exchange Loss
|
|
142
|
CA
|
RECDPCCC
|
Decimal
|
10
|
3
|
Fiscal Deposit Credit Card Charg
|
|
143
|
CA
|
RECDPCLR
|
Decimal
|
10
|
3
|
Fiscal Deposit Cleared
|
|
144
|
CA
|
RECDEXDIFF
|
Decimal
|
10
|
3
|
Deposit Cleared with Exchange Ra
|
|
145
|
CA
|
RECFCDEPIT
|
Decimal
|
10
|
3
|
Deposits In Transit To Fisc.Per.
|
|
146
|
CA
|
RECDFCLR
|
Decimal
|
10
|
3
|
Fiscal Deposit Cleared To Future
|
|
147
|
CA
|
SUMCHECK
|
Decimal
|
10
|
3
|
Total Checks
|
|
148
|
CA
|
RECWOUTSTD
|
Decimal
|
10
|
3
|
Checks Outstanding
|
|
149
|
CA
|
FUNWTAMT
|
Decimal
|
10
|
3
|
Withdrawal Functional Total
|
|
150
|
CA
|
RECWTWOSUM
|
Decimal
|
10
|
3
|
Sum of Withdrawal Total Write Of
|
|
151
|
CA
|
RECWTERR
|
Decimal
|
10
|
3
|
Total Withdrawal Bank Errors
|
|
152
|
CA
|
RECWTGAIN
|
Decimal
|
10
|
3
|
Total Withdrawal Exchange Gain
|
|
153
|
CA
|
RECWTLOSS
|
Decimal
|
10
|
3
|
Total Withdrawal Exchange Loss
|
|
154
|
CA
|
RECWTCCC
|
Decimal
|
10
|
3
|
Total Withdrawal Credit Card Cha
|
|
155
|
CA
|
RECWTCLR
|
Decimal
|
10
|
3
|
Total Withdrawal Cleared
|
|
156
|
CA
|
RECWPWOSUM
|
Decimal
|
10
|
3
|
Fiscal Withdrawal Write-Off To T
|
|
157
|
CA
|
RECWPERR
|
Decimal
|
10
|
3
|
Fiscal Withdrawal Bank Errors
|
|
158
|
CA
|
RECWPGAIN
|
Decimal
|
10
|
3
|
Fiscal Withdrawal Exchange Gain
|
|
159
|
CA
|
RECWPLOSS
|
Decimal
|
10
|
3
|
Fiscal Withdrawal Exchange Loss
|
|
160
|
CA
|
RECWPCCC
|
Decimal
|
10
|
3
|
Fiscal Withdrawal Credit Card Ch
|
|
161
|
CA
|
RECWPCLR
|
Decimal
|
10
|
3
|
Clear To Reconciliation Period
|
|
162
|
CA
|
RECWEXDIFF
|
Decimal
|
10
|
3
|
Checks Cleared with Exch. Rate D
|
|
163
|
CA
|
RECFCCHKOS
|
Decimal
|
10
|
3
|
Checks Outstanding To Fisc.Per.
|
|
164
|
CA
|
RECWFCLR
|
Decimal
|
10
|
3
|
Fiscal Withdrawal Cleared To Fut
|
|
165
|
CA
|
RECFCMISC
|
Decimal
|
10
|
3
|
Fiscal Miscellaneous Entry
|
|
166
|
CA
|
RECFCWMISC
|
Decimal
|
10
|
3
|
Payment Misc. Entries To Fiscal
|
|
167
|
CA
|
RECFCDMISC
|
Decimal
|
10
|
3
|
Deposit Misc. Entries To Fiscal
|
|
168
|
CA
|
RECFWMISC
|
Decimal
|
10
|
3
|
Payment Misc. Entries To Future
|
|
169
|
CA
|
RECFDMISC
|
Decimal
|
10
|
3
|
Deposit Misc. Entries To Future
|
|
170
|
CA
|
RECPDEPB
|
Decimal
|
10
|
3
|
Fiscal Deposit Book Amount
|
|
171
|
CA
|
RECPCHKB
|
Decimal
|
10
|
3
|
Fiscal Withdrawal Book Amount
|
|
172
|
CA
|
DTLACCESS
|
Int
|
2
|
0
|
Detail Access Portal
0 - No 1 - Yes |
|
173
|
EA
|
RECDELTA
|
Decimal
|
10
|
3
|
Reconciliation Delta
|
|
174
|
CA
|
PROCESSCMD
|
Int
|
2
|
0
|
Process Command Code
0 - Sum Details 1 - Apply Details Cleared 2 - Apply Details Outstanding |
|
175
|
CEA
|