SY40500 - Business Alerts Rules Master | Prospr

SY40500 - Business Alerts Rules Master

Select * from SY40500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BARULEID	Business Alert Rule ID	Long Integer	4	View
DSCRIPTN	Description	String	32	View
BUSALRTID	Business Alert ID	String	16	View
EMAILMSG	Email Message	String	256	View
LSTRWCHKD	Last Row Checked	Long Integer	4	View
INCLDRSLTS	Include Results	Boolean	2	View
DBNAME	Database Name	String	12	View
CMPANYID	Company ID	Integer	2	View
FREQTYPE	Frequency Type	Integer	2	View
FREQINT	Frequency Interval	Integer	2	View
FRQSUBTYP	Frequency Subtype	Integer	2	View
FRQSUBINT	Frequency Subinterval	Integer	2	View
FRQRELINT	Frequency Relative Interval	Integer	2	View
FRQRCINT	Frequency Recurrence Interval	Integer	2	View
STRTTIME	Start Time	Time	4	View
ENDTIME	End Time	Time	4	View
STRTDATE	Start Date	Date	4	View
ENDDATE	End Date	Date	4	View
CREATDDT	Created Date	Date	4	View
CRUSRID	Created User ID	String	16	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
ENABLED	Enabled	Boolean	2	View
KEEPHIST	Keep History	Boolean	2	View
NMBRTIME	Number of Times Alert Ran	Integer	2	View
NOTEINDX	Note Index	Currency	10	View
SCHEDTXT	ScheduleText	String	256	View