VCHR_AF_HFLD_VW

(SQL View)
 Index Back

Voucher Approval Search

Voucher Approval Search Record

SELECT a.business_unit , a.voucher_id , a.gross_amt , a.txn_currency_cd , a.voucher_style , a.vchr_src FROM PS_VOUCHER a WHERE a.vchr_apprvl_flg = 'W' AND a.voucher_style NOT IN ('TMPL','THRD') AND A.ENTRY_STATUS <> 'X' AND a.close_status <> 'C' AND a.process_man_close <> 'Y' UNION SELECT a.business_unit , a.voucher_id , a.pay_amt , a.txn_currency_cd , a.voucher_style , a.vchr_src FROM PS_VOUCHER a WHERE a.vchr_apprvl_flg = 'W' AND a.voucher_style = 'THRD' AND A.ENTRY_STATUS <> 'X' AND a.close_status <> 'C' AND a.process_man_close <> 'Y'

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_AP_NONVW

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

Default Value: NEXT

3 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
4 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
5 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
6 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source