GTM20001V - GTM_aaUnpostedDistView | Prospr - Dynamics GP Table Reference

GTM20001V - GTM_aaUnpostedDistView

Select * from GTM20001V

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
aaSubLedgerHdrID	aaSubLedgerHdrID	Long Integer	4	View
aaSubLedgerDistID	aaSubLedgerDistID	Long Integer	4	View
aaSubLedgerAssignID	aaSubLedgerAssignID	Long Integer	4	View
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
DOCTYPE	Document Type	Integer	2	View
DOCNUMBR	Document Number	String	22	View
Master_ID	Master ID	String	32	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
DISTTYPE	Distribution Type 1 = Cash 2 = Payable 3 = Discount Available 4 = Discount Taken 5 = Finance Charge 6 = Purchase 8 = Misc. Charge 9 = Freight 10 = Taxes 11 = Writeoffs 12 = Other 13 = GST Disc	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
GLPOSTDT	GL Posting Date	Date	4	View
POSTED	Posted	Boolean	2	View
HISTORY	History	Boolean	2	View