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 TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
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 IDINT5Integer24
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_NumberCurrency1019
4APLICFIL SearchApplication FileSTR255String256255
5Status SearchStatusINTInteger20
6DUEDATE SearchDue DateDTDate48
7RECURRINGTASK SearchRecurring TaskCB_RecurringTaskBoolean20
8RECURPATTRN SearchRecurrence PatternGBInteger20
9FREQUENCY SearchFrequencyGBInteger20
10FRQRCINT SearchFrequency Recurrence IntervalINT2Integer22
11DAYSOFTHEWEEK SearchWhich Days of the WeekML_DaysoftheWeekLong Integer40
12MONTHINTERVAL SearchMonth IntervalINT2Integer22
13MTHSLCTD SearchMonth SelectedMonthInteger20
14DAYOFMONTH SearchDay of the MonthINTInteger20
15WHICHWEEKDAY SearchWhich Week DayDDL_WeekDayFrequencyInteger20
16WeekDay SearchWeekDayDDL_WeekDaysInteger20
17STRTDATE SearchStart DateDTDate48
18ENDDATETYPE SearchEnding Date TypeGBInteger20
19TIMETREP SearchTimes To RepeatINT4_U0Integer24
20ENDINGDT SearchEnding DateDTDate48
21Priority SearchPriorityINT5Integer24
22Completion_Date SearchCompletion DateDTDate48
23COMPLETEDBY SearchCompleted bySTR15_User_IDString1615
24CRUSRID SearchCreated User IDSTR15_User_IDString1615
25TASKTYPE SearchTask TypeDDL_TaskTypeInteger20
26LinkTo SearchLinkToDDLInteger20
27CmdID SearchCmdIDINT5_RU0Integer25
28CmdFormID SearchCmdFormIDINT5_RU0Integer25
29CmdDictID SearchCmdDictIDID_INTInteger24
30FilePath SearchFilePathSTR255String256255
31INET1 SearchINet1STR200String202200
32USRDAT01 SearchUser Defined Date 1DTDate48
33USRDAT02 SearchUser Defined Date 2DTDate48
34USRDAT03 SearchUser Defined Date 3DTDate48
35USRTSK01 SearchUser Defined Task 1STR80String8280
36USRTSK02 SearchUser Defined Task 2STR80String8280
37USRTSK03 SearchUser Defined Task 3STR80String8280
38USRTSK04 SearchUser Defined Task 4STR80String8280
39USRTSK05 SearchUser Defined Task 5STR80String8280
40TXTFIELD SearchText FieldTX32000Text232000
41DEX_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.

Leave a Reply

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