1. Accounting Foundation Cloud Service Core Functions
  2. Managing Data
  3. Data Egress
  4. Connectors
  5. Icons and Description

12.3.1.1 Icons and Description

This section describes the tools AFCS provides to create connectors.

Table 12-5 Icons and Description

Icon Description

This image displays the Source icon.

 Click the Source button to view the list of all External Data Descriptors created in the setup. Use the External Data Store field to filter and the search icon to quickly locate the EDD you are looking for. After locating the EDD, you can drag the desired EDD on to the canvas.

This image displays the Target icon.

 Click the Target button to view the list of all Application Data Interfaces (ADIs). Use the Applications field to filter and the search icon to quickly locate the ADI you are looking for.

This image displays the Mapping Window icon.

 The Mapping component is used to map the source columns to target columns.

This image displays the Entity icon.

 The Join component is used to define a join between two entities. Double click this icon and provide the join condition information.

This image displays the Filter icon.

 The Filter component is used for define the filter of a given entity. Double click this icon and provide the filter expression information.

This image displays the Lookup icon.

 The Lookup component is used to define the lookup condition. Double click this icon and provide the lookup information.

This image displays the Derived Column icon.

 The Expression component is used to define defining the derived columns. Double click this icon to define an expression, which can be mapped to the target column.

This image displays the Hierarchy icon.

 The Flattened Table To Hierarchy component is used to transform flattened hierarchy entities into parent-child hierarchy entities.

This image displays the Rows to Column icon.

 The Transpose (Row to Column) component is used to transpose rows to columns for a given entity. Double click this icon to define the pivot data element and the new columns, which are transposed from multiple rows of the source entity.

This image displays the Column to Row icon.

 The Transpose (Column to row) component is used to transpose columns to rows for a given entity. Double click this icon to define the unpivot data element and new rows which are transposed from the columns of the source entity.

This image displays the Aggregation icon.

 The Aggregation component is used to define a group by and having a clause for aggregation. Double click this icon to define a group by and having a clause for aggregation.

This image displays the Delete icon.

 Click this button to remove all the nodes added to the canvas.