GL50500 - glDivisionalClosingPLTemp | Prospr - Dynamics GP Table Reference

GL50500 - glDivisionalClosingPLTemp

Select * from GL50500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
ORD	Ord	Long Integer	4	View
SGMNTID	Segment ID	String	68	View
Ledger_ID	Ledger ID	Integer	2	View
CURNCYID	Currency ID	String	16	View
TranslationCurrencyID	Translation Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
RTCLCMTD	Rate Calculation Method	Integer	2	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
CurrencyTranslationType	Currency Translation Type	Integer	2	View
REARNAMT	Retained Earnings Amount	Currency	10	View
ORIGAMT	Originating Amount	Currency	10	View
Translation_Amount	Translation Amount	Currency	10	View
RERINDX	Retained Earnings Account Index	Long Integer	4	View