Customer Payment Document Setup (RVLPD005)

SELECT
       ['Debtor Payment Document Setup'].CUSTNMBR AS 'Debtor Payment Document Setup-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       RVLPD005 AS ['Debtor Payment Document Setup']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Debtor Payment Document Setup'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR

SELECT
       ['Debtor Payment Document Setup'].CHEKBKID AS 'Debtor Payment Document Setup-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       RVLPD005 AS ['Debtor Payment Document Setup']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Debtor Payment Document Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID

SELECT
       ['Debtor Payment Document Setup'].NOTEINDX AS 'Debtor Payment Document Setup-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       RVLPD005 AS ['Debtor Payment Document Setup']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Debtor Payment Document Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX