PROBINSTPrompt Table: SP_PRBINS_NONVW
BUSINESS_UNITPrompt Table: PL_PLNTOSBU_VW
PL_SEQ_NBRPrompt Table: PL_PLNTOBU_VW
Prompt Table: PL_PLNTOITEM_VW
Prompt Table: PL_PLNTOSHIP_VW
PL_PLNTO_VW(SQL View) |
Index Back |
|---|---|
PL_PLNTO_VWPL_PLNTO_VW |
| SELECT PROBINST ,BUSINESS_UNIT ,PL_SEQ_NBR ,DESTIN_BU ,INV_ITEM_ID ,SHIP_TYPE_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_PLNTOSBU_VW |
| 3 | PL_SEQ_NBR |
Number(9,0) | DECIMAL(9) NOT NULL | 01/09/02 EGS (CN#PL900-1): Added |
| 4 | DESTIN_BU | Character(5) | VARCHAR2(5) NOT NULL |
Destination Unit
Prompt Table: PL_PLNTOBU_VW |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: PL_PLNTOITEM_VW |
| 6 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: PL_PLNTOSHIP_VW |