Sales Payment Document Keys Master (RVLPD007)

0	Balance Carried Forward
1	Sales / Invoice
2	Scheduled Payments
3	Debit Memo
4	Finance Charge
5	Service Repairs
6	Warranties
7	Credit Memo
8	Returns
9	Payments

SELECT
       ['Sales Payment Document Keys Master'].CUSTNMBR AS 'Sales Payment Document Keys Master-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       RVLPD007 AS ['Sales Payment Document Keys Master']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Sales Payment Document Keys Master'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR

SELECT
       ['Sales Payment Document Keys Master'].CHEKBKID AS 'Sales Payment Document Keys Master-Checkbook ID'
       ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
       RVLPD007 AS ['Sales Payment Document Keys Master']
INNER JOIN
       CM00100 AS ['CM Checkbook Master']
              ON
                     ['Sales Payment Document Keys Master'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID