CZ Tables (145)
CZ - Configurator — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
CZ_ADDRESSES |
24 | OBSOLETE, MDApp only |
CZ_ADDRESS_USES |
16 | OBSOLETE, MDApp only for interface to OM |
CZ_ARCHIVES |
14 | Configurator Extension Archive Table |
CZ_ARCHIVE_REFS |
9 | Archives-reference path Table |
CZ_ATP_REQUESTS |
17 | ATP interface table |
CZ_COMBO_FEATURES |
18 | Explicit compatibility OC/features table |
CZ_CONFIG_ATTRIBUTES |
40 | Configuration-Item Attributes table |
CZ_CONFIG_EXT_ATTRIBUTES |
13 | Extended Attributes for Installed Base integration -- the fully-normalized attribute attachment to Configuration Items |
CZ_CONFIG_HDRS |
46 | Configuration header table |
CZ_CONFIG_INPUTS |
31 | User inputs while creating configuration |
CZ_CONFIG_ITEMS |
62 | Items selected for the configuration |
CZ_CONFIG_MESSAGES |
22 | Configuration messages |
CZ_CONFIG_USAGES |
26 | Records uses of configuration items by client applications |
CZ_CONTACTS |
38 | OBSOLETE, customer contacts for MDApp |
CZ_CUSTOMERS |
32 | OBSOLETE, customers for MDApp |
CZ_CUSTOMER_END_USERS |
13 | OBSOLETE, assigns customers to MDApp users |
CZ_DB_LOGS |
20 | Log reporting table |
CZ_DB_SETTINGS |
6 | Oracle Configurator system settings |
CZ_DB_SIZES |
8 | Record-counts table |
CZ_DES_CHART_CELLS |
17 | Contents of design chart cells |
CZ_DES_CHART_COLUMNS |
9 | Parameters for Design Chart columns |
CZ_DES_CHART_FEATURES |
16 | Controlling features in each Design Chart |
CZ_DEVL_PRJ_USER_GROUPS |
13 | OBSOLETE, assigns projects to MDApp users |
CZ_DEVL_PROJECTS |
37 | Master record for a configurator model/project |
CZ_DRILL_DOWN_ITEMS |
25 | OBSOLETE, describes items in a quote |
CZ_EFFECTIVITY_SETS |
20 | Table lists named/shared effectivities for reference by effectivity-governed tables. |
CZ_END_USERS |
47 | Oracle SellingPoint users |
CZ_END_USER_GROUPS |
16 | Oracle SellingPoint end user groups |
CZ_EXPRESSIONS |
19 | Master record for Configurator expressions |
CZ_EXPRESSION_NODES |
48 | Expression contents in a tree or sequential "un-parsed" node order |
CZ_EXP_TMP_LINES |
17 | OBSOLETE. Used for order export |
CZ_EXT_APPLICATIONS |
5 | New table for storing applications that will be shown as publishing options in Developer. Also stores preferred UI style for these applicat |
CZ_FCE_FILES |
11 | |
CZ_FILTER_SETS |
20 | Defines a Populator data filter using an Expression |
CZ_FUNC_COMP_REFS |
15 | NOT USED. |
CZ_FUNC_COMP_SPECS |
22 | Functional companion specifications |
CZ_GRID_CELLS |
16 | Contents of explicit compatibility cells |
CZ_GRID_COLS |
15 | Specifies a column in an explicit compatibility |
CZ_GRID_DEFS |
15 | Defines the parameters of an explicit compatibility rule. |
CZ_IMP_ADDRESS |
23 | Data to be imported (or rejected) into CZ_ADDRESSES |
CZ_IMP_ADDRESS_USE |
10 | Data to be imported (or rejected) into CZ_ADDRESS_USES |
CZ_IMP_CONTACT |
44 | Data to be imported (or rejected) into CZ_CONTACTS |
CZ_IMP_CUSTOMER |
36 | Data to be imported (or rejected) into CZ_CUSTOMERS |
CZ_IMP_CUSTOMER_END_USER |
19 | Data to be imported (or rejected) into CZ_CUSTOMER_END_USERS |
CZ_IMP_DEVL_PROJECT |
35 | Data to be imported (or rejected) into CZ_DEVL_PROJECTS |
CZ_IMP_END_USER |
50 | Data to be imported (or rejected) into CZ_END_USERS |
CZ_IMP_END_USER_GROUP |
23 | Data to be imported (or rejected) into CZ_END_USER_GROUPS |
CZ_IMP_INTL_TEXT |
16 | OBSOLETE Data to be imported (or rejected) into CZ_INTL_TEXTS |
CZ_IMP_ITEM_MASTER |
37 | Data to be imported (or rejected) into CZ_ITEM_MASTERS |
CZ_IMP_ITEM_PARENT |
30 | NOT USED |
CZ_IMP_ITEM_PROPERTY_VALUE |
35 | Data to be imported (or rejected) into CZ_ITEM_PROPERTY_VALUES |
CZ_IMP_ITEM_TYPE |
28 | Data to be imported (or rejected) into CZ_ITEM_TYPES |
CZ_IMP_ITEM_TYPE_PROPERTY |
31 | Data to be imported (or rejected) into CZ_ITEM_TYPE_PROPERTIES |
CZ_IMP_LOCALIZED_TEXTS |
24 | Import table for CZ_LOCALIZED_TEXTS |
CZ_IMP_MODEL_REF_EXPLS |
22 | Data to be imported (or rejected) to CZ_MODEL_REF_EXPLS |
CZ_IMP_PRICE |
23 | Data to be imported (or rejected) into CZ_PRICES |
CZ_IMP_PRICE_GROUP |
27 | Data to be imported (or rejected) into CZ_PRICE_GROUPS |
CZ_IMP_PROPERTY |
32 | Data to be imported (or rejected) into CZ_PROPERTIES |
CZ_IMP_PS_NODES |
99 | Data to be imported (or rejected) into CZ_PS_NODES |
CZ_IMP_RULES |
67 | Import table for Rules |
CZ_IMP_TMP_ITEMCAT |
2 | |
CZ_IMP_USER_GROUP |
25 | Data to be imported (or rejected) into CZ_USER_GROUPS |
CZ_INTL_TEXTS |
14 | OBSOLETE |
CZ_ITEM_MASTERS |
32 | Items used to structure the product |
CZ_ITEM_PARENTS |
15 | NOT USED. |
CZ_ITEM_PROPERTY_VALUES |
17 | Item property values |
CZ_ITEM_TYPES |
24 | Item types |
CZ_ITEM_TYPE_PROPERTIES |
15 | Item properties by item types |
CZ_JRAD_CHUNKS |
4 | JRAD "chunks" (document subsections) |
CZ_LCE_CLOBS |
2 | Packages entire LCE for a component into a single row using a CLOB to hold the data |
CZ_LCE_HEADERS |
20 | Compiled logic record headers |
CZ_LCE_LINES |
22 | Compiled logic records |
CZ_LCE_LOAD_SPECS |
13 | Logic-file loading rules table. |
CZ_LCE_OPERANDS |
16 | Logic record operands |
CZ_LCE_TEXTS |
3 | Optimized storage of LCE lines, several per row |
CZ_LOCALES |
13 | NEVER USED. For internationalization |
CZ_LOCALIZED_TEXTS |
23 | Stores all texts that are displayed in Configurator runtime UI. Multi-language. |
CZ_LOCK_HISTORY |
14 | Records lock actions by user and object |
CZ_LOOKUP_VALUES |
14 | Lookup-value storage |
CZ_LOOKUP_VALUES_TL |
17 | Translations of labels and descriptions for lookup values |
CZ_MODEL_PUBLICATIONS |
46 | Publications table. Each row is a published TOP model |
CZ_MODEL_REF_EXPLS |
17 | Model-reference explosions table |
CZ_MODEL_USAGES |
10 | Usages table. Limited to 64 |
CZ_MODEL_USAGES_TL |
4 | Stores translatable descriptions for model usages. |
CZ_NODE_TYPE_CLASSES |
11 | |
CZ_OPPORTUNITY_HDRS |
26 | Opportunity headers for SellingPoint |
CZ_OPP_HDR_CONTACTS |
13 | Contact list for opportunities. Obsolete |
CZ_PB_CLIENT_APPS |
4 | Lists applications for a publication |
CZ_PB_LANGUAGES |
2 | The CZ_PB_LANGUAGES table is used to assign languages to Publications, allowing configuration requests to be served in a particular specifie |
CZ_PB_MODEL_EXPORTS |
16 | Model-exports table |
CZ_PB_TEMP_IDS |
4 | Maps source IDs to remote IDs for Publishing |
CZ_PERSISTENT_REC_IDS |
8 | |
CZ_POPULATORS |
32 | Table holds product-structure Populators |
CZ_POPULATOR_MAPS |
15 | OBSOLETE |
CZ_PRICES |
24 | Oracle SellingPoint list prices used in the Quote module. |
CZ_PRICE_GROUPS |
24 | Oracle SellingPoint price lists used in the Quote module. Price lists |
CZ_PRICING_STRUCTURES |
12 | Interface table for Pricing requests |
CZ_PROPERTIES |
28 | Item properties |
CZ_PROPOSAL_HDRS |
32 | Proposals header table |
CZ_PROP_QUOTE_HDRS |
14 | Proposal-Quote join table |
CZ_PSNODE_PROPCOMPAT_GENS |
26 | Used for client-side logic generation. |
CZ_PS_NODES |
91 | Project structure nodes |
CZ_PS_PROP_VALS |
16 | Project node property values |
CZ_PUBLICATION_USAGES |
2 | Join table between publications and usages |
CZ_QUOTE_HDRS |
56 | Quote header table, obsolete |
CZ_QUOTE_MAIN_ITEMS |
21 | OBSOLETE, listed items in quote |
CZ_QUOTE_ORDERS |
17 | OBSOLETE. Tracks SellingPoint orders submitted to OE. |
CZ_QUOTE_SPARES |
22 | Associates spares with quotes for SellingPoint. OBSOLETE. |
CZ_QUOTE_SPECIAL_ITEMS |
25 | Associates special order items with a quote |
CZ_REL_TYPES |
13 | NEVER USED. Intended to qualify parent-child relationships for CZ_ITEM_PARENTS. |
CZ_RP_ENTRIES |
14 | Repository table. |
CZ_RULES |
59 | Rules table |
CZ_RULE_FOLDERS |
26 | Table implements rule folders and rule sequences |
CZ_SERVERS |
15 | Identifies database servers for import and Publication |
CZ_SIGNATURES |
21 | Data type specification table |
CZ_SIGNATURE_ARGUMENTS |
17 | Rule-Template parameter specification |
CZ_SPARES_SPECIALS |
20 | OBSOLETE. MDApp spares-specials table |
CZ_SUB_CON_SETS |
14 | NEVER USED |
CZ_TERMINATE_MSGS |
5 | XML terminate messages. |
CZ_TYPE_RELATIONSHIPS |
11 | Records type relationships and properties |
CZ_UI_ACTIONS |
35 | User-interface Actions definition |
CZ_UI_CONT_TYPE_TEMPLS |
14 | Lists templates for each content type in a UI |
CZ_UI_DEFS |
75 | UI definition table |
CZ_UI_IMAGES |
13 | Records images (icons) for use in modelling and runtime |
CZ_UI_NODES |
59 | Describes each UI node |
CZ_UI_NODE_PROPS |
16 | Attaches property values to UI nodes |
CZ_UI_PAGES |
39 | Configurator UI page definition |
CZ_UI_PAGE_ELEMENTS |
26 | UI page components |
CZ_UI_PAGE_REFS |
30 | Page references in a menu or flow |
CZ_UI_PAGE_SETS |
16 | UI Menu or page flow |
CZ_UI_PROPERTIES |
14 | Attaches property values to UIs |
CZ_UI_REFS |
10 | UI-to-UI references |
CZ_UI_REF_TEMPLATES |
14 | Template-to-Template references |
CZ_UI_TEMPLATES |
28 | UI Content Template |
CZ_UI_TEMPLATE_ELEMENTS |
12 | UI Content Template components |
CZ_UI_XMLS |
9 | XML documents used in building a UI |
CZ_USER_GROUPS |
20 | OBSOLETE. Oracle SellingPoint user groups |
CZ_XFR_FIELDS |
8 | Import rules specifications, field level |
CZ_XFR_FIELD_REQUIRES |
8 | NOT IN USE. Attaches FK rules to import specifications |
CZ_XFR_PRICE_LISTS |
7 | Oracle price lists to be imported |
CZ_XFR_PROJECT_BILLS |
15 | Project bills import control table |
CZ_XFR_RUN_INFOS |
9 | Summary information about batch runs |
CZ_XFR_RUN_RESULTS |
5 | Summary of records imported |
CZ_XFR_STATUS_CODES |
3 | Descriptions of particular run status values |
CZ_XFR_TABLES |
8 | Import control table responsible for NOUPDATE flags |