BUSINESS_UNITINV_ITEM_IDEN=Engineering
PR=Manufacturing
RTG_TYPEPR=Production
RW=Rework
TD=Teardown
RTG_CODEEG_ECR_RTGCD_VW(SQL View) |
Index Back |
|---|---|
ECR/ECO Routing Code ViewCN#EG750-4.0 dbe (Engineering Routings) - New View. Used to determine valid Routing Codes within ECR/ECO maintenance. 02/01/00 TKI CN#SF800-14.0 Added RTG_STATE, RTG_TYPE and DESCR 03/08/00 TKI CN#SF800-14.0 Added where RTG_STATE = 'EN' to view sql 07/11/00 RSX Removed where clause (as we need to show both entries from EBOM and MBOM). Also made RTG_STATE as not a search key. |
| SELECT business_unit , inv_item_id , rtg_state , rtg_type , rtg_code , descr FROM PS_EN_RTG_HEADER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | RTG_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Routing State
EN=Engineering PR=Manufacturing |
| 4 | RTG_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown |
| 5 | RTG_CODE |
Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |