Understanding Configured Table Setup

A configured rules table is a collection of data that you define for a configured item. During order processing, assembly inclusion rules can refer to tables to retrieve component parts, calculated segment values, price adjustments, or display information.

You can use tables to reduce the number of assembly inclusion rules that are required when segment answers vary greatly. The table type should be the same as the assembly inclusion rule type that refers to it.

Setting up tables adds time to the setup process. However, tables can dramatically reduce the number of assembly inclusion rules and their complexity, thus improving processing time and simplifying setup.

When you enter an order for a configured item, you select answers for the segments that are defined for the item. For example, for a forklift, you might select a value of 4000 for segment 10 (Lift Rating) and a value of PROPANE for segment 20 (Power type).

Depending on the values that you define for each segment, you can specify the information that returns to the order. You must define the values for each segment as a key to the table.

You can define tables that correspond to the matching assembly inclusion rule types:

Table	Description
P Table (Quantity/Parts)	Defines part tables that can return multiple part numbers. To produce the configured item, P tables return part numbers to the sales order and, eventually, to the work order parts list.
Q Table (Quantity/Parts)	Defines part tables that can return multiple part numbers. Conceptually similar to P tables, Q tables return part numbers only to the work order parts list. They do not return values to the sales order.
C Table (Calculated values)	Defines a calculated segment table that can return multiple numeric or alphanumeric values as defined on Configured Item Segments. C tables return calculated values to segments. Other rule types can then use these values to control or affect actions.
H Table (Hot Spots)	Defines numeric information about a configured item to be returned to the Hot Spot field on the order entry form for display purposes only. H tables are limited to one return value. H tables are conceptually similar to C tables. Examples of hot spot information include price, foreign price, domestic price, cost, foreign cost, domestic cost, and weight.
X Table (Pricing)	Defines a price table that returns one numeric value. X tables return prices to the sales order, based on one or more segment answers. Unless otherwise specified, the line type is an M by default. Whatever the line type is in the assembly inclusion rules, the rules for the price rollup flag prevail—that is, either break out separately or roll into the parent. X tables are limited to one return value.

Note: No table corresponds to the assembly inclusion rule for routing.

Because only one value can be returned for H and X tables, the system limits setup options when you specify the return dimensions for these table types.

Because a table might contain many segments (keys) and values, you must decide how the table information appears before you can review table information.

Note: The tables that are used for rules processing within the JD Edwards EnterpriseOne Configurator system are not UDCs.

As you work with table information, you can speed data entry by setting a processing option for copying rows of data.

You also can define effectivity dates for the table.

When creating C tables that return multiple values, you must define destination segment numbers during the Table/Item Cross Reference step. The Table Return Segment Values form automatically appears when you are entering a C table.