SCV Data Viewer
Use this page to view or modify data stored in the SCV database. The SCV Data Viewer screen consists of these panels:
- Data Sources (Left panel): These data sources are displayed:
- Data sheets: The enabled datasheets are displayed.
- Tables: The registered tables in the SCV registry and extension tables in the SCV database are displayed.
- Views: The database views in the SCV database are displayed.
- Data (Right panel): Displays data related to the source selected on the Data Sources panel.
You can select a data source in the Data Sources panel, to view the related information in the Data panel and use these icons to perform specific actions:
- : Modify data in SCV. This option is displayed, only if you have the Edit/Import permission, and the data source table must be User or Core extension type.
- : Import data to the SCV Data Viewer screen from the SCV menu. This option is displayed, only if you have the Edit/Import permission, and the source table is User, Inbox, or Core-table extension type.
- : Export data from the SCV Data Viewer screen.
- : Validate data in the source table. This option is displayed only if you have the Edit/Import permission, and the source table is User or Inbox.
If the table is extension table, all PK columns are in read-only mode and cannot be modified. If the table is inbox or user table, all PK columns are editable and must be specified.
This table lists the formatting of numerical, date, and date-time data across different user locale settings in the Data panel:
| Data type | Database value | German locale | UK locale | US locale |
|---|---|---|---|---|
| Numerical | 1234.56789123 | 1.234,56789123 | 1,234.56789123 | 1,234.56789123 |
| Date | 2024-04-10 | 10.04.2024 | 10/04/2024 | 04/10/2024 |
| Date and Time | 2024-04-10 15:59:21.73338383 | 10.04.2024 15:59 | 10/04/2024 15:59 | 04/10/2024 15:59 |