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: Project

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 TypeSQL DB LengthKeyable Length
1BARULEID SearchBusiness Alert Rule IDLong IntLong Integer48
2DSCRIPTN SearchDescriptionSTR30String3230
3BUSALRTID SearchBusiness Alert IDSTR15_Vendor_IDString1615
4EMAILMSG SearchEmail MessageSTR255String256255
5LSTRWCHKD SearchLast Row CheckedLong IntLong Integer48
6INCLDRSLTS SearchInclude ResultsBooleanBoolean20
7DBNAME SearchDatabase NameSTR10_LBAUString1210
8CMPANYID SearchCompany IDINT5Integer24
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 TypeINTInteger20
10FREQINT SearchFrequency IntervalINTInteger20
11FRQSUBTYP SearchFrequency SubtypeINTInteger20
12FRQSUBINT SearchFrequency SubintervalINTInteger20
13FRQRELINT SearchFrequency Relative IntervalINTInteger20
14FRQRCINT SearchFrequency Recurrence IntervalINT2Integer22
15STRTTIME SearchStart TimeTM6Time46
16ENDTIME SearchEnd TimeTM6Time46
17STRTDATE SearchStart DateDTDate48
18ENDDATE SearchEnd DateDTDate48
19CREATDDT SearchCreated DateDTDate48
20CRUSRID SearchCreated User IDSTR15_User_IDString1615
21MODIFDT SearchModified DateDTDate48
22MDFUSRID SearchModified User IDSTR15String1615
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 SearchEnabledBooleanBoolean20
24KEEPHIST SearchKeep HistoryBooleanBoolean20
25NMBRTIME SearchNumber of Times Alert RanINTInteger20
26NOTEINDX SearchNote IndexDLR14Currency1014
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 SearchScheduleTextSTR255String256255
28DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurveProductsFieldService (949)ProjectBusiness Alerts Rules Master (SVC40500)

Leave a Reply

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