Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SY40500
Product: Microsoft Dynamics GP (0)
Series: System
Display Name: Business Alerts Rules Master
Physical Name: SY40500
Technical Name: SY_Rules_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 BARULEID 
Business Alert Rule ID Long Integer Long Int 8 2 DSCRIPTN Description String STR30 30 3 BUSALRTID Business Alert ID String STR15_Vendor_ID 15 4 EMAILMSG Email Message String STR255 255 5 LSTRWCHKD Last Row Checked Long Integer Long Int 8 6 INCLDRSLTS Include Results Boolean Boolean 0 7 DBNAME Database Name String STR10_LBAU 10 8 CMPANYID Company ID Integer INT5 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['Business Alerts Rules Master'].CMPANYID AS 'Business Alerts Rules Master-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
SY40500 AS ['Business Alerts Rules Master']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['Business Alerts Rules Master'].CMPANYID = ['Company Master'].CMPANYID9 FREQTYPE Frequency Type Integer INT 0 10 FREQINT Frequency Interval Integer INT 0 11 FRQSUBTYP Frequency Subtype Integer INT 0 12 FRQSUBINT Frequency Subinterval Integer INT 0 13 FRQRELINT Frequency Relative Interval Integer INT 0 14 FRQRCINT Frequency Recurrence Interval Integer INT2 2 15 STRTTIME Start Time Time TM6 6 16 ENDTIME End Time Time TM6 6 17 STRTDATE Start Date Date DT 8 18 ENDDATE End Date Date DT 8 19 CREATDDT Created Date Date DT 8 20 CRUSRID Created User ID String STR15_User_ID 15 21 MODIFDT Modified Date Date DT 8 22 MDFUSRID Modified User ID String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['Business Alerts Rules Master'].MDFUSRID AS 'Business Alerts Rules Master-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SY40500 AS ['Business Alerts Rules Master']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Business Alerts Rules Master'].MDFUSRID = ['Users Master'].USERID23 ENABLED Enabled Boolean Boolean 0 24 KEEPHIST Keep History Boolean Boolean 0 25 NMBRTIME Number of Times Alert Ran Integer INT 0 26 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Business Alerts Rules Master'].NOTEINDX AS 'Business Alerts Rules Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SY40500 AS ['Business Alerts Rules Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Business Alerts Rules Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX27 SCHEDTXT ScheduleText String STR255 255