Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRMINWAGE


                             PRMINWAGE FILE

                              Minimum Wage

This file contains minimum wage information by tax authority. Minimum wage is
verified in the calculation of overtime.

REFERENCED BY

BN66.1    PR139     PR140     PR189     PR195     PR206
PR80.1    PR89.1    PR132

UPDATED BY

PR06.1    PR06.3    PR08.1    PR08.2    PR702

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PMW-TAX-ID-CODE        Alpha 10                                  PR06.3  PR08.2
Element: Tax Id Code   Contains the tax authority.

PMW-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PR06.3  PR08.2
Element: Date          Contains the effective date of the
                       minimum wage.

PMW-MINIMUM-WAGE       Signed 5.2                                PR06.3  PR08.2
Element: Minimum Wage  Contains the amount of the minimum wage.

PMW-TAX-STATE          Alpha 2                                   PR06.1  PR06.3
State Taxing           Contains the value that identifies the    PR08.2
Authority Code         state for which the minimum wage is
                       defined.

PMW-TAX-PROVINCE       Alpha 2                                   PR06.3  PR08.1
Element: Province                                                PR08.2

PMW-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

PMW-CURR-ND            Numeric 1
Account Currency
Code

PMW-COUNTRY-CODE       Alpha 2                                   PR06.3  PR08.2
Element: Country Code  The country code.  Required for VAT and   PR702
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

                         PRMINWAGE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PMWSET1   TAX-ID-CODE                                            BN66.1  PR06.1
          EFFECT-DATE*                                           PR06.3  PR08.1
                                                                 PR08.2  PR139
                                                                 PR140   PR189
                                                                 PR195   PR206
                                                                 PR702   PR80.1
                                                                 PR89.1

PMWSET2   TAX-STATE     KeyChange, Subset                        PR132
          EFFECT-DATE*  Where COUNTRY-CODE = "US"
          TAX-ID-CODE

PMWSET3   TAX-PROVINCE  KeyChange, Subset                        PR132
          EFFECT-DATE*  Where COUNTRY-CODE = "CA"
          TAX-ID-CODE

                         PRMINWAGE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Tax Id Code    PRTAXAUTH    Required

                            PMW-TAX-ID-CODE    -> PRX-TAX-ID-CODE