AP_WB_FLTR_VW

(SQL View)
 Index Back

Match Workbench for WorkCenter

Used to retrieve summary information of vouchers that require matching.

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VENDOR_SETID , A.VENDOR_ID FROM PS_VOUCHER A , PS_VENDOR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.MATCH_ACTION = 'Y' AND A.ENTRY_STATUS ='P' AND A.CLOSE_STATUS <> 'C' AND A.IN_PROCESS_FLG = 'N'

# 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 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Prompt Table: SP_SETID_NONVW

4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_ACT_VW