BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_MG
COMPONENT_IDPrompt Table: MASTER_ITEM_TBL
SF_COMP_DSTC_VW(SQL View) |
Index Back |
|---|---|
Unrestricted component list vw03/09/99 TKI CN# SF800-19.0 Used as prompt table for txn history inquiry COMPONENT_ID field |
| select distinct a.business_unit, a.component_id, b.descr60 from PS_SF_COMP_LIST a, PS_MASTER_ITEM_TBL b, PS_SET_CNTRL_REC c where c.recname = 'MASTER_ITEM_TBL' and c.setcntrlvalue = a.business_unit and b.setid = c.setid and b.inv_item_id = a.component_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_TBL_MG |
| 2 | COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
Prompt Table: MASTER_ITEM_TBL |
| 3 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |