Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            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    TX02.1
TX03.1    TX03.2    TX140     TX300

UPDATED BY

AC15.1    AP00.3    AP10.1    AP10.2    AP10.5    AP10.6
AP110     AP125     AP126     AP170     AP180     AP181
AP190     AP20.1    AP20.2    AP20.5    AP20.6    AP20.7
AP225     AP226     AP23.1    AP25.1    AP25.2    AP26.1
AP30.2    AP32.2    AP510     AP520     AR08.1    AR10.1
AR115     AR124     AR15.4    AR190     AR20.1    AR21.1
AR21.2    AR21.3    AR24.1    AR29.2    AR30.1    AR30.2
AR30.4    AR42.1    AR42.2    AR42.7    AR43.1    AR550
AR560     AR570     AR575     AR580     AR82.1    BL02.1
BL08.1    BL09.1    BL120     BL122     BL130     BL20.1
BL20.3    BL21.2    BL21.5    BL29.1    BL29.2    BL520
BL802     BL820     BL902     BL92.1    BL940     CB03.2
CB10.1    CB10.3    CB191     CB20.1    CB30.1    CB500
CX05.1    CX05.2    CX100     CX20.1    CX20.2    CX20.4
CX20.5    CX220     CX30.1    CX300     CX506     CX805
CXCP.1    DT180     DT181     EE05.3    EE20.3    EE520
DR100     IC02.1    IC10.1    IC10.2    IC11.1    IC12.1
IC141     IC142     IC811     IC812     IC83.1    IN20.1
MA08.1    MA140     MA208     MA40.1    MA40.2    MA41.1
MA41.2    MA41.4    MA41.5    MA41.6    MA43.1    MA43.2
MA43.3    MA43.4    MA52.1    MA530     MA540     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
OE112     OE113     OE114     OE129     OE14.1    OE14.2
OE14.4    OE15.1    OE15.2    OE15.3    OE15.4    OE15.5
OE15.7    OE30.1    OE30.2    OE30.3    OE30.4    OE30.5
OE30.6    OE30.7    OE30.9    OE510     OE80.1    OE80.2
OE80.3    OE80.4    OE80.5    OE810     OE830     OE920
OE950     PBIP.1    PO100     PO120     PO121     PO122
PO123     PO132     PO20.1    PO21.1    PO21.2    PO21.5
PO21.6    PO22.1    PO22.2    PO22.3    PO220     PO225
PO25.1    PO25.3    PO25.4    PO25.7    PO28.3    PO28.8
PO31.1    PO820     PO821     RQ10.1    RQ10.3    RQ11.1
RQ20.1    RQ20.3    RQ20.4    RQ35.1    RQ500     TX01.2
TX804     TX904     TX955     WH130     WH132     WH190
WH20.2    WH20.7    WH222     WH30.1    WH30.2    WH30.3
WH31.1    WH31.2    WH31.3    WH32.1    WH32.2    WH32.3
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                                    AC15.1  AP00.3
Tax Table            A user-defined code for the tax table.      AP10.1  AP10.2
                     This field represents up to eight           AP10.5  AP10.6
                     individual tax codes to be applied to       AP110   AP125
                     the same transaction.                       AP126   AP170
                                                                 AP180   AP181
                     The tax table code must have already        AP190   AP20.1
                     been defined using TX01.1 (Tax Code         AP20.2  AP20.5
                     Master).                                    AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-EFFECT-DATE      Numeric 8  (yyyymmdd)                       AC15.1  AP00.3
Effective Date       The effective date for the tax table.       AP10.1  AP10.2
                     More than one tax table can exist with      AP10.5  AP10.6
                     the same name and different effective       AP110   AP125
                     dates.                                      AP126   AP170
                                                                 AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-DESCRIPTION      Alpha 30  (Lower Case)                      AC15.1  AP00.3
Description          The name or description of the tax          AP10.1  AP10.2
                     table.                                      AP10.5  AP10.6
                                                                 AP110   AP125
                                                                 AP126   AP170
                                                                 AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-TAX-CODE1        Alpha 10                                    AC15.1  AP00.3
