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_MSTRSeq 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'].CCode12 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