AAG00302 - aaDistrQueryFltr | Prospr - Dynamics GP Table Reference

AAG00302 - aaDistrQueryFltr

Query Builder

Select * from AAG00302

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
aaDistrQueryID	aaDistrQueryID	Long Integer	4	View
aaMvmtQueryID	aaMvmtQueryID	Long Integer	4	View
aaColumn	aaColumn	Integer	2	View
aaTrxDimID	aaTrxDimID	Long Integer	4	View
aaAll	aaAll	Boolean	2	View
aaSelectOption	aaSelectOption	Integer	2	View
aaFromStr	aaFromStr	String	32	View
aaIncludeEmpty	aaIncludeEmpty	Boolean	2	View
aaFromDimCode	aaFromDimCode	String	32	View
aaToStr	aaToStr	String	32	View
aaFromNum	aaFromNum	Currency	10	View
aaToDimCode	aaToDimCode	String	32	View
aaFromDimCodeNum	aaFromDimCodeNum	Currency	10	View
aaToNum	aaToNum	Currency	10	View
aaFromBool	aaFromBool	Boolean	2	View
aaToDimCodeNum	aaToDimCodeNum	Currency	10	View
aaFromDimCodeBool	aaFromDimCodeBool	Boolean	2	View
aaToBool	aaToBool	Boolean	2	View
aaFromDate	aaFromDate	Date	4	View
aaToDimCodeBool	aaToDimCodeBool	Boolean	2	View
aaFromDimCodeDate	aaFromDimCodeDate	Date	4	View
aaToDate	aaToDate	Date	4	View
aaToDimCodeDate	aaToDimCodeDate	Date	4	View
From_Account_Number_1	From Account Number:Account_Segment_Pool1	String	10	View
From_Account_Number_2	From Account Number:Account_Segment_Pool2	String	10	View
From_Account_Number_3	From Account Number:Account_Segment_Pool3	String	10	View
From_Account_Number_4	From Account Number:Account_Segment_Pool4	String	10	View
From_Account_Number_5	From Account Number:Account_Segment_Pool5	String	10	View
To_Account_Number_1	To Account Number:Account_Segment_Pool1	String	10	View
To_Account_Number_2	To Account Number:Account_Segment_Pool2	String	10	View
To_Account_Number_3	To Account Number:Account_Segment_Pool3	String	10	View
To_Account_Number_4	To Account Number:Account_Segment_Pool4	String	10	View
To_Account_Number_5	To Account Number:Account_Segment_Pool5	String	10	View

AAG00302 - aaDistrQueryFltr

Query Builder

Customer Service

Information

My Account

Contact Us