Defining Table Definitions with Dimensions for Configured Tables
Access the Rule Table Definition Revisions form.
- Rules Table Name
Enter the name of a collection of data that you set up to minimize the number of assembly inclusion rules that you need for a configured item. You must define rule table names in UDC table 32/TN. A rule table can be accessed by 1 to 20 keys and can return up to 99 values. When you reference a rule table in an assembly inclusion rule, the system uses the rule keys to retrieve the values that are associated with the rule table. For example, if you defined segment 10 to be the color of an item, you could set the table to retrieve item Red Component when the customer enters Red for segment 10. In this example, the table would be:
Item Color: Value
Red: Red Component
The table would include the following instruction:
If the color segment value is red, then use item number Red Component on the configured item sales order and work order parts list.
- C Table - Calculated Values, P Table - SO Parts List, Q Table - WO Parts List, X Table - Price Adjustments, and H Table - Hot Spots
Enter a value that identifies the type of rule table. Values are:
P: Part list (on sales order and work order)
Q: Work order component (on work order only)
C: Calculated values
H: Hot Spot
X: Price/Cost adjustment
- Number of Segments
Enter how many keys (segments) are used to access the table. Key values must be on the current level or a previous level of the configured item.
The maximum is 20 keys.
- Number of Table Values
Enter how many values the system returns from the rules table when a match is found on the table keys. If you enter more than one return value for a C (calculated) rule, you must indicate the segment numbers to return the values to.
With H and X tables, the Number of Table Values field is automatically populated with 1.