W200006 - W2 MMREF-1 Detail | Prospr - Dynamics GP Table Reference

W200006 - W2 MMREF-1 Detail

Select * from W200006

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
RPTNGYR	Reporting Year	Integer	2	View
CMPANYID	Company ID	Integer	2	View
CMPNYNAM	Company Name	String	66	View
Location_Address	Location Address	String	24	View
Delivery_Address	Delivery Address	String	24	View
CITY	City	String	36	View
STATECD	State Code	String	4	View
ZIPCODE	Zip Code	String	12	View
Foreign_Address	Foreign Address	Boolean	2	View
Foreign_StateProvince	Foreign State/Province	String	24	View
Foreign_Postal_Code	Foreign Postal Code	String	16	View
CCode	Country Code	String	8	View
EPRIDNBR	Employer ID Number	String	10	View
Establishment_Number	Establishment Number	String	6	View
Employment_Code	Employment Code	Integer	2	View
Terminated_Business	Terminated Business	Boolean	2	View
Agent_Indicator_Code	Agent Indicator Code	Integer	2	View
Agent_ID_Number	Agent ID Number	String	10	View
Agent_for_EIN	Agent for EIN	String	10	View
WAGEFILE	Wage File Exists	String	4	View
DATE1	Date	Date	4	View
TIME1	Time	Time	4	View
INCLUDCO	Include Company	Boolean	2	View
EMPW2TOT	Employer W2 Total	Long Integer	4	View
EMPWTOC	Employer Wages, Tips, Other	Currency	10	View
EMPFEDTX	Employer Federal Tax	Currency	10	View
EMPSSWGS	Employer Social Security Wages	Currency	10	View
EMPSSTIP	Employer Social Security Tips	Currency	10	View
EMPSSTAX	Employer Social Security Tax	Currency	10	View
EMPMEDWG	Employer Medicare Wages	Currency	10	View
EMPMEDTX	Employer Medicare Tax	Currency	10	View
Employer_EIC_Payments	Employer EIC Payments	Currency	10	View
Employer_Allocated_Tips	Employer Allocated Tips	Currency	10	View
EmployerKind	Employer Kind	Integer	2	View