In Infor CRM, views of tables owned by sysdba may be visible in the database. In this context, a view is a virtual table. It can contain columns from one or many tables. Views can be used to improve speed and performance by limiting the number of columns that need to be returned, or views may be used for security purposes by limiting the availability of some columns.
|
|
All views ending with an underscore ( _ ) are auto-generated by the Infor CRM OLE DB Provider on an as-needed basis. Each table may have a corresponding view (also designated with an underscore). These views are for internal use only and are subject to change in each release. |
The database includes the following views:
| View | Purpose |
|---|---|
|
SYSDBA.ACTIVITYRESOURCEVIEW |
Used by the Activity Editor when looking up a resource to add. Combines the user and activity resource information into a single view. |
|
SYSDBA.CampaignTargetsView |
Combines the CONTACT and LEAD tables to form a view of campaign targets and their responses. Used for the campaign targets tab view on the campaign entity. |
|
SYSDBA.CONTACTSYNCVIEW |
Used by the accounting integration sync engine to determine what information to send. Combines the vector clock change information in the CONTACT table with the tombstone (delete) information for contacts in the SLXCONTRACTSYNCLOG table into a single view of all changes for the contacts resource. |
| SYSDBA.GroupStatsView | Group statistics are stored in the new GROUPSTATS table which is updated using the TrackGroupUsage method in GroupBuilder. The method is called from the Groups SystemAdapter endpoint when a group response is sent back to the client. The GroupStatsView displays Group statistics, but is not yet exposed in the product. |
|
SYSDBA.DepartmentView |
The SECCODE table contains teams, departments, system users, and users. This view exposes owners of type = D which are departments. |
|
SYSDBA.ORMCOLUMN |
Provides a database platform independent view of all column schema. |
|
SYSDBA.ORMKEYCOLUMN |
Provides a database platform independent view of all primary keys. |
|
SYSDBA.ORMTABLE |
Provides a database platform independent view of all tables. |
|
SYSDBA.OwnerView |
Exposes all owners in the SECCODE table that are appropriate for look up and assignment: excludes the default department of None and user types of P=Template, W=Admin, and R=Retired. |
|
SYSDBA.PACKAGEKITCHILDVIEW |
View to combine the child Products of both Packages and Kits when there is a Package/Product and Kit/Product hierarchy. |
| SYSDBA.PickList_ActiveLanguageView |
Added in 8.3.0.08 A list of unique language codes currently being used in the PICKLIST table. This information can be viewed in the Picklist Manager as a filter option for the items’ grid. |
| SYSDBA.PickList_FlatView |
Added in 8.3.0.08 Provides a different presentation of the PICKLIST table that matches the header record with the item record so that items can easily be referenced by the picklist name. |
| SYSDBA.PickList_LanguageView |
Added in 8.3.0.08 Handles the language fallback hierarchy used to determine the best language to display to a user when using a localized picklist. |
|
SYSDBA.PickListItemView |
The PICKLIST table is decomposed into a list of pick lists (PickListView) and a separate view of the pick list items by picklist ID (PickListItemView). 8.3.0.08 - Added the language code of the picklist item. |
|
SYSDBA.PickListView |
The PICKLIST table is decomposed into a list of pick lists (PickListView) and a separate view of the pick list items by picklist ID (PickListItemView). 8.3.0.08 - Added the default language code of the picklist’s header and the default code value. |
|
SYSDBA.PRODPACKAGEKITVIEW |
View to combine all top level Packages, Products, and Kits when there is a Package/Product and Kit/Product hierarchy. |
|
SYSDBA.SALESORDERSYNCVIEW |
Used by the accounting integration sync engine to determine what information to send. Applies to sales orders that have IsQuote = false. Combines the vector clock change information in the SALESORDER table with the tombstone (delete) information for sales orders in the SLXCONTRACTSYNCLOG table into a single view of all changes for the salesorders resource. |
|
SYSDBA.SALESQUOTATIONSYNCVIEW |
Used by the accounting integration sync engine to determine what information to send. Applies to sales orders that have IsQuote = true. Combines the vector clock change information in the SALESORDER table with the tombstone (delete) information for sales orders in the SLXCONTRACTSYNCLOG table into a single view of all changes for the salesorders resource. |
|
SYSDBA.SLX_PLUGINNOBLOB |
Used to manage plugins. Queries the Plugin Table and returns all rows except the Blob field. This improves database performance and overall scalability. |
|
SYSDBA.SLX_RELEASEDPLUGINS |
Used by Architect to manage plugin releases. Created to bypass security releases so that plugins can be managed by a non-Administrative user. |
|
SYSDBA.TeamView |
The SECCODE table contains teams, departments, system users, and users. This view exposes owners of type = G which are teams. |
