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

AC160     AC56.1    AC560     AM115     AM117     AM15.1
AM15.2    AM15.3    AM15.4    AM19.1    AM19.2    AM20.1
AM20.3    AM21.1    AM21.3    AM500     AM51.1    AM551
AM97.1    AP00.3    AP00.4    AP03.3    AP10.1    AP10.2
AP10.5    AP10.6    AP110     AP115     AP125     AP126
AP131     AP170     AP180     AP181     AP190     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.6    AP20.7
AP21.1    AP210     AP220     AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    AP30.2    AP30.4    AP305     AP510
AP520     AP90.1    AP91.1    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    AR32.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     BL30.1
BL30.2    BL30.3    BL30.5    BL31.1    BL31.2    BL31.3
BL31.5    BL31.7    BL32.1    BL32.2    BL32.3    BL32.4
BL520     BL80.1    BL802     BL820     BL92.1    BR00.1
BR00.2    BR02.3    BR11.1    BR120     BR121     BR122
BR123     BR140     BR151     BR152     BR156     BR16.1
BR180     BR20.1    BR20.2    BR20.3    BR20.4    BR20.5
BR20.6    BR420     BR46.1    BR46.2    BR46.4    BR48.1
BR521     CB03.2    CB10.1    CB10.3    CB150     CB191
CB20.1    CB30.1    CB43.1    CB44.1    CB45.1    CB46.1
CB50.1    CB500     CB54.1    CB543     CB544     CB55.1
CB554     CXCP.1    DT180     DT181     EE05.1    EE20.3
EE520     ET175     ET542     IC02.1    IC11.1    IC12.1
IC130     IC330     IC811     IC812     MX123     MX500
MA08.1    MA180     MA208     MA279     MA310     MA41.1
MA41.2    MA41.4    MA41.7    MA43.1    MA43.2    MA43.3
MA43.4    MA43.6    MA43.7    MA530     MA531     MA540
MA60.2    MA60.3    MA60.5    MA61.1    MA63.1    MA65.1
MA66.2    MA66.3    MA67.2    MA67.3    MA68.2    MA68.3
MA68.5    MA70.1    MA75.1    MA80.1    MAI1.1    PD10.1
PD10.2    PD130     PD20.1    PD20.2    PD20.3    PD235
PO10.1    PO100     PO101     PO120     PO122     PO131
PO132     PO135     PO136     PO150     PO190     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO220     PO223     PO229     PO23.1    PO233     PO24.1
PO25.1    PO25.5    PO25.6    PO25.7    PO253     PO254
PO26.1    PO27.2    PO278     PO29.1    PO30.1    PO30.2
PO30.3    PO300     PO31.1    PO31.2    PO32.1    PO32.2
PO32.4    PO33.1    PO34.1    PO35.1    PO36.1    PO36.2
PO38.1    PO39.1    PO39.2    PO44.1    PO50.1    PO52.1
PO520     PO536     PO54.1    PO54.2    PO54.3    PO54.4
POED.1    POI3.1    POI7.1    POID.1    POIF.1    POIG.1
POII.1    POIJ.1    POIM.1    POIT.1    PR05.1    PR05.3
PR226     PR247     PR26.1    PR47.1    PR514     UK47.1
RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1    RQ13.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

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: Prod Tax Cat  A 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: Effect Date   The 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.

TXR-DISCRETION-AMT     Signed 15.2
Element: Taxable Amt   This is the taxable amount.

                         TXTAXRATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXRSET1   TAX-CODE                                               AC160   AC56.1
          PROD-TAX-CAT                                           AC560   AM115
          EFFECT-DATE*                                           AM117   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.3
                                                                 AP00.4  AP03.3
                                                                 AP10.1  AP10.2
                                                                 AP10.5  AP10.6
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 ...

TXRSET2   TAX-CODE      KeyChange, Subset                        AC160   AC56.1
          PROD-TAX-CAT  Where (PROD-TAX-CAT != Spaces )          AC560   AM115
          EFFECT-DATE*                                           AM117   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.3
                                                                 AP00.4  AP03.3
                                                                 AP10.1  AP10.2
                                                                 AP10.5  AP10.6
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 ...

TXRSET3   TAX-CODE      KeyChange, Subset                        AC160   AC56.1
          PROD-TAX-CAT  Where PROD-TAX-CAT = Spaces              AC560   AM115
          EFFECT-DATE*                                           AM117   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM19.1
                                                                 AM19.2  AM20.1
                                                                 AM20.3  AM21.1
                                                                 AM21.3  AM500
                                                                 AM51.1  AM551
                                                                 AM97.1  AP00.3
                                                                 AP00.4  AP03.3
                                                                 AP10.1  AP10.2
                                                                 AP10.5  AP10.6
                                                                 AP110   AP115
                                                                 AP125   AP126
                                                                 ...

                         TXTAXRATE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Txcodemast     TXCODEMAST   Required

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