| Table Name: | mod_level |
| Table Number: | 329 |
| Group: | Product Mgr |
| Description: | Defines a version (sometimes called a revision) of a generic part (see part_num) to the system. A generic part must have at least one version |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| active | CHAR | varchar | 40 | CHANGE_FIELD | Active/inactive/obsolete | Search (25) | ||
| config_type | LONG | tinyint | 0 | DIRECT | Declares Configurator constraints for the part: i.e., 0=not to be configured, 1=configure as a product, 2=configure as an option, default=0 | Search (3) | ||
| description | CHAR | varchar | 255 | ALLOW_NULL | Marketing text to be used to present the product or option to the user or customer | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| eff_date | CLK_TIME | datetime | The date the support program version becomes effective | Search (4) | ||||
| end_date | CLK_TIME | datetime | The date the support program version expires | Search (4) | ||||
| mod_level | CHAR | varchar | 10 | CHANGE_FIELD | Name of the part revision | Search (73) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (91) | ||
| replaces_date | CLK_TIME | datetime | If obsolete, specifies date and time of obsolescence | Search (1) | ||||
| x_modify_stmp | CLK_TIME | datetime | CHANGE_DATE, USER_DEFINED | The date and time when change fields were last updated | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| part_info2backorder | OTM | backorder | backorder2part_info | Backorders involving the part revision | |||
| part_info2bug | OTM | bug | bug_product2part_info | Change requests for the part revision | |||
| mod_level2bus_opp_role | MTM | bus_opp_role | bus_opp_role2mod_level | Opportunities invloving the mod_level | mtm_mod_level49_ bus_opp_role3 | ||
| case_cat_part2case | OTM | case | case_prt2part_info | Catalog part selection for case (entitlement) product | |||
| de_cat_part2case | OTM | case | de_prt2part_info | Catalog (generic) part selection for case (DE) product | |||
| part_info2catalog | MTM | catalog | catalog2part_info | Product catalog<s> to which the part revision belongs | mtm_catalog0_ mod_level3 | Search (1) | |
| part_info2contr_itm | OTM | contr_itm | contr_itm2mod_level | Releated contract items | |||
| part_info2demand_dtl | OTM | demand_dtl | demand_dtl2part_info | Part requests for the part revision was supplied | |||
| orig_part2demand_dtl | OTM | demand_dtl | orig_part2part_info | Part requests which originally requested the revision | |||
| part_attach2doc_inst | OTM | doc_inst | doc_inst2mod_level | Attachments to the part request | |||
| part_info2eco_dtl | OTM | eco_dtl | eco_dtl2mod_level | ECO affecting the mod level | |||
| applies2eco_mod_role | OTM | eco_mod_role | applies2mod_level | ECO roles applied to the mod_level | |||
| result2eco_mod_role | OTM | eco_mod_role | result2mod_level | ECO roles which created the mod_level | |||
| mod_level2elgblty_set | MTM | elgblty_set | elgbty_set2mod_level | Rules associated with the product | mtm_mod_level56_ elgblty_set3 | ||
| service2entitlement | OTOF | entitlement | service2mod_level | Related entitlement-required for mod_levels which are Support Programs | |||
| install2fcs_detail | OTM | fcs_detail | install2part_mod | Reserved; custom | |||
| remove2fcs_detail | OTM | fcs_detail | remove2part_mod | Reserved; custom | |||
| mod_level2flex_tmpl | MTM | flex_tmpl | flex_tmpl2mod_level | Flexible attribute templates that are to be used by part versions, via direct relations | mtm_mod_level53_ flex_tmpl1 | ||
| part_info2interact | OTM | interact | interact2mod_level | Interactions referencing the part revision | |||
| part_info2inv_ctrl | MTO | inv_ctrl | inv_ctrl2mod_level | Inventory control group for the part_revison | |||
| mod_level2lead | MTM | lead | lead2mod_level | Leads interested in the part | mtm_mod_level50_ lead15 | ||
| part_info2lit_req_itm | OTM | lit_req_itm | lit_req_itm2mod_level | Related sales literature template items | |||
| part_info2log_info | OTOP | log_info | log_info2part_info | Reserved; future | |||
| part_num_incl2part_num | MTM | mod_level | incl_part_num2part_num | Related included products; builds parent-child relationships between products; this is the parent | mtm_mod_level5_ mod_level4 | ||
| incl_part_num2part_num | MTM | mod_level | part_num_incl2part_num | Related Included products; builds parent-child relationships between products; this is the included product | mtm_mod_level4_ mod_level5 | Search (2) | |
| replacespn2mod_level | OTOF | mod_level | replacedpn2mod_level | Part which the current part replaces | |||
| replacedpn2mod_level | OTOP | mod_level | replacespn2mod_level | Part which replaces the current part | Search (1) | ||
| mod_level2mtl_log | OTM | mtl_log | mtl_log2mod_level | Repair part expenditures using the revision | |||
| part_info2N_Option | OTOF | N_Option | N_Option2mod_level | Related configuration option | |||
| part_info2N_Product | OTOF | N_Product | N_Product2mod_level | Related configuration product | |||
| mod_level2offering | OTM | offering | offering2mod_level | Offering consists of top-level part in site-part hierarchy | |||
| bus_mod_level2offering | OTM | offering | bus_offering2mod_level | Offering using the top level account level product | |||
| mod_level2part_action | MTM | part_action | part_action2mod_level | Action is valid for a part | mtm_mod_level52_ part_action0 | ||
| n_part_info2part_auth | OTM | part_auth | n_auth_parts2part_mod | Notes which location<s> parts are authorized for | |||
| n_part_info2part_inst | OTM | part_inst | n_part_inst2part_mod | Related inventory parts of the revision at inventory locations | |||
| part_info2part_num | MTO | part_num | part_num2mod_level | Part to which the revision belongs | Search (92) | ||
| part_info2part_qty | OTM | part_qty | part_qty2part_info | Relation to parent part number to track the quantity of the included part number | |||
| part_incl2part_qty | OTM | part_qty | part_qty2part_incl | Relation to included part number to indicate the quantity of the included part number | |||
| player_mod2part_role | OTM | part_role | role_player2mod_level | Part revison playing the role for another part revision | |||
| for_mod2part_role | OTM | part_role | role_for2mod_level | Part revison receiving the role from another part revision | |||
| part_info2part_stats | OTOP | part_stats | part_stats2part_info | The inventory count metrics object for the product | Search (1) | ||
| inst_part_info2part_used | OTM | part_used | part_used2inst_part_info | In Log Part Used form, tracks exchange of BOM | |||
| rem_part_info2part_used | OTM | part_used | part_used2rem_part_info | In Log Part Used form, tracks removal of BOM | |||
| part_info2price_inst | OTM | price_inst | price_inst2part_info | Reserved; obsolete | |||
| priced_part2price_qty | OTM | price_qty | priced_part2mod_level | Quantities which are used in assigning prices to the part revision | |||
| context_part2price_qty | OTM | price_qty | context_part2mod_level | Quantities for which the part revision provides a pricing context for another part | |||
| part_info2price_role | OTM | price_role | price_role2part_info | Assigned price instance for the part revision | |||
| mod_level2proc_inst | MTM | proc_inst | proc_inst2mod_level | Product mod_level presented in this process/script run | mtm_mod_level55_ proc_inst10 | ||
| mod_level2process | MTM | process | process2mod_level | Product mod_levels that may be presented in this process/script | mtm_mod_level54_ process8 | ||
| part_info2prog_logic | OTM | prog_logic | prog_logic2part_info | Programmed Logics that were defined using the part revision. Reserved; not used | |||
| part_info2prtnum_cat | OTOF | prtnum_cat | prtnum_cat2part_info | Links categories of keyphrase to the part number. Reserved; not used | |||
| part2qq_line_item | OTM | qq_line_item | q_item2mod_level | Repair part expenditures using the revision | |||
| part_info2recv_parts | OTM | recv_parts | recv_parts2part_info | Receive transactions for the part revison. Reserved | |||
| part_info2recv_prob | OTM | recv_prob | problem2part_info | Receiving problems involving the part revison | |||
| part_info2retrn_info | OTM | retrn_info | new_part_mod2part_info | Returns involving the part revision. Reserved; future | |||
| part_info2rpr_inst_qty | OTM | rpr_inst_qty | inst_qty2part_info | Repair BOM member parts | |||
| part_info2site_part | OTM | site_part | site_part2part_info | Related parts installed at a site/sites | |||
| part_info2vendor_part | OTM | vendor_part | vendor_part2mod_level | Supplier information for the part revision |
| Index Name | Fields | Flags |
|---|---|---|
| mod_level_index | part_info2part_num:mod_level | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_part_info2inv_ctrl | part_info2inv_ctrl, objid | nonclustered, unique located on PRIMARY |
| ind_part_info2part_num | part_info2part_num | nonclustered located on PRIMARY |
| ind_replacedpn2mod_level | replacedpn2mod_level | nonclustered located on PRIMARY |
| mod_level_index | part_info2part_num, mod_level | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| mod_level | |||