OPRIDRUN_CNTL_IDREQUEST_IDA=Process all eligible vouchers
B=Process Business Unit
E=Process Supplier
G=Process Control Group
O=Process Voucher Origin
S=Process Voucher source
V=Process Voucher
Default Value: A
VCHR_APPRVL_RUN(SQL Table) |
Index Back |
|---|---|
Voucher Approval RequestVoucher Approval Request options |
| # | 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 | REQUEST_ID |
Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 4 | REQUEST_DT | Date(10) | DATE | Request Date |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | VCHR_APPR_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Approval options
A=Process all eligible vouchers B=Process Business Unit E=Process Supplier G=Process Control Group O=Process Voucher Origin S=Process Voucher source V=Process Voucher Default Value: A |
| 8 | FROM_DT | Date(10) | DATE | From Date |
| 9 | TO_DT | Date(10) | DATE | To Date |
| 10 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 11 | WHERE_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 12 | WHERE_CLAUSE3 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 13 | WHERE_CLAUSE4 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 14 | WHERE_CLAUSE5 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 15 | WHERE_CLAUSE6 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |