Understanding Table Creation

When an existing or custom application requires that you create tables for the JD Edwards EnterpriseOne database, use JD Edwards EnterpriseOne Table Design Aid to create the custom tables. You can access JD Edwards EnterpriseOne Table Design Aid from the Oracle's JD Edwards EnterpriseOne Object Management Workbench.

To create tables:

1. Create a table object.

   Use the recommended naming conventions when creating table objects.

2. Design the table.

   Add data dictionary items as table columns and create indices. Include audit fields in the table.

3. Generate the table.

4. Add data to the table.