Name in AssignmentPro: Assignment Contact 1-10 (View)
Name in Database: vwEQ_ASSIGNMENT_CONTACT
Description inc. recommended uses and limitations: Returns the first 10 entries from the Assignment Contact screen records in one row
Tables used in the view:
ASSIGNMENT_CONTACT
ASSIGNMENT_CONTACT_CF
CLASSIFICATION
COUNTRY
STATE_PROVINCE
Fields contained in the view:
Assignment Contact Details
Name
Type
Contact ID
Assignment Address
Address Lines 1-3
City
Country
Postal Code
State
Email
Fax
Mobile
Phone
After Hours Phone
Click here for details on how to create a user report to return all fields for a given name in the database.