Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our MC scripts. All of our scripts for Dynamics GP can be found here
MC Scripts
 
No records to display.
Module List > Module COMPANY..MC tables
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change


ClearPixel
Freq
Used
 Display Name
 MC00200Multicurrency Account Master
 MC00201Multicurrency Summary Master
 MC00300Multicurrency Account Historical Rates
 MC00500Multicurrency Posting Definitions Master
 MC020102Multicurrency Receivables Transactions
 MC020103Multicurrency Payables Transactions

This table contains the originating amounts for multicurrency transactions. For every MC transaction there is a record created in this table, and should remain in the table as long as the transaction is in the Payables tables. When Payables history tables are cleared for a particular transaction this record will be removed at the same time. In SBF, this table is not available. Multiple currencies are not supported in SBF.

 

For multicurrency transactions, amounts are entered in the originating currency; therefore, the amounts that are saved in this table are the actual values entered by the user. What is stored in the usual work, open or history tables is the functional calculated amounts, based upon the exchange rate.

 MC020104Multicurrency RM Revaluation Activity
 MC020105Multicurrency PM Revaluation Activity
Freq
Used
 Display Name
 MC10000Multicurrency Revaluaton Work
 MC10001Multicurrency Revaluation Currency Work
 MC10101MC RM Distribution Temp File
Work Tables
Freq
Used
 Display Name
 MC30001Multicurrency Account Summary History
Freq
Used
 Display Name
 MC40000Multicurrency Setup
 MC40100Multicurrency Rate Type Setup
 MC40201Multicurrency Account Setup
 MC40301Multicurrency Rate Type Account Setup
 MC40500Multicurrency User Preferences
 MC40600 
 MC50100Multicurrency Period Balances Temporary
 MC50200Multicurrency Account Rate Temporary
 MC60400Euro Enable Setup
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3