OPRIDPrompt Table: OPERATOR_VW
RUN_CNTL_IDEM_EXT_BUYER_VW(SQL View) |
Index Back |
|---|---|
RunControl Buyer Vchr ExtractSearch Record for Voucher Extract - Buyer Component (EM_VCHR_EXTRACT). |
| SELECT DISTINCT A.OPRID , A.RUN_CNTL_ID FROM PS_PRCSRUNCNTL A , PS_EM_VCHR_EXT_BUS B WHERE A.OPRID = B.OPRID AND A.RUN_CNTL_ID = B.RUN_CNTL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |