BANK |
1 |
String*8 |
Bank Code |
E A K R |
Mask: %-8N |
SERIAL |
2 |
??? |
Transaction Header Serial |
E A K R |
|
LINE |
3 |
Long |
Transaction Detail Line |
E A K R |
|
SRCEAPP |
4 |
String*2 |
Source Application |
E A R X |
Mask: %-2N |
STATUS |
5 |
Integer |
Transaction Detail Status |
E A P X |
List:8 entries
1 |
= |
Not Posted |
2 |
= |
Void |
3 |
= |
Outstanding |
6 |
= |
Cleared with bank error |
4 |
= |
Reversed |
7 |
= |
Non-negotiable |
8 |
= |
Continuation |
9 |
= |
Printed |
|
TRANSTYPE |
6 |
Integer |
Transaction Type |
E A R X |
List:2 entries
1 |
= |
Withdrawals |
2 |
= |
Deposits |
|
TYPE |
7 |
Integer |
Detail Transaction Type |
E A X |
List:7 entries
1 |
= |
Check |
2 |
= |
EFT |
3 |
= |
Transfer |
4 |
= |
Service Charge |
5 |
= |
Credit Card |
6 |
= |
Cash |
7 |
= |
Other |
|
IDREMIT |
8 |
String*24 |
Remittance ID |
E A X |
|
DATEREMIT |
9 |
Date |
Transaction Date |
E A X |
|
BTCHNBR |
10 |
BCD*5.0 |
Batch Number |
E A X |
|
ENTRYNBR |
11 |
BCD*4.0 |
Entry Number |
E A X |
|
POSTSEQ |
12 |
BCD*5.0 |
Posting Sequence Number |
E A X |
|
REFERENCE |
13 |
String*60 |
Transaction Reference |
E A X |
|
COMMENT |
14 |
String*60 |
Transaction Description |
E A X |
|
PAYORID |
15 |
String*12 |
Payer Code |
E A X |
Mask: %-12C |
PAYORNAME |
16 |
String*60 |
Payee Name |
E A X |
|
VENDORNAME |
17 |
String*60 |
Vendor Name |
E A X |
|
SRCEAMOUNT |
18 |
BCD*10.3 |
Source Transaction Amount |
E A X |
|
FUNCAMOUNT |
19 |
BCD*10.3 |
Functional Transaction Amount |
E A X |
|
RATETYPE |
20 |
String*2 |
Exchange Rate Type |
E A X |
Mask: %-2N |
SRCECURN |
21 |
String*3 |
Receipt Currency |
E A X |
Mask: %-3N |
RATEDATE |
22 |
Date |
Exchange Rate Date |
E A X |
|
RATE |
23 |
BCD*8.7 |
Exchange Rate |
E A X |
|
RATESPREAD |
24 |
BCD*8.7 |
Rate Spread |
E A X |
|
RATEOP |
25 |
Integer |
Rate Operation |
E A X |
List:3 entries
1 |
= |
Multiply |
2 |
= |
Divide |
0 |
= |
Not Specified |
|
DISTCODE |
26 |
String*6 |
Distribution Code |
A X |
Mask: %-6N |
GLACCOUNT |
27 |
String*45 |
G/L Account |
A X |
Mask: %-45C |
DDTYPE |
33 |
Integer |
Drilldown Type |
E A |
|
DDLINK |
34 |
BCD*10.0 |
Drilldown Link |
E A |
|
RECSTATUS |
35 |
Integer |
Reconciliation Status |
A P X |
List:3 entries
1 |
= |
Not Posted |
2 |
= |
Void |
3 |
= |
Outstanding |
|
RECSTATCHG |
36 |
Date |
Status Change Date |
A C |
|
RECCOMMENT |
37 |
String*60 |
Reconciliation Description |
A X |
|
RECCLEARED |
38 |
BCD*10.3 |
Cleared Amount |
A X |
|
POSTDATE |
39 |
Date |
Reconciliation Posting Date |
A X |
|
POSTYEAR |
40 |
String*4 |
Reconciliation Posting Year |
A X |
Mask: %04D |
POSTPERIOD |
41 |
Integer |
Reconciliation Posting Period |
A P X |
List:1 entries
|
RECONCILED |
42 |
Boolean |
Reconciled |
A |
|
RECPENDING |
43 |
BCD*10.3 |
Remaining In Transit Amount |
A |
|
PAYMCODE |
44 |
String*12 |
Payment Code |
E A X |
|
CHKFORM |
45 |
String*6 |
Check Stock Code |
E A X |
Mask: %-6N |
OFXTID |
46 |
String*50 |
OFX Transaction ID |
A X |
|
FSCYEAR |
47 |
String*4 |
Fiscal Year |
E A X |
Mask: %04D |
FSCPERIOD |
48 |
Integer |
Fiscal Period |
E A P X |
List:13 entries
1 |
= |
1 |
2 |
= |
2 |
3 |
= |
3 |
4 |
= |
4 |
5 |
= |
5 |
6 |
= |
6 |
7 |
= |
7 |
8 |
= |
8 |
9 |
= |
9 |
10 |
= |
10 |
11 |
= |
11 |
12 |
= |
12 |
13 |
= |
13 |
|
REVDATE |
49 |
Date |
Reversal/Return Date |
A X |
|
SRCEDOCNUM |
50 |
String*22 |
Source Document Number |
E A X |
|
CANREVINVC |
51 |
Integer |
Can Reverse Invoice |
E A X |
List:2 entries
|
REVINVC |
52 |
Integer |
Reverse Invoice |
A X |
List:2 entries
|
COMPLETED |
53 |
Integer |
Reconciled and Journaled Transaction |
E A X |
List:2 entries
0 |
= |
Not Completed |
10 |
= |
Completed |
|
PSTSEQ |
54 |
BCD*5.0 |
Posting Sequence |
E A |
|
ENTRYTYPE |
55 |
Integer |
Entry Type |
E A X |
|
POSTED |
56 |
Date |
Document Posted Date |
E A X |
|
LSTRECSTAT |
57 |
Integer |
Last Reconciliation Status |
E A X |
|
RECLEVEL |
58 |
Integer |
Reconciled By |
A |
List:2 entries
0 |
= |
Reconciled by Header |
1 |
= |
Reconciled by Detail |
|
RECERR |
80 |
BCD*10.3 |
Reconciliation Error |
A C |
|
RECERRPEND |
81 |
BCD*10.3 |
Reconciliation Error Pending |
A C |
|
RECEXGAIN |
82 |
BCD*10.3 |
Reconciliation Exchange Gain |
A C |
|
RECEXLOSS |
83 |
BCD*10.3 |
Reconciliation Exchange Loss |
A C |
|
RECSUGGEST |
84 |
Integer |
Reconciliation Suggestion |
A C |
List:12 entries
1 |
= |
Not Posted |
2 |
= |
Void |
3 |
= |
Outstanding |
4 |
= |
Reversed |
5 |
= |
Cleared |
6 |
= |
Cleared with bank error |
7 |
= |
Non-negotiable |
8 |
= |
Continuation |
9 |
= |
Printed |
10 |
= |
Cleared with write-off |
11 |
= |
Cleared with exchange rate difference |
12 |
= |
Cleared with credit card charge |
|
RECAMOUNT |
85 |
BCD*10.3 |
Transaction Amount |
A C |
|
RECOUTSTND |
86 |
BCD*10.3 |
Outstanding Amount |
A C |
|
RECTARGET |
87 |
Integer |
Reconciliation Target |
A C |
List:6 entries
0 |
= |
No Target |
1 |
= |
Bank Error |
2 |
= |
Bank Pending Error |
3 |
= |
Exchange Gain |
4 |
= |
Exchange Loss |
5 |
= |
Credit Card Charge |
|
DCODEDESC |
88 |
String*60 |
Distribution Code Description |
A |
|
GLACCOUNTD |
89 |
String*60 |
G/L Account Description |
A |
|
RECDELTA |
90 |
BCD*10.3 |
Reconciliation Amount Delta |
A C |
|
LINEONE |
91 |
Long |
Line |
A C |
|
LINEPOST |
92 |
Long |
Line Outstanding |
A C |
|
LINEREC |
93 |
Long |
Line Reconciled |
A C |
|
RECCCC |
95 |
BCD*10.3 |
Reconciliation Credit Card Charge |
A C |
|
RECWOSUM |
96 |
BCD*10.3 |
Write-Off Amount |
A C |
|
CURFUNC |
97 |
String*3 |
Functional Currency |
A C |
|
CURSTMT |
98 |
String*3 |
Statement Currency |
A C |
|
SUMAMOUNT |
99 |
BCD*10.3 |
Summated Transaction Amount |
A C |
|
RECSPREAD |
100 |
BCD*10.3 |
Reconciliation Spread |
A C |
|
RECPAMOUNT |
101 |
BCD*10.3 |
Fiscal Transaction Remaining In Transit |
A C |
|
RECPOUTSTD |
102 |
BCD*10.3 |
Fiscal Outstanding Amount |
A C |
|
RECPWO |
103 |
BCD*10.3 |
Fiscal Write Offs |
A C |
|
RECPERR |
104 |
BCD*10.3 |
Fiscal Bank Errors |
A C |
|
RECPGAIN |
105 |
BCD*10.3 |
Fiscal Exchange Gain |
A C |
|
RECPLOSS |
106 |
BCD*10.3 |
Fiscal Exchange Loss |
A C |
|
RECPCCC |
107 |
BCD*10.3 |
Fiscal Credit Card Charge |
A C |
|
RECPCLR |
108 |
BCD*10.3 |
Fiscal Cleared |
A C |
|
RECPFUNAM |
109 |
BCD*10.3 |
Fiscal Functional Amount |
A C |
|
RECPORIG |
110 |
BCD*10.3 |
Fiscal Original Transaction Amount |
A C |
|
RECTBOOK |
111 |
BCD*10.3 |
Total Book Amount |
A C |
|
RECPBOOK |
112 |
BCD*10.3 |
Fiscal Book Amount |
A C |
|
RECTREMAIN |
113 |
BCD*10.3 |
Total Remaining Amount |
A C |
|
RECPREMAIN |
114 |
BCD*10.3 |
Fiscal Remaining Amount |
A C |
|
RECRWOSUM |
115 |
BCD*10.3 |
Fiscal Write-Off To This Period |
A C |
|
RECFCLR |
116 |
BCD*10.3 |
Fiscal Cleared To Future |
A C |
|
RECRCLR |
117 |
BCD*10.3 |
Fiscal Cleared To Current |
A C |
|
RECWOSUMR |
118 |
BCD*10.3 |
Current Period's Write-Off |
A C |
|
RECFCLRR |
119 |
BCD*10.3 |
Posted Fiscal Cleared To Future |
A C |
|
AGERECLD |
120 |
Integer |
No. of Days Since Reconciled |
A C |
|
STMTAMOUNT |
121 |
BCD*10.3 |
Statement Amount |
A C |
|
LINECCC |
122 |
Long |
Line Credit Card |
E A C |
|
LINEEXCH |
123 |
Long |
Line Exchange Difference |
E A C |
|
LINEREVINV |
124 |
Long |
Line Can Reverse Invoice |
E A C |
|
CURRTYPE |
125 |
Integer |
Bank Statement Type |
E A X |
|
RECYEAR |
126 |
String*4 |
Reconciliation Year |
E A X |
Mask: %04D |
RECPERIOD |
127 |
Integer |
Reconciliation Period |
E A X |
|
AMTDTLREC |
128 |
BCD*10.3 |
Reconcile by Detail Reconciled |
A C |
|
AMTDTLOUT |
129 |
BCD*10.3 |
Reconcile by Detail Outstanding |
A C |
|
|