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 Group Display Name: User Tasks
Physical Name: SY01403
Technical Name: syUserTasks
Group Technical Name: syUserTasks
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | USERID  | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
| 2 | CMPANYID | Company ID | Integer | INT5 | 4 | |
Key to the Company Master (SY01500).
Click to show/hideSELECT
['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 | ||||||
| 3 | CMRECNUM | Record Number | Currency | DLR_Document_Number | 19 | |
| 4 | APLICFIL | Application File | String | STR255 | 255 | |
| 5 | Status | Status | Integer | INT | 0 | |
| 6 | DUEDATE | Due Date | Date | DT | 8 | |
| 7 | RECURRINGTASK | Recurring Task | Boolean | CB_RecurringTask | 0 | |
| 8 | RECURPATTRN | Recurrence Pattern | Integer | GB | 0 | |
| 9 | FREQUENCY | Frequency | Integer | GB | 0 | |
| 10 | FRQRCINT | Frequency Recurrence Interval | Integer | INT2 | 2 | |
| 11 | DAYSOFTHEWEEK | Which Days of the Week | Long Integer | ML_DaysoftheWeek | 0 | |
| 12 | MONTHINTERVAL | Month Interval | Integer | INT2 | 2 | |
| 13 | MTHSLCTD | Month Selected | Integer | Month | 0 | |
| 14 | DAYOFMONTH | Day of the Month | Integer | INT | 0 | |
| 15 | WHICHWEEKDAY | Which Week Day | Integer | DDL_WeekDayFrequency | 0 | |
| 16 | WeekDay | WeekDay | Integer | DDL_WeekDays | 0 | |
| 17 | STRTDATE | Start Date | Date | DT | 8 | |
| 18 | ENDDATETYPE | Ending Date Type | Integer | GB | 0 | |
| 19 | TIMETREP | Times To Repeat | Integer | INT4_U0 | 4 | |
| 20 | ENDINGDT | Ending Date | Date | DT | 8 | |
| 21 | Priority | Priority | Integer | INT5 | 4 | |
| 22 | Completion_Date | Completion Date | Date | DT | 8 | |
| 23 | COMPLETEDBY | Completed by | String | STR15_User_ID | 15 | |
| 24 | CRUSRID | Created User ID | String | STR15_User_ID | 15 | |
| 25 | TASKTYPE | Task Type | Integer | DDL_TaskType | 0 | |
| 26 | LinkTo | LinkTo | Integer | DDL | 0 | |
| 27 | CmdID | CmdID | Integer | INT5_RU0 | 5 | |
| 28 | CmdFormID | CmdFormID | Integer | INT5_RU0 | 5 | |
| 29 | CmdDictID | CmdDictID | Integer | ID_INT | 4 | |
| 30 | FilePath | FilePath | String | STR255 | 255 | |
| 31 | INET1 | INet1 | String | STR200 | 200 | |
| 32 | USRDAT01 | User Defined Date 1 | Date | DT | 8 | |
| 33 | USRDAT02 | User Defined Date 2 | Date | DT | 8 | |
| 34 | USRDAT03 | User Defined Date 3 | Date | DT | 8 | |
| 35 | USRTSK01 | User Defined Task 1 | String | STR80 | 80 | |
| 36 | USRTSK02 | User Defined Task 2 | String | STR80 | 80 | |
| 37 | USRTSK03 | User Defined Task 3 | String | STR80 | 80 | |
| 38 | USRTSK04 | User Defined Task 4 | String | STR80 | 80 | |
| 39 | USRTSK05 | User Defined Task 5 | String | STR80 | 80 | |
| 40 | TXTFIELD | Text Field | Text | TX32000 | 32000 | |