Columns
Each destination table has a list of Pre-defined columns, as well as some automatically referenced tables. This information is generated by Studio to manage the Insight and to provide relationships that the Insight expects. These columns cannot be removed from your project. You can, of course create columns and references as required to support your business scenario.
Tables may be copied to Destinations from Sources using the Copy Sources to Destination functionality. But even if tables are copied from sources, Studio generates default columns. Only columns selected in sources will be copied to destination.
Each column has a technical name and a friendly name. Additionally, the Columns panel also displays the following information:
- Data Types: The following
data types are supported:
- BIGINT: Stores only numeric values
- DATETIME: Stores dates and times
- DECIMAL: Stores decimal values
- NVACHAR: Saves textual information such as descriptions or names. It can store any alphanumeric value limited to 1000 characters.
- Data Length: When you add a new column and select decimal or nvarchar as the data type, it is mandatory to provide the data length. When copying a table from Sources to Destinations, the data length defined in the source table is retained in the destination table but can be edited by the user as required. However, when a new column is added, the data length for the data type decimal is 19,2 by default and for nvarchar it is 1000.
- Advanced View: Selecting Advanced View determines whether or not the column will be shown in a basic view in Infor Risk & Compliance. Basic views include pages like the Data Browser and IntelliLinks display for the selected object.
- View Key: his is the primary object in rule building. View keys will be displayed on level 2 of the Exceptions Browser. The column that is defined as the View key in Destinations is displayed in the Infor Risk & Compliance Data Browser as a hyperlink enabling users to drill down to further details. For example, if the APINVOICE table is selected in Destinations and the column VOUCHER_NBR is marked as a View Key, then when the Insight is published to Infor Risk & Compliance, the column VOUCHER_NBR is displayed as a hyperlink in the Data Browser.
- Ignore in Extract: If Ignore in Extract is set to 'true', the column will not be extracted. The default is 'false'.
- Column Type: If a column is marked standard, the values or data it contains will be displayed exactly as they are in the source ERP system. The data does not undergo any transformation during mapping. If a column is marked lookup, the values in that field will undergo a transformation during the mapping phase. Extracted data will be mapped based on the values and settings defined in the lookup category.
Add column to destination table