E1 Database Integration Tips 2
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.
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 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.
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).
By: Sean Hoppe on