1. Administrator's Guide
  2. Integrating Data
  3. Loading Data
  4. Defining Data Load Rules to Extract Data
  5. Defining Data Load Rule Details
  6. Defining Source Filter Options for JD Edwards GL Source Systems

Defining Source Filter Options for JD Edwards GL Source Systems

When defining data load mapping details, define the data to extract, including whether to extract the company code, ledger type, amount type.

To define the source filter options for a JD Edwards GL source system:

  1. On the Workflow tab, under Data Load, select Data Load Rule.
  2. In Data Load Rule, select a data load rule or click Add.
  3. Select the Source Options tab.
  4. Select the Amount Type.

    Select PTD for Period to Date, or YTD for Year to Date balances.

  5. Select the Company Code.

    Specify the company code in four characters or less using alphanumeric characters.

  6. Select the Ledger.

    Specify the ledger in two characters or less using alphanumeric characters from the JD Edwards source system. For example, ledger types include:

    • AA–Actual

    • BA–Budget

    • CA–Original Currency Transaction

  7. Click Save.