Table: Definition tab

About the Definition tab

Defining the Table structure

Defining table entries

How to add and modify Table data

Organizing complementary information

Defining and modifying column properties

About the Definition tab

The Definition tab provides a means of visualising the Table structure and contents.

For details about how to use this tab, refer to the following sections in this topic:

The Table definition icon bar comprises a set of buttons which you use for manipulating the:

Defining the Table structure (columns)

Use the following command icons to define table structure prior to creating the table entries. Unless otherwise indicated, these actions are only available if the Table object is modifiable (that is, when the Table status is other than Released): [FOR DETAILS: life cycle and statuses]

 

Click To

Add a new column - Composer displays the Column Properties window where you define the properties of a column. When you complete and save the definition, Composer adds the column to the Table.

[FOR DETAILS: How to define and modify column properties]

The column added is:

  • by default an argument if the preceding column is part of the argument, or if there is no preceding column.  
  • a value in all other cases.

Display or edit column properties of an existing column.

Composer displays the Column Properties window for the selected Table column. (Note: The display function is available regardless of the status of the Table object.)

[FOR DETAILS: How to define and modify column properties]

Remove a column

Select one or more columns to delete.

Warning: AccountingIntegrator Enabler performs the deletion immediately. It does not present any confirmation message or possibility to cancel.

Note: You cannot delete an argument or value column if it is the last of its type, because  a Table must contain at least one argument and value.

Toggle key column

Use this icon to change all selected argument columns into value columns and vice versa.

Select one or more adjacent columns of the same type (argument or value).

Note: The first column of the argument and the last column of the value must not be included in the selection.

Split column

This command works on argument or value columns which are not of date type.

Select one column only.

Composer opens a dialog with two structure fields: one for the original column, the other for the new fields being created. Use this to define the field length properties of the resulting columns.

The system automatically attributes half the original field length to each of the new columns. You can modify the given lengths by adjusting the field lengths manually, on condition that they add up to the original field length in the unsplit column.  

After validation, the data is separated between the two new columns as per the field lengths indicated.

Merge columns

Select at least two adjacent columns of the same type (argument or value). Use Ctrl-click to select each column.

The resulting field has the following characteristics:

  • Data type remains the same if the original columns have identical data types. It becomes alphanumeric if columns are of different data types, are of date type or if the sum of the columns lengths is greater that the column type limits.
  • Field length is the sum of the lengths of the original columns (within the 256 character limit).
  • Data from the original columns  is concatenated to fit into a single one.

Toggle default value

This action enables you to enable/disable the default values for the columns of the table.

Sort by column

The sort is only a help to the edition. The button is only enabled when the selected columns that contain information have an alphanumeric name. The lines in the table are sorted alphabetically using the values in the selected column as criteria.The sort is not multi-criteria: you can select only one columnat a time. When you save the table, the sort criteria and the sorted table are not saved.

Search

You can only search alphanumeric columns. this action enables you to find a value from the current position in the specified column in the table. You can set the search as case sensitive or search whole words.

Adapt values

This button is enabled only when you select alphanumeric columns.

It adjusts the length of the values in each row to the length defined in the column properties.

Defining table entries

Use the following icons described in this section to define the table entries. No two main entries can have identical arguments. Each version of an entry is indicated as such and is therefore not considered a main entry.

Difference between main and version Table entries

Using the example of bank interest rates, consider the Table below with the following parameters:

  • argument = interest code
  • value = bank interest rate

The main table entries are as follows:

Interest code Interest rate Start validity date End validity date

TBB

34

01/01/1999

12/31/2003

T4M

53

01/01/1999

12/31/2003

TMI

26

01/01/1999

12/31/2003

As interest rates depend on external financial factors, changes imposed by financial regulators or institutions will necessitate changes to this interest rate table. For example, a decision on 09/16/2003 by the European Central Bank to raise interest rates could mean that the TBB interest rate changes from 09/18/2003 and the T4M interest rate from 10/12/2003.

