PROBINSTPrompt Table: SP_PRBINS_NONVW
BUSINESS_UNITPrompt Table: PL_PLNTOSBU2_VW
PL_SEQ_NBRDefault Value: 0
DESTIN_BUPrompt Table: PL_PLNTOBU2_VW
INV_ITEM_IDPrompt Table: PL_PLNTOITM2_VW
PL_PLNTRN_ADDVW(SQL View) |
Index Back |
|---|---|
PL_PLNTRN_ADDVWPL_PLNTRN_ADDVW |
| SELECT DISTINCT PROBINST , BUSINESS_UNIT , PL_SEQ_NBR , DESTIN_BU , INV_ITEM_ID FROM PS_PL_PLN_TRANSFER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROBINST |
Character(20) | VARCHAR2(20) NOT NULL |
Optimization Problem Instance
Prompt Table: SP_PRBINS_NONVW |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: PL_PLNTOSBU2_VW |
| 3 | PL_SEQ_NBR |
Number(9,0) | DECIMAL(9) NOT NULL |
01/09/02 EGS (CN#PL900-1): Added
Default Value: 0 |
| 4 | DESTIN_BU |
Character(5) | VARCHAR2(5) NOT NULL |
Destination Unit
Prompt Table: PL_PLNTOBU2_VW |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: PL_PLNTOITM2_VW |