| View Name: | lgc2mod2prt |
| View Number: | 344 |
| Group: | Product Mgr |
| Description: | Solution path/logic. Used by forms Solution Paths (329), Path Descriptions (8100), Keyphrase Selections (8102). Reserved; not used |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| active | mod_level | active | Active/inactive/obsolete | |
| description | part_num | description | Maps to sales and mfg systems | |
| domain | part_num | domain | Name of the domain for the part num | |
| family | part_num | family | Marketing product family the part belongs to; new user-defined pop up replaces relation to gbst_elm | |
| lgc_desc | prog_logic | description | Description of the path | |
| lgc_is_cmn | prog_logic | is_cmn | Reserved; future | |
| lgc_number | prog_logic | id_number | Unique ID number for the path; consists of solution-# | |
| line | part_num | line | Marketing product line, within family, of the part; new user-defined pop up replaces relation to gbst_elm | |
| mod_level | mod_level | mod_level | Revision level | |
| mod_objid | mod_level | objid | Part revision internal record number | |
| model_num | part_num | model_num | Marketing model number of the part; within family and line | |
| name | part_class | name | A unique name for the part class | |
| objid | prog_logic | objid | Prog logic internal record number | 3 (UNIQUE) |
| part_active | part_num | active | Active/inactive/obsolete | |
| part_number | part_num | part_number | Part number/name | |
| part_type | part_num | part_type | User-defined pop up to denote a part type separate from the domain | |
| partnum_objid | part_num | objid | Part num internal record number | |
| pmh_objid | part_class | objid | Part class internal record number | |
| quantity | part_num | sn_track | Track part for serialization; i.e., 0=by quantity, 1=by serial number |
Join From | Join To |
|---|---|
| (prog_logic).prog_logic2part_class | (part_class).part_class2prog_logic |
| (prog_logic).prog_logic2part_info | (mod_level).part_info2prog_logic |
| (mod_level).part_info2part_num | (part_num).part_num2mod_level |
| lgc2mod2prt | |||