Table Name: | part_class |
Table Number: | 330 |
Group: | Product Mgr |
Description: | Defines logical groups of parts (generic parts) for DE purposes. Reserved; not used |
Flags: | |
Baseline/Custom: | Baseline |
Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
---|---|---|---|---|---|---|---|---|
description | CHAR | varchar | 255 | A brief description for the part class | ||||
dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
name | CHAR | varchar | 40 | A unique name for the part class | Search (3) | |||
objid | LONG | int | 3 | DIRECT | Internal record number | Search (6) |
Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
---|---|---|---|---|---|---|---|
part_class2part_num | OTM | part_num | part_num2part_class | Parts assigned to the part class. Reserved; not used | |||
part_class2prog_logic | OTM | prog_logic | prog_logic2part_class | Related programmed logic for use with Diagnosis Engine. Reserved; not used | |||
part_class2prtkp_set | OTOF | prtkp_set | prtkp_set2part_class | Related keyphrase set. Reserved; not used | |||
part_class2prtnum_cat | OTOF | prtnum_cat | prtnum_cat2part_class | Keyphrase category for the part class. Used for part classes which apply to more than one part number. Reserved; not used |
Index Name | Fields | Flags |
---|---|---|
name_index | name | UNIQUE |
Index Name | Fields | Additional Information |
---|---|---|
name_index | name | nonclustered, unique located on PRIMARY |
objindex | objid | clustered, unique located on PRIMARY |
View ID | View Name | Tables |
---|---|---|
112 | pmhpml_view | mod_level, part_class, part_num |
129 | psfg2psfs2pmh | part_class, prtkp_cat, prtkp_set |
152 | pmh2psf2gsfg | gbkp_cat, gbkp_set, part_class, prtkp_set |
344 | lgc2mod2prt | mod_level, part_class, part_num, prog_logic |
373 | lgc2pd2class | part_class, probdesc, prog_logic |
402 | prtcls2shwg2psfg | gbkp_cat, part_class, prtkp_cat, prtnum_cat |
part_class | |||