GL10001 - Transaction Amounts Work | Prospr - Dynamics GP Table Reference

GL10001 - Transaction Amounts Work

Query Builder

Select * from GL10001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BACHNUMB	Batch Number	String	16	View
JRNENTRY	Journal Entry	Long Integer	4	View
SQNCLINE	Sequence Line	Currency	10	View
ACTINDX	Account Index	Long Integer	4	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
DSCRIPTN	Description	String	32	View
GLLINMSG	GL LINE Messages	Long Integer	4	View
GLLINMS2	GL LINE Messages2	Long Integer	4	View
CURRNIDX	Currency Index	Integer	2	View
GLLINVAL	GL Line Valid	Long Integer	4	View
ACCTTYPE	Account Type Field values: 1 = Posting Account 2 = Unit Account 3 = Posting Allocation Account 4 = Unit Allocation Account	Integer	2	View
FXDORVAR	Fixed Or Variable 1 = Fixed Allocation 2 = Variable Allocation	Integer	2	View
BALFRCLC	Balance For Calculation 0 = Year To Date 1 = TRX Period	Integer	2	View
PSTNGTYP	Posting Type 0 = Balance Sheet 1 = Profit and Loss	Integer	2	View
DECPLACS	Decimal Places	Integer	2	View
ORCTRNUM	Originating Control Number	String	22	View
ORDOCNUM	Originating Document Number	String	22	View
ORMSTRID	Originating Master ID	String	32	View
ORMSTRNM	Originating Master Name	String	66	View
ORTRXTYP	Originating TRX Type	Integer	2	View
OrigSeqNum	Originating Sequence Number	Long Integer	4	View
ORTRXDESC	Originating TRX Description	String	32	View
DTA_GL_Status	DTA GL Status	Integer	2	View
INTERID	Intercompany ID	String	6	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	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
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
LNESTAT	Line Status	Integer	2	View
CorrespondingUnit	CorrespondingUnit	String	6	View

GL10001 - Transaction Amounts Work

Query Builder

Customer Service

Information

My Account

Contact Us