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 TypeSQL DB LengthKeyable Length
1RPTNGYR SearchReporting YearINT4_U0Integer24
2CMPNYNAM SearchCompany NameSTR64_Company_NameString6664
3Location_Address SearchLocation AddressSTR22_LBAUString2422
4Delivery_Address SearchDelivery AddressSTR22_LBAUString2422
5CITY SearchCitySTR35String3635
6STATECD SearchState CodeSTR2_State_CodeString42
7ZIPCODE SearchZip CodeSTR10String1210
8Foreign_Address SearchForeign AddressCB_Foreign_AddressBoolean20
9Foreign_StateProvince SearchForeign State/ProvinceSTR23String2423
10Foreign_Postal_Code SearchForeign Postal CodeSTR15_LBAUString1615
11CCode SearchCountry CodeSTR6_VATString86
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 NameSTR57String5857
13Submitter_Location_Addre SearchSubmitter Location AddressSTR22_LBAUString2422
14Submitter_Delivery_Addre SearchSubmitter Delivery AddressSTR22_LBAUString2422
15Submitter_City SearchSubmitter CitySTR22_LBAUString2422
16Submitter_State_Code SearchSubmitter State CodeSTR2_State_CodeString42
17Submitter_Zip_Code SearchSubmitter Zip CodeSTR10String1210
18Submitter_Foreign_Addres SearchSubmitter Foreign AddressCB_Foreign_AddressBoolean20
19Submitter_Foreign_StateP SearchSubmitter Foreign State/ProvinceSTR23String2423
20Submitter_Foreign_Postal SearchSubmitter Foreign Postal CodeSTR15_LBAUString1615
21Submitter_Country_Code SearchSubmitter Country CodeSTR2_LBAUString42
22Submitter_EIN SearchSubmitter EINSTR9_Employer_ID_NumberString109
23Method_of_Notification SearchMethod of NotificationDDL_Method_Of_NotificationInteger20
24Preparer_Code SearchPreparer CodeDDL_Preparer_CodeInteger20
25CNTCPRSN SearchContact PersonSTR60String6260
26PHONNAME SearchPhone NumberPhone_NumberString2214
27FAXNUMBR SearchFax NumberSTR14_FAXString2214
28EMail SearchEMailSTR255String256255
29MMREFPIN SearchMMREF PINSTR17_MMREFPINString1817
30DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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