To view the field and table name for any field within the software:
- On the page with the field for which you want to view the field name or table name, click Edit Layout in the lower right corner. The Edit Layout window opens.
- Hover over the field name you want to change.
- Click Edit. The Field Settings window opens.
- The Name field displays the database field name and the Name - Tables field displays the database table name.
- Click OK.
Comments
3 comments
What would the table name be of Opportunity Types - Supplier?
0 upvotes
Hello Gavin,
All opportunities data is stored in the CR073_Issues table. Supplier opportunities are identified as opportunities where the Class value is designated as Supplier Issue (that is, CR073_ISSUE_CLASS ="S").
For reference, here is the list of values for issue class. It can be helpful when viewing raw opportunities data.
Regards,
Sam
1 upvotes
Perfect, thank you Sam
0 upvotes
Please sign in to leave a comment.