BUSINESS_UNITVOUCHER_IDY/N Table Edit
Default Value: N
A=Approved
D=Denied
P=Pending
Default Value: P
VCHR_APPRVL(SQL View) |
Index Back |
|---|---|
Voucher Payment ApprovalVoucher Payment Approval |
| select business_unit, voucher_id, busprocname, appr_rule_set, appr_instance, appr_check_flg, appr_status from PS_VOUCHER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| 4 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
| 5 | APPR_INSTANCE | Number(9,0) | DECIMAL(9) NOT NULL | Unique number for each runtime occurrence of a virtual approver process |
| 6 | APPR_CHECK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Approval Check Flag
Y/N Table Edit Default Value: N |
| 7 | APPR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved D=Denied P=Pending Default Value: P |