In this case, you create new versions of the TBB and T4M Table entries. You cannot modify the current table entry since it is still valid and required. You therefore need a version of this original Table entry which will be valid from 09/18/2003 (for TBB) so that the new interest rate will be taken into account in the transformation process. This gives the modified Table below, with new versions of the Table entries as well as the changes to the original main entry validity dates shown in bold:

Interest code Interest rate Start validity date End validity date

TBB

2.2.1

01/01/1999

09/17/2003

TBB

3.6

09/18/2003

12/31/2003

T4M

5.3

01/01/1999

09/09/2003

T4M

5.35

09/10/2003

12/31/2003

TMI

2.6

01/01/1999

12/31/2003

Use the following icons to define Table entries. Unless otherwise indicated, these actions are only available if the Table object is modifiable:

Icon Function

Add a new table main entry

To insert an entry at a particular position, click the entry above where you want to add the new one. Then click this icon.

If you click anywhere on the Table and then click this icon, the system adds an entry at the beginning of the Table.

Remove table main entry / entry version

Select any entry other than the default line.

The deletion removes the selected versions from the Table definitively.

If an entry version is deleted, the validity dates of the other versions are amended.

Add table entry version

Select the entry that you want the new entry to follow. Since versions cannot overlap, you must change the default End date before creating a new version.

The system assigns the Start date of the new version as the End date of the previous entry release plus 1 day.

The default End date is 12/31/2099.

If you change these suggested dates, Composer automatically amends the validity dates of successive releases.

Insert table entry version

Select the entry that you want the new entry to precede.

The system assigns the current date as the end date and recalculates the start validity date of the following version so that no dates overlap.

The suggested Start date is the end date of the previous entry release plus 1 day, provided that a previous release exists.

The suggested End date is the start date of the next entry release minus 1 day.

If you change these suggested dates, Composer automatically amends the validity dates of successive releases.

Import table entries from a file

This option launches the Import table entries wizard to help you import a large number of entries.

How to add and modify Table data

To add data to a Table cell:

  1. On the icon bar, click . Composer adds a line at the bottom of the Table.
  2. Click a cell in the added line. Composer selects the cell that you clicked.
  3. Enter data in the selected cell. The data that you enter is a constant that must not conflict with the Data Class that you assigned to the Table column. [FOR DETAILS: Constants]

To modify:

  • some of the data in a Table cell, double click the cell that contains the data you want to modify. Composer places the cursor at the end of the cell data. You can now modify the data.

Using the Import table entries wizard

Click to open the Import table entries wizard to import a set of entry values from a file (for example .txt or .csv) with the following structure:

key_1 <sep> key_2<sep> val_1 <sep> val_2 <sep> [ <sep> label ] [ <sep> end_date ]

Where:

  • key_x represents each key column in the Table.
  • val_x represents each value column in the Table.
  • <sep> represents the field separator.
  • label and end_date are optional elements.

If the Label check-box is selected, a label with a lenght of one or more characters must exist before the end_date definition.

To import the file, use follow these steps:

  1. Select the file
  2. Identify the specific file entries to use
  3. Validate the selected entries

Step 1 - Selecting a file

 

Field Contents

File

(Mandatory)

The file must be prepared in advance, before the entries are added.

The file must be encoded in UTF-8.

Enter file name or click Browse to open up the search window to locate the required file.

Click Open to read the selected .txt file into the application.

After you complete the entry, click Next to proceed to Step 2.

Content

Use the following fields to specify the structure of the Table entries in the specified file.

Label

Select the check box to indicate that the file contains labels.

Validity date

Select the check box to activate the Validity date format drop-down list from which you select the date format used in the data file.

Field separator

(Mandatory)

Specify the field separator used in the file.

The default field separator is the semicolon (;).

 

Step 2 - Selecting file entries to use in the Table

