Lawson Insight Technical Documentation |
|
TXTAXTABLE
TXTAXTABLE FILE
Tax Table
The Tax Table file contains tax table information. A tax table defines a
series of up to eight tax codes to be applied to a single transaction and it
defines how each tax code will affect the taxable amount of a transaction.
The tax table code can be assigned to a transaction to create up to eight
individual tax distribution records for the transaction.
REFERENCED BY
BL121 BL123 BL202 BL290 BL80.1 BR180
PO150 RQII.1 TX02.1 TX03.1 TX03.2 TX140
TX221 TX300
UPDATED BY
AC160 AC56.1 AC560 AM115 AM117 AM15.1
AM15.2 AM15.3 AM15.4 AM19.1 AM19.2 AM20.1
AM20.3 AM21.1 AM21.3 AM500 AM51.1 AM551
AM97.1 AP00.3 AP00.4 AP03.3 AP10.1 AP10.2
AP10.5 AP10.6 AP110 AP115 AP125 AP126
AP131 AP170 AP180 AP181 AP190 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.6 AP20.7
AP21.1 AP210 AP220 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP305 AP510
AP520 AP90.1 AP91.1 AP95.1 API1.1 API2.1
API3.1 API4.1 API5.1 AR08.1 AR10.1 AR115
AR124 AR15.4 AR190 AR20.1 AR21.1 AR21.2
AR21.3 AR24.1 AR29.2 AR30.1 AR32.1 AR34.1
AR42.1 AR42.2 AR42.7 AR43.1 AR550 AR560
AR570 AR575 AR580 ARLL.1 BL01.1 BL02.1
BL09.1 BL120 BL122 BL130 BL20.1 BL20.3
BL20.5 BL20.6 BL21.2 BL21.5 BL29.1 BL29.2
BL30.1 BL30.2 BL30.3 BL30.5 BL31.1 BL31.2
BL31.3 BL31.5 BL31.7 BL32.1 BL32.2 BL32.3
BL32.4 BL520 BL802 BL820 BL92.1 BR00.1
BR00.2 BR02.3 BR11.1 BR120 BR121 BR122
BR123 BR140 BR151 BR152 BR156 BR16.1
BR20.1 BR20.2 BR20.3 BR20.4 BR20.5 BR20.6
BR420 BR46.1 BR46.2 BR46.4 BR48.1 BR521
CB03.2 CB10.1 CB10.3 CB150 CB191 CB20.1
CB30.1 CB43.1 CB44.1 CB45.1 CB46.1 CB50.1
CB500 CB54.1 CB543 CB544 CB55.1 CB554
CXCP.1 DT180 DT181 EE05.1 EE20.3 EE520
ET175 ET542 IC02.1 IC11.1 IC12.1 IC130
IC330 IC811 IC812 MX123 MX500 MA08.1
MA180 MA208 MA279 MA310 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6 MA43.7 MA530 MA531 MA540 MA60.2
MA60.3 MA60.5 MA61.1 MA63.1 MA65.1 MA66.2
MA66.3 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PD235 PO10.1
PO100 PO101 PO120 PO122 PO131 PO132
PO135 PO136 PO190 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO220 PO223
PO229 PO23.1 PO233 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO253 PO254 PO26.1 PO27.2
PO278 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.1 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.1 PO54.2 PO54.3 PO54.4 POED.1 POI3.1
POI7.1 POID.1 POIF.1 POIG.1 POII.1 POIJ.1
POIM.1 POIT.1 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQIB.1 RQIC.1 RQID.1 RQIF.1 RQIG.1
RQIJ.1 TX01.2 TX804 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXT-TAX-TABLE Alpha 10 AC160 AC56.1
Element: Tax Table A user-defined code for the tax table. AC560 AM115
This field represents up to eight AM117 AM15.1
individual tax codes to be applied to AM15.2 AM15.3
the same transaction. AM15.4 AM19.1
AM19.2 AM20.1
The tax table code must have already AM20.3 AM21.1
been defined using TX01.1 (Tax Code AM21.3 AM500
Master). AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-EFFECT-DATE Numeric 8 (yyyymmdd) AC160 AC56.1
Element: Effect Date The effective date for the tax table. AC560 AM115
More than one tax table can exist with AM117 AM15.1
the same name and different effective AM15.2 AM15.3
dates. AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-DESCRIPTION Alpha 30 (Lower Case) AC160 AC56.1
Element: Description The name or description of the tax AC560 AM115
table. AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-TAX-CODE1 Alpha 10 AC160 AC56.1
Element: Tax Code The first tax code in the tax table. AC560 AM115
The first tax code is used to calculate AM117 AM15.1
the sales tax based on the taxable AM15.2 AM15.3
transaction amount. The tax code must AM15.4 AM19.1
have already been defined using TX01.1 AM19.2 AM20.1
(Tax Code Master). AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-FLAG1 Alpha 1 AC160 AC56.1
Element: Flag1 This field indicates what the effect AC560 AM115
will be on taxable amounts for the next AM117 AM15.1
tax code in the table. The tax rate AM15.2 AM15.3
defined for the first tax code in the AM15.4 AM19.1
table will be calculated against the AM19.2 AM20.1
taxable amount of the transaction. AM20.3 AM21.1
AM21.3 AM500
Leave the field blank to have no effect AM51.1 AM551
on the next tax code's taxable amount. AM97.1 AP00.3
AP00.4 AP03.3
Add means that the value of that AP10.1 AP10.2
calculation will be added to the AP10.5 AP10.6
transaction's taxable amount for the AP110 AP115
next tax code. AP125 AP126
AP131 AP170
Subtract means that the value of that AP180 AP181
tax calculation will be subtracted from AP190 AP20.1
the taxable amount of the transaction AP20.2 AP20.3
for the next tax code. AP20.4 AP20.5
+ = Add To Taxable AP20.6 AP20.7
- = Subtract From Taxable AP21.1 AP210
" " = No Effect On Taxable AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-TAX-CODE2 Alpha 10 AC160 AC56.1
Element: Tax Code The second tax code in the tax table. AC560 AM115
You must have defined the tax code using AM117 AM15.1
TX01.1 (Tax Code Master). AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-FLAG2 Alpha 1 AC160 AC56.1
Element: Flag1 This field indicates what the effect AC560 AM115
will be on the taxable amounts for the AM117 AM15.1
next tax code in the table. AM15.2 AM15.3
AM15.4 AM19.1
Leave the field blank to have no effect AM19.2 AM20.1
on the next tax code's taxable amount. AM20.3 AM21.1
AM21.3 AM500
Add means that the value of that tax AM51.1 AM551
calculation will be added to the AM97.1 AP00.3
transaction's taxable amount for the AP00.4 AP03.3
next tax code. AP10.1 AP10.2
AP10.5 AP10.6
Subtract means that the value of that AP110 AP115
tax calculation will be subtracted from AP125 AP126
the taxable amount of the transaction AP131 AP170
for the next tax code. AP180 AP181
+ = Add To Taxable AP190 AP20.1
- = Subtract From Taxable AP20.2 AP20.3
" " = No Effect On Taxable AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-TAX-CODE3 Alpha 10 AC160 AC56.1
Element: Tax Code The third tax code in the tax table. AC560 AM115
You must have already defined the tax AM117 AM15.1
code using TX01.1 (Tax Code Master). AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-FLAG3 Alpha 1 AC160 AC56.1
Element: Flag1 This field indicates what the effect AC560 AM115
will be on taxable amounts for the next AM117 AM15.1
tax code in the table. AM15.2 AM15.3
AM15.4 AM19.1
Leave the field blank to have no effect AM19.2 AM20.1
on the next tax code's taxable amount. AM20.3 AM21.1
AM21.3 AM500
Add means that the value of that tax AM51.1 AM551
calculation will be added to the taxable AM97.1 AP00.3
amount of the transaction for the next AP00.4 AP03.3
tax code. AP10.1 AP10.2
AP10.5 AP10.6
Subtract means that the value of that AP110 AP115
tax calculation will be subtracted from AP125 AP126
the taxable amount of the transaction AP131 AP170
for the next tax code. AP180 AP181
+ = Add To Taxable AP190 AP20.1
- = Subtract From Taxable AP20.2 AP20.3
" " = No Effect On Taxable AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-TAX-CODE4 Alpha 10 AC160 AC56.1
Element: Tax Code The fourth tax code in the tax table. AC560 AM115
You must have already defined the tax AM117 AM15.1
code using TX01.1 (Tax Code Master). AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-FLAG4 Alpha 1 AC160 AC56.1
Element: Flag1 This field indicates what the effect AC560 AM115
will be on taxable amounts for the next AM117 AM15.1
tax code in the table. AM15.2 AM15.3
AM15.4 AM19.1
Leave the field blank to have no effect AM19.2 AM20.1
on the next tax code's taxable amount. AM20.3 AM21.1
AM21.3 AM500
Add means that the value of that tax AM51.1 AM551
calculation will be added to the taxable AM97.1 AP00.3
amount of the transaction for the next AP00.4 AP03.3
tax code. AP10.1 AP10.2
AP10.5 AP10.6
Subtract means that the value of that AP110 AP115
tax calculation will be subtracted from AP125 AP126
the taxable amount of the transaction AP131 AP170
for the next tax code. AP180 AP181
+ = Add To Taxable AP190 AP20.1
- = Subtract From Taxable AP20.2 AP20.3
" " = No Effect On Taxable AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-TAX-CODE5 Alpha 10 AC160 AC56.1
Element: Tax Code The fifth tax code in the tax table. AC560 AM115
You must have already defined the tax AM117 AM15.1
code using TX01.1 (Tax Code Master). AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-FLAG5 Alpha 1 AC160 AC56.1
Element: Flag1 This field indicates what the effect AC560 AM115
will be on taxable amounts for the next AM117 AM15.1
tax code in the table. AM15.2 AM15.3
AM15.4 AM19.1
Leave the field blank to have no effect AM19.2 AM20.1
on the next tax code's taxable amount. AM20.3 AM21.1
AM21.3 AM500
Add means that the value of that tax AM51.1 AM551
calculation will be added to the taxable AM97.1 AP00.3
amount of the transaction for the next AP00.4 AP03.3
tax code. AP10.1 AP10.2
AP10.5 AP10.6
Subtract means that the value of that AP110 AP115
tax calculation will be subtracted from AP125 AP126
the taxable amount of the transaction AP131 AP170
for the next tax code. AP180 AP181
+ = Add To Taxable AP190 AP20.1
- = Subtract From Taxable AP20.2 AP20.3
" " = No Effect On Taxable AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-TAX-CODE6 Alpha 10 AC160 AC56.1
Element: Tax Code The sixth tax code in the tax table. AC560 AM115
You must have already defined the tax AM117 AM15.1
code using TX01.1 (Tax Code Master). AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-FLAG6 Alpha 1 AC160 AC56.1
Element: Flag1 This field indicates what the effect AC560 AM115
will be on taxable amounts for the next AM117 AM15.1
tax code in the table. AM15.2 AM15.3
AM15.4 AM19.1
Leave the field blank to have no effect AM19.2 AM20.1
on the next tax code's taxable amount. AM20.3 AM21.1
AM21.3 AM500
Add means that the value of that tax AM51.1 AM551
calculation will be added to the taxable AM97.1 AP00.3
amount of the transaction for the next AP00.4 AP03.3
tax code. AP10.1 AP10.2
AP10.5 AP10.6
Subtract means that the value of that AP110 AP115
tax calculation will be subtracted from AP125 AP126
the taxable amount of the transaction AP131 AP170
for the next tax code. AP180 AP181
+ = Add To Taxable AP190 AP20.1
- = Subtract From Taxable AP20.2 AP20.3
" " = No Effect On Taxable AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-TAX-CODE7 Alpha 10 AC160 AC56.1
Element: Tax Code The seventh tax code in the tax table. AC560 AM115
You must have already defined the tax AM117 AM15.1
code using TX01.1 (Tax Code Master). AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-FLAG7 Alpha 1 AC160 AC56.1
Element: Flag1 This field indicates what the effect AC560 AM115
will be on taxable amounts for the next AM117 AM15.1
tax code in the table. AM15.2 AM15.3
AM15.4 AM19.1
Leave the field blank to have no effect AM19.2 AM20.1
on the next tax code's taxable amount. AM20.3 AM21.1
AM21.3 AM500
Add means that the value of that tax AM51.1 AM551
calculation will be added to the taxable AM97.1 AP00.3
amount of the transaction for the next AP00.4 AP03.3
tax code. AP10.1 AP10.2
AP10.5 AP10.6
Subtract means that the value of that AP110 AP115
tax calculation will be subtracted from AP125 AP126
the taxable amount of the transaction AP131 AP170
for the next tax code. AP180 AP181
+ = Add To Taxable AP190 AP20.1
- = Subtract From Taxable AP20.2 AP20.3
" " = No Effect On Taxable AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-TAX-CODE8 Alpha 10 AC160 AC56.1
Element: Tax Code The eighth tax code in the tax table. AC560 AM115
You must have already defined the tax AM117 AM15.1
code using TX01.1 (Tax Code Master). AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXT-FLAG8 Alpha 1 AC160 AC56.1
Element: Flag1 The taxable effect for the last tax AC560 AM115
code in the table must be blank. AM117 AM15.1
+ = Add To Taxable AM15.2 AM15.3
- = Subtract From Taxable AM15.4 AM19.1
" " = No Effect On Taxable AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.6 AP20.7
AP21.1 AP210
AP220 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP305 AP510
AP520 AP90.1
AP91.1 AP95.1
API1.1 API2.1
...
TXTAXTABLE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXTSET1 TAX-TABLE AC160 AC56.1
EFFECT-DATE* AC560 AM115
AM117 AM15.1
AM15.2 AM15.3
AM15.4 AM19.1
AM19.2 AM20.1
AM20.3 AM21.1
AM21.3 AM500
AM51.1 AM551
AM97.1 AP00.3
AP00.4 AP03.3
AP10.1 AP10.2
AP10.5 AP10.6
AP110 AP115
AP125 AP126
...
TXTAXTABLE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Code 1 Mast TXCODEMAST Required
TXT-TAX-CODE1 -> TCM-TAX-CODE
Code 2 Mast TXCODEMAST Required
When TXT-TAX-CODE2 != Spaces
TXT-TAX-CODE2 -> TCM-TAX-CODE
Code 3 Mast TXCODEMAST Required
When TXT-TAX-CODE3 != Spaces
TXT-TAX-CODE3 -> TCM-TAX-CODE
Code 4 Mast TXCODEMAST Required
When TXT-TAX-CODE4 != Spaces
TXT-TAX-CODE4 -> TCM-TAX-CODE
Code 5 Mast TXCODEMAST Required
When TXT-TAX-CODE5 != Spaces
TXT-TAX-CODE5 -> TCM-TAX-CODE
Code 6 Mast TXCODEMAST Required
When TXT-TAX-CODE6 != Spaces
TXT-TAX-CODE6 -> TCM-TAX-CODE
Code 7 Mast TXCODEMAST Required
When TXT-TAX-CODE7 != Spaces
TXT-TAX-CODE7 -> TCM-TAX-CODE
Code 8 Mast TXCODEMAST Required
When TXT-TAX-CODE8 != Spaces
TXT-TAX-CODE8 -> TCM-TAX-CODE
Txcodemast TXCODEMAST Required
TXT-TAX-TABLE -> TCM-TAX-CODE
|