Creating SCV datasheets

To create a SCV datasheet:

  1. Select Configuration > SCV > Datasheets.
  2. Click New.
  3. Specify this information:
    Name
    The unique name of the datasheet to be displayed in the application.
    Display Name
    The name of the datasheet to be displayed in the application. This is an optional field.
    Users
    The users authorized to access the datasheet.
    Roles
    The roles authorized to access the datasheet.
    Category
    The category in which you want to group the datasheet. You can create a new category or select from the categories already defined.
    Note: The category name is displayed in the SCV sub-menu.
    System
    The roles authorized to access the datasheet:
    • System generated record, if checked.
    • User-defined data, if unchecked.
  4. Select the Enabled option, to view the datasheet in the SCV menu.
  5. Select a Source to configure the data to be displayed on the SCV datasheet. The possible types:
    • Table: If you select this option, a list of all available tables within the internal SCV database is displayed. Select the required table from the list.
    • Query: If you select this option, specify the SQL query (SELECT item from TABLE_1). The query is used to retrieve the required data from the SCV database.
      Note: You must click Verify and Apply to validate the specified query. If the query cannot be resolved, a warning message is displayed. If the Table or Query is modified, you must click the Verify and Apply to ensure that:
      • The columns that are currently not applicable are removed from the ‘Available Columns’ and ‘Column to Display’ list.
      • The columns previously selected, that are still valid are not removed from the ‘Column to Display’ section.
  6. Check the Column to display check boxes in the Available and Columns section to specify the data to be displayed in the datasheet. You can also specify the Display Name for the Columns that are displayed.
  7. Click Save.

    You can create a duplicate of the existing datasheet and modify the parameters as required. To do so, select the required datasheet and click Duplicate.