TXTAXTABLE

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
TX02.1 TX03.1 TX03.2 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 AM22.1 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 AP150 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 AP271 AP30.2
AP30.4 AP300 AP305 AP510 AP520 AP90.1
AP91.1 AP95.1 API1.1 API2.1 API3.1 API4.1
API5.1 AR08.1 AR10.1 AR15.4 AR550 ARLL.1
BR00.1 BR00.2 BR02.3 BR11.1 BR120 BR121
BR122 BR123 BR140 BR151 BR152 BR156
BR16.1 BR180 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 CB10.5
CB150 CB191 CB20.1 CB20.6 CB30.1 CB43.1
CB44.1 CB45.1 CB46.1 CB50.1 CB500 CB54.1
CB543 CB544 CB55.1 CB554 CX05.1 CX05.2
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CX805 CXCP.1 EE05.1
EE11.1 EE20.3 EE520 DR100 IC02.1 IC10.1
IC10.2 IC11.1 IC12.1 IC130 IC140 IC141
IC142 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
IC802 IC81.1 IC811 IC812 IC83.1 IC840
EX175 EX542 MX123 MX500 MA08.1 MA180
MA208 MA26.1 MA279 MA310 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA530 MA531 MA540 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAED.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 PO150 PO190 PO20.1 PO20.6 PO20.9
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.2 PO22.3 PO22.4 PO22.5 PO220 PO223
PO229 PO23.1 PO233 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO253 PO254 PO26.1 PO26.2
PO26.3 PO26.4 PO26.5 PO26.6 PO26.7 PO26.9
PO27.2 PO278 PO28.2 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 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 PO54.5 POCP.1 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 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ260 RQ35.1 RQ500 RQIA.1 RQIB.1 RQIC.1
RQID.1 RQIF.1 RQIG.1 RQII.1 RQIJ.1 TX01.2
TX140 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 WH32.5 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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TXT-TAX-TABLE
Element: Tax Table
Alpha 10
A user-defined code for the tax table. This field represents up to eight individual tax codes to be applied to the same transaction. The tax table code must have already been defined using TX01.1 (Tax Code Master).
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
The effective date for the tax table. More than one tax table can exist with the same name and different effective dates.
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The name or description of the tax table.
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-TAX-CODE1
Element: Tax Code
Alpha 10
The first tax code in the tax table. The first tax code is used to calculate the sales tax based on the taxable transaction amount. The tax code must have already been defined using TX01.1 (Tax Code Master).
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-FLAG1
Element: Flag1
Alpha 1
This field indicates what the effect will be on taxable amounts for the next tax code in the table. The tax rate defined for the first tax code in the table will be calculated against the taxable amount of the transaction. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that calculation will be added to the transaction's taxable amount for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code.
+ = Add To Taxable
- = Subtract From Taxable
" " = No Effect On Taxable
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-TAX-CODE2
Element: Tax Code
Alpha 10
The second tax code in the tax table. You must have defined the tax code using TX01.1 (Tax Code Master).
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-FLAG2
Element: Flag1
Alpha 1
This field indicates what the effect will be on the taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the transaction's taxable amount for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code.
+ = Add To Taxable
- = Subtract From Taxable
" " = No Effect On Taxable
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-TAX-CODE3
Element: Tax Code
Alpha 10
The third tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-FLAG3
Element: Flag1
Alpha 1
This field indicates what the effect will be on taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the taxable amount of the transaction for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code.
+ = Add To Taxable
- = Subtract From Taxable
" " = No Effect On Taxable
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-TAX-CODE4
Element: Tax Code
Alpha 10
The fourth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-FLAG4
Element: Flag1
Alpha 1
This field indicates what the effect will be on taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the taxable amount of the transaction for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code.
+ = Add To Taxable
- = Subtract From Taxable
" " = No Effect On Taxable
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-TAX-CODE5
Element: Tax Code
Alpha 10
The fifth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-FLAG5
Element: Flag1
Alpha 1
This field indicates what the effect will be on taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the taxable amount of the transaction for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code.
+ = Add To Taxable
- = Subtract From Taxable
" " = No Effect On Taxable
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-TAX-CODE6
Element: Tax Code
Alpha 10
The sixth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-FLAG6
Element: Flag1
Alpha 1
This field indicates what the effect will be on taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the taxable amount of the transaction for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code.
+ = Add To Taxable
- = Subtract From Taxable
" " = No Effect On Taxable
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-TAX-CODE7
Element: Tax Code
Alpha 10
The seventh tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-FLAG7
Element: Flag1
Alpha 1
This field indicates what the effect will be on taxable amounts for the next tax code in the table. Leave the field blank to have no effect on the next tax code's taxable amount. Add means that the value of that tax calculation will be added to the taxable amount of the transaction for the next tax code. Subtract means that the value of that tax calculation will be subtracted from the taxable amount of the transaction for the next tax code.
+ = Add To Taxable
- = Subtract From Taxable
" " = No Effect On Taxable
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-TAX-CODE8
Element: Tax Code
Alpha 10
The eighth tax code in the tax table. You must have already defined the tax code using TX01.1 (Tax Code Master).
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1
TXT-FLAG8
Element: Flag1
Alpha 1
The taxable effect for the last tax code in the table must be blank.
+ = Add To Taxable
- = Subtract From Taxable
" " = No Effect On Taxable
...
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 AM22.1
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
AP150 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
AP271 AP30.2
AP30.4 AP300
AP305 AP510
AP520 AP90.1


TXTAXTABLE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TXTSET1 TAX-TABLE
EFFECT-DATE*
...
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 AM22.1
AM500 AM51.1
AM551 AM97.1
AP00.3 AP00.4
AP03.3 AP10.1
AP10.2 AP10.5
AP10.6 AP110
AP115 AP125


TXTAXTABLE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:29:34 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.