OPR_AP_UPE_VW (SQL View)	Index Back
AP User View AP User View - Uptake for 860 User Expiration Date Feature

OPR_AP_UPE_VW

(SQL View)

AP User View

AP User View - Uptake for 860 User Expiration Date Feature

SELECT a.oprid , a.name1 , a.business_unit , b.origin , a.setid , b.invoice_amt_max FROM ps_opr_def_tbl_fs a , PS_OPR_DEF_TBL_AP b , psoprdefn c WHERE a.oprid = b.oprid AND a.oprid = c.oprid AND (c.ACCTLOCK = 0 AND (c.PTACCTLOCKDATE IS NULL OR c.PTACCTLOCKDATE > %CurrentDateIn))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_FS

4 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
Prompt Table: ORIGIN_AP_OPT

5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

6 INVOICE_AMT_MAX Signed Number(28,3) DECIMAL(26,3) NOT NULL Entry Limit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW
2	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_FS
4	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Prompt Table: ORIGIN_AP_OPT
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
6	INVOICE_AMT_MAX	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Entry Limit