EM_SEC_PPY_VW (SQL View)	Index Back
Voucher Approval Search MarketPay Security This SQL view was cloned from the voucher search record. The voucher search record did not implement any kind of row-level security. This new search record (SQL view) joins to the User BU Permissions table ( ), and only returns appropriate rows. This table is used to control MarketPay Voucher Approval pages.

EM_SEC_PPY_VW

(SQL View)

Voucher Approval Search

MarketPay Security This SQL view was cloned from the voucher search record. The voucher search record did not implement any kind of row-level security. This new search record (SQL view) joins to the User BU Permissions table ( ), and only returns appropriate rows. This table is used to control MarketPay Voucher Approval pages.

SELECT DISTINCT c.oprid , a.business_unit , a.voucher_id , a.invoice_id , a.voucher_style , a.gross_amt , a.txn_currency_cd , a.invoice_dt , a.vendor_setid , a.vendor_id , b.name1 , a.vndr_loc , b.vendor_name_short FROM PS_VOUCHER a , ps_vendor b , ps_sec_bu_opr c WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND a.business_unit = c.business_unit AND a.VOUCHER_STYLE='PPAY'

Related Language Record: EM_SEC_PPY_LGVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_AP_NONVW

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

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

5 VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher

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

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

8 INVOICE_DT Date(10) DATE Invoice Date

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

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

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

12 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW
3	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
4	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
5	VOUCHER_STYLE	Character(4)	VARCHAR2(4) NOT NULL	Voucher Style ADJ=Adjustments AMR=Amortization Voucher CLBK=Claim Voucher CORR=Reversal Voucher JRNL=Journal Voucher PPAY=Prepaid Voucher REG=Regular Voucher RGTR=Register Voucher SGLP=Single Payment Voucher THRD=Third Party Voucher TMPL=Template Voucher
6	GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Invoice Amount
7	TXN_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Transaction Currency
8	INVOICE_DT	Date(10)	DATE	Invoice Date
9	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Default Value: VENDOR.SETID
10	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Default Value: VENDOR_SHRT_VW.VENDOR_ID Prompt Table: VENDOR_PRIM_VW
11	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
12	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
13	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name