User Tasks (SY01403)

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

Product: Microsoft Dynamics GP (0)
Series: System

Display Name: User Tasks
Physical Name: SY01403
Technical Name: syUserTasks

Group Display Name: User Tasks
Group Technical Name: syUserTasks

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['User Tasks'].USERID AS 'User Tasks-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SY01403 AS ['User Tasks']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['User Tasks'].USERID = ['Users Master'].USERID
2CMPANYID SearchCompany IDINT5Integer4
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['User Tasks'].CMPANYID AS 'User Tasks-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       SY01403 AS ['User Tasks']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['User Tasks'].CMPANYID = ['Company Master'].CMPANYID
3CMRECNUM SearchRecord NumberDLR_Document_NumberCurrency19
4APLICFIL SearchApplication FileSTR255String255
5Status SearchStatusINTInteger0
6DUEDATE SearchDue DateDTDate8
7RECURRINGTASK SearchRecurring TaskCB_RecurringTaskBoolean0
8RECURPATTRN SearchRecurrence PatternGBInteger0
9FREQUENCY SearchFrequencyGBInteger0
10FRQRCINT SearchFrequency Recurrence IntervalINT2Integer2
11DAYSOFTHEWEEK SearchWhich Days of the WeekML_DaysoftheWeekLong Integer0
12MONTHINTERVAL SearchMonth IntervalINT2Integer2
13MTHSLCTD SearchMonth SelectedMonthInteger0
14DAYOFMONTH SearchDay of the MonthINTInteger0
15WHICHWEEKDAY SearchWhich Week DayDDL_WeekDayFrequencyInteger0
16WeekDay SearchWeekDayDDL_WeekDaysInteger0
17STRTDATE SearchStart DateDTDate8
18ENDDATETYPE SearchEnding Date TypeGBInteger0
19TIMETREP SearchTimes To RepeatINT4_U0Integer4
20ENDINGDT SearchEnding DateDTDate8
21Priority SearchPriorityINT5Integer4
22Completion_Date SearchCompletion DateDTDate8
23COMPLETEDBY SearchCompleted bySTR15_User_IDString15
24CRUSRID SearchCreated User IDSTR15_User_IDString15
25TASKTYPE SearchTask TypeDDL_TaskTypeInteger0
26LinkTo SearchLinkToDDLInteger0
27CmdID SearchCmdIDINT5_RU0Integer5
28CmdFormID SearchCmdFormIDINT5_RU0Integer5
29CmdDictID SearchCmdDictIDID_INTInteger4
30FilePath SearchFilePathSTR255String255
31INET1 SearchINet1STR200String200
32USRDAT01 SearchUser Defined Date 1DTDate8
33USRDAT02 SearchUser Defined Date 2DTDate8
34USRDAT03 SearchUser Defined Date 3DTDate8
35USRTSK01 SearchUser Defined Task 1STR80String80
36USRTSK02 SearchUser Defined Task 2STR80String80
37USRTSK03 SearchUser Defined Task 3STR80String80
38USRTSK04 SearchUser Defined Task 4STR80String80
39USRTSK05 SearchUser Defined Task 5STR80String80
40TXTFIELD SearchText FieldTX32000Text32000
41DEX_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.

Leave a Reply

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