vrpt_WorkOrderPart

Updated January 27, 2026 16:15

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
ArchiveOnHandAdjustmentId	Archive On Hand Adjustment Id	int
BatchJobId	Batch Job Id	int	vr_BatchJob
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
ExtendedCost	Extended Cost	decimal
ExtendedRetail	Extended Retail	decimal
FailedPM	Indicates if the PM Failed	bit
Id	Work Order Part Id	int
InventoryId	Part Inventory Id	int	vrpt_PartInventoryList
InventorySKUCode	Part Code + Warehouse Code	nvarchar
LeaseBatchJobId	Lease Batch Job Id	int
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerName	Manufacturer Name	nvarchar
MinimumQuantity	Minimum Quantity	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Nocharge	No Charge	bit
NotLocated	Not Located	bit
OnHandAdjustmentId	On Hand Adjustment Id	int	vr_OnHandAdjustment
OriginalWOPartId	Original Work Order Part Id	int
PartCode	Part Code	nvarchar
PartComment	Work Order Part Comment	nvarchar
PartDescription	Part Description	nvarchar
PartId	Part Id	int	vr_Part
PartManufacturerNumber	Part Manufacturer Number	nvarchar
PartPercentage	Part Percentage	decimal
PartSerialized	Indicates if the Part is Serialized or Not	bit
PartUnitOfMeasure	Part Unit of Measure	nvarchar
PostDate	Post Date	datetime
Quantity	Quantity On Hand	decimal
ResolutionId	Resolution Id	int	vr_Resolution
SerialId	Serialized Part Id	int
SerialNumber	Part Serialized Number	nvarchar
SLPostDate	Sub Ledger Post Date	datetime
TaskCode	Task Code	nvarchar
TaskCompletionDate	Task Completion Date	datetime
TaskDescription	Task Description	nvarchar
TaskFinishDate	Task Finish date	datetime
TaskId	Task Id	int	vrpt_task
Taxable	Indicates if this Work Order Part is taxable	bit
TaxAmount	Tax Amount	decimal
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
TransDate	Transaction Date	datetime
UnitCost	Unit Cost	decimal
WarehouseCode	Warehouse Code	nvarchar
WarehouseId	Warehouse Id	int	vr_warehouse
WarehouseName	Warehouse Name	nvarchar
WholeSaleCost	Wholesale Cost	decimal
WorkNotDone	Work Not Done	bit
WorkOrderId	Work Order Id	int	vr_WorkOrder
WorkOrderNumber	Work Order Number	nvarchar
WorkOrderTaskId	Work Order Task Id	int	vr_WorkOrderTask

Articles in this section