## Appendix: Tables Used by JD Edwards EnterpriseOne Configurator

This appendix provides a list of the tables that are used by JD Edwards EnterpriseOne Configurator.

### Tables Used by JD Edwards EnterpriseOne Configurator

This table lists the tables used by JD Edwards EnterpriseOne Configurator in alphanumeric order:

Table | Description
Configurator Master (F3201) | Stores the history for the configured items of all the configurations ordered. Information stored includes configuration ID number, order number, order type, line number, and component ID number. This includes the document numbers for the parent order and all related orders for the configuration.
Configurator Master History (F32019) | Stores the history for the F3201 table. Note. Currently, this purge table is not being populated.
Configurator Constants (F3209) | Stores constants that you define to control Configurator processing at the branch/plant level.
Configurator Segment Detail (F3211) | Stores segment information such as configuration ID number, component ID number, segment number, segment value, parent item number, and configuration string ID.
Configurator Segment Detail History (F32119) | Stores the history for the Configurator Segment Detail table (F3211) Note. This purge table is not currently being populated.
Configurator Routings (F3212) | Stores configured routing information.
Configurator Component (F3215) | Stores component information such as configuration ID number, component ID number, parent component ID number, item number, branch, location, and lot number.
Configurator Component History (F32159) | Stores history for the F3215 table. Note. This purge table is not currently being populated.
Configurator Price/Cost (F3216) | Stores price and cost information such as configuration ID number, component ID number, line type, price roll-up, price, and cost.
Configurator Price/Cost History (F32169) | Stores history for the F3216 table. Note. This purge table is not currently being populated.
Rules Table Definition (F3281) | Stores table information such as description, table type, number of segments, and return values.
Configured Item/Rules Table Cross Reference (F3282) | Defines which segment values will be used as keys to refer to tables for each configured item.
Rules Table Value Definition (F32821) | Defines calculated segments that will be populated with the returned values.
Rules Table Detail (F3283) | Stores the actual table values (parts, prices, and so on) for each combination of segment key values that you define for the table.
Configured Item Information (F3290) | Stores settings that you define to control the printing of configured item information on order paperwork. Also stores the X rule based-on date codes for sales orders, purchase orders, and work orders and dynamic configuration entry setting.
Configured Item Segments (F3291) | Contains the segments for the configured items that are defined in the Item Master and Item Branch table.
Cross Segment Editing Rules (F3292) | Defines the relationships between the segments of configured items.
Cross Segment Editing Rules - Values (F32921) | Stores the *VALUES definitions for cross-segment editing rules and assembly inclusion rules.
Cross Segment Editing Rules - Range (F32922) | Stores the *RANGE definitions for cross-segment editing rules and assembly inclusion rules.
Assembly Inclusions Rules (F3293) | Stores the components, routings, calculations, and price adjustments for configured items. Also stores the supplier number related to purchased components of a configured item.
Item Master (F4101) | Stores basic information about each item in inventory, such as item numbers, description, category codes, and units of measure.
Item Branch (F4102) | Stores branch/plant information, such as quantities, branch-level category codes, and cost information for an item.
Item Location (F41021) | Stores primary and secondary locations for an item.
Item Cost File (F4105) | Stores inventory cost records.
Item Base Price (F4106) | Stores base price information for an item.
Sales Order Header (F4201) | Maintains information for a customer order, such as the billing instruction, address, and delivery.
Purchase Order Header (F4301) | Maintains information for a purchase order, such as supplier, payment terms for the order, delivery address, and date when the order is due.
Purchase Order Detail (F4311) | Defines the configured item and quantity of the purchase order. The column GBCFG (Generated by Configurator) has a flag that indicates that the purchase order has a related configured order.
Work Order Master (F4801) | Contains one record for each work order. This table stores information about a work order, such as the description, estimated hours, responsibility, and costing information. It also stores planned start and end dates.