W2 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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1RPTNGYR SearchReporting YearIntegerINT4_U04
2CMPNYNAM SearchCompany NameStringSTR64_Company_Name64
3Location_Address SearchLocation AddressStringSTR22_LBAU22
4Delivery_Address SearchDelivery AddressStringSTR22_LBAU22
5CITY SearchCityStringSTR3535
6STATECD SearchState CodeStringSTR2_State_Code2
7ZIPCODE SearchZip CodeStringSTR1010
8Foreign_Address SearchForeign AddressBooleanCB_Foreign_Address0
9Foreign_StateProvince SearchForeign State/ProvinceStringSTR2323
10Foreign_Postal_Code SearchForeign Postal CodeStringSTR15_LBAU15
11CCode SearchCountry CodeStringSTR6_VAT6
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
12Submitter_Name SearchSubmitter NameStringSTR5757
13Submitter_Location_Addre SearchSubmitter Location AddressStringSTR22_LBAU22
14Submitter_Delivery_Addre SearchSubmitter Delivery AddressStringSTR22_LBAU22
15Submitter_City SearchSubmitter CityStringSTR22_LBAU22
16Submitter_State_Code SearchSubmitter State CodeStringSTR2_State_Code2
17Submitter_Zip_Code SearchSubmitter Zip CodeStringSTR1010
18Submitter_Foreign_Addres SearchSubmitter Foreign AddressBooleanCB_Foreign_Address0
19Submitter_Foreign_StateP SearchSubmitter Foreign State/ProvinceStringSTR2323
20Submitter_Foreign_Postal SearchSubmitter Foreign Postal CodeStringSTR15_LBAU15
21Submitter_Country_Code SearchSubmitter Country CodeStringSTR2_LBAU2
22Submitter_EIN SearchSubmitter EINStringSTR9_Employer_ID_Number9
23Method_of_Notification SearchMethod of NotificationIntegerDDL_Method_Of_Notification0
24Preparer_Code SearchPreparer CodeIntegerDDL_Preparer_Code0
25CNTCPRSN SearchContact PersonStringSTR6060
26PHONNAME SearchPhone NumberStringPhone_Number14
27FAXNUMBR SearchFax NumberStringSTR14_FAX14
28EMail SearchEMailStringSTR255255
29MMREFPIN SearchMMREF PINStringSTR17_MMREFPIN17

Leave a Reply

Your email address will not be published. Required fields are marked *