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