Mapping Inputs to Outputs

Click Next on the Select Outputs form to access the Mapping form.

  1. Select the event on which mapping will occur.

    In most cases, you use either the Row Fetched event or Format Fetched event. Use the Format Fetched event if you are working with a user-defined format.

  2. Click Advanced ER to include additional event rule logic in the table conversion.

    The Event Rules Design form appears for the event that you selected on the Mapping form.

  3. Click Map Same to allow the system to map the inputs directly to the outputs.

    If the input and outputs share some of the same data, these fields are a direct map. For JD Edwards EnterpriseOne tables, the system maps fields by data dictionary item. For foreign tables, the system maps by column name.

  4. Drag inputs to outputs to manually map the inputs to the outputs.

    Note: Click Delete to erase the mapping for a selected output. Click Delete All to erase the mapping for all outputs.
  5. If multiple output files exist, select each file from the outputs list, and map the appropriate input columns to the appropriate output columns.

  6. To define advanced output, double-click an output column.

    The Advanced Outputs form enables you to define literals, calculations, and other mappings without using Advanced ER. You can use an advanced input to add a literal value into a field. You can also define a calculation to populate an output field, such as adding two input fields together.

  7. On the Advanced Outputs form, select one of these tabs, and add the appropriate input:

    • Available objects

      Select the appropriate object, and click Apply.

    • Literal

      Enter the appropriate value, and click Apply.

    • Defaults

      Select Use Dictionary Defaults, and click Apply.

      Select this option to use the default value in the data dictionary at runtime. If no default values exist in the data dictionary, the system displays a warning message.

    • Calculation

      Click Define Calculation, create a calculation in Expression Manager, and click Apply.

  8. Click Close on the Advanced Outputs form.

  9. On the Mapping form, select Issue a Write for this Event? to insert a row to the selected output after performing all column mappings for this event.

    When you select Issue a Write for this Event?, the system attaches the TC Insert Row event system function. This system function is automatically inserted at the end of the event rules. You cannot move it to another area. To specify when and where a row is inserted, attach the User Insert Row system function using Advanced ER, and move it to wherever it is needed.

  10. Click Next.