Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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