RM_Class_MSTR (RM00201)

SELECT
       ['RM_Class_MSTR'].CHEKBKID AS 'RM_Class_MSTR-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       RM00201 AS ['RM_Class_MSTR']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['RM_Class_MSTR'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID

SELECT
       ['RM_Class_MSTR'].TAXSCHID AS 'RM_Class_MSTR-Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       RM00201 AS ['RM_Class_MSTR']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['RM_Class_MSTR'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID

SELECT
       ['RM_Class_MSTR'].SHIPMTHD AS 'RM_Class_MSTR-Shipping Method'
       ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
       RM00201 AS ['RM_Class_MSTR']
INNER JOIN
       SY03000 AS ['Shipping Methods Master']
              ON
                     ['RM_Class_MSTR'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD

SELECT
       ['RM_Class_MSTR'].PYMTRMID AS 'RM_Class_MSTR-Payment Terms ID'
       ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
       RM00201 AS ['RM_Class_MSTR']
INNER JOIN
       SY03300 AS ['Payment Terms Master']
              ON
                     ['RM_Class_MSTR'].PYMTRMID = ['Payment Terms Master'].PYMTRMID

SELECT
       ['RM_Class_MSTR'].CURNCYID AS 'RM_Class_MSTR-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       RM00201 AS ['RM_Class_MSTR']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['RM_Class_MSTR'].CURNCYID = ['Currency Setup'].CURNCYID

SELECT
       ['RM_Class_MSTR'].RATETPID AS 'RM_Class_MSTR-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       RM00201 AS ['RM_Class_MSTR']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['RM_Class_MSTR'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID

SELECT
       ['RM_Class_MSTR'].SALSTERR AS 'RM_Class_MSTR-Sales Territory'
       ,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
       RM00201 AS ['RM_Class_MSTR']
INNER JOIN
       RM00303 AS ['Sales Territory Master File']
              ON
                     ['RM_Class_MSTR'].SALSTERR = ['Sales Territory Master File'].SALSTERR

SELECT
       ['RM_Class_MSTR'].SLPRSNID AS 'RM_Class_MSTR-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       RM00201 AS ['RM_Class_MSTR']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['RM_Class_MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID

SELECT
       ['RM_Class_MSTR'].NOTEINDX AS 'RM_Class_MSTR-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       RM00201 AS ['RM_Class_MSTR']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['RM_Class_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX