Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRTAXLEVY


                             PRTAXLEVY FILE

                            Payroll Tax Levy

Contains the information that makes up the tax table used for tax levies.

REFERENCED BY

BN100     BN101     BN102     BN103     BN104     BN105
BN145     BN150     BN245     BN305     BN31.1    BN31.2
BN32.1    BN32.2    BN32.3    BN45.1    BN531     BN65.1
BN66.1    BN71.1    BN72.1    BS13.1    BS14.1    BS15.1
BS32.1    ET530     ETI1.1    ETI2.1    HR11.1    HR11.2
HR511     LP130     PA02.1    PA100     PA102     PA115
PA13.1    PA13.2    PA502     PA513     PA52.1    PA52.3
PA52.4    PA52.5    PR110     PR113     PR120     PR128
PR13.1    PR13.2    PR13.5    PR13.6    PR13.8    PR130
PR131     PR132     PR134     PR136     PR139     PR14.1
PR14.2    PR140     PR15.1    PR15.2    PR189     PR195
PR205     PR210     PR26.1    PR26.2    PR29.1    PR32.2
PR33.2    PR33.3    PR35.1    PR35.2    PR35.3    PR35.4
PR35.5    PR35.6    PR35.8    PR35.9    PR36.1    PR39.1
PR39.2    PR45.1    PR47.1    PR47.2    PR514     PR529
PR530     PR539     PR560     PR80.1    PR80.3    PR82.1
PR89.1    UK102     UK47.1    UK47.2    UK560     TA147


UPDATED BY

HR100     PR10.1    PR710     PR910

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TXL-LEVY-YEAR          Numeric 4                                 PR10.1  PR710
Element: Levy Year     Contains the year that identifies the     PR910
                       IRS table.

TXL-LEVY-FILING-ST     Alpha 1                                   PR10.1  PR710
Element: Levy Filing StContains the levy filing status.          PR910

TXL-LEVY-EXEMPTS       Numeric 2                                 PR10.1  PR710
Element: Levy Exempts  Contains the number of levy exemptions.   PR910

TXL-LEVY-EXEMP-AMT     Signed 6.2 Occurs 4 Times                 PR10.1  PR710
Element: Levy Exemp AmtContains the levy exemption amount.       PR910

TXL-TAX-ID-CODE        Alpha 10                                  PR10.1  PR710
Element: Tax Id Code                                             PR910

                         PRTAXLEVY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXLSET1   TAX-ID-CODE                                            BN100   BN101
          LEVY-YEAR                                              BN102   BN103
          LEVY-FILING-ST                                         BN104   BN105
          LEVY-EXEMPTS                                           BN145   BN150
                                                                 BN245   BN305
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN66.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  ET530
                                                                 ETI1.1  ETI2.1
                                                                 HR100   HR11.1
                                                                 ...

                         PRTAXLEVY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Prtaxauth      PRTAXAUTH    Required

                            TXL-TAX-ID-CODE    -> PRX-TAX-ID-CODE