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: Pathname

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 TypeSQL DB LengthKeyable Length
1ASI_Favorite_Sequence SearchASI_Favorite_SequenceASI_LI_10_RULong Integer410
2ASI_Favorite_Dict_ID SearchASI_Favorite_Dict_IDINTInteger20
3ASI_Favorite_Type SearchASI_Favorite_TypeINTInteger20
4ASI_Favorite_Save_Level SearchASI_Favorite_Save_LevelASI_Favorite_Save_LevelInteger20
5CMPANYID SearchCompany IDINT5Integer24
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_NameSTR80String8280
7ASI_Field_Dict_ID_1 SearchASI_Field_Dict_ID[1]INTInteger20
8ASI_Field_Dict_ID_2 SearchASI_Field_Dict_ID[2]INTInteger20
9ASI_Field_Dict_ID_3 SearchASI_Field_Dict_ID[3]INTInteger20
10ASI_Field_Dict_ID_4 SearchASI_Field_Dict_ID[4]INTInteger20
11ASI_Field_List_1 SearchASI_Field_List[1]DDLInteger20
12ASI_Field_List_2 SearchASI_Field_List[2]DDLInteger20
13ASI_Field_List_3 SearchASI_Field_List[3]DDLInteger20
14ASI_Field_List_4 SearchASI_Field_List[4]DDLInteger20
15ASI_Search_Type_1 SearchASI_Search_Type[1]ASI_DDL_Search_TypeInteger20
16ASI_Search_Type_2 SearchASI_Search_Type[2]ASI_DDL_Search_TypeInteger20
17ASI_Search_Type_3 SearchASI_Search_Type[3]ASI_DDL_Search_TypeInteger20
18ASI_Search_Type_4 SearchASI_Search_Type[4]ASI_DDL_Search_TypeInteger20
19ASI_Match_Case_1 SearchASI_Match_Case[1]ASI_CB_Match_CaseBoolean20
20ASI_Match_Case_2 SearchASI_Match_Case[2]ASI_CB_Match_CaseBoolean20
21ASI_Match_Case_3 SearchASI_Match_Case[3]ASI_CB_Match_CaseBoolean20
22ASI_Match_Case_4 SearchASI_Match_Case[4]ASI_CB_Match_CaseBoolean20
23ASI_Start_Account_Number_1_1 SearchASI_Start_Account_Number[1]:Account_Segment_Pool1Account_Segment_Pool1String86
24ASI_Start_Account_Number_1_2 SearchASI_Start_Account_Number[1]:Account_Segment_Pool2Account_Segment_Pool2String86
25ASI_Start_Account_Number_1_3 SearchASI_Start_Account_Number[1]:Account_Segment_Pool3Account_Segment_Pool3String86
26ASI_Start_Account_Number_1_4 SearchASI_Start_Account_Number[1]:Account_Segment_Pool4Account_Segment_Pool4String86
27ASI_Start_Account_Number_1_5 SearchASI_Start_Account_Number[1]:Account_Segment_Pool5Account_Segment_Pool5String86
28ASI_Start_Account_Number_1_6 SearchASI_Start_Account_Number[1]:Account_Segment_Pool6Account_Segment_Pool6String86
29ASI_Start_Account_Number_1_7 SearchASI_Start_Account_Number[1]:Account_Segment_Pool7Account_Segment_Pool7String86
30ASI_Start_Account_Number_1_8 SearchASI_Start_Account_Number[1]:Account_Segment_Pool8Account_Segment_Pool8String86
31ASI_Start_Account_Number_1_9 SearchASI_Start_Account_Number[1]:Account_Segment_Pool9Account_Segment_Pool9String86
32ASI_Start_Account_Number_1_10 SearchASI_Start_Account_Number[1]:Account_Segment_Pool10Account_Segment_Pool10String86
33ASI_Start_Account_Number_2_1 SearchASI_Start_Account_Number[2]:Account_Segment_Pool1Account_Segment_Pool1String86
34ASI_Start_Account_Number_2_2 SearchASI_Start_Account_Number[2]:Account_Segment_Pool2Account_Segment_Pool2String86
35ASI_Start_Account_Number_2_3 SearchASI_Start_Account_Number[2]:Account_Segment_Pool3Account_Segment_Pool3String86
36ASI_Start_Account_Number_2_4 SearchASI_Start_Account_Number[2]:Account_Segment_Pool4Account_Segment_Pool4String86
37ASI_Start_Account_Number_2_5 SearchASI_Start_Account_Number[2]:Account_Segment_Pool5Account_Segment_Pool5String86
38ASI_Start_Account_Number_2_6 SearchASI_Start_Account_Number[2]:Account_Segment_Pool6Account_Segment_Pool6String86
39ASI_Start_Account_Number_2_7 SearchASI_Start_Account_Number[2]:Account_Segment_Pool7Account_Segment_Pool7String86
40ASI_Start_Account_Number_2_8 SearchASI_Start_Account_Number[2]:Account_Segment_Pool8Account_Segment_Pool8String86
41ASI_Start_Account_Number_2_9 SearchASI_Start_Account_Number[2]:Account_Segment_Pool9Account_Segment_Pool9String86
42ASI_Start_Account_Number_2_10 SearchASI_Start_Account_Number[2]:Account_Segment_Pool10Account_Segment_Pool10String86
43ASI_Start_Account_Number_3_1 SearchASI_Start_Account_Number[3]:Account_Segment_Pool1Account_Segment_Pool1String86
44ASI_Start_Account_Number_3_2 SearchASI_Start_Account_Number[3]:Account_Segment_Pool2Account_Segment_Pool2String86
45ASI_Start_Account_Number_3_3 SearchASI_Start_Account_Number[3]:Account_Segment_Pool3Account_Segment_Pool3String86
46ASI_Start_Account_Number_3_4 SearchASI_Start_Account_Number[3]:Account_Segment_Pool4Account_Segment_Pool4String86
47ASI_Start_Account_Number_3_5 SearchASI_Start_Account_Number[3]:Account_Segment_Pool5Account_Segment_Pool5String86
48ASI_Start_Account_Number_3_6 SearchASI_Start_Account_Number[3]:Account_Segment_Pool6Account_Segment_Pool6String86
49ASI_Start_Account_Number_3_7 SearchASI_Start_Account_Number[3]:Account_Segment_Pool7Account_Segment_Pool7String86
50ASI_Start_Account_Number_3_8 SearchASI_Start_Account_Number[3]:Account_Segment_Pool8Account_Segment_Pool8String86
51ASI_Start_Account_Number_3_9 SearchASI_Start_Account_Number[3]:Account_Segment_Pool9Account_Segment_Pool9String86
52ASI_Start_Account_Number_3_10 SearchASI_Start_Account_Number[3]:Account_Segment_Pool10Account_Segment_Pool10String86
53ASI_Start_Account_Number_4_1 SearchASI_Start_Account_Number[4]:Account_Segment_Pool1Account_Segment_Pool1String86
54ASI_Start_Account_Number_4_2 SearchASI_Start_Account_Number[4]:Account_Segment_Pool2Account_Segment_Pool2String86
55ASI_Start_Account_Number_4_3 SearchASI_Start_Account_Number[4]:Account_Segment_Pool3Account_Segment_Pool3String86
56ASI_Start_Account_Number_4_4 SearchASI_Start_Account_Number[4]:Account_Segment_Pool4Account_Segment_Pool4String86
57ASI_Start_Account_Number_4_5 SearchASI_Start_Account_Number[4]:Account_Segment_Pool5Account_Segment_Pool5String86
58ASI_Start_Account_Number_4_6 SearchASI_Start_Account_Number[4]:Account_Segment_Pool6Account_Segment_Pool6String86
59ASI_Start_Account_Number_4_7 SearchASI_Start_Account_Number[4]:Account_Segment_Pool7Account_Segment_Pool7String86
60ASI_Start_Account_Number_4_8 SearchASI_Start_Account_Number[4]:Account_Segment_Pool8Account_Segment_Pool8String86
61ASI_Start_Account_Number_4_9 SearchASI_Start_Account_Number[4]:Account_Segment_Pool9Account_Segment_Pool9String86
62ASI_Start_Account_Number_4_10 SearchASI_Start_Account_Number[4]:Account_Segment_Pool10Account_Segment_Pool10String86
63ASI_Start_Date_Token_DDL_1 SearchASI_Start_Date_Token_DDL[1]ASI_Date_Token_DDLInteger20
64ASI_Start_Date_Token_DDL_2 SearchASI_Start_Date_Token_DDL[2]ASI_Date_Token_DDLInteger20
65ASI_Start_Date_Token_DDL_3 SearchASI_Start_Date_Token_DDL[3]ASI_Date_Token_DDLInteger20
66ASI_Start_Date_Token_DDL_4 SearchASI_Start_Date_Token_DDL[4]ASI_Date_Token_DDLInteger20
67ASI_Start_Date_1 SearchASI_Start_Date[1]DATE_LONGDate48
68ASI_Start_Date_2 SearchASI_Start_Date[2]DATE_LONGDate48
69ASI_Start_Date_3 SearchASI_Start_Date[3]DATE_LONGDate48
70ASI_Start_Date_4 SearchASI_Start_Date[4]DATE_LONGDate48
71ASI_Start_DDL_1 SearchASI_Start_DDL[1]DDLInteger20
72ASI_Start_DDL_2 SearchASI_Start_DDL[2]DDLInteger20
73ASI_Start_DDL_3 SearchASI_Start_DDL[3]DDLInteger20
74ASI_Start_DDL_4 SearchASI_Start_DDL[4]DDLInteger20
75ASI_String_Start_1 SearchASI_Start_String[1]STR60String6260
76ASI_String_Start_2 SearchASI_Start_String[2]STR60String6260
77ASI_String_Start_3 SearchASI_Start_String[3]STR60String6260
78ASI_String_Start_4 SearchASI_Start_String[4]STR60String6260
79ASI_End_Account_Number_1_1 SearchASI_End_Account_Number[1]:Account_Segment_Pool1Account_Segment_Pool1String86
80ASI_End_Account_Number_1_2 SearchASI_End_Account_Number[1]:Account_Segment_Pool2Account_Segment_Pool2String86
81ASI_End_Account_Number_1_3 SearchASI_End_Account_Number[1]:Account_Segment_Pool3Account_Segment_Pool3String86
82ASI_End_Account_Number_1_4 SearchASI_End_Account_Number[1]:Account_Segment_Pool4Account_Segment_Pool4String86
83ASI_End_Account_Number_1_5 SearchASI_End_Account_Number[1]:Account_Segment_Pool5Account_Segment_Pool5String86
84ASI_End_Account_Number_1_6 SearchASI_End_Account_Number[1]:Account_Segment_Pool6Account_Segment_Pool6String86
85ASI_End_Account_Number_1_7 SearchASI_End_Account_Number[1]:Account_Segment_Pool7Account_Segment_Pool7String86
86ASI_End_Account_Number_1_8 SearchASI_End_Account_Number[1]:Account_Segment_Pool8Account_Segment_Pool8String86
87ASI_End_Account_Number_1_9 SearchASI_End_Account_Number[1]:Account_Segment_Pool9Account_Segment_Pool9String86
88ASI_End_Account_Number_1_10 SearchASI_End_Account_Number[1]:Account_Segment_Pool10Account_Segment_Pool10String86
89ASI_End_Account_Number_2_1 SearchASI_End_Account_Number[2]:Account_Segment_Pool1Account_Segment_Pool1String86
90ASI_End_Account_Number_2_2 SearchASI_End_Account_Number[2]:Account_Segment_Pool2Account_Segment_Pool2String86
91ASI_End_Account_Number_2_3 SearchASI_End_Account_Number[2]:Account_Segment_Pool3Account_Segment_Pool3String86
92ASI_End_Account_Number_2_4 SearchASI_End_Account_Number[2]:Account_Segment_Pool4Account_Segment_Pool4String86
93ASI_End_Account_Number_2_5 SearchASI_End_Account_Number[2]:Account_Segment_Pool5Account_Segment_Pool5String86
94ASI_End_Account_Number_2_6 SearchASI_End_Account_Number[2]:Account_Segment_Pool6Account_Segment_Pool6String86
95ASI_End_Account_Number_2_7 SearchASI_End_Account_Number[2]:Account_Segment_Pool7Account_Segment_Pool7String86
96ASI_End_Account_Number_2_8 SearchASI_End_Account_Number[2]:Account_Segment_Pool8Account_Segment_Pool8String86
97ASI_End_Account_Number_2_9 SearchASI_End_Account_Number[2]:Account_Segment_Pool9Account_Segment_Pool9String86
98ASI_End_Account_Number_2_10 SearchASI_End_Account_Number[2]:Account_Segment_Pool10Account_Segment_Pool10String86
99ASI_End_Account_Number_3_1 SearchASI_End_Account_Number[3]:Account_Segment_Pool1Account_Segment_Pool1String86
100ASI_End_Account_Number_3_2 SearchASI_End_Account_Number[3]:Account_Segment_Pool2Account_Segment_Pool2String86
101ASI_End_Account_Number_3_3 SearchASI_End_Account_Number[3]:Account_Segment_Pool3Account_Segment_Pool3String86
102ASI_End_Account_Number_3_4 SearchASI_End_Account_Number[3]:Account_Segment_Pool4Account_Segment_Pool4String86
103ASI_End_Account_Number_3_5 SearchASI_End_Account_Number[3]:Account_Segment_Pool5Account_Segment_Pool5String86
104ASI_End_Account_Number_3_6 SearchASI_End_Account_Number[3]:Account_Segment_Pool6Account_Segment_Pool6String86
105ASI_End_Account_Number_3_7 SearchASI_End_Account_Number[3]:Account_Segment_Pool7Account_Segment_Pool7String86
106ASI_End_Account_Number_3_8 SearchASI_End_Account_Number[3]:Account_Segment_Pool8Account_Segment_Pool8String86
107ASI_End_Account_Number_3_9 SearchASI_End_Account_Number[3]:Account_Segment_Pool9Account_Segment_Pool9String86
108ASI_End_Account_Number_3_10 SearchASI_End_Account_Number[3]:Account_Segment_Pool10Account_Segment_Pool10String86
109ASI_End_Account_Number_4_1 SearchASI_End_Account_Number[4]:Account_Segment_Pool1Account_Segment_Pool1String86
110ASI_End_Account_Number_4_2 SearchASI_End_Account_Number[4]:Account_Segment_Pool2Account_Segment_Pool2String86
111ASI_End_Account_Number_4_3 SearchASI_End_Account_Number[4]:Account_Segment_Pool3Account_Segment_Pool3String86
112ASI_End_Account_Number_4_4 SearchASI_End_Account_Number[4]:Account_Segment_Pool4Account_Segment_Pool4String86
113ASI_End_Account_Number_4_5 SearchASI_End_Account_Number[4]:Account_Segment_Pool5Account_Segment_Pool5String86
114ASI_End_Account_Number_4_6 SearchASI_End_Account_Number[4]:Account_Segment_Pool6Account_Segment_Pool6String86
115ASI_End_Account_Number_4_7 SearchASI_End_Account_Number[4]:Account_Segment_Pool7Account_Segment_Pool7String86
116ASI_End_Account_Number_4_8 SearchASI_End_Account_Number[4]:Account_Segment_Pool8Account_Segment_Pool8String86
117ASI_End_Account_Number_4_9 SearchASI_End_Account_Number[4]:Account_Segment_Pool9Account_Segment_Pool9String86
118ASI_End_Account_Number_4_10 SearchASI_End_Account_Number[4]:Account_Segment_Pool10Account_Segment_Pool10String86
119ASI_End_Date_Token_DDL_1 SearchASI_End_Date_Token_DDL[1]ASI_Date_Token_DDLInteger20
120ASI_End_Date_Token_DDL_2 SearchASI_End_Date_Token_DDL[2]ASI_Date_Token_DDLInteger20
121ASI_End_Date_Token_DDL_3 SearchASI_End_Date_Token_DDL[3]ASI_Date_Token_DDLInteger20
122ASI_End_Date_Token_DDL_4 SearchASI_End_Date_Token_DDL[4]ASI_Date_Token_DDLInteger20
123ASI_End_Date_1 SearchASI_End_Date[1]DATE_LONGDate48
124ASI_End_Date_2 SearchASI_End_Date[2]DATE_LONGDate48
125ASI_End_Date_3 SearchASI_End_Date[3]DATE_LONGDate48
126ASI_End_Date_4 SearchASI_End_Date[4]DATE_LONGDate48
127ASI_End_DDL_1 SearchASI_End_DDL[1]DDLInteger20
128ASI_End_DDL_2 SearchASI_End_DDL[2]DDLInteger20
129ASI_End_DDL_3 SearchASI_End_DDL[3]DDLInteger20
130ASI_End_DDL_4 SearchASI_End_DDL[4]DDLInteger20
131ASI_String_End_1 SearchASI_End_String[1]STR60String6260
132ASI_String_End_2 SearchASI_End_String[2]STR60String6260
133ASI_String_End_3 SearchASI_End_String[3]STR60String6260
134ASI_String_End_4 SearchASI_End_String[4]STR60String6260
135ASI_Search_From_Str_1 SearchASI_Search_From_Str[1]STR60String6260
136ASI_Search_From_Str_2 SearchASI_Search_From_Str[2]STR60String6260
137ASI_Search_From_Str_3 SearchASI_Search_From_Str[3]STR60String6260
138ASI_Search_From_Str_4 SearchASI_Search_From_Str[4]STR60String6260
139ASI_Search_To_Str_1 SearchASI_Search_To_Str[1]STR60String6260
140ASI_Search_To_Str_2 SearchASI_Search_To_Str[2]STR60String6260
141ASI_Search_To_Str_3 SearchASI_Search_To_Str[3]STR60String6260
142ASI_Search_To_Str_4 SearchASI_Search_To_Str[4]STR60String6260
143ASI_Search_Logic_Type SearchASI_Search_Logic_TypeASI_DDL_Search_Logic_TypeInteger20
144ASI_Max_Records SearchASI_Max_RecordsASI_LI_10_RULong Integer410
145ASI_Sort_Dict_ID SearchASI_Sort_Dict_IDINTInteger20
146ASI_Sort_Field SearchASI_Sort_FieldINTInteger20
147ASI_Sort_Type SearchASI_Sort_TypeINTInteger20
148ASI_Category_Node_ID SearchASI_Category_Node_IDASI_LI_10_RULong Integer410
149ASI_Field_Comparison_1 SearchASI_Field_Comparison[1]ASI_Field_ComparisonBoolean20
150ASI_Field_Comparison_2 SearchASI_Field_Comparison[2]ASI_Field_ComparisonBoolean20
151ASI_Field_Comparison_3 SearchASI_Field_Comparison[3]ASI_Field_ComparisonBoolean20
152ASI_Field_Comparison_4 SearchASI_Field_Comparison[4]ASI_Field_ComparisonBoolean20
153ASI_Start_Comp_Field_ID_1 SearchASI_Start_Comp_Field_ID[1]INTInteger20
154ASI_Start_Comp_Field_ID_2 SearchASI_Start_Comp_Field_ID[2]INTInteger20
155ASI_Start_Comp_Field_ID_3 SearchASI_Start_Comp_Field_ID[3]INTInteger20
156ASI_Start_Comp_Field_ID_4 SearchASI_Start_Comp_Field_ID[4]INTInteger20
157ASI_Start_Comp_Field_Dic_1 SearchASI_Start_Comp_Field_Dict[1]INTInteger20
158ASI_Start_Comp_Field_Dic_2 SearchASI_Start_Comp_Field_Dict[2]INTInteger20
159ASI_Start_Comp_Field_Dic_3 SearchASI_Start_Comp_Field_Dict[3]INTInteger20
160ASI_Start_Comp_Field_Dic_4 SearchASI_Start_Comp_Field_Dict[4]INTInteger20
161ASI_End_Comp_Field_ID_1 SearchASI_End_Comp_Field_ID[1]INTInteger20
162ASI_End_Comp_Field_ID_2 SearchASI_End_Comp_Field_ID[2]INTInteger20
163ASI_End_Comp_Field_ID_3 SearchASI_End_Comp_Field_ID[3]INTInteger20
164ASI_End_Comp_Field_ID_4 SearchASI_End_Comp_Field_ID[4]INTInteger20
165ASI_End_Comp_Field_Dict_1 SearchASI_End_Comp_Field_Dict[1]INTInteger20
166ASI_End_Comp_Field_Dict_2 SearchASI_End_Comp_Field_Dict[2]INTInteger20
167ASI_End_Comp_Field_Dict_3 SearchASI_End_Comp_Field_Dict[3]INTInteger20
168ASI_End_Comp_Field_Dict_4 SearchASI_End_Comp_Field_Dict[4]INTInteger20
169ASI_Search_Criteria SearchASI_Search_CriteriaTX32000Text232000
azurecurveProductsSmartList (1493)PathnameASI_SmartList_Favorites (ASIEXP91)

Leave a Reply

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