PL_FROM_CFG_VW(SQL View) |
Index Back |
---|---|
Config Cd - Prob Inst, BU,ItemConfig Cd - Prob Inst, BU,Item |
SELECT DISTINCT PROBINST , BUSINESS_UNIT , INV_ITEM_ID , CONFIG_CODE FROM PS_PL_BU_CFG_ITEMS |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: %EDITTABLE |
3 | FROM_ITEMID | Character(18) | VARCHAR2(18) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label ITEM_ID
Prompt Table: %EDITTABLE2 |
4 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |