MC020102 - Multicurrency Receivables Transactions
Dynamics GP table MC020102 (Multicurrency Receivables Transactions) contains 41 columns including DCSTATUS, RMDTYPAL, DOCNUMBR....
SQL Query Builder
41 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| DCSTATUS | Document Status1 = Work2 = Open3 = History | Integer | 2 | ||
Document Status values (4) 0 = Reserved1 = Work (unposted)2 = Open (posted, not fully applied)3 = History (fully applied/paid) | |||||
| RMDTYPAL | RM Document Type-All0 = Reserved for balance carried forward records1 = Sales / Invoice2 = Reserved for schedule payments3 = Debit Memos4 = Finance Charges5 = Service Repairs6= Warranties7 = Credit Memos8 = Returns9 = Payments | Integer | 2 | ||
| DOCNUMBR | Document Number | String | 22 | ||
| DOCDATE | Document Date | Date | 4 | ||
| CUSTNMBR | Customer Number | String | 16 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| CURRNIDX | Currency Index | Integer | 2 | ||
| RATETPID | Rate Type ID | String | 16 | ||
| EXGTBLID | Exchange Table ID | String | 16 | ||
| XCHGRATE | Exchange Rate | Currency (Variable) | 10 | ||
| EXCHDATE | Exchange Date | Date | 4 | ||
| TIME1 | Time | Time | 4 | ||
| RTCLCMTD | Rate Calculation Method | Integer | 2 | ||
| ORCTRXAM | Originating Current Trx Amount | Currency | 10 | ||
| ORSLSAMT | Originating Sales Amount | Currency | 10 | ||
| ORCSTAMT | Originating Cost Amount | Currency | 10 | ||
| ORFRTAMT | Originating Freight Amount | Currency | 10 | ||
| ORMISCAMT | Originating Misc Amount | Currency | 10 | ||
| ORTAXAMT | Originating Tax Amount | Currency | 10 | ||
| ORCASAMT | Originating Cash Amount | Currency | 10 | ||
| ORCHKAMT | Originating Check Amount | Currency | 10 | ||
| ORCCDAMT | Originating Credit Card Amount | Currency | 10 | ||
| ORAPPAMT | Originating Applied Amount | Currency | 10 | ||
| ORDISTKN | Originating Discount Taken Amount | Currency | 10 | ||
| ORDAVAMT | Originating Discount Available Amount | Currency | 10 | ||
| ORDATKN | Originating Discount Available Taken | Currency | 10 | ||
| ORDISRTD | Originating Discount Returned | Currency | 10 | ||
| ORDDLRAT | Originating Discount Dollar Amount | Currency | 10 | ||
| ORTDISAM | Originating Trade Discount Amount | Currency | 10 | ||
| ORORGTRX | Originating Original Trx Amount | Currency | 10 | ||
| ORWROFAM | Originating Write Off Amount | Currency | 10 | ||
| ORCOMAMT | Originating Commission Dollar Amount | Currency | 10 | ||
| ORBKTSLS | Originating Backout Sales Amount | Currency | 10 | ||
| ORBKTFRT | Originating Backout Freight Amount | Currency | 10 | ||
| ORBKTMSC | Originating Backout Misc Amount | Currency | 10 | ||
| UNGANLOS | Unrealized Gain-Loss Amount | Currency | 10 | ||
| RMMCERRS | RM MC Posting Error Messages | Long Integer | 4 | ||
| DENXRATE | Denomination Exchange Rate | Currency (Variable) | 10 | ||
| MCTRXSTT | MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = 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. | Integer | 2 | ||
| OrigBackoutTradeDisc | Originating Backout Trade Discount Amount | Currency | 10 | ||
Related Tables
Tables that share columns with MC020102. Click "Join" to add to your query.