PRMINWAGE FILE
Minimum Wage
This file contains minimum wage information by tax authority. Minimum wage is
verified in the calculation of overtime.
REFERENCED BY
PR139 PR195 PR206 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 PR06.1 PR06.3
EFFECT-DATE* PR08.1 PR08.2
PR139 PR195
PR206 PR702
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
|
