SY01403 - User Tasks

Dynamics GP table SY01403 (User Tasks) contains 40 columns including USERID, CMPANYID, CMRECNUM....

SQL Query Builder

SELECT * FROM SY01403

Select all

Column	Description	Type	Length	Shared With
USERID	User ID	String	16	80 tables
CMPANYID	Company ID	Integer	2	27 tables
CMRECNUM	Record Number	Currency	10	9 tables
APLICFIL	Application File	String	256	-
Status	Status	Integer	2	6 tables
DUEDATE	Due Date	Date	4	40 tables
RECURRINGTASK	Recurring Task	Boolean	2	-
RECURPATTRN	Recurrence Pattern	Integer	2	-
FREQUENCY	Frequency	Integer	2	-
FRQRCINT	Frequency Recurrence Interval	Integer	2	-
DAYSOFTHEWEEK	Which Days of the Week	Long Integer	4	1 tables
MONTHINTERVAL	Month Interval	Integer	2	-
MTHSLCTD	Month Selected	Integer	2	-
DAYOFMONTH	Day of the Month	Integer	2	-
WHICHWEEKDAY	Which Week Day	Integer	2	-
WeekDay	WeekDay	Integer	2	-
STRTDATE	Start Date	Date	4	15 tables
ENDDATETYPE	Ending Date Type	Integer	2	-
TIMETREP	Times To Repeat	Integer	2	4 tables
ENDINGDT	Ending Date	Date	4	7 tables
Priority	Priority	Integer	2	-
Completion_Date	Completion Date	Date	4	2 tables
COMPLETEDBY	Completed by	String	16	-
CRUSRID	Created User ID	String	16	10 tables
TASKTYPE	Task Type	Integer	2	-
LinkTo	LinkTo	Integer	2	-
CmdID	CmdID	Integer	2	-
CmdFormID	CmdFormID	Integer	2	-
CmdDictID	CmdDictID	Integer	2	-
FilePath	FilePath	String	256	-
INET1	INet1	String	202	2 tables
USRDAT01	User Defined Date 1	Date	4	2 tables
USRDAT02	User Defined Date 2	Date	4	-
USRDAT03	User Defined Date 3	Date	4	-
USRTSK01	User Defined Task 1	String	82	-
USRTSK02	User Defined Task 2	String	82	-
USRTSK03	User Defined Task 3	String	82	-
USRTSK04	User Defined Task 4	String	82	-
USRTSK05	User Defined Task 5	String	82	-
TXTFIELD	Text Field	Text	2	2 tables