Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
Tax Id Code          Contains the tax authority.

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

PMW-MINIMUM-WAGE     Signed 5.2                                  PR06.3  PR08.2
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
Tax Province                                                     PR08.2

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


PMW-CURR-ND          Numeric 1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

PMW-COUNTRY-CODE     Alpha 2                                     PR06.3  PR08.2
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