MC020103 - Multicurrency Payables Transactions
Stores originating currency amounts for payables transactions in multicurrency environments.
SQL Query Builder
43 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) | |||||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| VCHRNMBR | Voucher Number | String | 22 | ||
| PMNTNMBR | Payment Number | String | 22 | ||
| DOCDATE | Document Date | Date | 4 | ||
| VENDORID | Vendor ID | String | 16 | ||
| CURNCYID | Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. | String | 16 | ||
| 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 | ||
| OPURAMT | Originating Purchases Amount | Currency | 10 | ||
| ORFRTAMT | Originating Freight Amount | Currency | 10 | ||
| OMISCAMT | Originating Misc Charges Amount | Currency | 10 | ||
| ORTAXAMT | Originating Tax Amount | Currency | 10 | ||
| ORCASAMT | Originating Cash Amount | Currency | 10 | ||
| ORCHKAMT | Originating Check Amount | Currency | 10 | ||
| ORCHKTTL | Originating Check Total | Currency | 10 | ||
| ORCCDAMT | Originating Credit Card Amount | Currency | 10 | ||
| ORAPPAMT | Originating Applied Amount | Currency | 10 | ||
| ORDISTKN | Originating Discount Taken Amount | Currency | 10 | ||
| ORDATKN | Originating Discount Available Taken | Currency | 10 | ||
| ORDDLRAT | Originating Discount Dollar Amount | Currency | 10 | ||
| ORTDISAM | Originating Trade Discount Amount | Currency | 10 | ||
| ORWROFAM | Originating Write Off Amount | Currency | 10 | ||
| OBKPURAMT | Originating Backout Purchases 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 | ||
| OCHGAMT | Originating Charge Amount | Currency | 10 | ||
| ORDOCAMT | Originating Document Amount | Currency | 10 | ||
| ODISAMTAV | Originating Discount Amount Available | Currency | 10 | ||
| ORGAPDISCTKN | Originating Applied Discount Taken Amount | Currency | 10 | ||
| OTOTPAY | Originating Total Payments | Currency | 10 | ||
| OR1099AM | Originating 1099 Amount | Currency | 10 | ||
| 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 MC020103. Click "Join" to add to your query.