Business Alerts Rules Master (SVC40500)

azurecurveProductsFieldService (949)ProjectBusiness Alerts Rules Master (SVC40500)

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

Product: FieldService (949)
Series:

Display Name: Business Alerts Rules Master
Physical Name: SVC40500
Technical Name: SVC_Tasks_MSTR

Group Display Name: Service Table Group
Group Technical Name: Service

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1BARULEID SearchBusiness Alert Rule IDLong IntegerLong Int8
2DSCRIPTN SearchDescriptionStringSTR3030
3BUSALRTID SearchBusiness Alert IDStringSTR15_Vendor_ID15
4EMAILMSG SearchEmail MessageStringSTR255255
5LSTRWCHKD SearchLast Row CheckedLong IntegerLong Int8
6INCLDRSLTS SearchInclude ResultsBooleanBoolean0
7DBNAME SearchDatabase NameStringSTR10_LBAU10
8CMPANYID SearchCompany IDIntegerINT54
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
       SVC40500 AS ['Business Alerts Rules Master']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['Business Alerts Rules Master'].CMPANYID = ['Company Master'].CMPANYID
9FREQTYPE SearchFrequency TypeIntegerINT0
10FREQINT SearchFrequency IntervalIntegerINT0
11FRQSUBTYP SearchFrequency SubtypeIntegerINT0
12FRQSUBINT SearchFrequency SubintervalIntegerINT0
13FRQRELINT SearchFrequency Relative IntervalIntegerINT0
14FRQRCINT SearchFrequency Recurrence IntervalIntegerINT22
15STRTTIME SearchStart TimeTimeTM66
16ENDTIME SearchEnd TimeTimeTM66
17STRTDATE SearchStart DateDateDT8
18ENDDATE SearchEnd DateDateDT8
19CREATDDT SearchCreated DateDateDT8
20CRUSRID SearchCreated User IDStringSTR15_User_ID15
21MODIFDT SearchModified DateDateDT8
22MDFUSRID SearchModified User IDStringSTR1515
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
       SVC40500 AS ['Business Alerts Rules Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Business Alerts Rules Master'].MDFUSRID = ['Users Master'].USERID
23ENABLED SearchEnabledBooleanBoolean0
24KEEPHIST SearchKeep HistoryBooleanBoolean0
25NMBRTIME SearchNumber of Times Alert RanIntegerINT0
26NOTEINDX SearchNote IndexCurrencyDLR1414
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
       SVC40500 AS ['Business Alerts Rules Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Business Alerts Rules Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
27SCHEDTXT SearchScheduleTextStringSTR255255
azurecurveProductsFieldService (949)ProjectBusiness Alerts Rules Master (SVC40500)

Leave a Reply

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