View: Paper W-2 Information

RotoID: UT0007
Table: UTW2PD
Protocol: Flat
DLL:UTW2PD

Keys: 2

Title	Fields

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

Fields: 79

Field	Index	Type	Title	Attributes	Presentation

SEQUENCE	1	Integer	Sequence	E A K R
SORTPARAM	2	String*94	Sort Parameter	E A K R
PRIMEKEY	3	Long	PrimeKey	E A K R
CONTROL	4	Long	Control	E A
SUBTOTAL	5	Boolean	Subtotal	E A
VOIDW2	6	Boolean	Void W-2	E A
EMPLREIN	7	String*9	Employer EIN	E A	Mask: %-2d-%-7d
EMPLRNAME	8	String*60	Employer Name	E A
EMPLRADDR1	9	String*60	Employer Address 1	E A
EMPLRADDR2	10	String*60	Employer Address 2	E A
EMPLRADDR3	11	String*60	Employer Address 3	E A
EMPLRADDR4	12	String*60	Employer Address 4	E A
EMPLRCITY	13	String*30	Employer City	E A
EMPLRSTATE	14	String*30	Employer State	E A
EMPLRZIP	15	String*20	Employer Zip Code	E A	Mask: %-9c
SSN	16	String*11	Employee SSN	E A	Mask: %-3d-%-2d-%-4d
LASTNAME	17	String*20	Employee Last Name	E A
FIRSTNAME	18	String*15	Employee First Name	E A
MIDDLENAME	19	String*15	Employee Middle Name	E A
ADDRESS1	20	String*60	Employee Address 1	E A
ADDRESS2	21	String*60	Employee Address 2	E A
ADDRESS3	22	String*60	Employee Address 3	E A
ADDRESS4	23	String*60	Employee Address 4	E A
CITY	24	String*30	Employee City	E A
STATE	25	String*30	Employee State	E A
ZIP	26	String*20	Employee Zip Code	E A
WAGESTIPS	27	BCD*10.3	Amount	E A
FIT	28	BCD*10.3	Income Tax	E A
SSWAGES	29	BCD*10.3	Wages	E A
SSTAXWHLD	30	BCD*10.3	Tax Withheld	E A
MEDWAGETIP	31	BCD*10.3	Med. Wage Tip	E A
MEDTAXWHLD	32	BCD*10.3	Med. Tax Withheld	E A
SSTIPS	33	BCD*10.3	Tips	E A
ALLOCTIPS	34	BCD*10.3	Allocated Tips	E A
AEIC	35	BCD*10.3	AEIC	E A
DEPCARE	36	BCD*10.3	Dependent Care	E A
NONQUALCOD	37	String*1	Nonqualified COD	E A
NONQUALPLN	38	BCD*10.3	Nonqualified Plan	E A
BENEFITS	39	BCD*10.3	Fringe Benefit	E A
FEDCODE1	40	String*2	Box 12 Code 1	E A
FEDAMT1	41	BCD*10.3	Box 12 Amount 1	E A
FEDCODE2	42	String*2	Box 12 Code 2	E A
FEDAMT2	43	BCD*10.3	Box 12 Amount 2	E A
FEDCODE3	44	String*2	Box 12 Code 3	E A
FEDAMT3	45	BCD*10.3	Box 12 Amount 3	E A
OTHCODE1	46	String*15	Box 14 Code 1	E A
OTHAMT1	47	BCD*10.3	Box 14 Amount 1	E A
OTHCODE2	48	String*15	Box 14 Code 2	E A
OTHAMT2	49	BCD*10.3	Box 14 Amount 2	E A
OTHCODE3	50	String*15	Box 14 Code 3	E A
OTHAMT3	51	BCD*10.3	Box 14 Amount 3	E A
STATUTEMP	52	Boolean	Statutory Employee	E A
DECEASED	53	Boolean	Deceased	E A
PENSIONPLN	54	Boolean	Pension Plan	E A
LEGALREP	55	Boolean	Legal Representative	E A
EMPLOY942	56	Boolean	Hshld. Employee	E A
DEFERCOMP	57	Boolean	Deferred Comp. Contrib.	E A
FIPSCODE1	58	String*2	State Code 1	E A
REPORTID1	59	String*16	State Report ID 1	E A
SITWAGES1	60	BCD*10.3	State Amount 1	E A
SIT1	61	BCD*10.3	State Income Tax 1	E A
LOCNAME1	62	String*15	Local Report ID 1	E A
LOCWAGES1	63	BCD*10.3	Local Amount 1	E A
LOCTAX1	64	BCD*10.3	Local Income Tax 1	E A
FIPSCODE2	65	String*2	State Code 2	E A
REPORTID2	66	String*16	State Report ID 2	E A
SITWAGES2	67	BCD*10.3	State Amount 2	E A
SIT2	68	BCD*10.3	State Income Tax 2	E A
LOCNAME2	69	String*15	Local Report ID 2	E A
LOCWAGES2	70	BCD*10.3	Local Amount 2	E A
LOCTAX2	71	BCD*10.3	Local Income Tax 2	E A
COUNTRY	72	String*30	Country	E A
FEDCODE4	73	String*2	Box 12 Code 4	E A
FEDAMT4	74	BCD*10.3	Box 12 Amount 4	E A
EMPLOYEE	75	String*12	Employee	E A
OTHCODE4	76	String*15	Box 14 Code 4	E A
OTHAMT4	77	BCD*10.3	Box 14 Amount 4	E A
PHONENO	78	String*15	Phone Number	E A
CONFIRMNO	79	String*15	Confirmation Number	E A

© 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).