ASI_SmartList_Favorites (ASIEXP91)

azurecurve Products SmartList (1493)PathnameASI_SmartList_Favorites (ASIEXP91)

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

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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ASI_Favorite_Sequence	ASI_Favorite_Sequence	Long Integer	ASI_LI_10_RU	10
2	ASI_Favorite_Dict_ID	ASI_Favorite_Dict_ID	Integer	INT	0
3	ASI_Favorite_Type	ASI_Favorite_Type	Integer	INT	0
4	ASI_Favorite_Save_Level	ASI_Favorite_Save_Level	Integer	ASI_Favorite_Save_Level	0
5	CMPANYID	Company ID	Integer	INT5	4
	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
6	ASI_Favorite_Name	ASI_Favorite_Name	String	STR80	80
7	ASI_Field_Dict_ID_1	ASI_Field_Dict_ID[1]	Integer	INT	0
8	ASI_Field_Dict_ID_2	ASI_Field_Dict_ID[2]	Integer	INT	0
9	ASI_Field_Dict_ID_3	ASI_Field_Dict_ID[3]	Integer	INT	0
10	ASI_Field_Dict_ID_4	ASI_Field_Dict_ID[4]	Integer	INT	0
11	ASI_Field_List_1	ASI_Field_List[1]	Integer	DDL	0
12	ASI_Field_List_2	ASI_Field_List[2]	Integer	DDL	0
13	ASI_Field_List_3	ASI_Field_List[3]	Integer	DDL	0
14	ASI_Field_List_4	ASI_Field_List[4]	Integer	DDL	0
15	ASI_Search_Type_1	ASI_Search_Type[1]	Integer	ASI_DDL_Search_Type	0
16	ASI_Search_Type_2	ASI_Search_Type[2]	Integer	ASI_DDL_Search_Type	0
17	ASI_Search_Type_3	ASI_Search_Type[3]	Integer	ASI_DDL_Search_Type	0
18	ASI_Search_Type_4	ASI_Search_Type[4]	Integer	ASI_DDL_Search_Type	0
19	ASI_Match_Case_1	ASI_Match_Case[1]	Boolean	ASI_CB_Match_Case	0
20	ASI_Match_Case_2	ASI_Match_Case[2]	Boolean	ASI_CB_Match_Case	0
21	ASI_Match_Case_3	ASI_Match_Case[3]	Boolean	ASI_CB_Match_Case	0
22	ASI_Match_Case_4	ASI_Match_Case[4]	Boolean	ASI_CB_Match_Case	0
23	ASI_Start_Account_Number_1_1	ASI_Start_Account_Number[1]:Account_Segment_Pool1	String	Account_Segment_Pool1	6
24	ASI_Start_Account_Number_1_2	ASI_Start_Account_Number[1]:Account_Segment_Pool2	String	Account_Segment_Pool2	6
25	ASI_Start_Account_Number_1_3	ASI_Start_Account_Number[1]:Account_Segment_Pool3	String	Account_Segment_Pool3	6
26	ASI_Start_Account_Number_1_4	ASI_Start_Account_Number[1]:Account_Segment_Pool4	String	Account_Segment_Pool4	6
27	ASI_Start_Account_Number_1_5	ASI_Start_Account_Number[1]:Account_Segment_Pool5	String	Account_Segment_Pool5	6
28	ASI_Start_Account_Number_1_6	ASI_Start_Account_Number[1]:Account_Segment_Pool6	String	Account_Segment_Pool6	6
29	ASI_Start_Account_Number_1_7	ASI_Start_Account_Number[1]:Account_Segment_Pool7	String	Account_Segment_Pool7	6
30	ASI_Start_Account_Number_1_8	ASI_Start_Account_Number[1]:Account_Segment_Pool8	String	Account_Segment_Pool8	6
31	ASI_Start_Account_Number_1_9	ASI_Start_Account_Number[1]:Account_Segment_Pool9	String	Account_Segment_Pool9	6
32	ASI_Start_Account_Number_1_10	ASI_Start_Account_Number[1]:Account_Segment_Pool10	String	Account_Segment_Pool10	6
33	ASI_Start_Account_Number_2_1	ASI_Start_Account_Number[2]:Account_Segment_Pool1	String	Account_Segment_Pool1	6
34	ASI_Start_Account_Number_2_2	ASI_Start_Account_Number[2]:Account_Segment_Pool2	String	Account_Segment_Pool2	6
35	ASI_Start_Account_Number_2_3	ASI_Start_Account_Number[2]:Account_Segment_Pool3	String	Account_Segment_Pool3	6
36	ASI_Start_Account_Number_2_4	ASI_Start_Account_Number[2]:Account_Segment_Pool4	String	Account_Segment_Pool4	6
37	ASI_Start_Account_Number_2_5	ASI_Start_Account_Number[2]:Account_Segment_Pool5	String	Account_Segment_Pool5	6
38	ASI_Start_Account_Number_2_6	ASI_Start_Account_Number[2]:Account_Segment_Pool6	String	Account_Segment_Pool6	6
39	ASI_Start_Account_Number_2_7	ASI_Start_Account_Number[2]:Account_Segment_Pool7	String	Account_Segment_Pool7	6
40	ASI_Start_Account_Number_2_8	ASI_Start_Account_Number[2]:Account_Segment_Pool8	String	Account_Segment_Pool8	6
41	ASI_Start_Account_Number_2_9	ASI_Start_Account_Number[2]:Account_Segment_Pool9	String	Account_Segment_Pool9	6
42	ASI_Start_Account_Number_2_10	ASI_Start_Account_Number[2]:Account_Segment_Pool10	String	Account_Segment_Pool10	6
43	ASI_Start_Account_Number_3_1	ASI_Start_Account_Number[3]:Account_Segment_Pool1	String	Account_Segment_Pool1	6
44	ASI_Start_Account_Number_3_2	ASI_Start_Account_Number[3]:Account_Segment_Pool2	String	Account_Segment_Pool2	6
45	ASI_Start_Account_Number_3_3	ASI_Start_Account_Number[3]:Account_Segment_Pool3	String	Account_Segment_Pool3	6
46	ASI_Start_Account_Number_3_4	ASI_Start_Account_Number[3]:Account_Segment_Pool4	String	Account_Segment_Pool4	6
47	ASI_Start_Account_Number_3_5	ASI_Start_Account_Number[3]:Account_Segment_Pool5	String	Account_Segment_Pool5	6
48	ASI_Start_Account_Number_3_6	ASI_Start_Account_Number[3]:Account_Segment_Pool6	String	Account_Segment_Pool6	6
49	ASI_Start_Account_Number_3_7	ASI_Start_Account_Number[3]:Account_Segment_Pool7	String	Account_Segment_Pool7	6
50	ASI_Start_Account_Number_3_8	ASI_Start_Account_Number[3]:Account_Segment_Pool8	String	Account_Segment_Pool8	6
51	ASI_Start_Account_Number_3_9	ASI_Start_Account_Number[3]:Account_Segment_Pool9	String	Account_Segment_Pool9	6
52	ASI_Start_Account_Number_3_10	ASI_Start_Account_Number[3]:Account_Segment_Pool10	String	Account_Segment_Pool10	6
53	ASI_Start_Account_Number_4_1	ASI_Start_Account_Number[4]:Account_Segment_Pool1	String	Account_Segment_Pool1	6
54	ASI_Start_Account_Number_4_2	ASI_Start_Account_Number[4]:Account_Segment_Pool2	String	Account_Segment_Pool2	6
55	ASI_Start_Account_Number_4_3	ASI_Start_Account_Number[4]:Account_Segment_Pool3	String	Account_Segment_Pool3	6
56	ASI_Start_Account_Number_4_4	ASI_Start_Account_Number[4]:Account_Segment_Pool4	String	Account_Segment_Pool4	6
57	ASI_Start_Account_Number_4_5	ASI_Start_Account_Number[4]:Account_Segment_Pool5	String	Account_Segment_Pool5	6
58	ASI_Start_Account_Number_4_6	ASI_Start_Account_Number[4]:Account_Segment_Pool6	String	Account_Segment_Pool6	6
59	ASI_Start_Account_Number_4_7	ASI_Start_Account_Number[4]:Account_Segment_Pool7	String	Account_Segment_Pool7	6
60	ASI_Start_Account_Number_4_8	ASI_Start_Account_Number[4]:Account_Segment_Pool8	String	Account_Segment_Pool8	6
61	ASI_Start_Account_Number_4_9	ASI_Start_Account_Number[4]:Account_Segment_Pool9	String	Account_Segment_Pool9	6
62	ASI_Start_Account_Number_4_10	ASI_Start_Account_Number[4]:Account_Segment_Pool10	String	Account_Segment_Pool10	6
63	ASI_Start_Date_Token_DDL_1	ASI_Start_Date_Token_DDL[1]	Integer	ASI_Date_Token_DDL	0
64	ASI_Start_Date_Token_DDL_2	ASI_Start_Date_Token_DDL[2]	Integer	ASI_Date_Token_DDL	0
65	ASI_Start_Date_Token_DDL_3	ASI_Start_Date_Token_DDL[3]	Integer	ASI_Date_Token_DDL	0
66	ASI_Start_Date_Token_DDL_4	ASI_Start_Date_Token_DDL[4]	Integer	ASI_Date_Token_DDL	0
67	ASI_Start_Date_1	ASI_Start_Date[1]	Date	DATE_LONG	8
68	ASI_Start_Date_2	ASI_Start_Date[2]	Date	DATE_LONG	8
69	ASI_Start_Date_3	ASI_Start_Date[3]	Date	DATE_LONG	8
70	ASI_Start_Date_4	ASI_Start_Date[4]	Date	DATE_LONG	8
71	ASI_Start_DDL_1	ASI_Start_DDL[1]	Integer	DDL	0
72	ASI_Start_DDL_2	ASI_Start_DDL[2]	Integer	DDL	0
73	ASI_Start_DDL_3	ASI_Start_DDL[3]	Integer	DDL	0
74	ASI_Start_DDL_4	ASI_Start_DDL[4]	Integer	DDL	0
75	ASI_String_Start_1	ASI_Start_String[1]	String	STR60	60
76	ASI_String_Start_2	ASI_Start_String[2]	String	STR60	60
77	ASI_String_Start_3	ASI_Start_String[3]	String	STR60	60
78	ASI_String_Start_4	ASI_Start_String[4]	String	STR60	60
79	ASI_End_Account_Number_1_1	ASI_End_Account_Number[1]:Account_Segment_Pool1	String	Account_Segment_Pool1	6
80	ASI_End_Account_Number_1_2	ASI_End_Account_Number[1]:Account_Segment_Pool2	String	Account_Segment_Pool2	6
81	ASI_End_Account_Number_1_3	ASI_End_Account_Number[1]:Account_Segment_Pool3	String	Account_Segment_Pool3	6
82	ASI_End_Account_Number_1_4	ASI_End_Account_Number[1]:Account_Segment_Pool4	String	Account_Segment_Pool4	6
83	ASI_End_Account_Number_1_5	ASI_End_Account_Number[1]:Account_Segment_Pool5	String	Account_Segment_Pool5	6
84	ASI_End_Account_Number_1_6	ASI_End_Account_Number[1]:Account_Segment_Pool6	String	Account_Segment_Pool6	6
85	ASI_End_Account_Number_1_7	ASI_End_Account_Number[1]:Account_Segment_Pool7	String	Account_Segment_Pool7	6
86	ASI_End_Account_Number_1_8	ASI_End_Account_Number[1]:Account_Segment_Pool8	String	Account_Segment_Pool8	6
87	ASI_End_Account_Number_1_9	ASI_End_Account_Number[1]:Account_Segment_Pool9	String	Account_Segment_Pool9	6
88	ASI_End_Account_Number_1_10	ASI_End_Account_Number[1]:Account_Segment_Pool10	String	Account_Segment_Pool10	6
89	ASI_End_Account_Number_2_1	ASI_End_Account_Number[2]:Account_Segment_Pool1	String	Account_Segment_Pool1	6
90	ASI_End_Account_Number_2_2	ASI_End_Account_Number[2]:Account_Segment_Pool2	String	Account_Segment_Pool2	6
91	ASI_End_Account_Number_2_3	ASI_End_Account_Number[2]:Account_Segment_Pool3	String	Account_Segment_Pool3	6
92	ASI_End_Account_Number_2_4	ASI_End_Account_Number[2]:Account_Segment_Pool4	String	Account_Segment_Pool4	6
93	ASI_End_Account_Number_2_5	ASI_End_Account_Number[2]:Account_Segment_Pool5	String	Account_Segment_Pool5	6
94	ASI_End_Account_Number_2_6	ASI_End_Account_Number[2]:Account_Segment_Pool6	String	Account_Segment_Pool6	6
95	ASI_End_Account_Number_2_7	ASI_End_Account_Number[2]:Account_Segment_Pool7	String	Account_Segment_Pool7	6
96	ASI_End_Account_Number_2_8	ASI_End_Account_Number[2]:Account_Segment_Pool8	String	Account_Segment_Pool8	6
97	ASI_End_Account_Number_2_9	ASI_End_Account_Number[2]:Account_Segment_Pool9	String	Account_Segment_Pool9	6
98	ASI_End_Account_Number_2_10	ASI_End_Account_Number[2]:Account_Segment_Pool10	String	Account_Segment_Pool10	6
99	ASI_End_Account_Number_3_1	ASI_End_Account_Number[3]:Account_Segment_Pool1	String	Account_Segment_Pool1	6
100	ASI_End_Account_Number_3_2	ASI_End_Account_Number[3]:Account_Segment_Pool2	String	Account_Segment_Pool2	6
101	ASI_End_Account_Number_3_3	ASI_End_Account_Number[3]:Account_Segment_Pool3	String	Account_Segment_Pool3	6
102	ASI_End_Account_Number_3_4	ASI_End_Account_Number[3]:Account_Segment_Pool4	String	Account_Segment_Pool4	6
103	ASI_End_Account_Number_3_5	ASI_End_Account_Number[3]:Account_Segment_Pool5	String	Account_Segment_Pool5	6
104	ASI_End_Account_Number_3_6	ASI_End_Account_Number[3]:Account_Segment_Pool6	String	Account_Segment_Pool6	6
105	ASI_End_Account_Number_3_7	ASI_End_Account_Number[3]:Account_Segment_Pool7	String	Account_Segment_Pool7	6
106	ASI_End_Account_Number_3_8	ASI_End_Account_Number[3]:Account_Segment_Pool8	String	Account_Segment_Pool8	6
107	ASI_End_Account_Number_3_9	ASI_End_Account_Number[3]:Account_Segment_Pool9	String	Account_Segment_Pool9	6
108	ASI_End_Account_Number_3_10	ASI_End_Account_Number[3]:Account_Segment_Pool10	String	Account_Segment_Pool10	6
109	ASI_End_Account_Number_4_1	ASI_End_Account_Number[4]:Account_Segment_Pool1	String	Account_Segment_Pool1	6
110	ASI_End_Account_Number_4_2	ASI_End_Account_Number[4]:Account_Segment_Pool2	String	Account_Segment_Pool2	6
111	ASI_End_Account_Number_4_3	ASI_End_Account_Number[4]:Account_Segment_Pool3	String	Account_Segment_Pool3	6
112	ASI_End_Account_Number_4_4	ASI_End_Account_Number[4]:Account_Segment_Pool4	String	Account_Segment_Pool4	6
113	ASI_End_Account_Number_4_5	ASI_End_Account_Number[4]:Account_Segment_Pool5	String	Account_Segment_Pool5	6
114	ASI_End_Account_Number_4_6	ASI_End_Account_Number[4]:Account_Segment_Pool6	String	Account_Segment_Pool6	6
115	ASI_End_Account_Number_4_7	ASI_End_Account_Number[4]:Account_Segment_Pool7	String	Account_Segment_Pool7	6
116	ASI_End_Account_Number_4_8	ASI_End_Account_Number[4]:Account_Segment_Pool8	String	Account_Segment_Pool8	6
117	ASI_End_Account_Number_4_9	ASI_End_Account_Number[4]:Account_Segment_Pool9	String	Account_Segment_Pool9	6
118	ASI_End_Account_Number_4_10	ASI_End_Account_Number[4]:Account_Segment_Pool10	String	Account_Segment_Pool10	6
119	ASI_End_Date_Token_DDL_1	ASI_End_Date_Token_DDL[1]	Integer	ASI_Date_Token_DDL	0
120	ASI_End_Date_Token_DDL_2	ASI_End_Date_Token_DDL[2]	Integer	ASI_Date_Token_DDL	0
121	ASI_End_Date_Token_DDL_3	ASI_End_Date_Token_DDL[3]	Integer	ASI_Date_Token_DDL	0
122	ASI_End_Date_Token_DDL_4	ASI_End_Date_Token_DDL[4]	Integer	ASI_Date_Token_DDL	0
123	ASI_End_Date_1	ASI_End_Date[1]	Date	DATE_LONG	8
124	ASI_End_Date_2	ASI_End_Date[2]	Date	DATE_LONG	8
125	ASI_End_Date_3	ASI_End_Date[3]	Date	DATE_LONG	8
126	ASI_End_Date_4	ASI_End_Date[4]	Date	DATE_LONG	8
127	ASI_End_DDL_1	ASI_End_DDL[1]	Integer	DDL	0
128	ASI_End_DDL_2	ASI_End_DDL[2]	Integer	DDL	0
129	ASI_End_DDL_3	ASI_End_DDL[3]	Integer	DDL	0
130	ASI_End_DDL_4	ASI_End_DDL[4]	Integer	DDL	0
131	ASI_String_End_1	ASI_End_String[1]	String	STR60	60
132	ASI_String_End_2	ASI_End_String[2]	String	STR60	60
133	ASI_String_End_3	ASI_End_String[3]	String	STR60	60
134	ASI_String_End_4	ASI_End_String[4]	String	STR60	60
135	ASI_Search_From_Str_1	ASI_Search_From_Str[1]	String	STR60	60
136	ASI_Search_From_Str_2	ASI_Search_From_Str[2]	String	STR60	60
137	ASI_Search_From_Str_3	ASI_Search_From_Str[3]	String	STR60	60
138	ASI_Search_From_Str_4	ASI_Search_From_Str[4]	String	STR60	60
139	ASI_Search_To_Str_1	ASI_Search_To_Str[1]	String	STR60	60
140	ASI_Search_To_Str_2	ASI_Search_To_Str[2]	String	STR60	60
141	ASI_Search_To_Str_3	ASI_Search_To_Str[3]	String	STR60	60
142	ASI_Search_To_Str_4	ASI_Search_To_Str[4]	String	STR60	60
143	ASI_Search_Logic_Type	ASI_Search_Logic_Type	Integer	ASI_DDL_Search_Logic_Type	0
144	ASI_Max_Records	ASI_Max_Records	Long Integer	ASI_LI_10_RU	10
145	ASI_Sort_Dict_ID	ASI_Sort_Dict_ID	Integer	INT	0
146	ASI_Sort_Field	ASI_Sort_Field	Integer	INT	0
147	ASI_Sort_Type	ASI_Sort_Type	Integer	INT	0
148	ASI_Category_Node_ID	ASI_Category_Node_ID	Long Integer	ASI_LI_10_RU	10
149	ASI_Field_Comparison_1	ASI_Field_Comparison[1]	Boolean	ASI_Field_Comparison	0
150	ASI_Field_Comparison_2	ASI_Field_Comparison[2]	Boolean	ASI_Field_Comparison	0
151	ASI_Field_Comparison_3	ASI_Field_Comparison[3]	Boolean	ASI_Field_Comparison	0
152	ASI_Field_Comparison_4	ASI_Field_Comparison[4]	Boolean	ASI_Field_Comparison	0
153	ASI_Start_Comp_Field_ID_1	ASI_Start_Comp_Field_ID[1]	Integer	INT	0
154	ASI_Start_Comp_Field_ID_2	ASI_Start_Comp_Field_ID[2]	Integer	INT	0
155	ASI_Start_Comp_Field_ID_3	ASI_Start_Comp_Field_ID[3]	Integer	INT	0
156	ASI_Start_Comp_Field_ID_4	ASI_Start_Comp_Field_ID[4]	Integer	INT	0
157	ASI_Start_Comp_Field_Dic_1	ASI_Start_Comp_Field_Dict[1]	Integer	INT	0
158	ASI_Start_Comp_Field_Dic_2	ASI_Start_Comp_Field_Dict[2]	Integer	INT	0
159	ASI_Start_Comp_Field_Dic_3	ASI_Start_Comp_Field_Dict[3]	Integer	INT	0
160	ASI_Start_Comp_Field_Dic_4	ASI_Start_Comp_Field_Dict[4]	Integer	INT	0
161	ASI_End_Comp_Field_ID_1	ASI_End_Comp_Field_ID[1]	Integer	INT	0
162	ASI_End_Comp_Field_ID_2	ASI_End_Comp_Field_ID[2]	Integer	INT	0
163	ASI_End_Comp_Field_ID_3	ASI_End_Comp_Field_ID[3]	Integer	INT	0
164	ASI_End_Comp_Field_ID_4	ASI_End_Comp_Field_ID[4]	Integer	INT	0
165	ASI_End_Comp_Field_Dict_1	ASI_End_Comp_Field_Dict[1]	Integer	INT	0
166	ASI_End_Comp_Field_Dict_2	ASI_End_Comp_Field_Dict[2]	Integer	INT	0
167	ASI_End_Comp_Field_Dict_3	ASI_End_Comp_Field_Dict[3]	Integer	INT	0
168	ASI_End_Comp_Field_Dict_4	ASI_End_Comp_Field_Dict[4]	Integer	INT	0
169	ASI_Search_Criteria	ASI_Search_Criteria	Text	TX32000	32000

azurecurve Products SmartList (1493)PathnameASI_SmartList_Favorites (ASIEXP91)

Click to show/hide

Leave a Reply Cancel reply