EM_VCHRMTCH_VW2 (SQL View)	Index Back
eS Voucher Header view Same as VOUCHER_MTCH_VW without the PeopleCode - for performance reasons on the Invoice Cycle component

EM_VCHRMTCH_VW2

(SQL View)

eS Voucher Header view

Same as VOUCHER_MTCH_VW without the PeopleCode - for performance reasons on the Invoice Cycle component

SELECT a.business_unit , a.voucher_id , a.invoice_id , a.invoice_dt , a.vendor_setid , a.vendor_id , a.grp_ap_id , a.origin , a.oprid , a.post_status_ap , a.gross_amt , a.txn_currency_cd , a.dscnt_amt , a.due_dt , a.dscnt_due_dt , a.pymnt_terms_cd , a.match_action , a.match_status_vchr , a.appr_status FROM PS_VOUCHER a WHERE a.match_status_vchr IN ('E', 'O')

# 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: BUS_UNIT_TBL_AP

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

3 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

4 INVOICE_DT Date(10) DATE Invoice Date

5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
Default Value: VENDOR.SETID

6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Default Value: VENDOR_SHRT_VW.VENDOR_ID
Prompt Table: VNDR_ACTIVE_VW

7 GRP_AP_ID Character(10) VARCHAR2(10) NOT NULL Control Group ID
Prompt Table: GRP_AP_OPR_VW2

8 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
Default Value: OPR_DEF_TBL_AP.ORIGIN

9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_AP.OPRID

10 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted
Default Value: U

11 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount

12 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
Prompt Table: CURR_TXN_VW

13 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount

14 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

15 DSCNT_DUE_DT Date(10) DATE Discount Due Date

16 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table: PYMT_TR_EFF_VW

17 MATCH_ACTION Character(1) VARCHAR2(1) NOT NULL Match Action
N=No Match
Y=Standard
Default Value: N

18 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
Default Value: N

19 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending

#	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: BUS_UNIT_TBL_AP
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
4	INVOICE_DT	Date(10)	DATE	Invoice Date
5	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Default Value: VENDOR.SETID
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Default Value: VENDOR_SHRT_VW.VENDOR_ID Prompt Table: VNDR_ACTIVE_VW
7	GRP_AP_ID	Character(10)	VARCHAR2(10) NOT NULL	Control Group ID Prompt Table: GRP_AP_OPR_VW2
8	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Default Value: OPR_DEF_TBL_AP.ORIGIN
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPR_DEF_TBL_AP.OPRID
10	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted Default Value: U
11	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
12	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency Prompt Table: CURR_TXN_VW
13	DSCNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Amount
14	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
15	DSCNT_DUE_DT	Date(10)	DATE	Discount Due Date
16	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. Prompt Table: PYMT_TR_EFF_VW
17	MATCH_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Match Action N=No Match Y=Standard Default Value: N
18	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 Default Value: N
19	APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on appr_inst_log and derived records to track virtual approver status A=Approved D=Denied P=Pending