MC40000 - Multicurrency Setup | Prospr - Dynamics GP Table Reference

MC40000 - Multicurrency Setup

Select * from MC40000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
FUNLCURR	Functional Currency	String	16	View
FUNCRIDX	Functional Currency Index	Integer	2	View
RPTGCURR	Reporting Currency	String	16	View
RPTCRIDX	Reporting Currency Index	Integer	2	View
RPTXRATE	Reporting Exchange Rate	Currency (Variable)	10	View
RPRTCLMD	Reporting Rate Calculation Method	Integer	2	View
ALOWNWRT	Allow New Rates	Boolean	2	View
ANWRTPWD	Allow New Rates Password	String	12	View
ALWMODRT	Allow Modify Rates	Boolean	2	View
MODRTPWD	Allow Modify Rates Password	String	12	View
ALOVEXRT	Allow Override Exchange Rates	Boolean	2	View
OVXRTPWD	Allow Override Exchange Rates Password	String	12	View
AOVRTVAR	Allow Override Rate Variance	Boolean	2	View
OVRTVPWD	Allow Override Rate Variance Password	String	12	View
AOVRPTRT	Allow Override Reporting Rate	Boolean	2	View
OVRPRPWD	Allow Override Reporting Rate Password	String	12	View
AVGEXRAT	Average Exchange Rate	Integer	2	View
DEFFINTP	Default Financial Type	String	16	View
DEFSLSTP	Default Sales Type	String	16	View
DEFPURTP	Default Purchase Type	String	16	View
MNSUMHST	Maintain Summary History	Boolean	2	View
LSTREVAL	Last Revaluation	Date	4	View
LSTPRVAL	Last Purchasing Revaluation Date	Date	4	View
LSTSRVAL	Last Sales Revaluation Date	Date	4	View
LSTTRXRV	Last Transaction Removal	Date	4	View
LSTSUMRV	Last Summary Removal	Date	4	View
AVGCLMD	Average Calculation Method	Integer	2	View