Multicurrency Receivables Transactions (MC020102)

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
       ['Multicurrency Receivables Transactions'].CUSTNMBR AS 'Multicurrency Receivables Transactions-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       MC020102 AS ['Multicurrency Receivables Transactions']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['Multicurrency Receivables Transactions'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR

SELECT
       ['Multicurrency Receivables Transactions'].CURNCYID AS 'Multicurrency Receivables Transactions-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       MC020102 AS ['Multicurrency Receivables Transactions']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Multicurrency Receivables Transactions'].CURNCYID = ['Currency Setup'].CURNCYID

SELECT
       ['Multicurrency Receivables Transactions'].CURRNIDX AS 'Multicurrency Receivables Transactions-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       MC020102 AS ['Multicurrency Receivables Transactions']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['Multicurrency Receivables Transactions'].CURRNIDX = ['Currency Setup'].CURRNIDX

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

SELECT
       ['Multicurrency Receivables Transactions'].EXGTBLID AS 'Multicurrency Receivables Transactions-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       MC020102 AS ['Multicurrency Receivables Transactions']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['Multicurrency Receivables Transactions'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID

0	Euro currency is not created or no denomination currencies are enabled.
		1	Originating is not a denomination; Functional is not a denomination
		2	Originating is not a denomination; Functional is the Euro currency.
		3	Originating is not a denomination; Functional is a denomination.
		4	Originating is a denomination; Functional is not a denomination.
		5	Originating is a denomination; Functional is a denomination.
		6	Originating is a denomination; Functional is the Euro currency.
		7	Originating is the Euro currency; Functional is a denomination.
		8	Originating is the Euro currency; Functional is not a denomination.