EBIThree.com > JDE @ EBIThree.com > E1 Application Integration Tips 2

E1 Database Integration Tips 2


Cleo/EXTOL Business Integrator (EBI) 3 SQL Access icon

In SQL Actions, the E1 Database Schema/Environment name needs to be present and in double quotes. The table name would follow and also would have the needed double quotes.

Cleo/EXTOL Business Integrator (EBI) 3 JDE SQL Access


Cleo/EXTOL Business Integrator (EBI) 3 Schema icon

JDE uses the Data Dictionary(F9210) to store decimal positions and initially the decimal positions are not stored in Cleo Clarify. When a Clarify Schema is refreshed the numeric fields need to be updated to be implied decimal and the number of decimals inserted.

Cleo EXTOL Business Integrator (EBI) 3 Database Schema Decimal Type


Cleo EXTOL Business Integrator (EBI) 3 Ruleset icon
Ruleset Item 1:

When outbound documents use the middle tree updating, it is important to use the rule: “Move” and not any other rule, ie: Move-Trim Left/Right. If a trim rule is applied when EXTOL tries to apply the Database Update Adapter, the correct record(s) will not be found. This is due to spaces being concatenated.

Ruleset Item 2:

If a JDE numeric field is set-up in the Cleo Clarify Schema with a decimal position, then each time users move data to the numeric field, the “Move Numeric” rule should be used. This is application to inbound transactions.


Cleo EXTOL Business Integrator (EBI) 3 Database Adapter icon

When setting up the data selection in a Data Binding, we are basing our criteria on data JDE fields. For example in the outbound 855 we are selecting data on F47026.EDSP and F47026.EDST.

  • For F47046.EDSP we select records where the value is a ’ ’ (single space).
  • For F47046.EDST we select records where the value is ‘810 ’ (810 and 3 spaces).

Cleo EXTOL Business Integrator (EBI) 3 Database Adapter Selection Criteria

By: on