| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| fo_code | Task Code | nvarchar | |
| fo_description | Task Description | nvarchar | |
| fo_pk | Task Id | int | vrpt_task |
| ItemTypeId | Item Type Id | int | |
| rts_otherpercentage | Rate Schedule Other Charge Percentage | decimal | |
| rts_partpercentage | Rate Schedule Part Charge Percentage | decimal | |
| rts_pk | Rate Schedule Id | int | vr_rateSchedule |
| tagDescription | Tag Description | nvarchar | |
| tagNumber | Tag Number | nvarchar | |
| wo_actionRequested | Action Requested | nvarchar | |
| wo_charge | Indicates Whether the Work Order is Chargeable or Not | bit | |
| wo_completionDate | Completion (Closed) Date | datetime | |
| wo_number | Work Order Number | nvarchar | |
| wo_pk | Work Order Id | int | vr_WorkOrder |
| wo_rc_fk | Repair Center Id | int | vr_RepairCenter |
| wo_ReferenceNumber | Reference Number | nvarchar | |
| wo_requestDate | Request Date | datetime | |
| wo_requestor | Requestor | nvarchar | |
| wo_tax_fk | Tax Rate Id | int | vr_TaxRate |
| wo_taxCompound | Indicates if the record utilizes tax compound | bit | |
| wo_taxRate | Tax Rate | decimal | |
| wo_taxrate2 | Tax Rate 2 | decimal | |
| wocstCode | Work Order Account Code | nvarchar | |
| woTask_clnt_fk | Obsolete Column (No Longer Used) | int | |
| woTask_completionDate | Completion Date (Closed Date) | datetime | |
| woTask_con_fk | Contract Id | int | vr_contract |
| woTask_DueDate | Task Due Date | datetime | |
| woTask_est_endtime | Estimated End Time | datetime | |
| woTask_est_starttime | Estimated Start Time | datetime | |
| woTask_EstimateTime | Estimated Time | decimal | |
| woTask_fa_fk | Failure Code Id | int | vr_failureCode |
| woTask_failedPM | Indicates if the PM Failed | bit | |
| woTask_finishDate | Finish Date | datetime | |
| woTask_fo_fk | Task Id | int | vrpt_task |
| wotask_foadd_fk | Task Additional Info Id | int | |
| woTask_notLocated | Not Located | bit | |
| woTask_pk | Work Order Task Id | int | vr_WorkOrderTask |
| woTask_pm_fk | PM Schedule Id | int | vr_PMSchedule |
| woTask_postDate | Post Date | datetime | |
| woTask_rts_fk | Rate Schedule Id | int | vr_rateSchedule |
| woTask_SLPostDate | Sub Ledger Post Date | datetime | |
| woTask_ss_fk | Status Id | int | vr_Status |
| woTask_status | Task Status | nvarchar | |
| woTask_ven_fk | Vendor Id | int | vr_Vendor |
| woTask_wo_fk | Work Order Id | int | vr_WorkOrder |
| woTask_workNotDone | Work Not Done | bit |