Type: Custom Data View
Data View: Missing Work Orders Invoiced
Customer: Aptora
Public: Yes
Reports Included: No
Description: List of work orders which have been completed and no corresponding invoice/sale is attached.
Drill Down: Yes, opens work order.
Columns and data for the Missing Work Orders Invoiced Custom Data View are outlined below:
Column Name | Form | Field | Notes |
Technician Assigned | Work Order : General Tab | Assigned To | |
Employee Alias | Work Order : General Tab | Assigned To | |
Customer Name | Work Order | Customer:Job | |
Customer Display Name | Work Order | Customer:Job | |
WO Date | Work Order : General Tab | Date | |
WO Number | Work Order | Work Order # | |
WO SA Item | Work Order : Additional Info Tab | Associated Service Agreement | |
WO SA Description | Work Order : Additional Info Tab | Associated Service Agreement Description | |
WO SA Number | Work Order : Additional Info Tab | Associated Service Agreement Number | |
WO SA Term Begins | Work Order : Additional Info Tab | Associated Service Agreement Term Begins | |
WO SA Term Ends | Work Order : Additional Info Tab | Associated Service Agreement Term Ends | |
Is Planned Maintenance? | Work Order : Additional Info Tab | Planned Maint. | |
SA Discount Applied? | Work Order : Items Tab | ******** | Indicates whether a line item for a service agreement discount has been added |
WO Start Time | Work Order : General Tab | Start Time | |
WO Status | Work Order | Status | |
WO Type | Work Order : General Tab | Work Order Type | |
WO Department | Work Order : Additional Info Tab | Department | |
WO Full Department | Work Order : Additional Info Tab | Associated Department Full Name | |
WO Dept Alias | Work Order : Additional Info Tab | Associated Department Alias | |
WO Stage | Work Order : General Tab | Associated Stage | |
WO Brief Description | Work Order : General Tab | Brief Description | |
WO Detailed Description | Work Order : General Tab | Detailed Description | |
WO Private Notes | Work Order : Notes Tab | Private Notes | |
WO Technician Notes | Work Order : Notes Tab | Technician’s Notes | |
WO User Created | Work Order | WO Security Label | |
WO Date Created | Work Order | WO Security Label | |
WO User Revised | Work Order | WO Security Label | |
WO Date Revised | Work Order | WO Security Label | |
WorkOrderID | Work Order | Table ID of Work Order | |
EmployeeID | Work Order | Table ID of Assigned To Employee | |
CustJobsID | Work Order | Table ID of Customer:Job | |
DeptID | Work Order | Table ID of Department |