AAG50001 - aaSubLedgerDistReport | Prospr - Dynamics GP Table Reference

AAG50001 - aaSubLedgerDistReport

Select * from AAG50001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
TRXBTCHSRC	aaTRXBatchSource	String	52	View
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
aaSubLedgerHdrID	aaSubLedgerHdrID	Long Integer	4	View
aaSubLedgerDistID	aaSubLedgerDistID	Long Integer	4	View
ACTINDX	Account Index	Long Integer	4	View
DEBITAMT	Debit Amount	Currency	10	View
CRDTAMNT	Credit Amount	Currency	10	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
POSTED	Posted	Boolean	2	View