ASI_SmartList_Favorites (ASIEXP91)

azurecurveProductsSmartList (1493)PathnameASI_SmartList_Favorites (ASIEXP91)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP91

Product: SmartList (1493)
Series:

Display Name: ASI_SmartList_Favorites
Physical Name: ASIEXP91
Technical Name: ASI_Explorer_Favorites

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceLong IntegerASI_LI_10_RU10
2ASI_Favorite_Dict_ID SearchASI_Favorite_Dict_IDIntegerINT0
3ASI_Favorite_Type SearchASI_Favorite_TypeIntegerINT0
4ASI_Favorite_Save_Level SearchASI_Favorite_Save_LevelIntegerASI_Favorite_Save_Level0
5CMPANYID SearchCompany IDIntegerINT54
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['ASI_SmartList_Favorites'].CMPANYID AS 'ASI_SmartList_Favorites-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       ASIEXP91 AS ['ASI_SmartList_Favorites']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['ASI_SmartList_Favorites'].CMPANYID = ['Company Master'].CMPANYID
6ASI_Favorite_Name SearchASI_Favorite_NameStringSTR8080
7ASI_Field_Dict_ID_1 SearchASI_Field_Dict_ID[1]IntegerINT0
8ASI_Field_Dict_ID_2 SearchASI_Field_Dict_ID[2]IntegerINT0
9ASI_Field_Dict_ID_3 SearchASI_Field_Dict_ID[3]IntegerINT0
10ASI_Field_Dict_ID_4 SearchASI_Field_Dict_ID[4]IntegerINT0
11ASI_Field_List_1 SearchASI_Field_List[1]IntegerDDL0
12ASI_Field_List_2 SearchASI_Field_List[2]IntegerDDL0
13ASI_Field_List_3 SearchASI_Field_List[3]IntegerDDL0
14ASI_Field_List_4 SearchASI_Field_List[4]IntegerDDL0
15ASI_Search_Type_1 SearchASI_Search_Type[1]IntegerASI_DDL_Search_Type0
16ASI_Search_Type_2 SearchASI_Search_Type[2]IntegerASI_DDL_Search_Type0
17ASI_Search_Type_3 SearchASI_Search_Type[3]IntegerASI_DDL_Search_Type0
18ASI_Search_Type_4 SearchASI_Search_Type[4]IntegerASI_DDL_Search_Type0
19ASI_Match_Case_1 SearchASI_Match_Case[1]BooleanASI_CB_Match_Case0
20ASI_Match_Case_2 SearchASI_Match_Case[2]BooleanASI_CB_Match_Case0
21ASI_Match_Case_3 SearchASI_Match_Case[3]BooleanASI_CB_Match_Case0
22ASI_Match_Case_4 SearchASI_Match_Case[4]BooleanASI_CB_Match_Case0
23ASI_Start_Account_Number_1_1 SearchASI_Start_Account_Number[1]:Account_Segment_Pool1StringAccount_Segment_Pool16
24ASI_Start_Account_Number_1_2 SearchASI_Start_Account_Number[1]:Account_Segment_Pool2StringAccount_Segment_Pool26
25ASI_Start_Account_Number_1_3 SearchASI_Start_Account_Number[1]:Account_Segment_Pool3StringAccount_Segment_Pool36
26ASI_Start_Account_Number_1_4 SearchASI_Start_Account_Number[1]:Account_Segment_Pool4StringAccount_Segment_Pool46
27ASI_Start_Account_Number_1_5 SearchASI_Start_Account_Number[1]:Account_Segment_Pool5StringAccount_Segment_Pool56
28ASI_Start_Account_Number_1_6 SearchASI_Start_Account_Number[1]:Account_Segment_Pool6StringAccount_Segment_Pool66
29ASI_Start_Account_Number_1_7 SearchASI_Start_Account_Number[1]:Account_Segment_Pool7StringAccount_Segment_Pool76
30ASI_Start_Account_Number_1_8 SearchASI_Start_Account_Number[1]:Account_Segment_Pool8StringAccount_Segment_Pool86
31ASI_Start_Account_Number_1_9 SearchASI_Start_Account_Number[1]:Account_Segment_Pool9StringAccount_Segment_Pool96
32ASI_Start_Account_Number_1_10 SearchASI_Start_Account_Number[1]:Account_Segment_Pool10StringAccount_Segment_Pool106
33ASI_Start_Account_Number_2_1 SearchASI_Start_Account_Number[2]:Account_Segment_Pool1StringAccount_Segment_Pool16
34ASI_Start_Account_Number_2_2 SearchASI_Start_Account_Number[2]:Account_Segment_Pool2StringAccount_Segment_Pool26
35ASI_Start_Account_Number_2_3 SearchASI_Start_Account_Number[2]:Account_Segment_Pool3StringAccount_Segment_Pool36
36ASI_Start_Account_Number_2_4 SearchASI_Start_Account_Number[2]:Account_Segment_Pool4StringAccount_Segment_Pool46
37ASI_Start_Account_Number_2_5 SearchASI_Start_Account_Number[2]:Account_Segment_Pool5StringAccount_Segment_Pool56
38ASI_Start_Account_Number_2_6 SearchASI_Start_Account_Number[2]:Account_Segment_Pool6StringAccount_Segment_Pool66
39ASI_Start_Account_Number_2_7 SearchASI_Start_Account_Number[2]:Account_Segment_Pool7StringAccount_Segment_Pool76
40ASI_Start_Account_Number_2_8 SearchASI_Start_Account_Number[2]:Account_Segment_Pool8StringAccount_Segment_Pool86
41ASI_Start_Account_Number_2_9 SearchASI_Start_Account_Number[2]:Account_Segment_Pool9StringAccount_Segment_Pool96
42ASI_Start_Account_Number_2_10 SearchASI_Start_Account_Number[2]:Account_Segment_Pool10StringAccount_Segment_Pool106
43ASI_Start_Account_Number_3_1 SearchASI_Start_Account_Number[3]:Account_Segment_Pool1StringAccount_Segment_Pool16
44ASI_Start_Account_Number_3_2 SearchASI_Start_Account_Number[3]:Account_Segment_Pool2StringAccount_Segment_Pool26
45ASI_Start_Account_Number_3_3 SearchASI_Start_Account_Number[3]:Account_Segment_Pool3StringAccount_Segment_Pool36
46ASI_Start_Account_Number_3_4 SearchASI_Start_Account_Number[3]:Account_Segment_Pool4StringAccount_Segment_Pool46
47ASI_Start_Account_Number_3_5 SearchASI_Start_Account_Number[3]:Account_Segment_Pool5StringAccount_Segment_Pool56
48ASI_Start_Account_Number_3_6 SearchASI_Start_Account_Number[3]:Account_Segment_Pool6StringAccount_Segment_Pool66
49ASI_Start_Account_Number_3_7 SearchASI_Start_Account_Number[3]:Account_Segment_Pool7StringAccount_Segment_Pool76
50ASI_Start_Account_Number_3_8 SearchASI_Start_Account_Number[3]:Account_Segment_Pool8StringAccount_Segment_Pool86
51ASI_Start_Account_Number_3_9 SearchASI_Start_Account_Number[3]:Account_Segment_Pool9StringAccount_Segment_Pool96
52ASI_Start_Account_Number_3_10 SearchASI_Start_Account_Number[3]:Account_Segment_Pool10StringAccount_Segment_Pool106
53ASI_Start_Account_Number_4_1 SearchASI_Start_Account_Number[4]:Account_Segment_Pool1StringAccount_Segment_Pool16
54ASI_Start_Account_Number_4_2 SearchASI_Start_Account_Number[4]:Account_Segment_Pool2StringAccount_Segment_Pool26
55ASI_Start_Account_Number_4_3 SearchASI_Start_Account_Number[4]:Account_Segment_Pool3StringAccount_Segment_Pool36
56ASI_Start_Account_Number_4_4 SearchASI_Start_Account_Number[4]:Account_Segment_Pool4StringAccount_Segment_Pool46
57ASI_Start_Account_Number_4_5 SearchASI_Start_Account_Number[4]:Account_Segment_Pool5StringAccount_Segment_Pool56
58ASI_Start_Account_Number_4_6 SearchASI_Start_Account_Number[4]:Account_Segment_Pool6StringAccount_Segment_Pool66
59ASI_Start_Account_Number_4_7 SearchASI_Start_Account_Number[4]:Account_Segment_Pool7StringAccount_Segment_Pool76
60ASI_Start_Account_Number_4_8 SearchASI_Start_Account_Number[4]:Account_Segment_Pool8StringAccount_Segment_Pool86
61ASI_Start_Account_Number_4_9 SearchASI_Start_Account_Number[4]:Account_Segment_Pool9StringAccount_Segment_Pool96
62ASI_Start_Account_Number_4_10 SearchASI_Start_Account_Number[4]:Account_Segment_Pool10StringAccount_Segment_Pool106
63ASI_Start_Date_Token_DDL_1 SearchASI_Start_Date_Token_DDL[1]IntegerASI_Date_Token_DDL0
64ASI_Start_Date_Token_DDL_2 SearchASI_Start_Date_Token_DDL[2]IntegerASI_Date_Token_DDL0
65ASI_Start_Date_Token_DDL_3 SearchASI_Start_Date_Token_DDL[3]IntegerASI_Date_Token_DDL0
66ASI_Start_Date_Token_DDL_4 SearchASI_Start_Date_Token_DDL[4]IntegerASI_Date_Token_DDL0
67ASI_Start_Date_1 SearchASI_Start_Date[1]DateDATE_LONG8
68ASI_Start_Date_2 SearchASI_Start_Date[2]DateDATE_LONG8
69ASI_Start_Date_3 SearchASI_Start_Date[3]DateDATE_LONG8
70ASI_Start_Date_4 SearchASI_Start_Date[4]DateDATE_LONG8
71ASI_Start_DDL_1 SearchASI_Start_DDL[1]IntegerDDL0
72ASI_Start_DDL_2 SearchASI_Start_DDL[2]IntegerDDL0
73ASI_Start_DDL_3 SearchASI_Start_DDL[3]IntegerDDL0
74ASI_Start_DDL_4 SearchASI_Start_DDL[4]IntegerDDL0
75ASI_String_Start_1 SearchASI_Start_String[1]StringSTR6060
76ASI_String_Start_2 SearchASI_Start_String[2]StringSTR6060
77ASI_String_Start_3 SearchASI_Start_String[3]StringSTR6060
78ASI_String_Start_4 SearchASI_Start_String[4]StringSTR6060
79ASI_End_Account_Number_1_1 SearchASI_End_Account_Number[1]:Account_Segment_Pool1StringAccount_Segment_Pool16
80ASI_End_Account_Number_1_2 SearchASI_End_Account_Number[1]:Account_Segment_Pool2StringAccount_Segment_Pool26
81ASI_End_Account_Number_1_3 SearchASI_End_Account_Number[1]:Account_Segment_Pool3StringAccount_Segment_Pool36
82ASI_End_Account_Number_1_4 SearchASI_End_Account_Number[1]:Account_Segment_Pool4StringAccount_Segment_Pool46
83ASI_End_Account_Number_1_5 SearchASI_End_Account_Number[1]:Account_Segment_Pool5StringAccount_Segment_Pool56
84ASI_End_Account_Number_1_6 SearchASI_End_Account_Number[1]:Account_Segment_Pool6StringAccount_Segment_Pool66
85ASI_End_Account_Number_1_7 SearchASI_End_Account_Number[1]:Account_Segment_Pool7StringAccount_Segment_Pool76
86ASI_End_Account_Number_1_8 SearchASI_End_Account_Number[1]:Account_Segment_Pool8StringAccount_Segment_Pool86
87ASI_End_Account_Number_1_9 SearchASI_End_Account_Number[1]:Account_Segment_Pool9StringAccount_Segment_Pool96
88ASI_End_Account_Number_1_10 SearchASI_End_Account_Number[1]:Account_Segment_Pool10StringAccount_Segment_Pool106
89ASI_End_Account_Number_2_1 SearchASI_End_Account_Number[2]:Account_Segment_Pool1StringAccount_Segment_Pool16
90ASI_End_Account_Number_2_2 SearchASI_End_Account_Number[2]:Account_Segment_Pool2StringAccount_Segment_Pool26
91ASI_End_Account_Number_2_3 SearchASI_End_Account_Number[2]:Account_Segment_Pool3StringAccount_Segment_Pool36
92ASI_End_Account_Number_2_4 SearchASI_End_Account_Number[2]:Account_Segment_Pool4StringAccount_Segment_Pool46
93ASI_End_Account_Number_2_5 SearchASI_End_Account_Number[2]:Account_Segment_Pool5StringAccount_Segment_Pool56
94ASI_End_Account_Number_2_6 SearchASI_End_Account_Number[2]:Account_Segment_Pool6StringAccount_Segment_Pool66
95ASI_End_Account_Number_2_7 SearchASI_End_Account_Number[2]:Account_Segment_Pool7StringAccount_Segment_Pool76
96ASI_End_Account_Number_2_8 SearchASI_End_Account_Number[2]:Account_Segment_Pool8StringAccount_Segment_Pool86
97ASI_End_Account_Number_2_9 SearchASI_End_Account_Number[2]:Account_Segment_Pool9StringAccount_Segment_Pool96
98ASI_End_Account_Number_2_10 SearchASI_End_Account_Number[2]:Account_Segment_Pool10StringAccount_Segment_Pool106
99ASI_End_Account_Number_3_1 SearchASI_End_Account_Number[3]:Account_Segment_Pool1StringAccount_Segment_Pool16
100ASI_End_Account_Number_3_2 SearchASI_End_Account_Number[3]:Account_Segment_Pool2StringAccount_Segment_Pool26
101ASI_End_Account_Number_3_3 SearchASI_End_Account_Number[3]:Account_Segment_Pool3StringAccount_Segment_Pool36
102ASI_End_Account_Number_3_4 SearchASI_End_Account_Number[3]:Account_Segment_Pool4StringAccount_Segment_Pool46
103ASI_End_Account_Number_3_5 SearchASI_End_Account_Number[3]:Account_Segment_Pool5StringAccount_Segment_Pool56
104ASI_End_Account_Number_3_6 SearchASI_End_Account_Number[3]:Account_Segment_Pool6StringAccount_Segment_Pool66
105ASI_End_Account_Number_3_7 SearchASI_End_Account_Number[3]:Account_Segment_Pool7StringAccount_Segment_Pool76
106ASI_End_Account_Number_3_8 SearchASI_End_Account_Number[3]:Account_Segment_Pool8StringAccount_Segment_Pool86
107ASI_End_Account_Number_3_9 SearchASI_End_Account_Number[3]:Account_Segment_Pool9StringAccount_Segment_Pool96
108ASI_End_Account_Number_3_10 SearchASI_End_Account_Number[3]:Account_Segment_Pool10StringAccount_Segment_Pool106
109ASI_End_Account_Number_4_1 SearchASI_End_Account_Number[4]:Account_Segment_Pool1StringAccount_Segment_Pool16
110ASI_End_Account_Number_4_2 SearchASI_End_Account_Number[4]:Account_Segment_Pool2StringAccount_Segment_Pool26
111ASI_End_Account_Number_4_3 SearchASI_End_Account_Number[4]:Account_Segment_Pool3StringAccount_Segment_Pool36
112ASI_End_Account_Number_4_4 SearchASI_End_Account_Number[4]:Account_Segment_Pool4StringAccount_Segment_Pool46
113ASI_End_Account_Number_4_5 SearchASI_End_Account_Number[4]:Account_Segment_Pool5StringAccount_Segment_Pool56
114ASI_End_Account_Number_4_6 SearchASI_End_Account_Number[4]:Account_Segment_Pool6StringAccount_Segment_Pool66
115ASI_End_Account_Number_4_7 SearchASI_End_Account_Number[4]:Account_Segment_Pool7StringAccount_Segment_Pool76
116ASI_End_Account_Number_4_8 SearchASI_End_Account_Number[4]:Account_Segment_Pool8StringAccount_Segment_Pool86
117ASI_End_Account_Number_4_9 SearchASI_End_Account_Number[4]:Account_Segment_Pool9StringAccount_Segment_Pool96
118ASI_End_Account_Number_4_10 SearchASI_End_Account_Number[4]:Account_Segment_Pool10StringAccount_Segment_Pool106
119ASI_End_Date_Token_DDL_1 SearchASI_End_Date_Token_DDL[1]IntegerASI_Date_Token_DDL0
120ASI_End_Date_Token_DDL_2 SearchASI_End_Date_Token_DDL[2]IntegerASI_Date_Token_DDL0
121ASI_End_Date_Token_DDL_3 SearchASI_End_Date_Token_DDL[3]IntegerASI_Date_Token_DDL0
122ASI_End_Date_Token_DDL_4 SearchASI_End_Date_Token_DDL[4]IntegerASI_Date_Token_DDL0
123ASI_End_Date_1 SearchASI_End_Date[1]DateDATE_LONG8
124ASI_End_Date_2 SearchASI_End_Date[2]DateDATE_LONG8
125ASI_End_Date_3 SearchASI_End_Date[3]DateDATE_LONG8
126ASI_End_Date_4 SearchASI_End_Date[4]DateDATE_LONG8
127ASI_End_DDL_1 SearchASI_End_DDL[1]IntegerDDL0
128ASI_End_DDL_2 SearchASI_End_DDL[2]IntegerDDL0
129ASI_End_DDL_3 SearchASI_End_DDL[3]IntegerDDL0
130ASI_End_DDL_4 SearchASI_End_DDL[4]IntegerDDL0
131ASI_String_End_1 SearchASI_End_String[1]StringSTR6060
132ASI_String_End_2 SearchASI_End_String[2]StringSTR6060
133ASI_String_End_3 SearchASI_End_String[3]StringSTR6060
134ASI_String_End_4 SearchASI_End_String[4]StringSTR6060
135ASI_Search_From_Str_1 SearchASI_Search_From_Str[1]StringSTR6060
136ASI_Search_From_Str_2 SearchASI_Search_From_Str[2]StringSTR6060
137ASI_Search_From_Str_3 SearchASI_Search_From_Str[3]StringSTR6060
138ASI_Search_From_Str_4 SearchASI_Search_From_Str[4]StringSTR6060
139ASI_Search_To_Str_1 SearchASI_Search_To_Str[1]StringSTR6060
140ASI_Search_To_Str_2 SearchASI_Search_To_Str[2]StringSTR6060
141ASI_Search_To_Str_3 SearchASI_Search_To_Str[3]StringSTR6060
142ASI_Search_To_Str_4 SearchASI_Search_To_Str[4]StringSTR6060
143ASI_Search_Logic_Type SearchASI_Search_Logic_TypeIntegerASI_DDL_Search_Logic_Type0
144ASI_Max_Records SearchASI_Max_RecordsLong IntegerASI_LI_10_RU10
145ASI_Sort_Dict_ID SearchASI_Sort_Dict_IDIntegerINT0
146ASI_Sort_Field SearchASI_Sort_FieldIntegerINT0
147ASI_Sort_Type SearchASI_Sort_TypeIntegerINT0
148ASI_Category_Node_ID SearchASI_Category_Node_IDLong IntegerASI_LI_10_RU10
149ASI_Field_Comparison_1 SearchASI_Field_Comparison[1]BooleanASI_Field_Comparison0
150ASI_Field_Comparison_2 SearchASI_Field_Comparison[2]BooleanASI_Field_Comparison0
151ASI_Field_Comparison_3 SearchASI_Field_Comparison[3]BooleanASI_Field_Comparison0
152ASI_Field_Comparison_4 SearchASI_Field_Comparison[4]BooleanASI_Field_Comparison0
153ASI_Start_Comp_Field_ID_1 SearchASI_Start_Comp_Field_ID[1]IntegerINT0
154ASI_Start_Comp_Field_ID_2 SearchASI_Start_Comp_Field_ID[2]IntegerINT0
155ASI_Start_Comp_Field_ID_3 SearchASI_Start_Comp_Field_ID[3]IntegerINT0
156ASI_Start_Comp_Field_ID_4 SearchASI_Start_Comp_Field_ID[4]IntegerINT0
157ASI_Start_Comp_Field_Dic_1 SearchASI_Start_Comp_Field_Dict[1]IntegerINT0
158ASI_Start_Comp_Field_Dic_2 SearchASI_Start_Comp_Field_Dict[2]IntegerINT0
159ASI_Start_Comp_Field_Dic_3 SearchASI_Start_Comp_Field_Dict[3]IntegerINT0
160ASI_Start_Comp_Field_Dic_4 SearchASI_Start_Comp_Field_Dict[4]IntegerINT0
161ASI_End_Comp_Field_ID_1 SearchASI_End_Comp_Field_ID[1]IntegerINT0
162ASI_End_Comp_Field_ID_2 SearchASI_End_Comp_Field_ID[2]IntegerINT0
163ASI_End_Comp_Field_ID_3 SearchASI_End_Comp_Field_ID[3]IntegerINT0
164ASI_End_Comp_Field_ID_4 SearchASI_End_Comp_Field_ID[4]IntegerINT0
165ASI_End_Comp_Field_Dict_1 SearchASI_End_Comp_Field_Dict[1]IntegerINT0
166ASI_End_Comp_Field_Dict_2 SearchASI_End_Comp_Field_Dict[2]IntegerINT0
167ASI_End_Comp_Field_Dict_3 SearchASI_End_Comp_Field_Dict[3]IntegerINT0
168ASI_End_Comp_Field_Dict_4 SearchASI_End_Comp_Field_Dict[4]IntegerINT0
169ASI_Search_Criteria SearchASI_Search_CriteriaTextTX3200032000
azurecurveProductsSmartList (1493)PathnameASI_SmartList_Favorites (ASIEXP91)

Leave a Reply

Your email address will not be published. Required fields are marked *