VCHR_AF_MASS_VW

(SQL View)
Index Back

Voucher Approval Search

Voucher Approval Search Record

SELECT DISTINCT a.business_unit , a.voucher_id , d.oprid , a.invoice_id , a.gross_amt , a.pay_amt , a.txn_currency_cd , a.voucher_style , a.vchr_src , a.appr_status , a.vendor_setid , a.vendor_id , e.attachment_num , d.eoawstep_status FROM PS_VOUCHER a , ps_vchr_af_xref b , ps_eoaw_stepinst c , ps_eoaw_userinst d , ps_ap_vchr_ata_cnt e WHERE a.entry_status ='P' AND a.vchr_apprvl_flg = 'W' AND a.in_process_flg = 'N' AND a.business_unit = b.business_unit AND a.voucher_id = b.voucher_id AND b.eoawthread_id=c.eoawthread_id AND b.eoawprcs_id=c.eoawprcs_id AND b.eoawdefn_id=c.eoawdefn_id AND c.eoawstep_instance = d.eoawstep_instance AND a.business_unit = e.business_unit AND a.voucher_id = e.voucher_id AND a.APPR_STATUS = e.APPR_STATUS AND ((A.APPR_STATUS = 'P' AND c.eoawSTEP_STATUS IN ('P','H') AND d.eoawstep_status IN ('P','H')) OR (A.APPR_STATUS IN ('A', 'D') AND D.EOAWSTEP_STATUS = A.APPR_STATUS))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AP_NONVW

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
5 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
6 PAY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount
7 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
8 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
9 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source
10 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
11 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
12 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
13 ATTACHMENT_NUM Number(5,0) INTEGER NOT NULL Attachment Number
14 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=On Hold
I=No Action Taken
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
R=No longer in role
T=Terminated
U=Auto approved
X=Deleted
Z=Pending Denial