Tax Table - Tax      The first tax code in the tax table.        AP10.1  AP10.2
Code 1               The first tax code is used to calculate     AP10.5  AP10.6
                     the sales tax based on the taxable          AP110   AP125
                     transaction amount.  The tax code must      AP126   AP170
                     have already been defined using TX01.1      AP180   AP181
                     (Tax Code Master).                          AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-FLAG1            Alpha 1                                     AC15.1  AP00.3
Tax Distrib. Flag -  This field indicates what the effect        AP10.1  AP10.2
Tax Code 1           will be on taxable amounts for the next     AP10.5  AP10.6
                     tax code in the table.  The tax rate        AP110   AP125
                     defined for the first tax code in the       AP126   AP170
                     table will be calculated against the        AP180   AP181
                     taxable amount of the transaction.          AP190   AP20.1
                                                                 AP20.2  AP20.5
                     Leave the field blank to have no effect     AP20.6  AP20.7
                     on the next tax code's taxable amount.      AP225   AP226
                                                                 AP23.1  AP25.1
                     Add means that the value of that            AP25.2  AP26.1
                     calculation will be added to the            AP30.2  AP32.2
                     transaction's taxable amount for the        AP510   AP520
                     next tax code.                              AR08.1  AR10.1
                                                                 AR115   AR124
                     Subtract means that the value of that       AR15.4  AR190
                     tax calculation will be subtracted from     AR20.1  AR21.1
                     the taxable amount of the transaction       AR21.2  AR21.3
                     for the next tax code.                      AR24.1  AR29.2
                     + = Add To Taxable                          AR30.1  AR30.2
                     - = Subtract From Taxable                   AR30.4  AR42.1
                     " " = No Effect On Taxable                  AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-TAX-CODE2        Alpha 10                                    AC15.1  AP00.3
Tax Table - Tax      The second tax code in the tax table.       AP10.1  AP10.2
Code 2               You must have defined the tax code using    AP10.5  AP10.6
                     TX01.1 (Tax Code Master).                   AP110   AP125
                                                                 AP126   AP170
                                                                 AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-FLAG2            Alpha 1                                     AC15.1  AP00.3
Tax Distrib. Flag -  This field indicates what the effect        AP10.1  AP10.2
Tax Code 2           will be on the taxable amounts for the      AP10.5  AP10.6
                     next tax code in the table.                 AP110   AP125
                                                                 AP126   AP170
                     Leave the field blank to have no effect     AP180   AP181
                     on the next tax code's taxable amount.      AP190   AP20.1
                                                                 AP20.2  AP20.5
                     Add means that the value of that tax        AP20.6  AP20.7
                     calculation will be added to the            AP225   AP226
                     transaction's taxable amount for the        AP23.1  AP25.1
                     next tax code.                              AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                     Subtract means that the value of that       AP510   AP520
                     tax calculation will be subtracted from     AR08.1  AR10.1
                     the taxable amount of the transaction       AR115   AR124
                     for the next tax code.                      AR15.4  AR190
                     + = Add To Taxable                          AR20.1  AR21.1
                     - = Subtract From Taxable                   AR21.2  AR21.3
                     " " = No Effect On Taxable                  AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-TAX-CODE3        Alpha 10                                    AC15.1  AP00.3
Tax Table - Tax      The third tax code in the tax table.        AP10.1  AP10.2
Code 3               You must have already defined the tax       AP10.5  AP10.6
                     code using TX01.1 (Tax Code Master).        AP110   AP125
                                                                 AP126   AP170
                                                                 AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-FLAG3            Alpha 1                                     AC15.1  AP00.3
