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

PR206     PR132     TP135     TP140

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: Effective DateContains 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       Represents the number of decimals
Code                   defined for the currency of the object.

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                                            PR06.1  PR06.3
          EFFECT-DATE*                                           PR08.1  PR08.2
                                                                 PR206   PR702

PMWSET2   TAX-STATE     KeyChange, Subset                        PR132   TP135
          EFFECT-DATE*  Where COUNTRY-CODE = "US"                TP140
          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