vrpt_WorkOrderAllocatedPart

Updated January 27, 2026 13:13

Field Name	Field Description	Data Type	FK Join
Balance	Remaining Balance	int
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Id	Work Order Allocated Part Id	int
InventoryAverageCost	Inventory Average Cost	decimal
InventoryId	Inventory Id	int	vr_PartInventory
InventoryMarkup	Inventory Markup	decimal
InventorySKUCode	Inventory SKU Code	nvarchar
InventoryStandardCost	Inventory Standard Cost	decimal
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerId	Manufacturer Id	int	vr_Vendor
ManufacturerName	Manufacturer Name	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
PartAverageCost	Part Average Cost	decimal
PartCode	Part Code	nvarchar
PartDescription	Part Description	nvarchar
PartId	Part Id	int	vr_Part
PartManufacturerNumber	Part Manufacturer Number	nvarchar
PartMarkup	Part Markup	decimal
PartMFRNumber	Part Manufacturer Number	nvarchar
PartSerialized	Indicates if the part is serialized	bit
PartStandardCost	Part Standard Cost	decimal
Quantity	Quantity	int
SerialId	Serial Id	int
SerialNumber	Serial Number	nvarchar
TaskCode	Task Code	nvarchar
TaskDescription	Task Description	nvarchar
WarehouseCode	Warehouse Code	nvarchar
WarehouseId	Warehouse Id	int	vr_warehouse
WorkOrderTaskId	Work Order Task Id	int	vr_WorkOrderTask
WorkOrderTaskWorkOrderId	Work Order Id	int	vr_WorkOrder