Creating Event Rules in Table Conversions

Access a table conversion form that includes an Advanced ER button.

  1. From the Events drop-down list, select the event to which you want to attach event rules, and click Advanced ER.

  2. On the Event Rules Design form, select any of these options to define specific business logic:

    • Assignment

      Select this option to assign a fixed value, a field, or a mathematical expression to a field or variable.

    • If\While

      Select this option to create If and While logic statements, which are conditional instructions for event rule logic.

    • Business Function

      Select this option to attach an existing JD Edwards EnterpriseOne business function to an event. Business functions can retrieve a next number value for a new customer or convert Julian calendar dates to month, day, and year.

    • System Function

      Select this option to attach an existing JD Edwards EnterpriseOne system function, such as Copy Table Environment or User Insert Row.

    • Variables

      Select this option to create event rule variables, using existing data items, to store values for additional processing. Event rule variables can be used to accumulate totals, record the number of records that are read, and so on.

    • Else

      Select this option to create Else logic statements. An Else statement is automatically inserted after an If statement.

    • Table I/O

      Select this option to open tables in the input, output, or sign-in environment. Table I/O enables you to read data from tables other than the input table and use the data to create an output record. For example, suppose that you create a table conversion that loops through records in the F0101 table. The table conversion copies the records to another table, loops back through the records to find each customer that has a specific employee as a contact, and copies the information to the output table.

    • Report Interconnect

      Select this option to connect a batch process or report to the table conversion.

  3. Define the logic, save the event rules, and quit Event Rules Design.