GTM20017V - GTM_aaPostedGLDistView | Prospr - Dynamics GP Table Reference

GTM20017V - GTM_aaPostedGLDistView

Select * from GTM20017V

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
aaGLWorkHdrID	aaGLWorkHdrID	Long Integer	4	View
aaGLWorkDistID	aaGLWorkDistID	Long Integer	4	View
aaGLWorkAssignID	aaGLWorkAssignID	Long Integer	4	View
JRNENTRY	Journal Entry	Long Integer	4	View
RCTRXSEQ	Recurring TRX Sequence	Currency	10	View
aaTRXType	aaTRXType	Integer	2	View
GLPOSTDT	GL Posting Date	Date	4	View
aaTrxDimID	aaTrxDimID	Long Integer	4	View
aaTrxCodeID	aaTrxCodeID	Long Integer	4	View
aaTrxDimCode	aaTrxDimCode	String	32	View
INTERID	Intercompany ID	String	6	View
ACTINDX	Account Index	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
DEBITAMT	Debit Amount	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
CURNCYID	Currency ID	String	16	View
SEQNUMBR	Sequence Number	Long Integer	4	View