Customer Master Address File (RM00102)

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

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

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'

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

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

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

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

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

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