JDE Development, SQL Scripts, Administration & More – Content for advanced Developers, CNCs and SysAdmins
SQL Queries for quickly reviewing & modifying JDE business data and/or system configuration.
About By default, JDE creates a lot of database table index definitions. When the “Generate Table” command is used in OMW, all of the JDE-defined Indexes are generated along with it. But why does JDE have so many indexes to begin with? The reason for all of those predefined indexes really comes down to design …
Purpose Display all jobs in the JDE Scheduler system in an efficient & easy-to-read format. About Like most of the applications in JDE that were built for system administrators, the JDE Scheduler Application P91300 is pretty awful to use. Critical information is scattered throughout several different screens without one good screen to overview the entire …
Purpose Re-balance the JDE F4229 “Sales As-Of” file based on actual details in the F42119 Sales Detail History file. This should be used to maintain reporting accuracy if you have directly modified Sales Detail History in F42119. About JDE maintains a Sales History Summary in the file F4229 that is used to help increase reporting …
[SQL Server only] Purpose Quickly copy data for 1 or more tables from one database to another. This is useful for performing partial data refreshes between environments. About This query is optimized for speed. For each table: disable all indexes, truncate table, copy data from source, rebuild indexes. Usage Specify table(s) to be refreshed in …