1. Accounting Foundation Cloud Service Core Functions
  2. Managing Data
  3. Data Egress
  4. Mapping

12.3.11 Mapping

This section provides information about the Mapping component.
  1. Drag and drop the Mapping component on the canvas to define a mapping. Connect the inputs and outputs for the Mapping component before specifying the mapping details.
  2. To position the component on the canvas, drag and move the component, or click the component and use arrow keys on the keyboard to move it around.
  3. Double-click the Mapping component on the canvas. The EDDs, ADIs, and their respective data/derived data elements are displayed in the Mapping window.
  4. Filter the source attributes by selecting an option from the drop-down list. Click a data element under Source.
  5. Filter the target attributes by selecting an option from the drop-down list. Click a data element under Target. and then click the Map button. The column mappings are displayed.
  6. Click the Map button. The mapped items are displayed on the right. column mappings are displayed.
  7. Repeat the steps to map as many source-target pairs as required. Note that you can use the filter icons for the Source and Target lists to filter unmapped, mandatory, or those items that are valid for the application.
  8. The following validations are performed for the mapping:
    1. Data type validation
    2. Data length validation
    3. Data precision validation
  9. The result of the validation for each mapping is indicated as Remarks next to each mapping.
  10. At any given time, you can select the Unmap button to unmap the source and target.
  11. Click Auto Map to auto map a source and target.

    Note:

    Auto-mapping is done by matching the logical/physical column name of both the source and target.
  12. Hover your mouse over a data element under Target column to see detailed information which includes the description, length, and scale.
  13. Use the search icons to search for source or target data elements.
  14. Click the Delete All icon to delete all the mappings. You can also delete individual mappings by selecting the cross symbol next to the column mapping.
  15. Click the Import Mapping icon to import a mapping Excel sheet.
  16. Click the Export Mapping icon to export the mapping information in an Excel format.
  17. Use the search field to search for mappings. You can search for an item based on the Source Column Name, Target Column Name, Source Entity, Target Entity, or Remarks.