SeanHoppe.com Cleo Best Practices SQL Select of EXDGDPP for Numeric Field Decimal Values
Querying EXDGDPP for Numeric Field Decimal Values
When performing a Physical/Logical Table refresh in Cleo (EXTOL) EDI Integrator, end-users will want to take into account manually entered
In our example below we performed the SQL query over EXDGDPP to determine the decimal positions of JDEdwards F47012 numeric fields.
SQL Query: SELECT * FROM EXDGDPP WHERE GDFLDC>0 AND GDRCFM ='F47012' AND GDGFIL = 'I850JDE3'
Note: Field GDFLDC will show the respective decimal position.
By: Sean Hoppe on