AAG00315 - aaMLQueryUsrWrk | Prospr - Dynamics GP Table Reference

AAG00315 - aaMLQueryUsrWrk

Query Builder

Select * from AAG00315

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
YEAR1	Year	Integer	2	View
aaYearFld	aaYearFld	String	34	View
From_Period	From Period	Integer	2	View
To_Period	To Period	Integer	2	View
aaPerFld	aaPerFld	String	34	View
aaPerStr	aaPerStr	String	34	View
aaEmptyCodeStr	aaEmptyCodeStr	String	34	View
aaTimeSpreadUsed	aaTimeSpreadUsed	Boolean	2	View
aaCodeSpreadUsed	aaCodeSpreadUsed	Boolean	2	View
aaCodeSpreadCol	aaCodeSpreadCol	Integer	2	View
THSSPRTR	Thousands Separator	String	2	View
DECSPRTR	Decimal Separator	String	2	View
aaNegSignLeft	aaNegativeSignLeft	String	2	View
aaNegSignRight	aaNegativeSignRight	String	2	View
aaTruncateTo	aaTruncateTo	Integer	2	View
aaClearEmptyCells	aaClearEmptyCells	Boolean	2	View
aaSQLCreate	aaSQLCreate	Text	2	View
aaSQLInsert	aaSQLInsert	Text	2	View
aaSQLSelect	aaSQLSelect	Text	2	View
aaSQLFrom	aaSQLFrom	Text	2	View
aaSQLWhere	aaSQLWhere	Text	2	View
aaSQLGroupBy	aaSQLGroupBy	Text	2	View
aaSQLCols	aaSQLColumns	Text	2	View