All Tables

When you select the Tables tab in the right panel, the Configuration Assistant displays a list of all JD Edwards EnterpriseOne tables in the Tables datasource for the environment you are logged in to.

The grid contains a variety of information about each table, including the current row count.

By default, the lists of Tables is shown with a split screen where the top portion lists all the tables, and the bottom portion is used to display the records in the specified table. You can click the up and down arrow in the separator bar to toggle the split screen on and off (“See the figure below for the location of the arrows.").

Note: The system performs the data retrieval and table analysis in a method that improves memory management.The table search starts the first time you click on the Table node of a configuration. The table record count is not calculated until you select a table. To select all tables with data, you can use the check drop-down list to select Tables With Data, which instructs the system to calculate the record count on all the tables. You can then deselect unwanted tables. For details about using the check option, see Multiple Selects and Deselects.

Note: The Tables tree node in the left pane displays subnodes for selected records if All Tables or Selected Tables are selected. The tree subnode shows record level detail such as *All records or the Primary Key for Selected Records.

You can use the lower half of the All Tables split panel to search and select individual records within a table. To view a specific record within a table, use the checkbox in the top half of the split panel to select a table. The bottom half of the split panel displays each record, where boldfaced entries indicate key fields (not necessarily the Primary Key). To search for specific key values within a record, enter a value in the data entry field on the Search panel and click the Search tab. Individual Results tabs are created to display the results of each search.

Caution: A value of blank in any field indicates a wild card search for any value. Because tables with a large number of records can consume more memory than available, Configuration Assistant displays a warning if a search is going to return too much data. In this case, you should either narrow the search or select the entire table.

Tip: Hover Text: You can hover over any field description within a record to ascertain the literal key name. For example, in F0002, if you hover on Product Code the key name NNSY is displayed.

Tip: None Exist Icon: This icon in the Rows column of a listed table indicates an error condition for a table. For example, it could indicate a table specification mismatch, that a DD item is missing, or that the table does not exist in the datasource to which it is mapped.