| SEQUENCENO |
1 |
Long |
Sequence Number |
E A K R |
|
| LINE |
2 |
Long |
Line Number |
E A K R |
|
| BANK |
3 |
String*8 |
Bank |
A |
|
| POSTDATE |
4 |
Date |
Reserved |
E A C |
|
| DISTCODE |
5 |
String*6 |
Distribution Code |
E A |
Mask: %-6N |
| REFERENCE |
6 |
String*60 |
Reference |
E A |
|
| COMMENT |
7 |
String*60 |
Description |
E A |
|
| AMOUNT |
8 |
BCD*10.3 |
Amount |
A C |
|
| SRCEAMT |
9 |
BCD*10.3 |
Source Amount |
E A |
|
| RATETYPE |
10 |
String*2 |
Reserved |
E A C |
|
| SRCECURN |
11 |
String*3 |
Reserved |
E A C |
|
| RATEDATE |
12 |
Date |
Reserved |
E A C |
|
| RATE |
13 |
BCD*8.7 |
Reserved |
E A C |
|
| RATESPREAD |
14 |
BCD*8.7 |
Reserved |
E A C |
|
| RATEOP |
15 |
Integer |
Reserved |
E A C |
|
| GLACCOUNT |
16 |
String*45 |
G/L Account |
E A X |
Mask: %-45C |
| ENTRYTYPE |
17 |
Integer |
Entry Type |
E A P |
List: 4 entries
| 0 | = | User-entered | | 10 | = | Unmatched OFX | | 19 | = | Unmatched OFX correction | | 20 | = | Unmatched OFX error |
|
| BIGCOMMENT |
18 |
String*250 |
Comments |
E A |
|
| ENTRYAMT |
26 |
BCD*10.3 |
Statement Amount |
A |
|
| SRCEGROAMT |
27 |
BCD*10.3 |
Gross Source Amount |
A |
|
| FUNCGROAMT |
28 |
BCD*10.3 |
Gross Amount |
A |
|
| DISTCODED |
29 |
String*60 |
Distribution Code Description |
A |
|
| GLACCOUNTD |
30 |
String*60 |
G/L Account Description |
A |
|
| LINEONE |
31 |
Long |
Line |
A |
|
| SETDEFAULT |
32 |
Integer |
Set Default Setup Values |
E A C |
|
| CREATEDIST |
33 |
Integer |
Call for Create Distribution |
E A C |
|
| SWTAXBL |
50 |
Integer |
Taxable |
E A C |
List: 2 entries
|
| TXAMTCALC |
51 |
Integer |
Tax Amount Calculation |
E A |
List: 2 entries
|
| CODETAXGRP |
52 |
String*12 |
Tax Group |
E A |
Mask: %-12N |
| TAXAUTH1 |
53 |
String*12 |
Tax Authority 1 |
E A C |
Mask: %-12N |
| TAXAUTH2 |
54 |
String*12 |
Tax Authority 2 |
E A C |
Mask: %-12N |
| TAXAUTH3 |
55 |
String*12 |
Tax Authority 3 |
E A C |
Mask: %-12N |
| TAXAUTH4 |
56 |
String*12 |
Tax Authority 4 |
E A C |
Mask: %-12N |
| TAXAUTH5 |
57 |
String*12 |
Tax Authority 5 |
E A C |
Mask: %-12N |
| TAXVCLSS1 |
58 |
Integer |
Tax Vendor Class 1 |
E A |
|
| TAXVCLSS2 |
59 |
Integer |
Tax Vendor Class 2 |
E A |
|
| TAXVCLSS3 |
60 |
Integer |
Tax Vendor Class 3 |
E A |
|
| TAXVCLSS4 |
61 |
Integer |
Tax Vendor Class 4 |
E A |
|
| TAXVCLSS5 |
62 |
Integer |
Tax Vendor Class 5 |
E A |
|
| TAXICLSS1 |
63 |
Integer |
Tax Item Class 1 |
E A |
|
| TAXICLSS2 |
64 |
Integer |
Tax Item Class 2 |
E A |
|
| TAXICLSS3 |
65 |
Integer |
Tax Item Class 3 |
E A |
|
| TAXICLSS4 |
66 |
Integer |
Tax Item Class 4 |
E A |
|
| TAXICLSS5 |
67 |
Integer |
Tax Item Class 5 |
E A |
|
| TAXINCL1 |
68 |
Integer |
Tax Include 1 |
E A |
List: 2 entries
|
| TAXINCL2 |
69 |
Integer |
Tax Include 2 |
E A |
List: 2 entries
|
| TAXINCL3 |
70 |
Integer |
Tax Include 3 |
E A |
List: 2 entries
|
| TAXINCL4 |
71 |
Integer |
Tax Include 4 |
E A |
List: 2 entries
|
| TAXINCL5 |
72 |
Integer |
Tax Include 5 |
E A |
List: 2 entries
|
| BASETAX1 |
73 |
BCD*10.3 |
Tax Base Amount 1 |
E A |
|
| BASETAX2 |
74 |
BCD*10.3 |
Tax Base Amount 2 |
E A |
|
| BASETAX3 |
75 |
BCD*10.3 |
Tax Base Amount 3 |
E A |
|
| BASETAX4 |
76 |
BCD*10.3 |
Tax Base Amount 4 |
E A |
|
| BASETAX5 |
77 |
BCD*10.3 |
Tax Base Amount 5 |
E A |
|
| TXCALCBASE |
78 |
Integer |
Tax Base Calculation Method |
E A |
List: 2 entries
|
| AMTTAX1 |
79 |
BCD*10.3 |
Tax Amount 1 |
E A |
|
| AMTTAX2 |
80 |
BCD*10.3 |
Tax Amount 2 |
E A |
|
| AMTTAX3 |
81 |
BCD*10.3 |
Tax Amount 3 |
E A |
|
| AMTTAX4 |
82 |
BCD*10.3 |
Tax Amount 4 |
E A |
|
| AMTTAX5 |
83 |
BCD*10.3 |
Tax Amount 5 |
E A |
|
| AMTTXBL |
84 |
BCD*10.3 |
Taxable AMount |
E A C |
|
| AMTNOTTXBL |
85 |
BCD*10.3 |
Non Taxable Amount |
E A C |
|
| AMTTAXTOT |
86 |
BCD*10.3 |
Tax Total |
E A C |
|
| AMTDOCTOT |
87 |
BCD*10.3 |
Document Total Before Tax |
E A C |
|
| AMTNETTOT |
88 |
BCD*10.3 |
Document Total Including Tax |
E A C |
|
| AMTDIST |
89 |
BCD*10.3 |
Tax Distribution amount |
E A C |
|
| AMTINCLUDE |
90 |
BCD*10.3 |
Total Included Amount |
E A C |
|
| AMTNETDIST |
91 |
BCD*10.3 |
Tax Net Distribution Amount |
E A C |
|
| AMTEXCLUDE |
92 |
BCD*10.3 |
Total Excluded Amount |
E A C |
|
| AMTGRODIST |
93 |
BCD*10.3 |
Tax Gross Distribution Amount |
E A C |
|
| AMTEXPENS1 |
94 |
BCD*10.3 |
Tax Expense Amount 1 |
E A C |
|
| AMTEXPENS2 |
95 |
BCD*10.3 |
Tax Expense Amount 2 |
E A C |
|
| AMTEXPENS3 |
96 |
BCD*10.3 |
Tax Expense Amount 3 |
E A C |
|
| AMTEXPENS4 |
97 |
BCD*10.3 |
Tax Expense Amount 4 |
E A C |
|
| AMTEXPENS5 |
98 |
BCD*10.3 |
Tax Expense Amount 5 |
E A C |
|
| AMTRECVRB1 |
99 |
BCD*10.3 |
Tax Recoverable Amount 1 |
E A C |
|
| AMTRECVRB2 |
100 |
BCD*10.3 |
Tax Recoverable Amount 2 |
E A C |
|
| AMTRECVRB3 |
101 |
BCD*10.3 |
Tax Recoverable Amount 3 |
E A C |
|
| AMTRECVRB4 |
102 |
BCD*10.3 |
Tax Recoverable Amount 4 |
E A C |
|
| AMTRECVRB5 |
103 |
BCD*10.3 |
Tax Recoverable Amount 5 |
E A C |
|
| AMTALLOC1 |
104 |
BCD*10.3 |
Tax Allocated Amount 1 |
E A C |
|
| AMTALLOC2 |
105 |
BCD*10.3 |
Tax Allocated Amount 2 |
E A C |
|
| AMTALLOC3 |
106 |
BCD*10.3 |
Tax Allocated Amount 3 |
E A C |
|
| AMTALLOC4 |
107 |
BCD*10.3 |
Tax Allocated Amount 4 |
E A C |
|
| AMTALLOC5 |
108 |
BCD*10.3 |
Tax Allocated Amount 5 |
E A C |
|
| TOTAMTALOC |
109 |
BCD*10.3 |
Total Tax Allocated Amount |
E A C |
|
| TXAMT1RC |
110 |
BCD*10.3 |
Tax Reporting Amount 1 |
E A |
|
| TXAMT2RC |
111 |
BCD*10.3 |
Tax Reporting Amount 2 |
E A |
|
| TXAMT3RC |
112 |
BCD*10.3 |
Tax Reporting Amount 3 |
E A |
|
| TXAMT4RC |
113 |
BCD*10.3 |
Tax Reporting Amount 4 |
E A |
|
| TXAMT5RC |
114 |
BCD*10.3 |
Tax Reporting Amount 5 |
E A |
|
| TXEXPNS1RC |
115 |
BCD*10.3 |
Tax Reporting Expensed 1 |
E A C |
|
| TXEXPNS2RC |
116 |
BCD*10.3 |
Tax Reporting Expensed 2 |
E A C |
|
| TXEXPNS3RC |
117 |
BCD*10.3 |
Tax Reporting Expensed 3 |
E A C |
|
| TXEXPNS4RC |
118 |
BCD*10.3 |
Tax Reporting Expensed 4 |
E A C |
|
| TXEXPNS5RC |
119 |
BCD*10.3 |
Tax Reporting Expensed 5 |
E A C |
|
| TXRECVB1RC |
120 |
BCD*10.3 |
Tax Reporting Recoverable Amount 1 |
E A C |
|
| TXRECVB2RC |
121 |
BCD*10.3 |
Tax Reporting Recoverable Amount 2 |
E A C |
|
| TXRECVB3RC |
122 |
BCD*10.3 |
Tax Reporting Recoverable Amount 3 |
E A C |
|
| TXRECVB4RC |
123 |
BCD*10.3 |
Tax Reporting Recoverable Amount 4 |
E A C |
|
| TXRECVB5RC |
124 |
BCD*10.3 |
Tax Reporting Recoverable Amount 5 |
E A C |
|
| TXALLOC1RC |
125 |
BCD*10.3 |
Tax Reporting Allocated Amount 1 |
E A C |
|
| TXALLOC2RC |
126 |
BCD*10.3 |
Tax Reporting Allocated Amount 2 |
E A C |
|
| TXALLOC3RC |
127 |
BCD*10.3 |
Tax Reporting Allocated Amount 3 |
E A C |
|
| TXALLOC4RC |
128 |
BCD*10.3 |
Tax Reporting Allocated Amount 4 |
E A C |
|
| TXALLOC5RC |
129 |
BCD*10.3 |
Tax Reporting Allocated Amount 5 |
E A C |
|
| TXALOCRC |
130 |
BCD*10.3 |
Total Tax Reporting Allocated Amount |
E A C |
|
| TXTOTRC |
131 |
BCD*10.3 |
Total Tax Reporting Amount |
E A C |
|
| FUNNETTAX |
132 |
BCD*10.3 |
Functional Net of Tax |
E A C |
|
| FUNGRODIS |
133 |
BCD*10.3 |
Functional Gross Distribution Amount |
E A C |
|
| TAXVERSION |
134 |
Long |
Tax Version |
E A C |
|
| TXCALCRMET |
135 |
Integer |
Tax Calculation Reporting Method |
E A |
List: 2 entries
|
| CODECURNRC |
136 |
String*3 |
Tax Reporting Currency Code |
E A |
Mask: %-3N |
| RATERC |
137 |
BCD*8.7 |
Tax Reporting Rate |
E A |
|
| RATETYPERC |
138 |
String*2 |
Tax Reporting Rate Type |
E A |
Mask: %-2N |
| RATEDATERC |
139 |
Date |
Tax Reporting Rate Date |
E A |
|
| RATEOPRC |
140 |
Integer |
Tax Reporting Rate Operation |
E A C |
List: 3 entries
| 1 | = | Multiply | | 2 | = | Divide | | 0 | = | Not Specified |
|
| EXPNSACNT1 |
141 |
String*45 |
Tax Expense Account 1 |
E A X |
Mask: %-45C |
| EXPNSACNT2 |
142 |
String*45 |
Tax Expense Account 2 |
E A X |
Mask: %-45C |
| EXPNSACNT3 |
143 |
String*45 |
Tax Expense Account 3 |
E A X |
Mask: %-45C |
| EXPNSACNT4 |
144 |
String*45 |
Tax Expense Account 4 |
E A X |
Mask: %-45C |
| EXPNSACNT5 |
145 |
String*45 |
Tax Expense Account 5 |
E A X |
Mask: %-45C |
| RECBLACNT1 |
146 |
String*45 |
Tax Recoverable Account 1 |
E A X |
Mask: %-45C |
| RECBLACNT2 |
147 |
String*45 |
Tax Recoverable Account 2 |
E A X |
Mask: %-45C |
| RECBLACNT3 |
148 |
String*45 |
Tax Recoverable Account 3 |
E A X |
Mask: %-45C |
| RECBLACNT4 |
149 |
String*45 |
Tax Recoverable Account 4 |
E A X |
Mask: %-45C |
| RECBLACNT5 |
150 |
String*45 |
Tax Recoverable Account 5 |
E A X |
Mask: %-45C |
| TAXRATE1 |
151 |
BCD*8.7 |
Tax Rate 1 |
E A |
|
| TAXRATE2 |
152 |
BCD*8.7 |
Tax Rate 2 |
E A |
|
| TAXRATE3 |
153 |
BCD*8.7 |
Tax Rate 3 |
E A |
|
| TAXRATE4 |
154 |
BCD*8.7 |
Tax Rate 4 |
E A |
|
| TAXRATE5 |
155 |
BCD*8.7 |
Tax Rate 5 |
E A |
|
| TXGRPDESC |
200 |
String*60 |
Tax Group Description |
E A C |
|
| PROCESSCMD |
201 |
Integer |
Tax Process Command |
E A X |
List: 2 entries
| 0 | = | Calculate Taxes | | 1 | = | Derive Tax Reporting Exchange Rate |
|
| TXAU1DESC |
202 |
String*60 |
Tax Authority Description 1 |
E A C |
|
| TXAU2DESC |
203 |
String*60 |
Tax Authority Description 2 |
E A C |
|
| TXAU3DESC |
204 |
String*60 |
Tax Authority Description 3 |
E A C |
|
| TXAU4DESC |
205 |
String*60 |
Tax Authority Description 4 |
E A C |
|
| TXAU5DESC |
206 |
String*60 |
Tax Authority Description 5 |
E A C |
|
| VCLS1DESC |
207 |
String*60 |
Vendor Tax Class Description 1 |
E A C |
|
| VCLS2DESC |
208 |
String*60 |
Vendor Tax Class Description 2 |
E A C |
|
| VCLS3DESC |
209 |
String*60 |
Vendor Tax Class Description 3 |
E A C |
|
| VCLS4DESC |
210 |
String*60 |
Vendor Tax Class Description 4 |
E A C |
|
| VCLS5DESC |
211 |
String*60 |
Vendor Tax Class Description 5 |
E A C |
|
| ICLS1DESC |
212 |
String*60 |
Item Tax Class Description 1 |
E A C |
|
| ICLS2DESC |
213 |
String*60 |
Item Tax Class Description 2 |
E A C |
|
| ICLS3DESC |
214 |
String*60 |
Item Tax Class Description 3 |
E A C |
|
| ICLS4DESC |
215 |
String*60 |
Item Tax Class Description 4 |
E A C |
|
| ICLS5DESC |
216 |
String*60 |
Item Tax Class Description 5 |
E A C |
|
| FUNTXAMT1 |
217 |
BCD*10.3 |
Functional Tax Amount 1 |
E A C |
|
| FUNTXAMT2 |
218 |
BCD*10.3 |
Functional Tax Amount 2 |
E A C |
|
| FUNTXAMT3 |
219 |
BCD*10.3 |
Functional Tax Amount 3 |
E A C |
|
| FUNTXAMT4 |
220 |
BCD*10.3 |
Functional Tax Amount 4 |
E A C |
|
| FUNTXAMT5 |
221 |
BCD*10.3 |
Functional Tax Amount 5 |
E A C |
|
| FUNTXBSE1 |
222 |
BCD*10.3 |
Functional Tax Base Amount 1 |
E A C |
|
| FUNTXBSE2 |
223 |
BCD*10.3 |
Functional Tax Base Amount 2 |
E A C |
|
| FUNTXBSE3 |
224 |
BCD*10.3 |
Functional Tax Base Amount 3 |
E A C |
|
| FUNTXBSE4 |
225 |
BCD*10.3 |
Functional Tax Base Amount 4 |
E A C |
|
| FUNTXBSE5 |
226 |
BCD*10.3 |
Functional Tax Base Amount 5 |
E A C |
|
| FUNTOTTAX |
227 |
BCD*10.3 |
Functional Tax Total |
E A C |
|
| FUNTXEXP1 |
228 |
BCD*10.3 |
Functional Expensed Amount 1 |
E A C |
|
| FUNTXEXP2 |
229 |
BCD*10.3 |
Functional Expensed Amount 2 |
E A C |
|
| FUNTXEXP3 |
230 |
BCD*10.3 |
Functional Expensed Amount 3 |
E A C |
|
| FUNTXEXP4 |
231 |
BCD*10.3 |
Functional Expensed Amount 4 |
E A C |
|
| FUNTXEXP5 |
232 |
BCD*10.3 |
Functional Expensed Amount 5 |
E A C |
|
| FUNTXRCB1 |
233 |
BCD*10.3 |
Functional Recoverable Amount 1 |
E A C |
|
| FUNTXRCB2 |
234 |
BCD*10.3 |
Functional Recoverable Amount 2 |
E A C |
|
| FUNTXRCB3 |
235 |
BCD*10.3 |
Functional Recoverable Amount 3 |
E A C |
|
| FUNTXRCB4 |
236 |
BCD*10.3 |
Functional Recoverable Amount 4 |
E A C |
|
| FUNTXRCB5 |
237 |
BCD*10.3 |
Functional Recoverable Amount 5 |
E A C |
|
| FUNTXALOC1 |
238 |
BCD*10.3 |
Functional Allocated Amount 1 |
E A C |
|
| FUNTXALOC2 |
239 |
BCD*10.3 |
Functional Allocated Amount 2 |
E A C |
|
| FUNTXALOC3 |
240 |
BCD*10.3 |
Functional Allocated Amount 3 |
E A C |
|
| FUNTXALOC4 |
241 |
BCD*10.3 |
Functional Allocated Amount 4 |
E A C |
|
| FUNTXALOC5 |
242 |
BCD*10.3 |
Functional Allocated Amount 5 |
E A C |
|
| FUNAMTALOC |
243 |
BCD*10.3 |
Functional Total Tax Allocated |
E A C |
|
| CURNRCDESC |
244 |
String*60 |
Tax Reporting Currency Description |
E A C |
|
| RATERCDESC |
245 |
String*60 |
Tax Reporting RateType Description |
E A C |
|
|