SQL ACCESS

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.

SCHEMA

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.

RULESET

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.

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.

DATABASE ADAPTER

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).