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 TypeLength
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_CodeString15
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_IDString15
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 ZoneSTR3String3
5SHIPMTHD SearchShipping MethodSTR15_Shipping_MethodString15
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_IDString15
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 PersonSTR60String60
8ADDRESS1 SearchAddress 1STR60String60
9ADDRESS2 SearchAddress 2STR60String60
10ADDRESS3 SearchAddress 3STR60String60
11COUNTRY SearchCountrySTR60String60
12CITY SearchCitySTR35String35
13STATE SearchStateSTR30_StateString29
14ZIP SearchZipSTR10String10
15PHONE1 SearchPhone 1Phone_NumberString14
16PHONE2 SearchPhone 2Phone_NumberString14
17PHONE3 SearchPhone 3Phone_Number3String14
18FAX SearchFaxSTR14_FAXString14
19MODIFDT SearchModified DateDTDate8
20CREATDDT SearchCreated DateDTDate8
21GPSFOINTEGRATIONID SearchGPSFO Integration IDSTR30String30
22INTEGRATIONSOURCE SearchIntegration SourceINTInteger0
23INTEGRATIONID SearchIntegration IDSTR30String30
24CCode SearchCountry CodeSTR6_VATString6
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_CodeString15
26LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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_TerritoryString15
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 1STR20String20
29USERDEF2 SearchUser Defined 2STR20String20
30ShipToName SearchShipToNameSTR64_Customer_NameString64
31Print_Phone_NumberGB SearchPrint Phone Number GBGBInteger0
32DEX_ROW_TS Searchdatetimedatetime3
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 Searchintint10

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 *