W2 MMREF-1 Detail (W200006)

azurecurve Products Microsoft Dynamics GP (0)SystemW2 MMREF-1 Detail (W200006)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: W2 MMREF-1 Detail
Physical Name: W200006
Technical Name: W2_MMREF1_Detail

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	RPTNGYR	Reporting Year	Integer	INT4_U0	4
2	CMPANYID	Company ID	Integer	INT5	4
	Key to the Company Master (SY01500). Click to show/hide SELECT ['W2 MMREF-1 Detail'].CMPANYID AS 'W2 MMREF-1 Detail-Company ID' ,['Company Master'].CMPANYID AS 'Company Master-Company ID' FROM W200006 AS ['W2 MMREF-1 Detail'] INNER JOIN DYNAMICS..SY01500 AS ['Company Master'] ON ['W2 MMREF-1 Detail'].CMPANYID = ['Company Master'].CMPANYID
3	CMPNYNAM	Company Name	String	STR64_Company_Name	64
4	Location_Address	Location Address	String	STR22_LBAU	22
5	Delivery_Address	Delivery Address	String	STR22_LBAU	22
6	CITY	City	String	STR35	35
7	STATECD	State Code	String	STR2_State_Code	2
8	ZIPCODE	Zip Code	String	STR10	10
9	Foreign_Address	Foreign Address	Boolean	CB_Foreign_Address	0
10	Foreign_StateProvince	Foreign State/Province	String	STR23	23
11	Foreign_Postal_Code	Foreign Postal Code	String	STR15_LBAU	15
12	CCode	Country Code	String	STR6_VAT	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['W2 MMREF-1 Detail'].CCode AS 'W2 MMREF-1 Detail-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM W200006 AS ['W2 MMREF-1 Detail'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['W2 MMREF-1 Detail'].CCode = ['VAT Country Code MSTR'].CCode
13	EPRIDNBR	Employer ID Number	String	STR9_Employer_ID_Number	9
14	Establishment_Number	Establishment Number	String	STR5	5
15	Employment_Code	Employment Code	Integer	DDL_Employment_Code	0
16	Terminated_Business	Terminated Business	Boolean	CB_Terminated_Business	0
17	Agent_Indicator_Code	Agent Indicator Code	Integer	DDL_Agent_Indicator_Code	0
18	Agent_ID_Number	Agent ID Number	String	STR9_Employer_ID_Number	9
19	Agent_for_EIN	Agent for EIN	String	STR9_Employer_ID_Number	9
20	WAGEFILE	Wage File Exists	String	STR3	3
21	DATE1	Date	Date	DT6	6
22	TIME1	Time	Time	TM6	6
23	INCLUDCO	Include Company	Boolean	CB	0
24	EMPW2TOT	Employer W2 Total	Long Integer	LI7_U2	7
25	EMPWTOC	Employer Wages, Tips, Other	Currency	DLR14	14
26	EMPFEDTX	Employer Federal Tax	Currency	DLR14	14
27	EMPSSWGS	Employer Social Security Wages	Currency	DLR14	14
28	EMPSSTIP	Employer Social Security Tips	Currency	DLR14	14
29	EMPSSTAX	Employer Social Security Tax	Currency	DLR14	14
30	EMPMEDWG	Employer Medicare Wages	Currency	DLR14	14
31	EMPMEDTX	Employer Medicare Tax	Currency	DLR14	14
32	Employer_EIC_Payments	Employer EIC Payments	Currency	DLR14	14
33	Employer_Allocated_Tips	Employer Allocated Tips	Currency	DLR14	14
34	EmployerKind	Employer Kind	Integer	DDL_Employer_Kind	0

azurecurve Products Microsoft Dynamics GP (0)SystemW2 MMREF-1 Detail (W200006)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply