| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| fo_code | Task Code | nvarchar | |
| fo_description | Task Description | nvarchar | |
| fu_description | Area Description | nvarchar | |
| fu_unitID | Area Location Id | nvarchar | |
| fwor_wk_fk | Labor Technician Id | int | vrpt_Technician |
| Hours | Hours | decimal | |
| Id | Work Order Id | int | vr_WorkOrder |
| LaborCost | Labor Cost | decimal | |
| othercost | Total Other Cost | numeric | |
| partcost | Part Cost | numeric | |
| tagDescription | Tag Description | nvarchar | |
| tagNumber | Tag Number | nvarchar | |
| wk_firstName | Technician First Name | nvarchar | |
| wk_id | Technician Record Id | nvarchar | |
| wk_lastName | Technician Last Name | nvarchar | |
| WK_NAME | Technician Name | nvarchar | |
| wo_completionDate | Completion (Closed) Date | datetime | |
| wo_fu_fk | Area Record Id | int | vr_area |
| wo_itemType_fk | Item Type Id | int | |
| wo_number | Work Order Number | nvarchar | |
| wo_requestDate | Request Date | datetime | |
| woTask_fo_fk | Task Id | int | vrpt_task |
| woTask_wo_fk | Work Order Id | int | vr_WorkOrder |