BUSINESS_UNITPrompt Table: BUS_UNIT_TBL_MG
COMPONENT_IDPrompt Table: MASTER_ITEM_TBL
LANGUAGE_CDSF_COMPDSTC_LVW(SQL View) |
Index Back |
|---|---|
Unrestricted comp list RL vw07/02/99 TKI CN# SF800-19.0 Related language view; used as prompt table for txn history inquiry COMPONENT_ID field |
| SELECT DISTINCT a.business_unit , a.component_id , d.language_cd , d.descr60 FROM PS_SF_COMP_LIST a , PS_MASTER_ITM_LANG d , PS_SET_CNTRL_REC c WHERE c.recname = 'MASTER_ITEM_TBL' AND c.setcntrlvalue = a.business_unit AND d.setid = c.setid AND d.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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |