MC00500 - Multicurrency Posting Definitions Master
Dynamics GP table MC00500 (Multicurrency Posting Definitions Master) contains 16 columns including BCHSOURC, BACHNUMB, SERIES....
SQL Query Builder
16 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| BCHSOURC | Batch Source | String | 16 | ||
| BACHNUMB | Batch Number | String | 16 | ||
| SERIES | Series1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll - USA7 = Project | Integer | 2 | ||
Module Series values (8) 1 = All2 = Financial3 = Sales4 = Purchasing5 = Inventory6 = Payroll7 = Project10 = 3rd Party | |||||
| 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 | ||
| ORIGCNTRLTOT | Originating Control Total | Currency | 10 | ||
| ORIGBTCHTOT | Originating Batch Total | Currency | 10 | ||
| EXGTBLID | Exchange Table ID | String | 16 | ||
| XCHGRATE | Exchange Rate | Currency (Variable) | 10 | ||
| RATETPID | Rate Type ID | String | 16 | ||
| RTCLCMTD | Rate Calculation Method | Integer | 2 | ||
| TIME1 | Time | Time | 4 | ||
| EXCHDATE | Exchange Date | Date | 4 | ||
| CHEKDATE | Check Date | Date | 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 | ||
Related Tables
Tables that share columns with MC00500. Click "Join" to add to your query.