PROBINSTPrompt Table: SP_PRBINS_NONVW
BUSINESS_UNITPrompt Table: PL_PLNPOBU_VW
PL_SEQ_NBRPrompt Table: PL_PLNPOITEM_VW
Prompt Table: PL_PURCHOPT1_VW
Prompt Table: PL_PLNPOVDR_VW
Prompt Table: PL_PURCHOPT3_VW
PL_PLN_PO_VW(SQL View) |
Index Back |
|---|---|
PL_PLN_PO_VWPL_PLN_PO_VW |
| SELECT PROBINST ,BUSINESS_UNIT ,PL_SEQ_NBR ,INV_ITEM_ID ,VENDOR_SETID ,VENDOR_ID ,VNDR_LOC FROM PS_PL_PLN_PO |
| # | 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_PLNPOBU_VW |
| 3 | PL_SEQ_NBR |
Number(9,0) | DECIMAL(9) NOT NULL | 01/09/02 EGS (CN#PL900-1): Added |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: PL_PLNPOITEM_VW |
| 5 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: PL_PURCHOPT1_VW |
| 6 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: PL_PLNPOVDR_VW |
| 7 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table: PL_PURCHOPT3_VW |