vrpt_PartsUsedOnEquipWO

Updated January 12, 2026 17:05

Field Name	Field Description	Data Type	FK Join
f_pk	Work Order Part Id	int	vr_workorderPart
f_quantity	Part cost line quantity	decimal
f_totalcost	Part cost line total cost	decimal
f_unitCost	Part cost line unit cost	decimal
fc_code	Equipment Type Code	nvarchar
fc_description	Equipment Type Description	nvarchar
fj_description	Task Type Description	nvarchar
fm_description	Equipment Description	nvarchar
fm_tagNumber	Equipment Tag Number	nvarchar
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
id	Work Order Id	int	vr_WorkOrder
inv_record_code	Part Inventory Record Code	nvarchar
pa_description	Part Description	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
rc_pk	Repair Center Id	int	vr_RepairCenter
WH_PK	Warehouse Id	int	vr_warehouse
wo_completionDate	Completion (Closed) Date	datetime
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_requestDate	Request Date	datetime
woTask_completionDate	Completion Date (Closed Date)	datetime