Table: Paper W-2 Information

Table: UTW2PD
View: UT0007
Record length: 1371
Flags: A R 

Keys: 2

Title  Flags  Fields

Primary Key Name  SEQUENCE, SORTPARAM, PRIMEKEY
Key Name  D M  SEQUENCE, SORTPARAM, CONTROL, SUBTOTAL

Fields: 81

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   

This page was generated on 2008-May-02

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.