| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| Id | Legacy Work Order Id | int | |
| ItemDescription | Legacy Work Order Item Description | nvarchar | |
| ItemTag | Legacy Work Order Item Tag | nvarchar | |
| wol_actionRequested | Legacy Work Order Action Requested | nvarchar | |
| wol_closedDate | Legacy Work Order Closed Date | datetime | |
| wol_failureCode | Legacy Work Order Failure Code | nvarchar | |
| wol_item_fk | Legacy Work Order Item Id | int | |
| wol_itemType_fk | Legacy Work Order Item Type Id | int | vr_WebTMAItemTypes |
| wol_itemTypeName | Legacy Work Order Item Type | varchar | |
| wol_location | Legacy Work Order Location | nvarchar | |
| wol_number | Legacy Work Order Number | nvarchar | |
| wol_pk | Legacy Work Order Id | int | |
| wol_requestDate | Legacy Work Order Request Date | datetime | |
| wol_requestor | Legacy Work Order Requestor | nvarchar | |
| wol_riskLevel | Legacy Work Order Risk Level | nvarchar | |
| wol_taskDescription | Legacy Task Description | nvarchar | |
| wol_techComments | Legacy Work Order Technician Comments | nvarchar | |
| wol_totalCost | Legacy Work Order Total Cost | decimal | |
| wol_totalHours | Legacy Work Order Total Hours | decimal | |
| wol_type | Legacy Work Order Type | nvarchar |