ASIEXP91 - ASI_SmartList_Favorites | Prospr - Dynamics GP Table Reference

ASIEXP91 - ASI_SmartList_Favorites

Query Builder

Select * from ASIEXP91

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	4	View
ASI_Favorite_Dict_ID	ASI_Favorite_Dict_ID	Integer	2	View
ASI_Favorite_Type	ASI_Favorite_Type	Integer	2	View
ASI_Favorite_Save_Level	ASI_Favorite_Save_Level	Integer	2	View
CMPANYID	Company ID	Integer	2	View
ASI_Favorite_Name	ASI_Favorite_Name	String	82	View
ASI_Field_Dict_ID_1	ASI_Field_Dict_ID[1]	Integer	2	View
ASI_Field_Dict_ID_2	ASI_Field_Dict_ID[2]	Integer	2	View
ASI_Field_Dict_ID_3	ASI_Field_Dict_ID[3]	Integer	2	View
ASI_Field_Dict_ID_4	ASI_Field_Dict_ID[4]	Integer	2	View
ASI_Field_List_1	ASI_Field_List[1]	Integer	2	View
ASI_Field_List_2	ASI_Field_List[2]	Integer	2	View
ASI_Field_List_3	ASI_Field_List[3]	Integer	2	View
ASI_Field_List_4	ASI_Field_List[4]	Integer	2	View
ASI_Search_Type_1	ASI_Search_Type[1]	Integer	2	View
ASI_Search_Type_2	ASI_Search_Type[2]	Integer	2	View
ASI_Search_Type_3	ASI_Search_Type[3]	Integer	2	View
ASI_Search_Type_4	ASI_Search_Type[4]	Integer	2	View
ASI_Match_Case_1	ASI_Match_Case[1]	Boolean	2	View
ASI_Match_Case_2	ASI_Match_Case[2]	Boolean	2	View
ASI_Match_Case_3	ASI_Match_Case[3]	Boolean	2	View
ASI_Match_Case_4	ASI_Match_Case[4]	Boolean	2	View
ASI_Start_Account_Number_1_1	ASI_Start_Account_Number[1]:Account_Segment_Pool1	String	10	View
ASI_Start_Account_Number_1_2	ASI_Start_Account_Number[1]:Account_Segment_Pool2	String	10	View
ASI_Start_Account_Number_1_3	ASI_Start_Account_Number[1]:Account_Segment_Pool3	String	10	View
ASI_Start_Account_Number_1_4	ASI_Start_Account_Number[1]:Account_Segment_Pool4	String	10	View
ASI_Start_Account_Number_1_5	ASI_Start_Account_Number[1]:Account_Segment_Pool5	String	10	View
ASI_Start_Account_Number_2_1	ASI_Start_Account_Number[2]:Account_Segment_Pool1	String	10	View
ASI_Start_Account_Number_2_2	ASI_Start_Account_Number[2]:Account_Segment_Pool2	String	10	View
ASI_Start_Account_Number_2_3	ASI_Start_Account_Number[2]:Account_Segment_Pool3	String	10	View
ASI_Start_Account_Number_2_4	ASI_Start_Account_Number[2]:Account_Segment_Pool4	String	10	View
ASI_Start_Account_Number_2_5	ASI_Start_Account_Number[2]:Account_Segment_Pool5	String	10	View
ASI_Start_Account_Number_3_1	ASI_Start_Account_Number[3]:Account_Segment_Pool1	String	10	View
ASI_Start_Account_Number_3_2	ASI_Start_Account_Number[3]:Account_Segment_Pool2	String	10	View
ASI_Start_Account_Number_3_3	ASI_Start_Account_Number[3]:Account_Segment_Pool3	String	10	View
ASI_Start_Account_Number_3_4	ASI_Start_Account_Number[3]:Account_Segment_Pool4	String	10	View
ASI_Start_Account_Number_3_5	ASI_Start_Account_Number[3]:Account_Segment_Pool5	String	10	View
ASI_Start_Account_Number_4_1	ASI_Start_Account_Number[4]:Account_Segment_Pool1	String	10	View
ASI_Start_Account_Number_4_2	ASI_Start_Account_Number[4]:Account_Segment_Pool2	String	10	View
ASI_Start_Account_Number_4_3	ASI_Start_Account_Number[4]:Account_Segment_Pool3	String	10	View
ASI_Start_Account_Number_4_4	ASI_Start_Account_Number[4]:Account_Segment_Pool4	String	10	View
ASI_Start_Account_Number_4_5	ASI_Start_Account_Number[4]:Account_Segment_Pool5	String	10	View
ASI_Start_Date_Token_DDL_1	ASI_Start_Date_Token_DDL[1]	Integer	2	View
ASI_Start_Date_Token_DDL_2	ASI_Start_Date_Token_DDL[2]	Integer	2	View
ASI_Start_Date_Token_DDL_3	ASI_Start_Date_Token_DDL[3]	Integer	2	View
ASI_Start_Date_Token_DDL_4	ASI_Start_Date_Token_DDL[4]	Integer	2	View
ASI_Start_Date_1	ASI_Start_Date[1]	Date	4	View
ASI_Start_Date_2	ASI_Start_Date[2]	Date	4	View
ASI_Start_Date_3	ASI_Start_Date[3]	Date	4	View
ASI_Start_Date_4	ASI_Start_Date[4]	Date	4	View
ASI_Start_DDL_1	ASI_Start_DDL[1]	Integer	2	View
ASI_Start_DDL_2	ASI_Start_DDL[2]	Integer	2	View
ASI_Start_DDL_3	ASI_Start_DDL[3]	Integer	2	View
ASI_Start_DDL_4	ASI_Start_DDL[4]	Integer	2	View
ASI_String_Start_1	ASI_Start_String[1]	String	62	View
ASI_String_Start_2	ASI_Start_String[2]	String	62	View
ASI_String_Start_3	ASI_Start_String[3]	String	62	View
ASI_String_Start_4	ASI_Start_String[4]	String	62	View
ASI_End_Account_Number_1_1	ASI_End_Account_Number[1]:Account_Segment_Pool1	String	10	View
ASI_End_Account_Number_1_2	ASI_End_Account_Number[1]:Account_Segment_Pool2	String	10	View
ASI_End_Account_Number_1_3	ASI_End_Account_Number[1]:Account_Segment_Pool3	String	10	View
ASI_End_Account_Number_1_4	ASI_End_Account_Number[1]:Account_Segment_Pool4	String	10	View
ASI_End_Account_Number_1_5	ASI_End_Account_Number[1]:Account_Segment_Pool5	String	10	View
ASI_End_Account_Number_2_1	ASI_End_Account_Number[2]:Account_Segment_Pool1	String	10	View
ASI_End_Account_Number_2_2	ASI_End_Account_Number[2]:Account_Segment_Pool2	String	10	View
ASI_End_Account_Number_2_3	ASI_End_Account_Number[2]:Account_Segment_Pool3	String	10	View
ASI_End_Account_Number_2_4	ASI_End_Account_Number[2]:Account_Segment_Pool4	String	10	View
ASI_End_Account_Number_2_5	ASI_End_Account_Number[2]:Account_Segment_Pool5	String	10	View
ASI_End_Account_Number_3_1	ASI_End_Account_Number[3]:Account_Segment_Pool1	String	10	View
ASI_End_Account_Number_3_2	ASI_End_Account_Number[3]:Account_Segment_Pool2	String	10	View
ASI_End_Account_Number_3_3	ASI_End_Account_Number[3]:Account_Segment_Pool3	String	10	View
ASI_End_Account_Number_3_4	ASI_End_Account_Number[3]:Account_Segment_Pool4	String	10	View
ASI_End_Account_Number_3_5	ASI_End_Account_Number[3]:Account_Segment_Pool5	String	10	View
ASI_End_Account_Number_4_1	ASI_End_Account_Number[4]:Account_Segment_Pool1	String	10	View
ASI_End_Account_Number_4_2	ASI_End_Account_Number[4]:Account_Segment_Pool2	String	10	View
ASI_End_Account_Number_4_3	ASI_End_Account_Number[4]:Account_Segment_Pool3	String	10	View
ASI_End_Account_Number_4_4	ASI_End_Account_Number[4]:Account_Segment_Pool4	String	10	View
ASI_End_Account_Number_4_5	ASI_End_Account_Number[4]:Account_Segment_Pool5	String	10	View
ASI_End_Date_Token_DDL_1	ASI_End_Date_Token_DDL[1]	Integer	2	View
ASI_End_Date_Token_DDL_2	ASI_End_Date_Token_DDL[2]	Integer	2	View
ASI_End_Date_Token_DDL_3	ASI_End_Date_Token_DDL[3]	Integer	2	View
ASI_End_Date_Token_DDL_4	ASI_End_Date_Token_DDL[4]	Integer	2	View
ASI_End_Date_1	ASI_End_Date[1]	Date	4	View
ASI_End_Date_2	ASI_End_Date[2]	Date	4	View
ASI_End_Date_3	ASI_End_Date[3]	Date	4	View
ASI_End_Date_4	ASI_End_Date[4]	Date	4	View
ASI_End_DDL_1	ASI_End_DDL[1]	Integer	2	View
ASI_End_DDL_2	ASI_End_DDL[2]	Integer	2	View
ASI_End_DDL_3	ASI_End_DDL[3]	Integer	2	View
ASI_End_DDL_4	ASI_End_DDL[4]	Integer	2	View
ASI_String_End_1	ASI_End_String[1]	String	62	View
ASI_String_End_2	ASI_End_String[2]	String	62	View
ASI_String_End_3	ASI_End_String[3]	String	62	View
ASI_String_End_4	ASI_End_String[4]	String	62	View
ASI_Search_From_Str_1	ASI_Search_From_Str[1]	String	62	View
ASI_Search_From_Str_2	ASI_Search_From_Str[2]	String	62	View
ASI_Search_From_Str_3	ASI_Search_From_Str[3]	String	62	View
ASI_Search_From_Str_4	ASI_Search_From_Str[4]	String	62	View
ASI_Search_To_Str_1	ASI_Search_To_Str[1]	String	62	View
ASI_Search_To_Str_2	ASI_Search_To_Str[2]	String	62	View
ASI_Search_To_Str_3	ASI_Search_To_Str[3]	String	62	View
ASI_Search_To_Str_4	ASI_Search_To_Str[4]	String	62	View
ASI_Search_Logic_Type	ASI_Search_Logic_Type	Integer	2	View
ASI_Max_Records	ASI_Max_Records	Long Integer	4	View
ASI_Sort_Dict_ID	ASI_Sort_Dict_ID	Integer	2	View
ASI_Sort_Field	ASI_Sort_Field	Integer	2	View
ASI_Sort_Type	ASI_Sort_Type	Integer	2	View
ASI_Category_Node_ID	ASI_Category_Node_ID	Long Integer	4	View
ASI_Field_Comparison_1	ASI_Field_Comparison[1]	Boolean	2	View
ASI_Field_Comparison_2	ASI_Field_Comparison[2]	Boolean	2	View
ASI_Field_Comparison_3	ASI_Field_Comparison[3]	Boolean	2	View
ASI_Field_Comparison_4	ASI_Field_Comparison[4]	Boolean	2	View
ASI_Start_Comp_Field_ID_1	ASI_Start_Comp_Field_ID[1]	Integer	2	View
ASI_Start_Comp_Field_ID_2	ASI_Start_Comp_Field_ID[2]	Integer	2	View
ASI_Start_Comp_Field_ID_3	ASI_Start_Comp_Field_ID[3]	Integer	2	View
ASI_Start_Comp_Field_ID_4	ASI_Start_Comp_Field_ID[4]	Integer	2	View
ASI_Start_Comp_Field_Dic_1	ASI_Start_Comp_Field_Dict[1]	Integer	2	View
ASI_Start_Comp_Field_Dic_2	ASI_Start_Comp_Field_Dict[2]	Integer	2	View
ASI_Start_Comp_Field_Dic_3	ASI_Start_Comp_Field_Dict[3]	Integer	2	View
ASI_Start_Comp_Field_Dic_4	ASI_Start_Comp_Field_Dict[4]	Integer	2	View
ASI_End_Comp_Field_ID_1	ASI_End_Comp_Field_ID[1]	Integer	2	View
ASI_End_Comp_Field_ID_2	ASI_End_Comp_Field_ID[2]	Integer	2	View
ASI_End_Comp_Field_ID_3	ASI_End_Comp_Field_ID[3]	Integer	2	View
ASI_End_Comp_Field_ID_4	ASI_End_Comp_Field_ID[4]	Integer	2	View
ASI_End_Comp_Field_Dict_1	ASI_End_Comp_Field_Dict[1]	Integer	2	View
ASI_End_Comp_Field_Dict_2	ASI_End_Comp_Field_Dict[2]	Integer	2	View
ASI_End_Comp_Field_Dict_3	ASI_End_Comp_Field_Dict[3]	Integer	2	View
ASI_End_Comp_Field_Dict_4	ASI_End_Comp_Field_Dict[4]	Integer	2	View
ASI_Search_Criteria	ASI_Search_Criteria	Text	2	View

ASIEXP91 - ASI_SmartList_Favorites

Query Builder

Customer Service

Information

My Account

Contact Us