Caution: If you import different versions of a Table entry, the system inserts the imported entry after the first Table entry that has an earlier end date, modifying the start dates to match this change. Whenever an imported entry has the same key and end date as a Table entry, it will overwrite the value of the Table entry.

The list of Table entries read in the file is then displayed in the Found entries column. Use the following buttons to select the portion of this list and import the Table entry values:

  • Add all - selects all of the list
  • Add - selects only part of the list

The entries you select are moved to the Entries to import list in the right pane.

Step 3 - Validating the selected entries

A summary screen indicates the number of Table entries you selected. Click End to add the entries to the Table.

Moving, copying and replicating Table data

You can perform the following actions:

You can copy data from Excel spreadsheets and paste them directly into Composer. The system checks that data types of copied cells are compatible with those in the paste zone.

Moving and copying the contents of a cell

You can only copy cells containing editable text. Since the Fast Access column is a check box, you cannot copy it.

  1. Select the cell to copy.
  2. Right-click and select or from the contextual menu.
  3. Select the cell where you want to paste the data.
  4. Right-click and select from the contextual menu.
    The system retrieves the cell contents from the Clipboard and pastes it on to the new cell selected.

Moving and copying an entire Table entry

  1. Select the cell(s) or line(s) to copy.
  2. Right-click and select from the contextual menu
    In the Clipboard, Composer creates a character string concatenating all the cells, separating values of the cells with tabs and the lines with carriage returns.
  1. Select the new cell or line where you want to paste the copied values.
  2. Right click and select from the contextual menu.
    The system retrieves the concatenated string in step 2 from the Clipboard and pastes it into the selected cells. Composer does not create any new cells.

Moving and copying a column

You can only select the column copy and paste function if you select the column header.

  1. Select the column(s) to copy.
  2. Right-click and select from the contextual menu
    On the Clipboard, Composer creates concatenates all the cells in the selected range, using \t to separate columns and \n to separate lines.
  1. Select the new column(s) to paste the copied range to.
  2. Right-click and select from the contextual menu.
    The system retrieves the concatenated string in step 2 from the Clipboard and pastes it on to the new columns selected, starting with the first cell in the first column.

Replicating and copying a set of adjacent cells (a sub-table)

Replicating

Replicating involves copying the same cell into a given range of cells, starting with the first cell in the first column selected.

Use the following procedure to replicate or copy the contents of a given cell:

  1. Select the cells to copy
  2. Right-click and select from the contextual menu.
  3. Select the range of cells where want to paste the contents.
  4. Right-click and select Replicate from the contextual menu. This replicates the contents of the first cell in the range selected in step 1 across all the cells in the paste zone.

Organizing complementary information

Use the following icons to work with the information columns:

Icon Function

Hide or display information columns

This toggles the display of the columns prefixed with : Start date, End date and Fast access.

This command is available regardless of the status of the Table object.

Select or unselect all fast lookup fields.

This toggles the check box in the Fast access column.

This command is only available if the information columns are displayed. The system inverts the selected or unselected status of the first entry (after the default) and applies it to all the other entries.

Defining and modifying column properties

Use the Column Properties window to define, modify, and view column properties.

Respect the naming conventions when completing the following fields.

To define the column you must complete either the Field or Name field, but not both. If you select Field, the Name option is automatically grayed-out and if you select Name you cannot access the Field option.

Field Contents

Field

The Field drop-down list displays all available Business-Fields.

Select a Business-Field, Composer automatically assigns the corresponding information on data type in the Class field and length in the Definition field. They become non-modifiable.

Name

To identify this column by Name, enter a free-text name here. To complete the definition of this column you must complete the Class and Definition fields.

Label

Enter an optional free-text description of this column. This text only appears on this tab.

Class

From the drop-down list, select a data type compatible with the defined Field.

When you change the data type, a dialog appears asking whether you want to keep or delete the existing entries that use the original data type.

Definition

Set the maximum field size corresponding to the Data Class you selected in the Class field. Either type in a value or use the increment arrows.

Back to top

Related Links