Activity Tracking Setup (SY04300)

azurecurveProductsMicrosoft Dynamics GP (0)SystemActivity Tracking Setup (SY04300)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: Activity Tracking Setup
Physical Name: SY04300
Technical Name: SY_Security_Log_SETP

Group Display Name: Activity Tracking Setup
Group Technical Name: Activity Tracking Setup

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1TRKLGOUT SearchTrack LogoutsCBBoolean20
2TRKROUT SearchTrack RoutinesCBBoolean20
3TRKPSTLOG_1 SearchTrack Posting Log[1]ML_Track_PostingLong Integer40
4TRKPSTLOG_2 SearchTrack Posting Log[2]ML_Track_PostingLong Integer40
5TRKPSTLOG_3 SearchTrack Posting Log[3]ML_Track_PostingLong Integer40
6TRKPSTLOG_4 SearchTrack Posting Log[4]ML_Track_PostingLong Integer40
7TRKPSTLOG_5 SearchTrack Posting Log[5]ML_Track_PostingLong Integer40
8TRKPSTLOG_6 SearchTrack Posting Log[6]ML_Track_PostingLong Integer40
9TRKDAFLS SearchTrack Denied Access To FilesCBBoolean20
10TRKDAFRM SearchTrack Denied Access To FormsCBBoolean20
11TRKDARPTS SearchTrack Denied Access To ReportsCBBoolean20
12TRKFLOG SearchTrack Failed LoginCBBoolean20
13TRKFADDS SearchTrack Master File AddsCBBoolean20
14TRKFDEL SearchTrack Master File DeletesCBBoolean20
15TRKMODAC SearchTrack Modifier AccessCBBoolean20
16TRKRWACS SearchTrack Report Writer AccessCBBoolean20
17TRKSETAD SearchTrack Setup File AddsCBBoolean20
18TRKSETDL SearchTrack Setup File DeletesCBBoolean20
19TRKSETMD SearchTrack Setup File ModificationsCBBoolean20
20TRKTRXAD SearchTrack Transaction File AddsCBBoolean20
21TRKTRXDL SearchTrack Transaction File DeletesCBBoolean20
22TRKTRXMD SearchTrack Transaction File ModificationsCBBoolean20
23TRKFLMOD SearchTrack Master File ModificationsCBBoolean20
24TRMFMANT SearchTrack File MaintenanceCBBoolean20
25TRKATFRMS SearchTrack Successful Access To FormsCBBoolean20
26TRKAREPT SearchTrack Successful Access To ReportsCBBoolean20
27TrackSuccessfulSPAccess SearchTrack Successful Access To Service ProceduresCBBoolean20
28TrackDeniedSPAccess SearchTrack Denied Access To Service ProceduresCBBoolean20
29TRKSLOG SearchTrack Successful LoginCBBoolean20
30TRKUTLS SearchTrack UtilitiesCBBoolean20
31DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)SystemActivity Tracking Setup (SY04300)

Leave a Reply

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