Table | JDE Source

Update a Table’s Primary Keys from JDE

By Deepesh M Divakaran, on January 25th, 2012

Does that title sound funny? Can you update your Primary Keys of a record in a table too? Ofcourse you can, SQL does allow it. But does that work in an ERP? Yes ERP’s are supposed to keep their data integrity well, and secure it too. But in JD Edwards you have an option to [...] . . . → Read More: Update a Table’s Primary Keys from JDE

Information on Table Design Aid

By Muthu Kumar Lakshmanan, on September 22nd, 2011

I created a custom table. When creating a new table, when is it required to Generate the Table? Also under what circumstances is it necessary to run the Generate Header File option? A report using the custom table seems able to write to a table only when Generate Header File is done. Solution When creating [...] . . . → Read More: Information on Table Design Aid

Copy data from one table to another with the help of APIs

By Swapnil Ingale, on July 23rd, 2010

There are many requirements where data from One table needs to be copied to another. There are also various ways available. But there are some APIs which provide this functionality in very optimum way. e.g. JDEDM_LoadDSfromTableRecord, JDEDM_LoadTableRecordfromDS. Take example where one table contains 200 fields and due to interoperability one more table (Z-table) needs to [...] . . . → Read More: Copy data from one table to another with the help of APIs

Creating RTF Templates (OBIP)

By Sonal Teke, on May 28th, 2010

Create a RTF template with OBIP for JD Edwards. We will do a tutorial with the AP Ledger file, and try to create a report with Amounts for an address number . . . → Read More: Creating RTF Templates (OBIP)

Writing a P80010 Table Definition Browser App.

By Deepesh M Divakaran, on May 23rd, 2010

In OneWorld XE/8.0 days, we used to have an application – P80010 – Table Definition Browser Application. This application was of great help, as it showed the database fields in the Table, its indexes, the DD item name, description, the Data type of the field etc. You can do the same in the Newer versions of EnterpriseOne too, with a very simple app as shown in the article. . . . → Read More: Writing a P80010 Table Definition Browser App.

Categories

Recent Comments

Update a Table’s Primary Keys from JDE

Information on Table Design Aid

Copy data from one table to another with the help of APIs

Creating RTF Templates (OBIP)

Writing a P80010 Table Definition Browser App.

Login

Most Popular

Archives

Links