AP_UVCH_FLTR_VW

(SQL View)
Index Back

Match Workbench for WorkCenter

Used to retrieve summary information of vouchers that require matching.

SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , A.REMIT_VENDOR , A.SCHEDULED_PAY_DT , A.PYMNT_GROSS_AMT , A.CURRENCY_PYMNT , A.OPRID , A.OPRID_LAST_UPDT , A.ORIGIN , A.VOUCHER_STYLE , A.VCHR_SRC , A.ENTERED_DT FROM PS_AP_WC_VCHUNP_VW A

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

Prompt Table: SP_BUS_AP_NONVW

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

Prompt Table: VCHR_ID_VW3

3 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

Prompt Table: VNDR_RMT_VW

4 SCHEDULED_PAY_DT Date(10) DATE Scheduled to Pay
5 PYMNT_GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Payment Amount
6 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency

Prompt Table: CURRENCY_CD_TBL

7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Default Value: OPR_DEF_TBL_AP.OPRID

Prompt Table: OPRID_VW

8 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last User to Update

Default Value: OPR_DEF_TBL_AP.OPRID

Prompt Table: OPRID_VW

9 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

Default Value: OPR_DEF_TBL_AP.ORIGIN

Prompt Table: ORIGIN_AP_EFFVW

10 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
11 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source

Default Value: ONL

12 ENTERED_DT Date(10) DATE Entered on