Field Identifier | Suggested Field Variable |
---|---|
W2-EE-SSN | EID.GOVERNMENT_CODE |
Field Identifier | Suggested Field Variable |
---|---|
W2-ER-NAME | DED.ENTITY_NAME |
W2-ER-LOCN-ADDR | |
W2-ER-DELIV-ADDR | Blank |
W2-ER-CITY | Blank |
W2-ER-STATE | Blank |
W2-ER-ZIP | Blank |
W2-ER-ZIP-EXT | Blank |
For foreign country address: Derived from IDFDV
Field Identifier | Suggested Field Variable |
---|---|
W2-ER-COUNTRY | If W2-ER-COUNTRY=USA, then this country field is left 'Blank' Otherwise, W2-ER-COUNTRY will be retrieved from IDCO UDF ‘ISO COUNTRY CODE’ with the two character ISO Country Code |
Please note: Field Identifier ‘W2-ER-F-COUNTRY’ is used for printing on W2 Form and EFW2 file. This identifier can be specified as follows:
Field Identifier | Suggested Field Variable |
---|---|
W2-CONTROL-PRT | Specifies if the Control Number should be printed on the form or not Null, 0– Do not print Control Number on W2 Form 1 - Print Control Number as defined in W2-CONTROL-NUM Identifier 2 - Print Control Number as defined from RPYEU ‘Sort Level By’ prompt 3 - Print W2-CONTROL-NUM Identifier and Person Code 4 - Print ‘Sort Level By’ prompt and Person Code 5 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier 6 - Print ‘Sort Level By’ prompt and W2-CONTROL-NUM Identifier and Person Code |
W2-CONTROL-NUM | Control Number on Form, may contain a Data Base Column - Enter your company data e.g. ‘EID.PERSON_CODE’ |
Field Identifier | Suggested Field Variable |
---|---|
W2-EE-FIRST-NAME | EID.FIRST_NAME’ |
W2-EE-MIDDLE | EID.MIDDLE_NAME’ |
W2-EE-LAST-NAME | EID.LAST_NAME’ |
W2-EE-SUFFIX | EID.RANK’ derivation expression: Decode(~,'01','JR','02','SR',NULL) |
Field Identifier | Suggested Field Variable |
---|---|
W2-EE-LOCN-ADDR | Blank or constant ‘MAIL’ |
W2-EE-DELIV-ADDR | Blank |
W2-EE-CITY | Blank |
W2-EE-STATE | Blank |
W2-EE-ZIP | Blank |
W2-EE-ZIP-EXT | Blank |
For foreign country address: Derived from IDFDV
Field Identifier | Suggested Field Variable |
---|---|
W2-EE-COUNTRY | If W2-EE-COUNTRY, then this country field is left 'Blank' Otherwise, W2-EE-COUNTRY will be retrieved from IDCO UDF ‘ISO COUNTRY CODE’ with the two character ISO Country Code |
Please note: Field Identifier ‘W2-EE-COUNTRY’ is used for printing on W2 Form and EFW2 file. This identifier can be specified as follows:
Field Identifier | Suggested Field Variable |
---|---|
W2-FIT-WAGE | W2-BOX-01 |
Field Identifier | Suggested Field Variable |
---|---|
W2-FIT-TAX | W2-BOX-02 |
Field Identifier | Suggested Field Variable | |
---|---|---|
W2-SSN-WAGE | W2-BOX-03 |
The total of Box 3 and 7 cannot exceed the annual maximum social security wage base specified by the government. RPYEU will automatically supply the annual maximum when the government publishs the maximum amount every year. IDGV does not need to be set up with Registration Type ‘US FICA Registration’ and ‘Govt Rate Type’ = ‘US FICA Max Base Amt’. RPYEU program checks the maximum and an exception message is issued if the wage base is exceeded.
Field Identifier | Suggested Field Variable |
---|---|
W2-SSN-TAX | W2-BOX-04 |
Field Identifier | Suggested Field Variable |
---|---|
W2-MEDI-WAGE | W2-BOX-05 |
Field Identifier | Suggested Field Variable |
---|---|
W2-MEDI-TAX | W2-BOX-06 |
Field Identifier | Suggested Field Variable |
---|---|
W2-SSN-TIP | W2-BOX-07 |
The total of Box 3 and 7 cannot exceed the annual maximum social security wage base specified by the government. RPYEU will automatically supply the annual maximum when the government publishes the maximum amount every year. IDGV does not need to be set up with Registration Type ‘US FICA Registration’ and ‘Govt Rate Type’ = ‘US FICA Max Base Amt’. RPYEU program checks the maximum and an exception message is issued if the wage base is exceeded.
Field Identifier | Suggested Field Variable |
---|---|
W2-ALLOC-TIP | W2-BOX-08 |
Field Identifier | Suggested Field Variable |
---|---|
W2-DEP-CARE | W2-BOX-10 |
Field Identifier | Suggested Field Variable |
---|---|
W2-NQUAL | W2-BOX-11 |
Field Identifier | Suggested Field Variable |
---|---|
W2-CODE-A | |
W2-CODE-B | |
W2-CODE-C | |
W2-CODE-D | |
W2-CODE-E | |
W2-CODE-F | |
W2-CODE-G | |
W2-CODE-H | |
W2-CODE-J | |
W2-CODE-K | |
W2-CODE-L | |
W2-CODE-M | |
W2-CODE-N | |
W2-CODE-P | |
W2-CODE-Q | |
W2-CODE-R | |
W2-CODE-S | |
W2-CODE-T | |
W2-CODE-V | |
W2-CODE-W | |
W2-CODE-Y | |
W2-CODE-Z | |
W2-CODE-AA | |
W2-CODE-BB | |
W2-CODE-CC | |
W2-CODE-DD | |
W2-CODE-EE |
Field Identifier | Suggested Field Variable |
---|---|
W2-STAT-EE | If the amount is non zero, then this box is checked |
Retirement Plan
Field Identifier | Suggested Field Variable |
---|---|
W2-RETIRE-PLAN | If the amount is non zero, then this box is checked |
Third-party Sick Pay
Field Identifier | Suggested Field Variable |
---|---|
W2-3PARTY-SICK | If the amount is non zero, then this box is checked |
Box 14 - Other Derived from IDFDV
Field Identifier | Suggested Field Variable |
---|---|
W2-OTHER-01, W2-OTHER-02, ... up to W2-OTHER-20 | |
W2-SCHL-WAGE, for school district taxable wages | |
W2-SCHL-TAX, for school district tax |
Field Identifier | Suggested Field Variable |
---|---|
W2-STATE-CODE | DSP.STATE_PROVINCE_CODE |
Employer's State I.D. Number
Field Identifier | Suggested Field Variable |
---|---|
W2-STATE-REGIST | DGV.GOVT_REGIST_NUMBER |
Field Identifier | Suggested Field Variable |
---|---|
W2-ST-WAGE-HOME | W2-BOX-16-H |
W2-ST-WAGE-WORK | W2-BOX-16-W |
Field Identifier | Suggested Field Variable |
---|---|
W2-ST-TAX-HOME | W2-BOX-17-H |
W2-ST-TAX-WORK | W2-BOX-17-W |
Field Identifier | Suggested Field Variable | |
---|---|---|
W2-CN-WAGE-HOME | W2-BOX-18-CN-H | |
W2-CN-WAGE-WORK | W2-BOX-18-CN-W | |
W2-CI-WAGE-HOME | W2-BOX-18-CI-H | |
W2-CI-WAGE-WORK | W2-BOX-18-CI-W |
- this is the taxable earnings applicable for County or City tax withheld - if users specify an element that derives the County or City wages (i.e. Regular Earnings, O/T earnings etc), the element should contain all taxable earnings less exemptions such as 401K, 125 plans etc.
- Vertex County or City tax calculation differentiates wages by work local wage and residence local wage - W2 only requires to report local wages by Local name regardless if it is from work or residence local - the system will retrieve the proper work local wages according to the YTD WORK GEO code and the proper residence local wages according to the YTD RES GEO code and report these as local wages only
- IDFDV Field Identifier ‘W2-CI-WAGE-WORK’ is used to set up the WORK City wage information - this should include all City Wages pay components that are applicable to Work City Tax calculation - e.g. PC 6905 Work City Earnings, PC 6906 Work City Supplemental Earnings
- IDFDV Field Identifier ‘W2-CN-WAGE-WORK’ is used to set up the WORK County wage information - this should include all County Wages pay components that are applicable to Work County Tax calculation - e.g. PC 6805 Work County Earnings, PC 6806 Work County Supplemental Earnings
- IDFDV Field Identifier ‘W2-CI-WAGE-HOME’ is used to set up the Residence City wage information - this should include all City Wages pay components that are applicable to Residence City Tax calculation - e.g. PC 6925 Residence City Earnings, PC 6926 Residence City Supplemental Earnings
- IDFDV Field Identifier ‘W2-CN-WAGE-HOME’ is used to set up the Residence County wage information - this should include all County Wages pay components that are applicable to Residence County Tax calculation - e.g. PC 6825 Residence County Earnings, PC 6826 Residence County Supplemental Earnings
Box 19 - Local income tax
Field Identifier | Description |
---|
- Vertex County or City tax calculation differentiates City/County tax by work local tax and residence local tax - W2 only requires to report local income tax by Local name regardless if it is from work or residence local - the system will retrieve the proper work local tax according to the YTD WORK GEO code and the proper residence local tax according to the YTD RES GEO code and report these as local income tax only
- IDFDV Field Identifier ‘W2-CI-TAX -WORK’ is used to set up the WORK City tax information - this should include all City tax pay components that are applicable to Work City Tax calculation - e.g. PC 6901 Work City Tax, PC 6902 Work City Supplemental Tax
- IDFDV Field Identifier ‘W2-CN-TAX -WORK’ is used to set up the WORK County tax information - this should include all County tax pay components that are applicable to Work County Tax calculation - e.g. PC 6801 Work County Tax, PC 6802 Work County Supplemental Tax
- IDFDV Field Identifier ‘W2-CI-TAX -HOME’ is used to set up the Residence City tax information - this should include all City tax pay components that are applicable to Residence City Tax calculation - e.g. PC 6921 Residence City Tax, PC 6922 Residence City Supplemental Tax
- IDFDV Field Identifier ‘W2-CN-TAX -HOME’ is used to set up the Residence County tax information - this should include all County tax pay components that are applicable to Residence County Tax calculation - e.g. PC 6821 Residence County Tax, PC 6822 Residence County Supplemental Tax
For California SDI reporting, there are 2 options to print SDI on W2 Forms:
(1) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not zero, then Box 19 will print the employee SDI contribution and Box 20 will print the description ‘CASDI’
(2) - For California, if IDFDV Identifier Seq 7260 W2-SDI-TAX-EE is not set up, the user may set up Box 14 to print ‘CASDI’ and the SDI amount
Box 20 - Locality Name - IDFDV Field Identifier: ‘W2-CNTY-NAME’ - IDFDV Field Variable: ‘DCN.COUNTY_NAME’ - IDFDV Field Identifier: ‘W2-CITY-NAME’ - IDFDV Field Variable: ‘DTX.JURISDICTION_NAME’
- RPW2 program will print the proper DTX.JURISDICTION_NAME according to YTD GEO information - if County tax is reported, the County name is retrieved from the IDCN County screen with GEO code = ‘xx-xxx-0000’ - e.g. In Indiana, GEO code ‘15-097-0670’ is for the city of ‘Indianapolis’, then use County Code ‘15-097-0000’ to retrieve the County name of ‘Marion’ for reporting - if City tax is reported, the City name is retrieved from the IDTX Tax Jurisdiction screen with GEO code - an entry must also exist on IDGV screen with ‘Local Registration’ for a County or City in order for the County or City tax to be reported
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation