vrpt_ServiceBillingWorkOrder

Updated January 19, 2026 17:26

Field Name	Field Description	Data Type	FK Join
CC#	Department Phone Fax Number	nvarchar
CompletionDate	Completion (Closed) Date	datetime
DeptAccountCode	Department Account Code	nvarchar
DeptAccountName	Department Account Name	nvarchar
DeptAddress1	Department Address 1	nvarchar
DeptAddress2	Department Address 2	nvarchar
DeptCity	Department City	nvarchar
DeptCode	Department Code	nvarchar
DeptContact	Department Contact	nvarchar
DeptEmail	Department Email	nvarchar
DeptName	Department Name	nvarchar
DeptPhone	Department Phone	nvarchar
DeptState	Department State	nvarchar
DeptZip	Department Zip	nvarchar
Id	Work Order Id	int	vr_WorkOrder
Priority	Priority	nvarchar
PriorityCode	Priority Code	nvarchar
RCCode	Repair Center Code	nvarchar
RCName	Repair Center Name	nvarchar
ReferenceNo	Reference Number	nvarchar
RequestDate	Request Date	datetime
Requested	Requested	nvarchar
Requestor	Requestor	nvarchar
RequestorPhone	Requestor Phone	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
WOAccount	Work Order Account	nvarchar
WOAccountName	Work Order Account Name	nvarchar
WOnumber	Work Order Number	nvarchar
WOSupervisor	Work Order Supervisor	nvarchar
WOType	Work Order Type	nvarchar
WOTypeCode	Work Order Type Code	nvarchar