*
*
*
Buzz
Wouldn’t it be nice if, as a developer, you could stay inside of SQL or your chosen Integrated Development Environment (IDE) and get all the information necessary to identify what fields and tables you need to use to access the JDE data? Wouldn’t it be great if you could not only see the descriptions, but also see field lengths? Wouldn’t it be great to be able to search for specific field aliases throughout JDE to discover all the tables where specific fields are used throughout the JDE system? While we’re wishing, wouldn’t it be wonderful if we could perform wildcard searches for field descriptions, aliases, data types, and other information in the Data Dictionary, right from our development environments?
Posts Tagged ‘SQL Server’
How to search JDE EnterpriseOne Data Dictionary from SQL
Posted: August 17, 2009 in TechKnowledgy ArticlesTags: ERP, JD Edwards, JDE, Oracle, PeopleSoft, SQL, SQL Server, T-SQL
20
How to convert EnterpriseOne (JDE) Julian Dates
Posted: August 16, 2009 in TechKnowledgy ArticlesTags: AS/400, Dates, ERP, Gregorian, iSeries, JD Edwards, JDE, Julian, Oracle, PeopleSoft, Reporting Services, SQL, SQL Server, SSRS, T-SQL
Overview If you’ve ever worked with Oracle/PeopleSoft’s EnterpriseOne ERP system (also known as JD Edwards or simply JDE) you’ll quickly find that dealing with dates from the database is a bit challenging. EnterpriseOne stores all dates in the system in Julian Date format. EnterpriseOne has a lot of dates in every table. The Julian Date [...]
