Type: Custom Data View
Data View: Missing Invoice Work Orders
Customer: Aptora
Public: Yes
Reports Included: No
Description: List of invoices, sales, and credits which have been created and no corresponding work order is attached.
Drill Down: Yes, opens transaction type
Columns and data for the Missing Invoice Work Orders Custom Data View are outlined below:
Column Name | Form | Field | Notes |
Cust:Job Name | Invoice/Sale/Credit | Customer:Job | |
Tran No | Invoice/Sale/Credit | Number | |
Tran Date | Invoice/Sale/Credit | Date | |
Tran Type | Form Type | Invoice/Sale/Credit | |
Tran Total | Invoice/Sale/Credit | Total | |
Tran Department Display | Invoice/Sale/Credit | Associated Department Full Name |
|
Internal Memo | Invoice/Sale/Credit | Internal Memo | |
Tran Department Name | Invoice/Sale/Credit | Department |
|
Tran Department Alias | Invoice/Sale/Credit | Associated Department Alias |
|
Cust:Job Display Name | Invoice/Sale/Credit | Customer:Job |
|
Tran Sales Rep Name | Invoice/Sale/Credit | Associated Transaction Sales Rep Name |
|
Tran Sales Rep Alias | Invoice/Sale/Credit | Associated Transaction Sales Rep Alias |
|
Tran Sales Rep First Name | Invoice/Sale/Credit | Associated Transaction Sales Rep First Name | |
Tran Sales Rep Last Name | Invoice/Sale/Credit | Associated Transaction Sales Rep Last Name | |
Tran Bill To Line 1 | Invoice/Sale/Credit | Bill To Line 1 |
|
Tran Bill To Attn | Invoice/Sale/Credit | Bill To Attn |
|
Tran Bill To Address | Invoice/Sale/Credit | Bill To Address |
|
Tran Bill To Address2 | Invoice/Sale/Credit | Bill To Address2 |
|
Tran Bill To City | Invoice/Sale/Credit | Bill To City |
|
Tran Bill To State | Invoice/Sale/Credit | Bill To State |
|
Tran Bill To Zip | Invoice/Sale/Credit | Bill To Zip |
|
Tran Work Line 1 | Invoice/Sale/Credit | Work Line 1 |
|
Tran Work Attn | Invoice/Sale/Credit | Work Attn |
|
Tran Work Address | Invoice/Sale/Credit | Work Address |
|
Tran Work Address2 | Invoice/Sale/Credit | Work Address2 |
|
Tran Work City | Invoice/Sale/Credit | Work City |
|
Tran Work State | Invoice/Sale/Credit | Work State |
|
Tran Work Zip | Invoice/Sale/Credit | Work Zip |
|
From Mobile? | Invoice/Sale/Credit | Calculated Field | Indication of whether transaction was created from Aptora Mobile II. (Invoices Only) |
Tran User Created | Invoice/Sale/Credit | Transaction Security Label |
|
Tran Date Created | Invoice/Sale/Credit | Transaction Security Label |
|
Tran User Revised | Invoice/Sale/Credit | Transaction Security Label |
|
Tran Date Revised | Invoice/Sale/Credit | Transaction Security Label |
|
TranID | Invoice/Sale/Credit | Table ID of Transaction |
|
CustID | Invoice/Sale/Credit | Table ID of Customer:Job |
|