Tax Distrib. Flag -  This field indicates what the effect        AP10.1  AP10.2
Tax Code 3           will be on taxable amounts for the next     AP10.5  AP10.6
                     tax code in the table.                      AP110   AP125
                                                                 AP126   AP170
                     Leave the field blank to have no effect     AP180   AP181
                     on the next tax code's taxable amount.      AP190   AP20.1
                                                                 AP20.2  AP20.5
                     Add means that the value of that tax        AP20.6  AP20.7
                     calculation will be added to the taxable    AP225   AP226
                     amount of the transaction for the next      AP23.1  AP25.1
                     tax code.                                   AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                     Subtract means that the value of that       AP510   AP520
                     tax calculation will be subtracted from     AR08.1  AR10.1
                     the taxable amount of the transaction       AR115   AR124
                     for the next tax code.                      AR15.4  AR190
                     + = Add To Taxable                          AR20.1  AR21.1
                     - = Subtract From Taxable                   AR21.2  AR21.3
                     " " = No Effect On Taxable                  AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-TAX-CODE4        Alpha 10                                    AC15.1  AP00.3
Tax Table - Tax      The fourth tax code in the tax table.       AP10.1  AP10.2
Code 4               You must have already defined the tax       AP10.5  AP10.6
                     code using TX01.1 (Tax Code Master).        AP110   AP125
                                                                 AP126   AP170
                                                                 AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-FLAG4            Alpha 1                                     AC15.1  AP00.3
Tax Distrib. Flag -  This field indicates what the effect        AP10.1  AP10.2
Tax Code 4           will be on taxable amounts for the next     AP10.5  AP10.6
                     tax code in the table.                      AP110   AP125
                                                                 AP126   AP170
                     Leave the field blank to have no effect     AP180   AP181
                     on the next tax code's taxable amount.      AP190   AP20.1
                                                                 AP20.2  AP20.5
                     Add means that the value of that tax        AP20.6  AP20.7
                     calculation will be added to the taxable    AP225   AP226
                     amount of the transaction for the next      AP23.1  AP25.1
                     tax code.                                   AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                     Subtract means that the value of that       AP510   AP520
                     tax calculation will be subtracted from     AR08.1  AR10.1
                     the taxable amount of the transaction       AR115   AR124
                     for the next tax code.                      AR15.4  AR190
                     + = Add To Taxable                          AR20.1  AR21.1
                     - = Subtract From Taxable                   AR21.2  AR21.3
                     " " = No Effect On Taxable                  AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-TAX-CODE5        Alpha 10                                    AC15.1  AP00.3
Tax Table - Tax      The fifth tax code in the tax table.        AP10.1  AP10.2
Code 5               You must have already defined the tax       AP10.5  AP10.6
                     code using TX01.1 (Tax Code Master).        AP110   AP125
                                                                 AP126   AP170
                                                                 AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-FLAG5            Alpha 1                                     AC15.1  AP00.3
Tax Distrib. Flag -  This field indicates what the effect        AP10.1  AP10.2
Tax Code 5           will be on taxable amounts for the next     AP10.5  AP10.6
                     tax code in the table.                      AP110   AP125
                                                                 AP126   AP170
                     Leave the field blank to have no effect     AP180   AP181
                     on the next tax code's taxable amount.      AP190   AP20.1
                                                                 AP20.2  AP20.5
                     Add means that the value of that tax        AP20.6  AP20.7
                     calculation will be added to the taxable    AP225   AP226
                     amount of the transaction for the next      AP23.1  AP25.1
                     tax code.                                   AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                     Subtract means that the value of that       AP510   AP520
                     tax calculation will be subtracted from     AR08.1  AR10.1
                     the taxable amount of the transaction       AR115   AR124
                     for the next tax code.                      AR15.4  AR190
                     + = Add To Taxable                          AR20.1  AR21.1
                     - = Subtract From Taxable                   AR21.2  AR21.3
                     " " = No Effect On Taxable                  AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-TAX-CODE6        Alpha 10                                    AC15.1  AP00.3
Tax Table - Tax      The sixth tax code in the tax table.        AP10.1  AP10.2
Code 6               You must have already defined the tax       AP10.5  AP10.6
                     code using TX01.1 (Tax Code Master).        AP110   AP125
                                                                 AP126   AP170
                                                                 AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-FLAG6            Alpha 1                                     AC15.1  AP00.3
