|
|
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
|
