Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TXTAXRATE


                             TXTAXRATE FILE

                                Tax Rate

The Tax Rate file stores tax rates in effect for a specific tax code.  You
must define a tax rate for a tax code before the tax code can be applied to a
transaction.

REFERENCED 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     BL121     BL122
BL123     BL130     BL20.1    BL20.3    BL20.4    BL20.5
BL20.6    BL202     BL21.2    BL21.5    BL29.1    BL29.2
BL290     BL520     BL80.1    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     PO150     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     PO54.4    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    RQII.1    RQIJ.1
TX01.1    TX01.2    TX02.1    TX140     TX203     TX221
TX300     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

UPDATED BY

TX03.1    TX03.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TXR-TAX-CODE           Alpha 10                                  TX03.1  TX03.2
Element: Tax Code      This field is a user-defined code
                       representing tax information.  The tax
                       code must be defined using TX01.1 (Tax
                       Code Master).

TXR-PROD-TAX-CAT       Alpha 15                                  TX03.1  TX03.2
Element: Product Tax CaA product tax category lets you
                       determine the tax rate by item grouping.
                       You can override the tax rate for items
                       that could be taxable in one taxing
                       authority but not another, for example.

                       Define product tax categories in the
                       Inventory Control system.

TXR-EFFECT-DATE        Numeric 8  (yyyymmdd)                     TX03.1  TX03.2
Element: Effective DateThe date that the tax rate becomes
                       effective for this tax code.

TXR-TAX-RATE           Percent 7.5  (Percent)                    TX03.1  TX03.2
Element: Chrg Rate     This field represents the tax rate for
                       this tax code.

TXR-SECONDARY-RATE     Percent 7.5  (Percent)                    TX03.1  TX03.2
Element: Chrg Rate     A secondary tax rate is used when you
                       need to split the tax rate for a single
                       taxable transaction amount.

TXR-TAX-NAME           Derived
Element: Tax Name      This field contains the tax code name.

                         TXTAXRATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXRSET1   TAX-CODE      This index is used to access the most    AM115   AM117
          PROD-TAX-CAT  current tax rate record using a          AM15.1  AM15.2
          EFFECT-DATE*  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
                                                                 ...

TXRSET2   TAX-CODE      This index is used to access the most    AM115   AM117
          PROD-TAX-CAT  current tax rate record for tax codes    AM15.1  AM15.2
          EFFECT-DATE*  with a product tax category using a      AM15.3  AM15.4
                        descending key.                          AM20.1  AM20.3
                        KeyChange, Subset                        AM21.1  AM21.3
                        Where (PROD-TAX-CAT != Spaces )          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
                                                                 ...

TXRSET3   TAX-CODE      This subset is used to access the most   AM115   AM117
          PROD-TAX-CAT  recent tax rate record for a tax code    AM15.1  AM15.2
          EFFECT-DATE*  without a product tax category using a   AM15.3  AM15.4
                        descending key.                          AM20.1  AM20.3
                        KeyChange, Subset                        AM21.1  AM21.3
                        Where PROD-TAX-CAT = Spaces              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
                                                                 ...

                         TXTAXRATE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Txcodemast     TXCODEMAST   Required

                            TXR-TAX-CODE    -> TCM-TAX-CODE