vrpt_WorkOrderCostBreakDown

Updated April 06, 2026 15:36

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
BudgetCode	Budget Code	nvarchar
Chargeable	Indicates if the Cost Line is Chargeable or Not	bit
costlinepk	Cost Line Id	int
Description	Technician Name	nvarchar
Id	Work Order Labor Id	int	vr_WorkOrderLabor
Position	Position Description	nvarchar
PostDate	Post Date	datetime
quantity	Quantity	decimal
SLPostDate	Sub Ledger Post Date	datetime
SubTypeCode	Time SubType Code	nvarchar
SubTypeDesc	Time SubType Description	nvarchar
TestEquipCode	Static Field (Always NULL)	nvarchar
TestEquipDesc	Static Field (Always NULL)	nvarchar
TotalExtCost	Total Extended Cost	decimal
TotalExtRetail	Total Extended Retail Cost	decimal
TransDate	Transaction Date	datetime
TransType	Transaction Type (Labor, Part, Other, Contractor)	varchar
TypeCode	Time Type Code	nvarchar
TypeDesc	Time Type Description	nvarchar
UnitCost	Technician Charge Rate	decimal
wotask_fk	Work Order Task Id	int	vr_WorkOrderTask