PROCESS_INSTANCEA=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: E
VCHR_APRV_AET(SQL Table) |
Index Back |
|---|---|
Voucher Approval AET TableVoucher Approval AET Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 4 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 5 | WHERE_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 6 | WHERE_CLAUSE3 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 7 | WHERE_CLAUSE4 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 8 | WHERE_CLAUSE5 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 9 | WHERE_CLAUSE6 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 10 | WHERE_CLAUSE7 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 11 | WHERE_CLAUSE8 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 12 | WHERE_CLAUSE9 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 13 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 14 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 15 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 16 | VCHR_COUNT | Number(6,0) | INTEGER NOT NULL | Count of Vouchers |
| 17 | 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: E |
| 18 | AE_APPSTATUS | Number(1,0) | SMALLINT NOT NULL | AE Application Warning Status |