Table: Paper W-2 Information

Table: UTW2PD
View: UT0007
Record Length: 1401

Flags: A R 

Keys: 2

Title Flags Fields
Primary Key Name SEQUENCE, SORTPARAM, PRIMEKEY
Key Name D M  SEQUENCE, SORTPARAM, CONTROL, SUBTOTAL

Fields: 83

Field Type Title Presentation
SEQUENCE Integer Sequence
SORTPARAM String*94 Sort Parameter
PRIMEKEY Long PrimeKey
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CONTROL Long Control
SUBTOTAL Boolean Subtotal
VOIDW2 Boolean Void W-2
EMPLREIN String*9 Employer EIN Mask: %-2d-%-7d
EMPLRNAME String*60 Employer Name
EMPLRADDR1 String*60 Employer Address 1
EMPLRADDR2 String*60 Employer Address 2
EMPLRADDR3 String*60 Employer Address 3
EMPLRADDR4 String*60 Employer Address 4
EMPLRCITY String*30 Employer City
EMPLRSTATE String*30 Employer State
EMPLRZIP String*20 Employer Zip Code Mask: %-9c
SSN String*11 Employee SSN Mask: %-3d-%-2d-%-4d
LASTNAME String*20 Employee Last Name
FIRSTNAME String*15 Employee First Name
MIDDLENAME String*15 Employee Middle Name
ADDRESS1 String*60 Employee Address 1
ADDRESS2 String*60 Employee Address 2
ADDRESS3 String*60 Employee Address 3
ADDRESS4 String*60 Employee Address 4
CITY String*30 Employee City
STATE String*30 Employee State
ZIP String*20 Employee Zip Code
WAGESTIPS BCD*10.3 Amount
FIT BCD*10.3 Income Tax
SSWAGES BCD*10.3 Wages
SSTAXWHLD BCD*10.3 Tax Withheld
MEDWAGETIP BCD*10.3 Med. Wage Tip
MEDTAXWHLD BCD*10.3 Med. Tax Withheld
SSTIPS BCD*10.3 Tips
ALLOCTIPS BCD*10.3 Allocated Tips
AEIC BCD*10.3 AEIC
DEPCARE BCD*10.3 Dependent Care
NONQUALCOD String*1 Nonqualified COD
NONQUALPLN BCD*10.3 Nonqualified Plan
BENEFITS BCD*10.3 Fringe Benefit
FEDCODE1 String*2 Box 12 Code 1
FEDAMT1 BCD*10.3 Box 12 Amount 1
FEDCODE2 String*2 Box 12 Code 2
FEDAMT2 BCD*10.3 Box 12 Amount 2
FEDCODE3 String*2 Box 12 Code 3
FEDAMT3 BCD*10.3 Box 12 Amount 3
OTHCODE1 String*15 Box 14 Code 1
OTHAMT1 BCD*10.3 Box 14 Amount 1
OTHCODE2 String*15 Box 14 Code 2
OTHAMT2 BCD*10.3 Box 14 Amount 2
OTHCODE3 String*15 Box 14 Code 3
OTHAMT3 BCD*10.3 Box 14 Amount 3
STATUTEMP Boolean Statutory Employee
DECEASED Boolean Deceased
PENSIONPLN Boolean Pension Plan
LEGALREP Boolean Legal Representative
EMPLOY942 Boolean Hshld. Employee
DEFERCOMP Boolean Deferred Comp. Contrib.
FIPSCODE1 String*2 State Code 1
REPORTID1 String*16 State Report ID 1
SITWAGES1 BCD*10.3 State Amount 1
SIT1 BCD*10.3 State Income Tax 1
LOCNAME1 String*15 Local Report ID 1
LOCWAGES1 BCD*10.3 Local Amount 1
LOCTAX1 BCD*10.3 Local Income Tax 1
FIPSCODE2 String*2 State Code 2
REPORTID2 String*16 State Report ID 2
SITWAGES2 BCD*10.3 State Amount 2
SIT2 BCD*10.3 State Income Tax 2
LOCNAME2 String*15 Local Report ID 2
LOCWAGES2 BCD*10.3 Local Amount 2
LOCTAX2 BCD*10.3 Local Income Tax 2
COUNTRY String*30 Country
FEDCODE4 String*2 Box 12 Code 4
FEDAMT4 BCD*10.3 Box 12 Amount 4
EMPLOYEE String*12 Employee
OTHCODE4 String*15 Box 14 Code 4
OTHAMT4 BCD*10.3 Box 14 Amount 4
PHONENO String*15 Phone Number
CONFIRMNO String*15 Confirmation Number

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).