SmartList Builder SmartLists (SLB10000)

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

Display Name: SmartList Builder SmartLists
Physical Name: SLB10000
Technical Name: SLB_SmartLists

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	SmartList_ID	SmartList ID	STR15_LBAU	String	15
2	SmartList_Name	SmartList Name	STR64	String	64
3	SmartList_Item_Name	SmartList Item Name	STR64	String	64
4	SmartList_Number	SmartList Number	INT5	Integer	4
5	GoTo_Number	GoTo Number	INT5	Integer	4
6	Summary_SmartList_CB	Summary SmartList CB	Summary SmartList CB	Boolean	0
7	PRODID	Product ID	INT4	Integer	4
8	Series_Number	Series Number	INT5	Integer	4
9	NOTEINDX	Note Index	DLR14	Currency	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['SmartList Builder SmartLists'].NOTEINDX AS 'SmartList Builder SmartLists-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SLB10000 AS ['SmartList Builder SmartLists'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['SmartList Builder SmartLists'].NOTEINDX = ['Record Notes Master'].NOTEINDX
10	CREATDDT	Created Date	DT	Date	8
11	CRUSRID	Created User ID	STR15_User_ID	String	15
12	MODIFDT	Modified Date	DT	Date	8
13	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SmartList Builder SmartLists'].MDFUSRID AS 'SmartList Builder SmartLists-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SLB10000 AS ['SmartList Builder SmartLists'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SmartList Builder SmartLists'].MDFUSRID = ['Users Master'].USERID
14	ASI_Search_Type	ASI_Search_Type	ASI_Search_Type	Integer	0
15	TXTFIELD	Text Field	TX32000	Text	32000