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 IDStringSTR15_User_ID15
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 IDIntegerINT54
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 NumberCurrencyDLR_Document_Number19
4APLICFIL SearchApplication FileStringSTR255255
5Status SearchStatusIntegerINT0
6DUEDATE SearchDue DateDateDT8
7RECURRINGTASK SearchRecurring TaskBooleanCB_RecurringTask0
8RECURPATTRN SearchRecurrence PatternIntegerGB0
9FREQUENCY SearchFrequencyIntegerGB0
10FRQRCINT SearchFrequency Recurrence IntervalIntegerINT22
11DAYSOFTHEWEEK SearchWhich Days of the WeekLong IntegerML_DaysoftheWeek0
12MONTHINTERVAL SearchMonth IntervalIntegerINT22
13MTHSLCTD SearchMonth SelectedIntegerMonth0
14DAYOFMONTH SearchDay of the MonthIntegerINT0
15WHICHWEEKDAY SearchWhich Week DayIntegerDDL_WeekDayFrequency0
16WeekDay SearchWeekDayIntegerDDL_WeekDays0
17STRTDATE SearchStart DateDateDT8
18ENDDATETYPE SearchEnding Date TypeIntegerGB0
19TIMETREP SearchTimes To RepeatIntegerINT4_U04
20ENDINGDT SearchEnding DateDateDT8
21Priority SearchPriorityIntegerINT54
22Completion_Date SearchCompletion DateDateDT8
23COMPLETEDBY SearchCompleted byStringSTR15_User_ID15
24CRUSRID SearchCreated User IDStringSTR15_User_ID15
25TASKTYPE SearchTask TypeIntegerDDL_TaskType0
26LinkTo SearchLinkToIntegerDDL0
27CmdID SearchCmdIDIntegerINT5_RU05
28CmdFormID SearchCmdFormIDIntegerINT5_RU05
29CmdDictID SearchCmdDictIDIntegerID_INT4
30FilePath SearchFilePathStringSTR255255
31INET1 SearchINet1StringSTR200200
32USRDAT01 SearchUser Defined Date 1DateDT8
33USRDAT02 SearchUser Defined Date 2DateDT8
34USRDAT03 SearchUser Defined Date 3DateDT8
35USRTSK01 SearchUser Defined Task 1StringSTR8080
36USRTSK02 SearchUser Defined Task 2StringSTR8080
37USRTSK03 SearchUser Defined Task 3StringSTR8080
38USRTSK04 SearchUser Defined Task 4StringSTR8080
39USRTSK05 SearchUser Defined Task 5StringSTR8080
40TXTFIELD SearchText FieldTextTX3200032000

Leave a Reply

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