Table: start here

What is a Table

Where is a Table

How you define a Table

How you use a Table

What is a Table?

The Table object is an integrated table that you use to represent your company-specific reference table. Use Tables to manage table referencing and enable faster access from the Transformation or Enrichment-Rules via pre-defined DML Table functions. Use Table entries to check and enrich the data in an Input or Output-Business-Document during transformation. The physical properties of each Table entry are based on Business-Fields.

Composition of a Table

Each Table includes a:

  • Table entry (a line of data) that comprises the following column types, each identified by a unique name:
    • Table key (also referred to as the argument) column preceded by
    • The values that are contained in Key columns uniquely identify lines of data in a Table. Table Functions only identify and return data from the lines which contain the values you indicate must be present in the Key columns. Each Table must contain at least one Key column.
    • When you create a Table, it contains one Key column. If you define several Key columns, AccountingIntegrator Enabler concatenates the values of these columns to form a single Table Key.
    • The Table Key and validity period together enable you to access the usable data in the Table, that is the contents of the Value columns.
    • Table value
    • Value columns contain data that you do not want to use as Table keys but that you want to use to enrich or to validate Business Document data.
    • By default, when you create a Table it has one Value column that can contain up to 256 characters. You can separate this column into several Value columns to suit your requirements.
    • Label preceded by
    • Start Date and End Date preceded by
    • These columns define the validity period for the lines of data in a Table.
    • Fast access also preceded by
    • This option allows AccountingIntegrator EnablerRule Engine faster access to the Table entries, which is useful for Tables frequently used in the transformation process.
  • Default value line that contains non-modifiable grayed-out argument and information columns. These defaults represent values returned by the Table access functions when the specified key is not found. This default value is not mandatory. Therefore you need only enter values here if you want the Table access functions to always return some information.
  • Modifiable line for each Table entry.

Accessing Table contents

Although Table keys and values can be split over several columns and presented in a multi-columned format, Composer uses Table Functions to access each line in the Table as a single merged argument and a single merged value. The argument is the concatenation of all the arguments in the given line and similarly, the value is the concatenation of all the Value columns in that line.

By contrast, you can only access external reference tables using external calls or exits. [FOR DETAILS: Oracle database access functions]

Accessing the data in Tables

To specify the Table data that you want to use to enrich or to validate a Business-Document, you must use a Table Function. Table Functions have parameters that you define to identify Table data. Each parameter corresponds to one type of Table column.

To extract data, you can use the following Table Functions:

  • $ACCTAB: returns the value of a Table entry corresponding to a given argument and validity period
  • $ACCTABD: returns the value of a Table entry corresponding to a given argument and date
  • $EXTTAB: returns a part of the value of a Table entry corresponding to a given argument and validity period
  • $EXTTABD: returns a part of the value of a Table entry corresponding to a given argument and date

To validate data, you can use the following Table Functions:

  • $CHECKTAB: checks that the given argument is present in the Table as a table key and is valid within the validity period
  • $CHECKTABD: checks that the given argument is present in the Table as a table key and that the given date is included in the validity period of the Table

Tables that you create in other software

In a transformation session, you can use tables that you create in:

  • Composer: These are referred to throughout this documentation as Tables (or Table objects)In this case, you define the properties that describe the structure of the Table and the Table data. You can also use the Import entries wizard to import Table entries into AccountingIntegrator Enabler.
  • Oracle databases: In this case, you use external calls and exits to access the table entries.

Where is a Table?

Axway module

AccountingIntegrator Enabler

Workbench

Integration-Services: Finance tab

Object dependencies

When you define or import an object, it is stored in the metadata repository and is available for reuse by other objects. Typically, the objects that you define exist in a specific object hierarchy. That is, objects:

  • use objects below them in the hierarchy
  • are used by objects above them in the hierarchy

To help you manage the interlinked network of objects, the software provides the Object Dependencies Browser that displays the object dependencies for a selected object.

The following table lists the objects that use and are used by Tables.

How you define a Table

Before you define a Table

Before you create a Table, you must create the Business-Fields to use in the Table definition.

Defining a Table

Create the Table object from the Dictionary tab.

To define a new Table object, complete the following tabs:

In addition, the Table properties window contains the following tabs:

  • Signature tab
  • Description tab

After you define a Table

After you define a Table, you can:

How you use a Table

You can perform all basic operations on Table objects, depending on your user rights. [FOR DETAILS: "Working with objects" in the Composer User Guide.]

The Table object does not follow the standard object life cycle in the following respects:

  • You cannot explicitly send this object to Production.
  • You can use the UpdateServer command to modify Table entries of an existing Table already in Production.

Back to top

Related Links