vrpt_ItemTypeJobLink

Updated December 24, 2025 12:50

Field Name	Field Description	Data Type	FK Join
fj_code	Task Type Code	nvarchar
fj_description	Task Type Description	nvarchar
fj_parent_fk	Task Type Parent Id	int	vr_TaskType
fj_pk	Task Type Id	int	vr_TaskType
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
fo_pk	Task Id	int	vrpt_task
Id	Item Type Job Link Id	int
itemCode	Item Code	nvarchar
itemDescription	Item Description	nvarchar
itemType_Name	Item Type Name	nvarchar
itfo_createdDate	Record Creation Date	datetime
itfo_creator_fk	User Id (Record Creator)	int	vr_users
itfo_fj_fk	Task Type Id	int	vr_TaskType
itfo_fo_fk	Task Id	int	vrpt_task
itfo_item_fk	Item Id	int
itfo_itemType_fk	Item Type Id	int
itfo_modifiedDate	Last Modified Date	datetime
itfo_modifier_fk	User Id (Record Modifier)	int	vr_users
itfo_pk	Item Type Job Link Id	int
TaskOptionCode	Task Option Code	nvarchar
TaskOptionDesc	Task Option Description	nvarchar