Data management, maintenance, and storage is an essential key to success for any organization, but especially for those navigating complex business processes, information exchange, and enterprise resource planning (ERP) system configuration and optimization.

Read on to learn how JD Edwards tables (and their underlying database) can help your team manage, store, and transfer data more efficiently.

What is a Table in JD Edwards?

Oracle JD Edwards EnterpriseOne allows users to store and manage important ERP information in tables and views within an underlying database.

The EnterpriseOne system operates on a relational database, meaning that data tables are related using common key fields. JDE users can also create custom tables to sort, manage, and store data to be used in other JD Edwards applications and modules.

These database tables help store data in one place and organize it by columns and rows separating data items and records respectively. These tables and views are categorized by JD Edwards system codes and can be created by choosing data items from the comprehensive data dictionary and selecting key fields to be table indices.

Tables are defined to ensure the JD Edwards software recognizes the table exists, and indices help database management systems find and sort records more efficiently.

Understanding JDE Tables

Creating and managing tables, views, and data for existing or custom applications within JD Edwards can get complicated, especially without the right tools at your disposal. And, before creating a new table, it’s important that you identify whether an already existing table fills data item requirements.

If one does not exist, you will need to create a new table using the JD Edwards EnterpriseOne Design Aid. With this tool, users can generate a table whenever data items are added or deleted, indices are changed or added, or new data tables are created.

The JDE Table Design Aid can be accessed through the Object Management Workbench and is used to create custom tables for new or existing JD Edwards applications. Here’s how to create a table in JD Edwards:

  1. Outline a table object using the recommended naming conventions.
  2. Add data items as table columns, create indices, and outline audit fields to design the table.
  3. Generate the table in JD Edwards.
  4. Add, manage, and store data in the table.

Top JD Edwards Table Requests for Each Version

An essential step in creating and using JDE tables, building reports, or developing applications is recognizing the structure of your tables. Ensuring you understand table definitions, details, and references is critical in not only using tables for their intended purpose, but also in gaining a better understanding of the JD Edwards system as a whole.

There’s a seemingly never ending amount of tables to choose from in JD Edwards, including JDE Accounts Receivable tables, JDE Audit tables, JDE BOM tables, JDE Control tables, and many more options. But, here’s a JDE tables list including the main table requests for each version of the solution, as well as their table description and key purpose within JD Edwards:

  • JDE Version 9.2
    • Sales Order Detail File (Table F4211, Transaction Files): Used for Sales Management.
    • Item Master (Table F4101, Master Files): Used for Inventory Management.
    • Account Ledger (Table F0911, Master Files): Used for General Accounting Management.
  • JDE Version 9.1
    • Batch-to-Detail (Table F0011W): Used for General Accounting Management.
    • Address Book Master (Table F0101): Used for Address Book Management.
  • JDE Version 8.12
    • Accounts Payable Ledger (Table F0411): Used for Accounts Payable Management.
    • Purchase Order Detail File (Table F4311): Used for Procurement and Purchase Order Management.

Getting Started with Us

It’s no secret that creating custom tables, navigating complex table configurations, viewing data, and importing metadata into JDE tables is difficult without the right personnel and resources on your side. Luckily for you, this is where Surety Systems comes in.

Our team of senior-level JD Edwards consultants has the skills, experience, and techno-functional expertise needed to lead your team to success, no matter where your JD Edwards system needs lie.

How Can We Help?

Whether you need help identifying the key components to be included in your JDE tables, finding your way through column and row configuration, importing selected tables to other JD Edwards applications and external systems, or anything in between, our consultants have you covered.

Interesting in learning more about where our JD Edwards consultants can fit in your organization? Click the link to access more information about our JD Edwards consulting services or contact us today to get started.