W2 MMREF-1 Master (W200005)

azurecurve Products Microsoft Dynamics GP (0)SystemW2 MMREF-1 Master (W200005)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: W2 MMREF-1 Master
Physical Name: W200005
Technical Name: W2_MMREF1_MSTR

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	Location_Address	Location Address	String	STR22_LBAU	22
4	Delivery_Address	Delivery Address	String	STR22_LBAU	22
5	CITY	City	String	STR35	35
6	STATECD	State Code	String	STR2_State_Code	2
7	ZIPCODE	Zip Code	String	STR10	10
8	Foreign_Address	Foreign Address	Boolean	CB_Foreign_Address	0
9	Foreign_StateProvince	Foreign State/Province	String	STR23	23
10	Foreign_Postal_Code	Foreign Postal Code	String	STR15_LBAU	15
11	CCode	Country Code	String	STR6_VAT	6
	Key to the VAT Country Code MSTR (VAT10001). Click to show/hide SELECT ['W2 MMREF-1 Master'].CCode AS 'W2 MMREF-1 Master-Country Code' ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code' FROM W200005 AS ['W2 MMREF-1 Master'] INNER JOIN VAT10001 AS ['VAT Country Code MSTR'] ON ['W2 MMREF-1 Master'].CCode = ['VAT Country Code MSTR'].CCode
12	Submitter_Name	Submitter Name	String	STR57	57
13	Submitter_Location_Addre	Submitter Location Address	String	STR22_LBAU	22
14	Submitter_Delivery_Addre	Submitter Delivery Address	String	STR22_LBAU	22
15	Submitter_City	Submitter City	String	STR22_LBAU	22
16	Submitter_State_Code	Submitter State Code	String	STR2_State_Code	2
17	Submitter_Zip_Code	Submitter Zip Code	String	STR10	10
18	Submitter_Foreign_Addres	Submitter Foreign Address	Boolean	CB_Foreign_Address	0
19	Submitter_Foreign_StateP	Submitter Foreign State/Province	String	STR23	23
20	Submitter_Foreign_Postal	Submitter Foreign Postal Code	String	STR15_LBAU	15
21	Submitter_Country_Code	Submitter Country Code	String	STR2_LBAU	2
22	Submitter_EIN	Submitter EIN	String	STR9_Employer_ID_Number	9
23	Method_of_Notification	Method of Notification	Integer	DDL_Method_Of_Notification	0
24	Preparer_Code	Preparer Code	Integer	DDL_Preparer_Code	0
25	CNTCPRSN	Contact Person	String	STR60	60
26	PHONNAME	Phone Number	String	Phone_Number	14
27	FAXNUMBR	Fax Number	String	STR14_FAX	14
28	EMail	EMail	String	STR255	255
29	MMREFPIN	MMREF PIN	String	STR17_MMREFPIN	17

azurecurve Products Microsoft Dynamics GP (0)SystemW2 MMREF-1 Master (W200005)

Click to show/hide

Leave a Reply Cancel reply