OPRIDRUN_CNTL_IDPrompt Table: RQSTR_ACTIVE_VW
Prompt Table: REQ_PO_VW
Prompt Table: %RECNAME_EDIT2
Prompt Table: %RECNAME_EDIT
Prompt Table: %RECNAME_EDIT
A=Specific Requisition
B=Range of Requisitions
Default Value: A
PV_REQSORC_WRK(SQL Table) |
Index Back |
|---|---|
Quick Sourcer Work RecordThis derived record is used to record the eProcurement specific parameters for running Quick Sourcer. |
| # | 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 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table: RQSTR_ACTIVE_VW |
| 4 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL |
Requisition ID
Prompt Table: REQ_PO_VW |
| 5 | REQ_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Requisition Name
Prompt Table: %RECNAME_EDIT2 |
| 6 | PV_REQ_ID_FROM | Character(10) | VARCHAR2(10) NOT NULL |
From
Prompt Table: %RECNAME_EDIT |
| 7 | PV_REQ_ID_TO | Character(10) | VARCHAR2(10) NOT NULL |
To
Prompt Table: %RECNAME_EDIT |
| 8 | PV_REQ_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Requisition Selection Type
A=Specific Requisition B=Range of Requisitions Default Value: A |