AP_WC_WB_LVW (SQL View)	Index Back
Match Workbench for WorkCenter Used to retrieve summary information of vouchers that require matching in AP WorkCenter.

AP_WC_WB_LVW

(SQL View)

Match Workbench for WorkCenter

Used to retrieve summary information of vouchers that require matching in AP WorkCenter.

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , B.LANGUAGE_CD , B.VENDOR_NAME_SHORT FROM PS_VOUCHER A , PS_VENDOR_LANG 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'

Related Language Record for AP_WC_WB_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name