BUSINESS_UNITPrompt Table: SP_BUMGOP_NONVW
ECR_IDECO_STATECO=Engineering Change Order
CR=Engineering Chg Request
Default Value: CR
INV_ITEM_ID01=Manufacturing
02=Engineering
03=Mfg & Eng
Default Value: 02
EG_ECR_ASSY_VW(SQL View) |
Index Back |
|---|---|
EG ECR Assembly View |
| select a.business_unit, a.eco_id, a.eco_state, a.inv_item_id, a.eg_eco_target from PS_EG_ECO_ASSY a where eco_state = 'CR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
| 2 | ECR_ID |
Character(10) | VARCHAR2(10) NOT NULL | ECR Number |
| 3 | ECO_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
ECR / ECO Flag
CO=Engineering Change Order CR=Engineering Chg Request Default Value: CR |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | EG_ECO_TARGET | Character(2) | VARCHAR2(2) NOT NULL |
Affects
01=Manufacturing 02=Engineering 03=Mfg & Eng Default Value: 02 |