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 TypeLength
1BARULEID SearchBusiness Alert Rule IDLong IntLong Integer8
2DSCRIPTN SearchDescriptionSTR30String30
3BUSALRTID SearchBusiness Alert IDSTR15_Vendor_IDString15
4EMAILMSG SearchEmail MessageSTR255String255
5LSTRWCHKD SearchLast Row CheckedLong IntLong Integer8
6INCLDRSLTS SearchInclude ResultsBooleanBoolean0
7DBNAME SearchDatabase NameSTR10_LBAUString10
8CMPANYID SearchCompany IDINT5Integer4
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 TypeINTInteger0
10FREQINT SearchFrequency IntervalINTInteger0
11FRQSUBTYP SearchFrequency SubtypeINTInteger0
12FRQSUBINT SearchFrequency SubintervalINTInteger0
13FRQRELINT SearchFrequency Relative IntervalINTInteger0
14FRQRCINT SearchFrequency Recurrence IntervalINT2Integer2
15STRTTIME SearchStart TimeTM6Time6
16ENDTIME SearchEnd TimeTM6Time6
17STRTDATE SearchStart DateDTDate8
18ENDDATE SearchEnd DateDTDate8
19CREATDDT SearchCreated DateDTDate8
20CRUSRID SearchCreated User IDSTR15_User_IDString15
21MODIFDT SearchModified DateDTDate8
22MDFUSRID SearchModified User IDSTR15String15
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 RanINTInteger0
26NOTEINDX SearchNote IndexDLR14Currency14
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 SearchScheduleTextSTR255String255
28DEX_ROW_ID Searchintint10

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 *