EM_QV_SRCH_VW2 (SQL View)	Index Back
MP - Quick Voucher Search View MP - Quick Voucher Search View without security.

EM_QV_SRCH_VW2

(SQL View)

MP - Quick Voucher Search View

MP - Quick Voucher Search View without security.

SELECT DISTINCT A.BUSINESS_UNIT , A.VOUCHER_ID , A.INVOICE_ID , A.GROSS_AMT , A.INVOICE_DT , B.SETID , A.VENDOR_ID , B.VENDOR_NAME_SHORT , B.NAME1 , A.VNDR_LOC , A.VCHR_SRC , ' ' , A.VCHR_BLD_STATUS , A.TXN_CURRENCY_CD , A.PYMNT_TERMS_CD FROM PS_VCHR_HDR_QV A , PS_VENDOR B WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID

Related Language Record: EM_VCHR_SCH2_LG

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

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
Default Value: NEXT

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

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

5 INVOICE_DT Date(10) DATE Invoice Date

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

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

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

9 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

10 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
Prompt Table: EM_VNDR_LOC_VW

11 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source

12 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

13 VCHR_BLD_STATUS Character(1) VARCHAR2(1) NOT NULL Build Status
B=Build Voucher
D=Delete Voucher
E=Pre-Edit Error
H=Tolerance Hold
I=Initiated
N=Not processed
S=Voucher Staged
T=Stage Voucher

14 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency

15 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.

#	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: EM_BU_VNAGRT_VW
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID Default Value: NEXT
3	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
4	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
5	INVOICE_DT	Date(10)	DATE	Invoice Date
6	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Default Value: VENDOR.SETID
7	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Default Value: VENDOR_SHRT_VW.VENDOR_ID Prompt Table: EM_VNLNM_USR_VW
8	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
9	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
10	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: EM_VNDR_LOC_VW
11	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
12	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
13	VCHR_BLD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Build Status B=Build Voucher D=Delete Voucher E=Pre-Edit Error H=Tolerance Hold I=Initiated N=Not processed S=Voucher Staged T=Stage Voucher
14	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
15	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.