SmartList Favorites Master (ASIEXP81)

azurecurveProductsSmartList (1493)SystemSmartList Favorites Master (ASIEXP81)

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

Product: SmartList (1493)
Series:

Display Name: SmartList Favorites Master
Physical Name: ASIEXP81
Technical Name: ASI_MSTR_Explorer_Favorites

Group Display Name: SmartList Master
Group Technical Name: ASI_Explorer_Logical_MSTR

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

Click to show/hide

SELECT
       ['SmartList Favorites Master'].CMPANYID AS 'SmartList Favorites Master-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       ASIEXP81 AS ['SmartList Favorites Master']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['SmartList Favorites Master'].CMPANYID = ['Company Master'].CMPANYID
5USRCLASS SearchUser ClassStringSTR15_User_Class15
6USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

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

Leave a Reply

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