GL20001 - GL BBF Translation Open | Prospr - Dynamics GP Table Reference

GL20001 - GL BBF Translation Open

Query Builder

Select * from GL20001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
TranslationCurrencyID	Translation Currency ID	String	16	View
OPENYEAR	Open Year	Integer	2	View
JRNENTRY	Journal Entry	Long Integer	4	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
REFRENCE	Reference	String	32	View
TRXDATE	TRX Date	Date	4	View
TRXSORCE	TRX Source	String	14	View
ACTINDX	Account Index	Long Integer	4	View
SEQNUMBR	Sequence Number	Long Integer	4	View
PERIODID	Period ID	Integer	2	View
Ledger_ID	Ledger ID	Integer	2	View
CURNCYID	Currency ID	String	16	View
Original_Exchange_Rate	Original Exchange Rate	Currency (Variable)	10	View
ORGNTSRC	Originating Source	String	16	View
CRDTAMNT	Credit Amount	Currency	10	View
DEBITAMT	Debit Amount	Currency	10	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
TranslationCreditAmount	Translation Credit Amount	Currency	10	View
TranslationDebitAmount	Translation Debit Amount	Currency	10	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
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	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
Identity_Column	Identity Column	Long Integer	4	View

GL20001 - GL BBF Translation Open

Query Builder

Customer Service

Information

My Account

Contact Us