vrpt_TicketWorkOrder

Updated January 20, 2026 15:50

Field Name	Field Description	Data Type	FK Join
bldgDepartment	Building Department	nvarchar
creatorName	Creator Name	nvarchar
departmentCode	Department Code	nvarchar
departmentName	Department Name	nvarchar
fb_address1	Building Address 1	nvarchar
fb_address2	Building Address 2	nvarchar
fb_buildingNumber	Building Number	nvarchar
fb_city	Building City	nvarchar
fb_code	Building Code	nvarchar
fb_country	Building Country	nvarchar
fb_name	Building Name	nvarchar
fb_stateCode	Building State Code	nvarchar
fb_zip	Building Zip	nvarchar
fd_code	Facility Code	nvarchar
fd_name	Facility Name	nvarchar
ff_code	Floor Code	nvarchar
ff_description	Floor Description	nvarchar
fu_description	Area Description	nvarchar
fu_roomNumber	Area Room Number	nvarchar
fu_unitid	Area Location Id	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
hardwareSoftware	Displays Hardware or Software	nvarchar
hardwareSoftwareType	Displays Hardware Type or Software Type	varchar
Id	Work Order Id	int	vr_WorkOrder
itemSublocation	Item Sublocation	nvarchar
itemSubtypeDescription	Item Sub Type Description	nvarchar
itemTypeDescription	Item Type Description	nvarchar
itemTypePk	Item Type Id	int
mfg_name	Manufacturer Name	nvarchar
ModelNumber	Model Number	nvarchar
modifierName	Modifier Name	nvarchar
pos_description	Position Description	nvarchar
pri_description	Priority Description	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
requestorDepartment	Requestor's Department	nvarchar
riskFactor	Risk Factor	int
rq_address1	Requestor Address 1	nvarchar
rq_address2	Requestor Address 2	nvarchar
rq_city	Requestor City	nvarchar
rq_country	Requestor Country	varchar
rq_NAME	Requestor Name	nvarchar
rq_organization	Requestor Organization	nvarchar
rq_state	Requestor State	nvarchar
rq_title	Requestor Title	nvarchar
rq_zip	Requestor Zip	nvarchar
SerialNumber	Serial Number	nvarchar
StatusDescription	Status Description	nvarchar
StatusNote	Status Note	nvarchar
tagDescription	Tag Description	nvarchar
tagNumber	Tag Number	nvarchar
wc_description	Work Order Type Description	nvarchar
wo_actionRequested	Action Requested	nvarchar
wo_completionDate	Completion (Closed) Date	datetime
wo_createdDate	Record Creation Date	datetime
wo_curr_fk	Currency Id	int	vrpt_Currency
wo_exch_date	Currency Exchange Date	datetime
wo_exch_fk	Currency Exchange Id	int
wo_isTemplate	Is Template	bit
wo_lapseTime	Lapse Time	nvarchar
wo_modifiedDate	Last Modified Date	datetime
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder
wo_printDate	Last Print Date	datetime
wo_requestDate	Request Date	datetime
wo_requestor	Requestor	nvarchar
wo_requestorEmail	Requestor Email	nvarchar
wo_requestorPhone	Requestor Phone #	nvarchar
wo_rootcauseWONumber	Root Cause Work Order Number	nvarchar
wo_slpostDate	Sub Ledger Post Date	datetime
wo_techComments	Tech Comments	nvarchar
wo_templateName	Template Name	nvarchar
woLocationCode	Location Code	nvarchar
woLocationName	Location Name	nvarchar
woLocationTypePK	Location Type Id	int

Articles in this section