OPRIDRUN_CNTL_IDBUSINESS_UNITPrompt Table: SP_BU_OM_NONVW
OMPB_BOOK_DEFN_IDPrompt Table: OMPB_BOOK_DEFN
OMPB_BOOK_IDPrompt Table: OMPB_BOOK
OMPB_INSTANCEPrompt Table: OMPB_INSTANCE
RUN_OM_OMPB_OUT(SQL Table) |
Index Back |
|---|---|
Price Book param select tableStaging table to hold the selected values for Price Book EIP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_OM_NONVW |
| 4 | OMPB_BOOK_DEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Customer Price Book Definition ID
Prompt Table: OMPB_BOOK_DEFN |
| 5 | OMPB_BOOK_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Customer Price Book ID
Prompt Table: OMPB_BOOK |
| 6 | OMPB_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
price book instance
Prompt Table: OMPB_INSTANCE |
| 7 | DELETE_CONTROL | Character(1) | VARCHAR2(1) NOT NULL | DELETE_CONTROL |