| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| contractorCost | Contractor Cost | decimal | |
| cst_codeCharge | Charge Account Code | nvarchar | |
| cst_codeCredit | Credit Account Code | nvarchar | |
| cst_nameCharge | Charge Account Name | nvarchar | |
| cst_nameCredit | Credit Account Name | nvarchar | |
| fb_name | Building Name | nvarchar | |
| FD_NAME | Facility Name | nvarchar | |
| fj_code | Task Type Code | nvarchar | |
| fo_code | Task Code | nvarchar | |
| fo_description | Task Description | nvarchar | |
| fu_roomNumber | Area Room Number | nvarchar | |
| Id | Work Order Id | int | vr_WorkOrder |
| laborCost | Labor Cost | decimal | |
| linepk | Line Id | int | |
| otherCost | Total Other Cost | decimal | |
| partCost | Part Cost | decimal | |
| transDate | Transaction Date | datetime | |
| wc_code | Work Order Type Code | nvarchar | |
| wcs_code | Work Order SubType Code | nvarchar | |
| wo_actionRequested | Action Requested | nvarchar | |
| WO_NUMBER | Work Order Number | nvarchar | |
| WO_PK | Work Order Id | int | vr_WorkOrder |