| Table Name: | csc_product |
| Table Number: | 5127 |
| Group: | Exchange Mgr |
| Description: | Describes a single product. It can be a general product like 'HP Printers' or a more specific product like 'HP LaserJet 4M'. It may also describe sub-products that are components of the original product |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| csc_order | CHAR | varchar | 10 | Order for sequential statements | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| name | CHAR | varchar | 225 | Customer-defined popup with default name Exchange Product supplies the name product for the incident | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| relation | LONG | tinyint | DIRECT | Relation between identifier and value; i.e., 0=false (is not); 1=true (is) | ||||
| server_id | LONG | int | DIRECT | Exchange protocol server ID number | ||||
| vendor | CHAR | varchar | 80 | Creator/brand owner of the product | ||||
| version | CHAR | varchar | 10 | The name of the product |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| parent2csc_category | OTOP | csc_category | parent2csc_product | Hierarchical parent category for the product | |||
| child2csc_category | OTOP | csc_category | child2csc_product | Hierarchical subcategory for the product | |||
| prod2csc_expression | OTM | csc_expression | text2csc_product | Identifies the item. Note multiple values and relations can exist to enumerate different serial numbers, lot numbers, etc | |||
| prod2csc_incident | OTM | csc_incident | incident2csc_product | Support incidents related to the product | |||
| prod2csc_part | OTOP | csc_part | part2csc_product | Related normalized part | |||
| component2csc_product | MTO | csc_product | assembly2csc_product | Product in which the current product is nested | |||
| assembly2csc_product | OTM | csc_product | component2csc_product | Component products |
| Index Name | Fields | Flags |
|---|---|---|
| product_ind | server_id:name:version:prod2csc_part | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_prod2csc_part | prod2csc_part | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| product_ind | server_id, name, version, prod2csc_part | nonclustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| csc_product | |||