Customer Master Address File (RM00102)

azurecurveProductsMicrosoft Dynamics GP (0)SalesCustomer Master Address File (RM00102)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Customer Master Address File
Physical Name: RM00102
Technical Name: RM_Customer_MSTR_ADDR

Group Display Name: Receivables Customer Master Files
Group Technical Name: RM_Customer_MSTR_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['Customer Master Address File'].CUSTNMBR AS 'Customer Master Address File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       RM00102 AS ['Customer Master Address File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Customer Master Address File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
Partial key to the Address Electronic Funds Transfer Master (SY06000).

Click to show/hide

SELECT
       ['Customer Master Address File'].ADRSCODE AS 'Customer Master Address File-Address Code'
       ,['Address Electronic Funds Transfer Master'].ADRSCODE AS 'Address Electronic Funds Transfer Master-Address Code'
FROM
       RM00102 AS ['Customer Master Address File']
INNER JOIN
       SY06000 AS ['Address Electronic Funds Transfer Master']
              ON
                     ['Customer Master Address File'].ADRSCODE = ['Address Electronic Funds Transfer Master'].ADRSCODE
              AND
                     ['Customer Master Address File'].CUSTNMBR = ['Address Electronic Funds Transfer Master'].CUSTNMBR
              AND
                     ['Address Electronic Funds Transfer Master'].SERIES = 3
Partial key to the Internet Addresses (SY01200).

Click to show/hide

SELECT
       ['Customer Master Address File'].ADRSCODE AS 'Customer Master Address File-Address Code'
       ,['Internet Addresses'].ADRSCODE AS 'Internet Addresses-Address Code'
FROM
       RM00102 AS ['Customer Master Address File']
INNER JOIN
       SY01200 AS ['Internet Addresses']
              ON
                     ['Customer Master Address File'].ADRSCODE = ['Internet Addresses'].ADRSCODE
              AND
                     ['Customer Master Address File'].CUSTNMBR = ['Internet Addresses'].Master_ID
              AND
                     ['Internet Addresses'].Master_Type = 'CUS'
3SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['Customer Master Address File'].SLPRSNID AS 'Customer Master Address File-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       RM00102 AS ['Customer Master Address File']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['Customer Master Address File'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
4UPSZONE SearchUPS ZoneSTR3String43
5SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString1615
Key to the Shipping Methods Master (SY03000).

Click to show/hide

SELECT
       ['Customer Master Address File'].SHIPMTHD AS 'Customer Master Address File-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       RM00102 AS ['Customer Master Address File']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['Customer Master Address File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
6TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['Customer Master Address File'].TAXSCHID AS 'Customer Master Address File-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       RM00102 AS ['Customer Master Address File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['Customer Master Address File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
7CNTCPRSN SearchContact PersonSTR60String6260
8ADDRESS1 SearchAddress 1STR60String6260
9ADDRESS2 SearchAddress 2STR60String6260
10ADDRESS3 SearchAddress 3STR60String6260
11COUNTRY SearchCountrySTR60String6260
12CITY SearchCitySTR35String3635
13STATE SearchStateSTR30_StateString3029
14ZIP SearchZipSTR10String1210
15PHONE1 SearchPhone 1Phone_NumberString2214
16PHONE2 SearchPhone 2Phone_NumberString2214
17PHONE3 SearchPhone 3Phone_Number3String2214
18FAX SearchFaxSTR14_FAXString2214
19MODIFDT SearchModified DateDTDate48
20CREATDDT SearchCreated DateDTDate48
21GPSFOINTEGRATIONID SearchGPSFO Integration IDSTR30String3230
22INTEGRATIONSOURCE SearchIntegration SourceINTInteger20
23INTEGRATIONID SearchIntegration IDSTR30String3230
24CCode SearchCountry CodeSTR6_VATString86
Key to the VAT Country Code MSTR (VAT10001).

Click to show/hide

SELECT
       ['Customer Master Address File'].CCode AS 'Customer Master Address File-Country Code'
       ,['VAT Country Code MSTR'].CCode AS 'VAT Country Code MSTR-Country Code'
FROM
       RM00102 AS ['Customer Master Address File']
INNER JOIN
       VAT10001 AS ['VAT Country Code MSTR']
              ON
                     ['Customer Master Address File'].CCode = ['VAT Country Code MSTR'].CCode
25DECLID SearchDeclarant IDSTR15_Address_CodeString1615
26LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['Customer Master Address File'].LOCNCODE AS 'Customer Master Address File-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       RM00102 AS ['Customer Master Address File']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['Customer Master Address File'].LOCNCODE = ['Site Setup'].LOCNCODE
27SALSTERR SearchSales TerritorySTR15_Sales_TerritoryString1615
Key to the Sales Territory Master File (RM00303).

Click to show/hide

SELECT
       ['Customer Master Address File'].SALSTERR AS 'Customer Master Address File-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       RM00102 AS ['Customer Master Address File']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['Customer Master Address File'].SALSTERR = ['Sales Territory Master File'].SALSTERR
28USERDEF1 SearchUser Defined 1STR20String2220
29USERDEF2 SearchUser Defined 2STR20String2220
30ShipToName SearchShipToNameSTR64_Customer_NameString6664
31Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger20
32DEX_ROW_TS Searchdatetimedatetime33
DEX_ROW_TS records the time the record was last changed; often used with integration tools to identify which records have changed and need to be synchronised.
33DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)SalesCustomer Master Address File (RM00102)

Leave a Reply

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