BUSINESS_UNITREF_ROUTING_ITEMRTG_CODECP_REFROUTE_VW(SQL View) |
Index Back |
|---|---|
CP Ref Route Code for Mfg CfgCN#EG750-4.0 dbe (Engineering Routings) - Added RTG_STATE='PR' to WHERE clause. |
| select business_unit, inv_item_id, rtg_code, descr from PS_EN_RTG_HEADER where rtg_type = 'PR' and rtg_state = 'PR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REF_ROUTING_ITEM |
Character(18) | VARCHAR2(18) NOT NULL | Reference Routing Item |
| 3 | RTG_CODE |
Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |