| PSTSEQ |
1 |
BCD*5.0 |
Posting Sequence |
E A K R |
|
| BANK |
2 |
String*8 |
Bank Code |
E A K R |
Mask: %-8N |
| UNIQUE |
3 |
Long |
Entry Uniquifier |
E A K R |
|
| DATE |
4 |
Date |
Entry Date |
E A |
|
| TYPE |
5 |
String*6 |
Transaction Type |
E A |
Mask: %-6N |
| REFERENCE |
6 |
String*60 |
Reference |
E A |
|
| COMMENT |
7 |
String*60 |
Comment |
E A |
|
| AMOUNT |
8 |
BCD*10.3 |
Amount |
E A |
|
| SRCEAMT |
9 |
BCD*10.3 |
Source Amount |
E A |
|
| RATETYPE |
10 |
String*2 |
Exchange Rate Type |
E A |
Mask: %-2N |
| SRCECURN |
11 |
String*3 |
Payment Currency |
E A |
Mask: %-3N |
| RATEDATE |
12 |
Date |
Exchange Rate Date |
E A |
|
| RATE |
13 |
BCD*8.7 |
Exchange Rate |
E A |
|
| RATESPREAD |
14 |
BCD*8.7 |
Rate Spread |
E A |
|
| RATEOP |
15 |
Integer |
Rate Operation |
E A |
List: 3 entries
| 1 | = | Multiply | | 2 | = | Divide | | 0 | = | Not Specified |
|
| SRCEAMTCR |
16 |
BCD*10.3 |
Source Credit Amount |
E A |
|
| SRCEAMTDR |
17 |
BCD*10.3 |
Source Debit Amount |
E A |
|
| AMTCR |
18 |
BCD*10.3 |
Credit Amount |
E A |
|
| AMTDR |
19 |
BCD*10.3 |
Debit Amount |
E A |
|
| ENTRYAMT |
20 |
BCD*10.3 |
Statement Amount |
E A |
|
| IDACCT |
21 |
String*45 |
G/L Account |
E A |
Mask: %-45C |
| IDACCTOVR |
22 |
Boolean |
Account Number Override |
E A |
|
| ENTRYTYPE |
23 |
Integer |
Entry Type |
E A |
List: 4 entries
| 0 | = | User-entered | | 10 | = | Unmatched OFX | | 19 | = | Unmatched OFX correction | | 20 | = | Unmatched OFX error |
|
| RECYEAR |
24 |
String*4 |
Reconciliation Fiscal Year |
E A |
Mask: %04D |
| RECPERIOD |
25 |
Integer |
Reconciliation Fiscal Period |
E A |
List: 14 entries
| 0 | = | | | 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 |
|
| RECONCILED |
26 |
Boolean |
Reconciled |
E A |
|
| BIGCOMMENT |
27 |
String*250 |
Comments |
E A |
|
| RECPENT |
28 |
BCD*10.3 |
Fiscal Entry Amount |
E A |
|
| RECPENTREC |
29 |
BCD*10.3 |
Reconciled Entry Amount |
E A |
|
| CURFUNC |
30 |
String*3 |
Functional Currency |
E A |
|
| CURSTMT |
31 |
String*3 |
Statement Currency |
E A |
|
| SWTAXBL |
32 |
Integer |
Taxable |
E A |
List: 2 entries
|
| TXAMTCALC |
33 |
Integer |
Tax Amount Calculation |
E A |
List: 2 entries
|
| CODETAXGRP |
34 |
String*12 |
Tax Group |
E A |
Mask: %-12N |
| TAXAUTH1 |
35 |
String*12 |
Tax Authority 1 |
E A |
Mask: %-12N |
| TAXAUTH2 |
36 |
String*12 |
Tax Authority 2 |
E A |
Mask: %-12N |
| TAXAUTH3 |
37 |
String*12 |
Tax Authority 3 |
E A |
Mask: %-12N |
| TAXAUTH4 |
38 |
String*12 |
Tax Authority 4 |
E A |
Mask: %-12N |
| TAXAUTH5 |
39 |
String*12 |
Tax Authority 5 |
E A |
Mask: %-12N |
| TAXVCLSS1 |
40 |
Integer |
Tax Vendor Class 1 |
E A |
|
| TAXVCLSS2 |
41 |
Integer |
Tax Vendor Class 2 |
E A |
|
| TAXVCLSS3 |
42 |
Integer |
Tax Vendor Class 3 |
E A |
|
| TAXVCLSS4 |
43 |
Integer |
Tax Vendor Class 4 |
E A |
|
| TAXVCLSS5 |
44 |
Integer |
Tax Vendor Class 5 |
E A |
|
| TAXICLSS1 |
45 |
Integer |
Tax Item Class 1 |
E A |
|
| TAXICLSS2 |
46 |
Integer |
Tax Item Class 2 |
E A |
|
| TAXICLSS3 |
47 |
Integer |
Tax Item Class 3 |
E A |
|
| TAXICLSS4 |
48 |
Integer |
Tax Item Class 4 |
E A |
|
| TAXICLSS5 |
49 |
Integer |
Tax Item Class 5 |
E A |
|
| TAXINCL1 |
50 |
Integer |
Tax Include 1 |
E A |
List: 2 entries
|
| TAXINCL2 |
51 |
Integer |
Tax Include 2 |
E A |
List: 2 entries
|
| TAXINCL3 |
52 |
Integer |
Tax Include 3 |
E A |
List: 2 entries
|
| TAXINCL4 |
53 |
Integer |
Tax Include 4 |
E A |
List: 2 entries
|
| TAXINCL5 |
54 |
Integer |
Tax Include 5 |
E A |
List: 2 entries
|
| BASETAX1 |
55 |
BCD*10.3 |
Tax Base Amount 1 |
E A |
|
| BASETAX2 |
56 |
BCD*10.3 |
Tax Base Amount 2 |
E A |
|
| BASETAX3 |
57 |
BCD*10.3 |
Tax Base Amount 3 |
E A |
|
| BASETAX4 |
58 |
BCD*10.3 |
Tax Base Amount 4 |
E A |
|
| BASETAX5 |
59 |
BCD*10.3 |
Tax Base Amount 5 |
E A |
|
| BASETAXRC1 |
60 |
BCD*10.3 |
Tax Base Retainage amount1 |
E A |
|
| BASETAXRC2 |
61 |
BCD*10.3 |
Tax Base Retainage amount2 |
E A |
|
| BASETAXRC3 |
62 |
BCD*10.3 |
Tax Base Retainage amount3 |
E A |
|
| BASETAXRC4 |
63 |
BCD*10.3 |
Tax Base Retainage amount4 |
E A |
|
| BASETAXRC5 |
64 |
BCD*10.3 |
Tax Base Retainage amount5 |
E A |
|
| TXCALCBASE |
65 |
Integer |
Tax Base Calculation Method |
E A |
List: 2 entries
|
| AMTTAX1 |
66 |
BCD*10.3 |
Tax Amount 1 |
E A |
|
| AMTTAX2 |
67 |
BCD*10.3 |
Tax Amount 2 |
E A |
|
| AMTTAX3 |
68 |
BCD*10.3 |
Tax Amount 3 |
E A |
|
| AMTTAX4 |
69 |
BCD*10.3 |
Tax Amount 4 |
E A |
|
| AMTTAX5 |
70 |
BCD*10.3 |
Tax Amount 5 |
E A |
|
| AMTTXBL |
71 |
BCD*10.3 |
Taxable Amount |
E A |
|
| AMTNOTTXBL |
72 |
BCD*10.3 |
Non Taxable Amount |
E A |
|
| AMTTAXTOT |
73 |
BCD*10.3 |
Tax Total |
E A |
|
| AMTDOCTOT |
74 |
BCD*10.3 |
Document Total Before Tax |
E A |
|
| AMTNETTOT |
75 |
BCD*10.3 |
Document Total Including Tax |
E A |
|
| AMTINCLUDE |
76 |
BCD*10.3 |
Total Included Amount |
E A |
|
| AMTEXCLUDE |
77 |
BCD*10.3 |
Total Excluded Amount |
E A |
|
| AMTDIST |
78 |
BCD*10.3 |
Tax Distribution amount |
E A |
|
| AMTNETDIST |
79 |
BCD*10.3 |
Tax Net Distribution Amount |
E A |
|
| AMTGRODIST |
80 |
BCD*10.3 |
Tax Gross Distribution Amount |
E A |
|
| AMTEXPENS1 |
81 |
BCD*10.3 |
Tax Expense Amount 1 |
E A |
|
| AMTEXPENS2 |
82 |
BCD*10.3 |
Tax Expense Amount 2 |
E A |
|
| AMTEXPENS3 |
83 |
BCD*10.3 |
Tax Expense Amount 3 |
E A |
|
| AMTEXPENS4 |
84 |
BCD*10.3 |
Tax Expense Amount 4 |
E A |
|
| AMTEXPENS5 |
85 |
BCD*10.3 |
Tax Expense Amount 5 |
E A |
|
| AMTRECVRB1 |
86 |
BCD*10.3 |
Tax Recoverable Amount 1 |
E A |
|
| AMTRECVRB2 |
87 |
BCD*10.3 |
Tax Recoverable Amount 2 |
E A |
|
| AMTRECVRB3 |
88 |
BCD*10.3 |
Tax Recoverable Amount 3 |
E A |
|
| AMTRECVRB4 |
89 |
BCD*10.3 |
Tax Recoverable Amount 4 |
E A |
|
| AMTRECVRB5 |
90 |
BCD*10.3 |
Tax Recoverable Amount 5 |
E A |
|
| TOTAMTALOC |
91 |
BCD*10.3 |
Total Tax Allocated Amount |
E A |
|
| TXAMT1RC |
92 |
BCD*10.3 |
Tax Reporting Amount 1 |
E A |
|
| TXAMT2RC |
93 |
BCD*10.3 |
Tax Reporting Amount 2 |
E A |
|
| TXAMT3RC |
94 |
BCD*10.3 |
Tax Reporting Amount 3 |
E A |
|
| TXAMT4RC |
95 |
BCD*10.3 |
Tax Reporting Amount 4 |
E A |
|
| TXAMT5RC |
96 |
BCD*10.3 |
Tax Reporting Amount 5 |
E A |
|
| TXALOCRC |
97 |
BCD*10.3 |
Total Tax Reporting Allocated Amount |
E A |
|
| TXEXPNSRC |
98 |
BCD*10.3 |
Tax Reporting Expensed Amount |
E A |
|
| TXRECVBRC |
99 |
BCD*10.3 |
Tax Reporting Recoverable Amount |
E A |
|
| TXTOTRC |
100 |
BCD*10.3 |
Total Tax Reporting Amount |
E A |
|
| TAXVERSION |
101 |
Long |
Tax Version |
E A |
|
| TXCALCRMET |
102 |
Integer |
Tax Calculation Reporting Method |
E A |
List: 2 entries
|
| CODECURNRC |
103 |
String*3 |
Tax Reporting Currency Code |
E A |
Mask: %-3N |
| RATERC |
104 |
BCD*8.7 |
Tax Reporting Rate |
E A |
|
| RATETYPERC |
105 |
String*2 |
Tax Reporting Rate Type |
E A |
Mask: %-2N |
| RATEDATERC |
106 |
Date |
Tax Reporting Rate Date |
E A |
|
| RATEOPRC |
107 |
Integer |
Tax Reporting Rate Operation |
E A |
List: 3 entries
| 1 | = | Multiply | | 2 | = | Divide | | 0 | = | Not Specified |
|
| TXAU1DESC |
108 |
String*60 |
Tax Authority Description 1 |
E A |
|
| TXAU2DESC |
109 |
String*60 |
Tax Authority Description 2 |
E A |
|
| TXAU3DESC |
110 |
String*60 |
Tax Authority Description 3 |
E A |
|
| TXAU4DESC |
111 |
String*60 |
Tax Authority Description 4 |
E A |
|
| TXAU5DESC |
112 |
String*60 |
Tax Authority Description 5 |
E A |
|
| VCLS1DESC |
113 |
String*60 |
Vendor Tax Class Description 1 |
E A |
|
| VCLS2DESC |
114 |
String*60 |
Vendor Tax Class Description 2 |
E A |
|
| VCLS3DESC |
115 |
String*60 |
Vendor Tax Class Description 3 |
E A |
|
| VCLS4DESC |
116 |
String*60 |
Vendor Tax Class Description 4 |
E A |
|
| VCLS5DESC |
117 |
String*60 |
Vendor Tax Class Description 5 |
E A |
|
| ICLS1DESC |
118 |
String*60 |
Item Tax Class Description 1 |
E A |
|
| ICLS2DESC |
119 |
String*60 |
Item Tax Class Description 2 |
E A |
|
| ICLS3DESC |
120 |
String*60 |
Item Tax Class Description 3 |
E A |
|
| ICLS4DESC |
121 |
String*60 |
Item Tax Class Description 4 |
E A |
|
| ICLS5DESC |
122 |
String*60 |
Item Tax Class Description 5 |
E A |
|
| FUNTXAMT1 |
123 |
BCD*10.3 |
Functional Tax Amount 1 |
E A |
|
| FUNTXAMT2 |
124 |
BCD*10.3 |
Functional Tax Amount 2 |
E A |
|
| FUNTXAMT3 |
125 |
BCD*10.3 |
Functional Tax Amount 3 |
E A |
|
| FUNTXAMT4 |
126 |
BCD*10.3 |
Functional Tax Amount 4 |
E A |
|
| FUNTXAMT5 |
127 |
BCD*10.3 |
Functional Tax Amount 5 |
E A |
|
| FUNTXBSE1 |
128 |
BCD*10.3 |
Functional Tax Base Amount 1 |
E A |
|
| FUNTXBSE2 |
129 |
BCD*10.3 |
Functional Tax Base Amount 2 |
E A |
|
| FUNTXBSE3 |
130 |
BCD*10.3 |
Functional Tax Base Amount 3 |
E A |
|
| FUNTXBSE4 |
131 |
BCD*10.3 |
Functional Tax Base Amount 4 |
E A |
|
| FUNTXBSE5 |
132 |
BCD*10.3 |
Functional Tax Base Amount 5 |
E A |
|
| FUNNETTAX |
133 |
BCD*10.3 |
Functional Net of Tax |
E A |
|
| FUNGRODIS |
134 |
BCD*10.3 |
Functional Gross Distribution Amount |
E A |
|
| FUNAMTALOC |
135 |
BCD*10.3 |
Functional Total Tax Allocated |
E A |
|
| TAXRATE1 |
136 |
BCD*8.7 |
Tax Rate 1 |
E A |
|
| TAXRATE2 |
137 |
BCD*8.7 |
Tax Rate 2 |
E A |
|
| TAXRATE3 |
138 |
BCD*8.7 |
Tax Rate 3 |
E A |
|
| TAXRATE4 |
139 |
BCD*8.7 |
Tax Rate 4 |
E A |
|
| TAXRATE5 |
140 |
BCD*8.7 |
Tax Rate 5 |
E A |
|
| FUNTXEXP1 |
141 |
BCD*10.3 |
Functional Expensed Amount 1 |
E A |
|
| FUNTXEXP2 |
142 |
BCD*10.3 |
Functional Expensed Amount 2 |
E A |
|
| FUNTXEXP3 |
143 |
BCD*10.3 |
Functional Expensed Amount 3 |
E A |
|
| FUNTXEXP4 |
144 |
BCD*10.3 |
Functional Expensed Amount 4 |
E A |
|
| FUNTXEXP5 |
145 |
BCD*10.3 |
Functional Expensed Amount 5 |
E A |
|
| FUNTXRCB1 |
146 |
BCD*10.3 |
Functional Recoverable Amount 1 |
E A |
|
| FUNTXRCB2 |
147 |
BCD*10.3 |
Functional Recoverable Amount 2 |
E A |
|
| FUNTXRCB3 |
148 |
BCD*10.3 |
Functional Recoverable Amount 3 |
E A |
|
| FUNTXRCB4 |
149 |
BCD*10.3 |
Functional Recoverable Amount 4 |
E A |
|
| FUNTXRCB5 |
150 |
BCD*10.3 |
Functional Recoverable Amount 5 |
E A |
|
| TXRECVB1RC |
151 |
BCD*10.3 |
Tax Reporting Recoverable Amount 1 |
E A |
|
| TXRECVB2RC |
152 |
BCD*10.3 |
Tax Reporting Recoverable Amount 2 |
E A |
|
| TXRECVB3RC |
153 |
BCD*10.3 |
Tax Reporting Recoverable Amount 3 |
E A |
|
| TXRECVB4RC |
154 |
BCD*10.3 |
Tax Reporting Recoverable Amount 4 |
E A |
|
| TXRECVB5RC |
155 |
BCD*10.3 |
Tax Reporting Recoverable Amount 5 |
E A |
|
| TXGRPDESC |
156 |
String*60 |
Tax Group Description |
E A |
|
| CURNRCDESC |
157 |
String*60 |
Tax Reporting Currency Description |
E A |
|
| RATERCDESC |
158 |
String*60 |
Tax Reporting RateType Description |
E A |
|
| EXPNSACNT1 |
159 |
String*45 |
Tax Expense Account 1 |
E A |
|
| EXPNSACNT2 |
160 |
String*45 |
Tax Expense Account 2 |
E A |
|
| EXPNSACNT3 |
161 |
String*45 |
Tax Expense Account 3 |
E A |
|
| EXPNSACNT4 |
162 |
String*45 |
Tax Expense Account 4 |
E A |
|
| EXPNSACNT5 |
163 |
String*45 |
Tax Expense Account 5 |
E A |
|
| RECBLACNT1 |
164 |
String*45 |
Tax Recoverable Account 1 |
E A |
|
| RECBLACNT2 |
165 |
String*45 |
Tax Recoverable Account 2 |
E A |
|
| RECBLACNT3 |
166 |
String*45 |
Tax Recoverable Account 3 |
E A |
|
| RECBLACNT4 |
167 |
String*45 |
Tax Recoverable Account 4 |
E A |
|
| RECBLACNT5 |
168 |
String*45 |
Tax Recoverable Account 5 |
E A |
|
|