SY01403 - User Tasks | Prospr - Dynamics GP Table Reference

SY01403 - User Tasks

Select * from SY01403

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