OPR_DEF_AP_VW2

(SQL View)
Index Back

Join of FS, AP, and VND recs


SELECT A.OPRID, A.BUSINESS_UNIT, A.AS_OF_DATE, A.SETID, A.NAME1, B.ORIGIN, B.INVOICE_AMT_MAX, B.AUTH_POST_VOUCHER, B.AUTH_VCHR_GRP, B.AUTH_SCHED_PYMNT, C.AUTH_VNDR_UNCERTFY, C.AUTH_VNDR_CERTFY, C.AUTH_VNDR_INACT_ST FROM PS_OPR_DEF_TBL_FS A, PS_OPR_DEF_TBL_AP B, PS_OPR_DEF_TBL_VND C WHERE A.OPRID = B.OPRID AND A.OPRID = C.OPRID

# 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
3 AS_OF_DATE Date(10) DATE As of Date
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
6 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
7 INVOICE_AMT_MAX Signed Number(28,3) DECIMAL(26,3) NOT NULL Entry Limit
8 AUTH_POST_VOUCHER Character(1) VARCHAR2(1) NOT NULL Authority to Post Vouchers
9 AUTH_VCHR_GRP Character(1) VARCHAR2(1) NOT NULL Enter Vouchers Only in Groups
10 AUTH_SCHED_PYMNT Character(1) VARCHAR2(1) NOT NULL Manually Schedule Payments
11 AUTH_VNDR_UNCERTFY Character(1) VARCHAR2(1) NOT NULL Supplier Entered Status
12 AUTH_VNDR_CERTFY Character(1) VARCHAR2(1) NOT NULL Supplier Active Status
13 AUTH_VNDR_INACT_ST Character(1) VARCHAR2(1) NOT NULL Supplier Inactive Status