EM_MTCH_VCHR_VW (SQL View)	Index Back
EM Matched Voucher View View on PS_PO_LINE_MATCHED and PS_VOUCHER to obtain details pi and dttm of matched vouchers Uses left outer join

EM_MTCH_VCHR_VW

(SQL View)

EM Matched Voucher View

View on PS_PO_LINE_MATCHED and PS_VOUCHER to obtain details pi and dttm of matched vouchers Uses left outer join

SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , A.MATCH_STATUS_VCHR , C.MATCH_CNTRL_ID , B.DATETIME_STAMP , B.PROCESS_INSTANCE FROM PS_VOUCHER A , PS_PO_LINE_MATCHED B , PS_EM_AGREEMENT C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND C.SETID = ( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.RECNAME = 'EM_AGREEMENT' AND D.SETCNTRLVALUE = A.BUSINESS_UNIT) AND C.VENDOR_SETID = A.VENDOR_SETID AND C.VENDOR_ID = A.VENDOR_ID

# 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 MATCH_STATUS_VCHR Character(1) VARCHAR2(1) NOT NULL Match Status
C=Overridden - Credit Note
D=Match Dispute
E=Match Exceptions Exist
M=Matched
N=Not Applicable
O=Manually Overridden
T=To Be Matched

4 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule

5 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	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	MATCH_STATUS_VCHR	Character(1)	VARCHAR2(1) NOT NULL	Match Status C=Overridden - Credit Note D=Match Dispute E=Match Exceptions Exist M=Matched N=Not Applicable O=Manually Overridden T=To Be Matched
4	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule
5	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp
6	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance