Defining Data Copy with Table Input Actions

Access the JD Edwards EnterpriseOne Table Conversion Director.

  1. Select Data Copy with Table Input, and click Next.

  2. On the External Data form, select a processing option template, define a data structure, as appropriate, and click Next.

  3. On the Select Environments form, select an input environment and an output environment, and click Next.

  4. On the Select Input form, select a table, business view, or foreign table, and click Next.

  5. On the Sequencing form, define data sequencing as appropriate, and click Next.

  6. On the Data Selection form, define data selection as appropriate, and click Next.

  7. On the Table Options form, select Run Currency Triggers, if appropriate, and click Next.

    Select this option if a JD Edwards EnterpriseOne table included in the table conversion contains currency triggers. If a table contains currency fields and you do not select this option, the system cannot determine where the decimal should be placed within a field. If you do not select the currency trigger option and the source or destination fields are currency fields used in a calculation, you might receive unexpected results.

    Do not select Run Currency Triggers if the input and output data sources are the same type (for example, Oracle, IBM i, or SQL Server) and no calculations are being performed. Selecting this option results in slower processing.

    You should not use currency triggers for an environment that has a different path code than the login environment.

  8. On the Select Actions form, enter the name of a table in the Table field, modify the remaining fields as appropriate, and click Next.

  9. To import an existing copy table script from another location, click Import, locate the file that you want to import, and click Open.

  10. Click Advanced ER to add event rule logic to the copy table process, and click Next.

  11. On the Logging Options form, select logging options, and click Next.

  12. On the Finish form, select a version option, and click Finish.