| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| dp_code | Department Code | nvarchar | |
| dp_name | Department Name | nvarchar | |
| fb_code | Building Code | nvarchar | |
| fb_name | Building Name | nvarchar | |
| fd_code | Facility Code | nvarchar | |
| fd_name | Facility Name | nvarchar | |
| fo_averagetime | Task Average Time | decimal | |
| fo_code | Task Code | nvarchar | |
| fo_description | Task Description | nvarchar | |
| fo_estimatedcost | Task Estimated Cost | decimal | |
| fu_description | Area Description | nvarchar | |
| fu_roomNumber | Area Room Number | nvarchar | |
| fu_unitID | Area Location Id | nvarchar | |
| Id | Work Order Id | int | vr_WorkOrder |
| itemType_name | Item Type Name | nvarchar | |
| itemtype_pk | Item Type Id | int | vr_WebTMAItemTypes |
| rc_code | Repair Center Code | nvarchar | |
| rc_name | Repair Center Name | nvarchar | |
| tagDescription | Tag Description | nvarchar | |
| tagNumber | Tag Number | nvarchar | |
| TaskHours | Total Labor Hours | decimal | |
| TaskLabor | Total Labor Cost | decimal | |
| TaskLaborRetail | Total Labor Retail Cost | decimal | |
| TaskOther | Total Other Cost | decimal | |
| TaskOtherRetail | Total Other Retail Cost | decimal | |
| TaskParts | Total Parts Cost | decimal | |
| TaskPartsRetail | Total Parts Retail Cost | decimal | |
| ven_isContractor | Is Contractor | bit | |
| ven_name | Vendor Name | nvarchar | |
| wc_code | Work Order Type Code | nvarchar | |
| wc_description | Work Order Type Description | nvarchar | |
| wc_designated | Work Order Designation | smallint | |
| wo_actionRequested | Action Requested | nvarchar | |
| wo_completionDate | Completion (Closed) Date | datetime | |
| wo_fb_fk | Building Id | int | vr_building |
| wo_fd_fk | Facility Id | int | vr_Facility |
| wo_number | Work Order Number | nvarchar | |
| wo_pk | Work Order Id | int | vr_WorkOrder |
| wo_rc_fk | Repair Center Id | int | vr_RepairCenter |
| wo_requestDate | Request Date | datetime | |
| woTask_pk | Work Order Task Id | int | vr_WorkOrderTask |
| woTask_ven_fk | Vendor Id | int | vr_Vendor |
| woTask_wo_fk | Work Order Id | int | vr_WorkOrder |