vrpt_MyTaskToDoList

Updated January 05, 2026 17:28

Field Name	Field Description	Data Type	FK Join
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	To Do Id	int
itemType_name	Item Type Name	nvarchar
StatusDescription	Status Description	nvarchar
StatusNote	Status Note	nvarchar
tagNumber	Tag Number	nvarchar
TD_ACTIVE	Indicates if the Record is Active or Not	bit
TD_BillingInfo	Billing Info	nvarchar
TD_CloseDate	Close Date	datetime
TD_COMMENT	Comment	nvarchar
td_createddate	Record Creation Date	datetime
td_creator_fk	User Id (Record Creator)	int	vr_users
TD_DueDate	Due Date	datetime
TD_EMAIL	Email	nvarchar
td_item_fk	Item Id	int
td_itemType_fk	Item Type Id	int
TD_MILEAGE	Mileage	decimal
td_modifieddate	Last Modified Date	datetime
td_modifier_fk	User Id (Record Modifier)	int	vr_users
TD_OWNER	Owner	nvarchar
TD_PercentageComplete	Percentage Complete	decimal
td_pk	To Do Id	int
TD_PRIORITY	Prioirity	nvarchar
TD_PRIVATE	Indicates if the Record is Private	bit
TD_SS_FK	Status Id	int	vr_Status
TD_StartDate	Start Date	datetime
TD_TITLE	Title	nvarchar
TD_TotalWork	Total Work	decimal
TD_User_FK	User Id	int	vr_users
user_login_ID	User Login Id	nvarchar
userName	User Name	nvarchar