Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/DO50100
Product: Dynamics Online Services (6499)
Series: Sales
Display Name: DO Cust Billing Address
Physical Name: DO50100
Technical Name: doCustBillingAddressSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CUSTNMBR 
Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['DO Cust Billing Address'].CUSTNMBR AS 'DO Cust Billing Address-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
DO50100 AS ['DO Cust Billing Address']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['DO Cust Billing Address'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR2 Address_Verification_Opt Address Verification Option Address Verification Option Integer 0 3 ADRSCODE Address Code STR15_Address_Code String 15 4 CNTCPRSN Contact Person STR60 String 60 5 ADDRESS1 Address 1 STR60 String 60 6 CITY City STR35 String 35 7 STATE State STR30_State String 29 8 ZIP Zip STR10 String 10 9 COUNTRY Country STR60 String 60 10 NextElectronicNumber Next Process Electronic Number Long Int Long Integer 8