Multicurrency Receivables Transactions (MC020102)

azurecurveProductsMicrosoft Dynamics GP (0)SalesMulticurrency Receivables Transactions (MC020102)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MC020102

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Multicurrency Receivables Transactions
Physical Name: MC020102
Technical Name: MC_RM_Transactions

Group Display Name: Receivables Open Transaction Files
Group Technical Name: RM_Open_Transaction_Logical_File

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DCSTATUS SearchDocument StatusIntegerDDL_Doc_Status0
2RMDTYPAL SearchRM Document Type-AllIntegerINT22
Document Type records the type of document.

Click to show/hide the Document Types


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
3DOCNUMBR SearchDocument NumberStringSTR20_Document_Number20
4DOCDATE SearchDocument DateDateDT8
5CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

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
6CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

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
7TRXSORCE SearchTRX SourceStringSTR1313
8CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

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
9RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

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
10EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

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
11XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
12EXCHDATE SearchExchange DateDateDT_Date6
13TIME1 SearchTimeTimeTM66
14RTCLCMTD SearchRate Calculation MethodIntegerGB0
15ORCTRXAM SearchOriginating Current Trx AmountCurrencyDLR17_RBS0_UTR$17
16ORSLSAMT SearchOriginating Sales AmountCurrencyDLR19_RBSO_STR$19
17ORCSTAMT SearchOriginating Cost AmountCurrencyDLR19_RBSO_UTR$19
18ORFRTAMT SearchOriginating Freight AmountCurrencyDLR17_RBS0_UTR$17
19ORMISCAMT SearchOriginating Misc AmountCurrencyDLR19_RBSO_UTR$19
20ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
21ORCASAMT SearchOriginating Cash AmountCurrencyDLR19_RBSO_UTR$19
22ORCHKAMT SearchOriginating Check AmountCurrencyDLR19_RBSO_UTR$19
23ORCCDAMT SearchOriginating Credit Card AmountCurrencyDLR19_RBSO_UTR$19
24ORAPPAMT SearchOriginating Applied AmountCurrencyDLR17_RBS0_STR$17
25ORDISTKN SearchOriginating Discount Taken AmountCurrencyDLR17_RBS0_UTR$17
26ORDAVAMT SearchOriginating Discount Available AmountCurrencyDLR17_RBS0_UTR$17
27ORDATKN SearchOriginating Discount Available TakenCurrencyDLR17_RBS0_UTR$17
28ORDISRTD SearchOriginating Discount ReturnedCurrencyDLR17_RBS0_STR$17
29ORDDLRAT SearchOriginating Discount Dollar AmountCurrencyDLR11_RBS0_UTR$11
30ORTDISAM SearchOriginating Trade Discount AmountCurrencyDLR17_RBS0_UTR$17
31ORORGTRX SearchOriginating Original Trx AmountCurrencyDLR17_RBS0_STR$17
32ORWROFAM SearchOriginating Write Off AmountCurrencyDLR17_RBS0_STR$17
33ORCOMAMT SearchOriginating Commission Dollar AmountCurrencyDLR17_RBSO_STR$17
34ORBKTSLS SearchOriginating Backout Sales AmountCurrencyDLR19_RBS0_UTR$19
35ORBKTFRT SearchOriginating Backout Freight AmountCurrencyDLR19_RBS0_UTR$19
36ORBKTMSC SearchOriginating Backout Misc AmountCurrencyDLR19_RBS0_UTR$19
37UNGANLOS SearchUnrealized Gain-Loss AmountCurrencyDLR19_$S219
38RMMCERRS SearchRM MC Posting Error MessagesLong IntegerRM_MC_Posting_Error_Messages0
39DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
40MCTRXSTT SearchMC Transaction StateIntegerINT11
MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank.

Click to show/hide MC Transaction States

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.
41OrigBackoutTradeDisc SearchOriginating Backout Trade Discount AmountCurrencyDLR19_RBS0_UTR$19
azurecurveProductsMicrosoft Dynamics GP (0)SalesMulticurrency Receivables Transactions (MC020102)

Leave a Reply

Your email address will not be published. Required fields are marked *