Name in AssignmentPro: Vendor Integration Orders (View)
Name in Database: vwEQ_VENDOR_INTEGRATION_ORDER_JB
Description inc. recommended uses and limitations: This view shows the most recent note/communication for a specific order.
Tables used in the view:
ASSIGNMENT
CLASSIFICATION
NOTE_COMM_SERVICE_ORDER
NOTE_COMMUNICATION
SERVICE_ORDER
USER
VENDOR
VENDOR_INTEGRATION_BATCH
Fields contained in the view:
Assignment ID
Service order details
Service Order ID
Service Order Create Date
Service Order Status
Service Order Type
Status Reason
Note/Communication
Note ID
Note Order Type
Sent By
Body Note
Vendor
Vendor ID
Vendor Integration Batch Create Date
Vendor Integration Batch Status
Vendor Name
Click here for details on how to create a user report to return all fields for a given name in the database.