W2 Magnetic Media Detail (W200002)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/W200002

Display Name: W2 Magnetic Media Detail
Physical Name: W200002
Technical Name: W2_Mag_Media_Detail

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	RPTNGYR	Reporting Year	Integer	INT4_U0	4
2	CMPNYNAM	Company Name	String	STR64_Company_Name	64
3	EMPLTYPE	Employment Type	String	STR7_LB	7
4	WAGEFILE	Wage File Exists	String	STR3	3
5	DATE1	Date	Date	DT6	6
6	TIME1	Time	Time	TM6	6
7	EPRIDNBR	Employer ID Number	String	STR9_Employer_ID_Number	9
8	INCLUDCO	Include Company	Boolean	CB	0
9	EMPLRADD	Employer Address	String	STR30_LBAU	30
10	EMPLRCTY	Employer City	String	STR25_LBU	25
11	STATECD	State Code	String	STR2_State_Code	2
12	ZIPCODE	Zip Code	String	STR10	10
13	PHONNAME	Phone Number	String	Phone_Number	14
14	CMPANYID	Company ID	Integer	INT5	4
	Key to the Company Master (SY01500). Click to show/hide SELECT ['W2 Magnetic Media Detail'].CMPANYID AS 'W2 Magnetic Media Detail-Company ID' ,['Company Master'].CMPANYID AS 'Company Master-Company ID' FROM W200002 AS ['W2 Magnetic Media Detail'] INNER JOIN DYNAMICS..SY01500 AS ['Company Master'] ON ['W2 Magnetic Media Detail'].CMPANYID = ['Company Master'].CMPANYID
15	EMPW2TOT	Employer W2 Total	Long Integer	LI7_U2	7
16	EMPWTOC	Employer Wages, Tips, Other	Currency	DLR14	14
17	EMPFEDTX	Employer Federal Tax	Currency	DLR14	14
18	EMPSSWGS	Employer Social Security Wages	Currency	DLR14	14
19	EMPSSTAX	Employer Social Security Tax	Currency	DLR14	14
20	EMPMEDWG	Employer Medicare Wages	Currency	DLR14	14
21	EMPMEDTX	Employer Medicare Tax	Currency	DLR14	14
22	EMPSSTIP	Employer Social Security Tips	Currency	DLR14	14