MC00500 - Multicurrency Posting Definitions Master | Prospr

MC00500 - Multicurrency Posting Definitions Master

Select * from MC00500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BCHSOURC	Batch Source	String	16	View
BACHNUMB	Batch Number	String	16	View
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
ORIGCNTRLTOT	Originating Control Total	Currency	10	View
ORIGBTCHTOT	Originating Batch Total	Currency	10	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
RATETPID	Rate Type ID	String	16	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
TIME1	Time	Time	4	View
EXCHDATE	Exchange Date	Date	4	View
CHEKDATE	Check Date	Date	4	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = 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	View