| Table Name: | eco_hdr |
| Table Number: | 5148 |
| Group: | Logistics |
| Description: | A set of information about an ECO that potentially results in depot repair activity |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| create_date | CLK_TIME | datetime | The starting date for the campaign | |||||
| description | CHAR | text | 23 | ALLOW_NULL | Text of the ECO | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| eco_code | CHAR | varchar | 30 | ECO code; defaulted from a numbering scheme | Search (1) | |||
| eco_type | CHAR | varchar | 40 | Type of ECO: This is a user-defined pop up with default name ECO Type | ||||
| eff_type | CHAR | varchar | 40 | The effectivity type for the ECO: This is a user-defined pop up with default name ECO Effect Type | ||||
| end_date | CLK_TIME | datetime | The ending date for the ECO | Search (1) | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (2) | ||
| start_date | CLK_TIME | datetime | The starting date that the ECO is effective | Search (1) | ||||
| status | CHAR | varchar | 40 | Status of the ECO. This is a user-defined popup with default name ECO Status | Search (1) | |||
| title | CHAR | varchar | 255 | What the ECO is intended to achieve |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| eco2demand_dtl | MTM | demand_dtl | demand_dtl2eco_hdr | Demand details which have had this ECO applied | mtm_demand_dtl27_ eco_hdr3 | ||
| eco_hdr2doc_inst | OTM | doc_inst | doc_inst2eco_hdr | Documents for the ECO | |||
| eco_hdr2eco_details | OTM | eco_dtl | eco_details2eco_hdr | Related ECO details | |||
| hdr2eco_mod_role | OTM | eco_mod_role | eco_mod_role2eco_hdr | The part revisions that the ECO affects |
| Index Name | Fields | Flags |
|---|---|---|
| eco_code_ind | eco_code | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| eco_code_ind | eco_code | nonclustered, unique located on PRIMARY |
| ind_eco_hdr_eco_type | eco_type | nonclustered located on PRIMARY |
| ind_eco_hdr_end_date | end_date | nonclustered located on PRIMARY |
| ind_eco_hdr_start_date | start_date, end_date | nonclustered located on PRIMARY |
| ind_eco_hdr_status_type | status | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5151 | eco_products | eco_hdr, eco_mod_role, mod_level, part_num |
| 5190 | ecodtl_parts | eco_dtl, eco_hdr, mod_level, part_num |
| eco_hdr | |||