Screenshot:Dataset

Dataset

Sets of data.

Sets of data

Module : Module
Search Key : A fast method for finding a particular record.
Name : A non-unique identifier for a record/document often used as a search tool.
Description : A space to write additional related information.
Data Access Level : Indicates what type of data (in terms of AD_CLIENT and AD_ORG data columns) can be entered or viewed.
Export allowed : This data set can be exported
Export Reference Data
Sequence Number : The order of records in a specified document.
Default Values Data Set : Import data as default values, subsequent updates will not modify imported data.
Active : A flag indicating whether this record is available for use or de-activated.
Organization : Organizational entity within client
Dataset : Dataset
Client : Client for this installation.

Tables of a dataset.

Table : A dictionary table used for this tab that points to the database table.
Active : A flag indicating whether this record is available for use or de-activated.
Module : Module
HQL/SQL Where clause : The Where Clause indicates the HQL/SQL WHERE clause used for filtering data
Secondary SQL Where Clause : This is a secondary SQL where clause used by dbsourcemanager to filter data inside a table.
Include All Columns : Include all columns from the table in the dataset
Exclude Audit Info : Mark if the dataset table should exclude the audit info when comparing data
IsBusinessObject : Include Business Object
Organization : Organizational entity within client
Dataset Table : Dataset Table
Dataset : Dataset
Client : Client for this installation.

Columns of a Table of a dataset.

Column : A link to the database column of the table.
Active : A flag indicating whether this record is available for use or de-activated.
Module : Module
Excluded : Mark a column excluded from a dataset
Organization : Organizational entity within client
Dataset Table : Dataset Table
Dataset Column : Dataset Column
Client : Client for this installation.