Tax Distrib. Flag -  This field indicates what the effect        AP10.1  AP10.2
Tax Code 6           will be on taxable amounts for the next     AP10.5  AP10.6
                     tax code in the table.                      AP110   AP125
                                                                 AP126   AP170
                     Leave the field blank to have no effect     AP180   AP181
                     on the next tax code's taxable amount.      AP190   AP20.1
                                                                 AP20.2  AP20.5
                     Add means that the value of that tax        AP20.6  AP20.7
                     calculation will be added to the taxable    AP225   AP226
                     amount of the transaction for the next      AP23.1  AP25.1
                     tax code.                                   AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                     Subtract means that the value of that       AP510   AP520
                     tax calculation will be subtracted from     AR08.1  AR10.1
                     the taxable amount of the transaction       AR115   AR124
                     for the next tax code.                      AR15.4  AR190
                     + = Add To Taxable                          AR20.1  AR21.1
                     - = Subtract From Taxable                   AR21.2  AR21.3
                     " " = No Effect On Taxable                  AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-TAX-CODE7        Alpha 10                                    AC15.1  AP00.3
Tax Table - Tax      The seventh tax code in the tax table.      AP10.1  AP10.2
Code 7               You must have already defined the tax       AP10.5  AP10.6
                     code using TX01.1 (Tax Code Master).        AP110   AP125
                                                                 AP126   AP170
                                                                 AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-FLAG7            Alpha 1                                     AC15.1  AP00.3
Tax Distrib. Flag -  This field indicates what the effect        AP10.1  AP10.2
Tax Code 7           will be on taxable amounts for the next     AP10.5  AP10.6
                     tax code in the table.                      AP110   AP125
                                                                 AP126   AP170
                     Leave the field blank to have no effect     AP180   AP181
                     on the next tax code's taxable amount.      AP190   AP20.1
                                                                 AP20.2  AP20.5
                     Add means that the value of that tax        AP20.6  AP20.7
                     calculation will be added to the taxable    AP225   AP226
                     amount of the transaction for the next      AP23.1  AP25.1
                     tax code.                                   AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                     Subtract means that the value of that       AP510   AP520
                     tax calculation will be subtracted from     AR08.1  AR10.1
                     the taxable amount of the transaction       AR115   AR124
                     for the next tax code.                      AR15.4  AR190
                     + = Add To Taxable                          AR20.1  AR21.1
                     - = Subtract From Taxable                   AR21.2  AR21.3
                     " " = No Effect On Taxable                  AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-TAX-CODE8        Alpha 10                                    AC15.1  AP00.3
Tax Table - Tax      The eighth tax code in the tax table.       AP10.1  AP10.2
Code 8               You must have already defined the tax       AP10.5  AP10.6
                     code using TX01.1 (Tax Code Master).        AP110   AP125
                                                                 AP126   AP170
                                                                 AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

TXT-FLAG8            Alpha 1                                     AC15.1  AP00.3
Tax Distrib. Flag -  The taxable effect for the last tax         AP10.1  AP10.2
Tax Code 8           code in the table must be blank.            AP10.5  AP10.6
                     + = Add To Taxable                          AP110   AP125
                     - = Subtract From Taxable                   AP126   AP170
                     " " = No Effect On Taxable                  AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR15.4  AR190
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR42.1
                                                                 AR42.2  AR42.7
                                                                 AR43.1  AR550
                                                                 AR560   AR570
                                                                 AR575   AR580
                                                                 AR82.1  BL02.1
                                                                 BL08.1  BL09.1
                                                                 BL120   BL122
                                                                 BL130   BL20.1
                                                                 ...

                         TXTAXTABLE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXTSET1   TAX-TABLE     This index is used to access the most    AC15.1  AP00.3
          EFFECT-DATE*  recent tax table record using a          AP10.1  AP10.2
                        descending key.                          AP10.5  AP10.6
                                                                 AP110   AP125
                                                                 AP126   AP170
                                                                 AP180   AP181
                                                                 AP190   AP20.1
                                                                 AP20.2  AP20.5
                                                                 AP20.6  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP510   AP520
                                                                 AR08.1  AR10.1
                                                                 ...

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