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 PO150
PO54.4 RQII.1 TX02.1 TX03.1 TX03.2 TX140
TX221 TX300
UPDATED BY
AM115 AM117 AM15.1 AM15.2 AM15.3 AM15.4
AM20.1 AM20.3 AM21.1 AM21.3 AM500 AM51.1
AM551 AM97.1 AP00.3 AP10.1 AP10.2 AP10.5
AP10.6 AP110 AP125 AP126 AP131 AP170
AP180 AP181 AP190 AP220 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP510 AP520
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 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 BL520 BL802 BL820 BL92.1
BR00.1 BR00.2 BR02.3 BR11.1 BR120 BR121
BR122 BR140 BR16.1 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR20.6 BR420 BR46.1 BR46.2
BR46.4 BR521 CB03.2 CB10.1 CB10.3 CB191
CB20.1 CB30.1 CB500 CXCP.1 DT180 DT181
EE05.1 EE20.3 EE520 DR100 IC02.1 IC10.1
IC10.2 IC11.1 IC12.1 IC141 IC142 IC28.1
IC330 IC811 IC812 IC83.1 IC840 MA08.1
MA180 MA208 MA530 MA531 MA540 MA60.2
MA60.3 MA60.5 MA61.1 MA65.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE112 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.1
OE14.2 OE14.4 OE229 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE80.1 OE80.2 OE80.3 OE80.4 OE80.5
OE81.1 OE810 OE830 OE90.1 OE90.2 PO100
PO101 PO122 PO131 PO132 PO20.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO220 PO23.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 POED.1 POI3.1 POI7.1 POIE.1
POIF.1 POIG.1 POII.1 POIJ.1 POIM.1 POIT.1
PR05.1 PR05.3 PR197 PR226 PR247 PR26.1
PR47.1 UK47.1 RQ10.1 RQ10.2 RQ10.3 RQ11.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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXT-TAX-TABLE Alpha 10 AM115 AM117
Element: Tax Table A user-defined code for the tax table. AM15.1 AM15.2
This field represents up to eight AM15.3 AM15.4
individual tax codes to be applied to AM20.1 AM20.3
the same transaction. AM21.1 AM21.3
AM500 AM51.1
The tax table code must have already AM551 AM97.1
been defined using TX01.1 (Tax Code AP00.3 AP10.1
Master). AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-EFFECT-DATE Numeric 8 (yyyymmdd) AM115 AM117
Element: Effective DateThe effective date for the tax table. AM15.1 AM15.2
More than one tax table can exist with AM15.3 AM15.4
the same name and different effective AM20.1 AM20.3
dates. AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-DESCRIPTION Alpha 30 (Lower Case) AM115 AM117
Element: Description The name or description of the tax AM15.1 AM15.2
table. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-TAX-CODE1 Alpha 10 AM115 AM117
Element: Tax Code The first tax code in the tax table. AM15.1 AM15.2
The first tax code is used to calculate AM15.3 AM15.4
the sales tax based on the taxable AM20.1 AM20.3
transaction amount. The tax code must AM21.1 AM21.3
have already been defined using TX01.1 AM500 AM51.1
(Tax Code Master). AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-FLAG1 Alpha 1 AM115 AM117
Tax Distrib. Flag - This field indicates what the effect AM15.1 AM15.2
Tax Code 1 will be on taxable amounts for the next AM15.3 AM15.4
tax code in the table. The tax rate AM20.1 AM20.3
defined for the first tax code in the AM21.1 AM21.3
table will be calculated against the AM500 AM51.1
taxable amount of the transaction. AM551 AM97.1
AP00.3 AP10.1
Leave the field blank to have no effect AP10.2 AP10.5
on the next tax code's taxable amount. AP10.6 AP110
AP125 AP126
Add means that the value of that AP131 AP170
calculation will be added to the AP180 AP181
transaction's taxable amount for the AP190 AP220
next tax code. AP25.1 AP25.2
AP26.1 AP27.1
Subtract means that the value of that AP30.2 AP30.4
tax calculation will be subtracted from AP510 AP520
the taxable amount of the transaction AP95.1 API1.1
for the next tax code. API2.1 API3.1
+ = Add To Taxable API4.1 API5.1
- = Subtract From Taxable AR08.1 AR10.1
" " = No Effect On Taxable AR115 AR124
AR15.4 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-TAX-CODE2 Alpha 10 AM115 AM117
Element: Tax Code The second tax code in the tax table. AM15.1 AM15.2
You must have defined the tax code using AM15.3 AM15.4
TX01.1 (Tax Code Master). AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-FLAG2 Alpha 1 AM115 AM117
Tax Distrib. Flag - This field indicates what the effect AM15.1 AM15.2
Tax Code 1 will be on the taxable amounts for the AM15.3 AM15.4
next tax code in the table. AM20.1 AM20.3
AM21.1 AM21.3
Leave the field blank to have no effect AM500 AM51.1
on the next tax code's taxable amount. AM551 AM97.1
AP00.3 AP10.1
Add means that the value of that tax AP10.2 AP10.5
calculation will be added to the AP10.6 AP110
transaction's taxable amount for the AP125 AP126
next tax code. AP131 AP170
AP180 AP181
Subtract means that the value of that AP190 AP220
tax calculation will be subtracted from AP25.1 AP25.2
the taxable amount of the transaction AP26.1 AP27.1
for the next tax code. AP30.2 AP30.4
+ = Add To Taxable AP510 AP520
- = Subtract From Taxable AP95.1 API1.1
" " = No Effect On Taxable 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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-TAX-CODE3 Alpha 10 AM115 AM117
Element: Tax Code The third tax code in the tax table. AM15.1 AM15.2
You must have already defined the tax AM15.3 AM15.4
code using TX01.1 (Tax Code Master). AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-FLAG3 Alpha 1 AM115 AM117
Tax Distrib. Flag - This field indicates what the effect AM15.1 AM15.2
Tax Code 1 will be on taxable amounts for the next AM15.3 AM15.4
tax code in the table. AM20.1 AM20.3
AM21.1 AM21.3
Leave the field blank to have no effect AM500 AM51.1
on the next tax code's taxable amount. AM551 AM97.1
AP00.3 AP10.1
Add means that the value of that tax AP10.2 AP10.5
calculation will be added to the taxable AP10.6 AP110
amount of the transaction for the next AP125 AP126
tax code. AP131 AP170
AP180 AP181
Subtract means that the value of that AP190 AP220
tax calculation will be subtracted from AP25.1 AP25.2
the taxable amount of the transaction AP26.1 AP27.1
for the next tax code. AP30.2 AP30.4
+ = Add To Taxable AP510 AP520
- = Subtract From Taxable AP95.1 API1.1
" " = No Effect On Taxable 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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-TAX-CODE4 Alpha 10 AM115 AM117
Element: Tax Code The fourth tax code in the tax table. AM15.1 AM15.2
You must have already defined the tax AM15.3 AM15.4
code using TX01.1 (Tax Code Master). AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-FLAG4 Alpha 1 AM115 AM117
Tax Distrib. Flag - This field indicates what the effect AM15.1 AM15.2
Tax Code 1 will be on taxable amounts for the next AM15.3 AM15.4
tax code in the table. AM20.1 AM20.3
AM21.1 AM21.3
Leave the field blank to have no effect AM500 AM51.1
on the next tax code's taxable amount. AM551 AM97.1
AP00.3 AP10.1
Add means that the value of that tax AP10.2 AP10.5
calculation will be added to the taxable AP10.6 AP110
amount of the transaction for the next AP125 AP126
tax code. AP131 AP170
AP180 AP181
Subtract means that the value of that AP190 AP220
tax calculation will be subtracted from AP25.1 AP25.2
the taxable amount of the transaction AP26.1 AP27.1
for the next tax code. AP30.2 AP30.4
+ = Add To Taxable AP510 AP520
- = Subtract From Taxable AP95.1 API1.1
" " = No Effect On Taxable 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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-TAX-CODE5 Alpha 10 AM115 AM117
Element: Tax Code The fifth tax code in the tax table. AM15.1 AM15.2
You must have already defined the tax AM15.3 AM15.4
code using TX01.1 (Tax Code Master). AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-FLAG5 Alpha 1 AM115 AM117
Tax Distrib. Flag - This field indicates what the effect AM15.1 AM15.2
Tax Code 1 will be on taxable amounts for the next AM15.3 AM15.4
tax code in the table. AM20.1 AM20.3
AM21.1 AM21.3
Leave the field blank to have no effect AM500 AM51.1
on the next tax code's taxable amount. AM551 AM97.1
AP00.3 AP10.1
Add means that the value of that tax AP10.2 AP10.5
calculation will be added to the taxable AP10.6 AP110
amount of the transaction for the next AP125 AP126
tax code. AP131 AP170
AP180 AP181
Subtract means that the value of that AP190 AP220
tax calculation will be subtracted from AP25.1 AP25.2
the taxable amount of the transaction AP26.1 AP27.1
for the next tax code. AP30.2 AP30.4
+ = Add To Taxable AP510 AP520
- = Subtract From Taxable AP95.1 API1.1
" " = No Effect On Taxable 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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-TAX-CODE6 Alpha 10 AM115 AM117
Element: Tax Code The sixth tax code in the tax table. AM15.1 AM15.2
You must have already defined the tax AM15.3 AM15.4
code using TX01.1 (Tax Code Master). AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-FLAG6 Alpha 1 AM115 AM117
Tax Distrib. Flag - This field indicates what the effect AM15.1 AM15.2
Tax Code 1 will be on taxable amounts for the next AM15.3 AM15.4
tax code in the table. AM20.1 AM20.3
AM21.1 AM21.3
Leave the field blank to have no effect AM500 AM51.1
on the next tax code's taxable amount. AM551 AM97.1
AP00.3 AP10.1
Add means that the value of that tax AP10.2 AP10.5
calculation will be added to the taxable AP10.6 AP110
amount of the transaction for the next AP125 AP126
tax code. AP131 AP170
AP180 AP181
Subtract means that the value of that AP190 AP220
tax calculation will be subtracted from AP25.1 AP25.2
the taxable amount of the transaction AP26.1 AP27.1
for the next tax code. AP30.2 AP30.4
+ = Add To Taxable AP510 AP520
- = Subtract From Taxable AP95.1 API1.1
" " = No Effect On Taxable 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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-TAX-CODE7 Alpha 10 AM115 AM117
Element: Tax Code The seventh tax code in the tax table. AM15.1 AM15.2
You must have already defined the tax AM15.3 AM15.4
code using TX01.1 (Tax Code Master). AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-FLAG7 Alpha 1 AM115 AM117
Tax Distrib. Flag - This field indicates what the effect AM15.1 AM15.2
Tax Code 1 will be on taxable amounts for the next AM15.3 AM15.4
tax code in the table. AM20.1 AM20.3
AM21.1 AM21.3
Leave the field blank to have no effect AM500 AM51.1
on the next tax code's taxable amount. AM551 AM97.1
AP00.3 AP10.1
Add means that the value of that tax AP10.2 AP10.5
calculation will be added to the taxable AP10.6 AP110
amount of the transaction for the next AP125 AP126
tax code. AP131 AP170
AP180 AP181
Subtract means that the value of that AP190 AP220
tax calculation will be subtracted from AP25.1 AP25.2
the taxable amount of the transaction AP26.1 AP27.1
for the next tax code. AP30.2 AP30.4
+ = Add To Taxable AP510 AP520
- = Subtract From Taxable AP95.1 API1.1
" " = No Effect On Taxable 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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-TAX-CODE8 Alpha 10 AM115 AM117
Element: Tax Code The eighth tax code in the tax table. AM15.1 AM15.2
You must have already defined the tax AM15.3 AM15.4
code using TX01.1 (Tax Code Master). AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXT-FLAG8 Alpha 1 AM115 AM117
Tax Distrib. Flag - The taxable effect for the last tax AM15.1 AM15.2
Tax Code 1 code in the table must be blank. AM15.3 AM15.4
+ = Add To Taxable AM20.1 AM20.3
- = Subtract From Taxable AM21.1 AM21.3
" " = No Effect On Taxable AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
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 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
...
TXTAXTABLE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXTSET1 TAX-TABLE This index is used to access the most AM115 AM117
EFFECT-DATE* recent tax table record using a AM15.1 AM15.2
descending key. AM15.3 AM15.4
AM20.1 AM20.3
AM21.1 AM21.3
AM500 AM51.1
AM551 AM97.1
AP00.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP125 AP126
AP131 AP170
AP180 AP181
AP190 AP220
AP25.1 AP25.2
...
TXTSET3 TAX-TABLE This index is used to access tax tables
EFFECT-DATE without using a descending key.
KeyChange
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 (TCMSET1)
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
|