CNTRCT_RELTN_VW

(SQL View)
 Index Back

Contract Relationship View

7/4/2016 JOHAN Master contract pivot grid

SELECT A.SETID , A.CNTRCT_ID , A.VERSION_NBR , A.CNTRCT_ID_CHILD , A.VNDR_LOC , A.RELTN_TYPE , A.RELTN_STATUS , B.VERSION_NBR , B.CNTRCT_STATUS , B.DESCR , B.BUYER_ID , B.VERSION_STATUS , B.CNTRCT_PROC_OPT , B.CNTRCT_STYLE , S.CNTRCT_STYLE_NAME , O.OPRDEFNDESC , B.VENDOR_SETID , V.VENDOR_ID , V.NAME1 FROM PS_CNTRCT_RELTN A , (PS_CNTRCT_HDR B LEFT OUTER JOIN PSOPRDEFN O ON B.BUYER_ID = O.OPRID) , PS_CNTRCT_STYLE S , PS_VENDOR V WHERE A.SETID = B.SETID AND A.CNTRCT_ID_CHILD=B.CNTRCT_ID AND B.CNTRCT_STYLE = S.CNTRCT_STYLE AND B.VENDOR_SETID = V.SETID AND B.VENDOR_ID = V.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
4 CNTRCT_ID_CHILD Character(25) VARCHAR2(25) NOT NULL Contract ID To

Prompt Table: CNTRCT_CHI_SRCH

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

Prompt Table: %EDITTABLE7

6 RELTN_TYPE Character(1) VARCHAR2(1) NOT NULL Contract Relationship Type
C=Contract Child
S=Supplier Location
7 RELTN_STATUS Character(1) VARCHAR2(1) NOT NULL Relationship Status
A=Active
I=Inactive
8 VERSION_NBR2 Number(5,0) INTEGER NOT NULL Contract Version number
9 CNTRCT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
A=Approved
C=Closed
H=On-Hold
O=Open
P=Pre-Approved
X=Canceled

Default Value: O

10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

Prompt Table: BUYER_ACTIVE_VW

12 VERSION_STATUS Character(1) VARCHAR2(1) NOT NULL Contract version status
C=Current
D=Draft
H=History

Default Value: C

13 CNTRCT_PROC_OPT Character(4) VARCHAR2(4) NOT NULL Contract Process Option
AP=Recurring Voucher
BPO=Release to Single PO Only
DST=Distributor
GN=General Contract
GRPM=Group Multi Supplier
GRPS=Group Single Supplier
MFG=Manufacturer
PADV=Prepaid Voucher w/ Advance PO
PO=Purchase Order
PPAY=Prepaid Voucher
RPOV=Recurring PO Voucher
SPP=Special Purpose
14 CNTRCT_STYLE Character(10) VARCHAR2(10) NOT NULL Contract Style

Prompt Table: CNT_STYLPROC_VW

15 CNTRCT_STYLE_NAME Character(30) VARCHAR2(30) NOT NULL Style Description
16 BUYER_DESCR Character(30) VARCHAR2(30) NOT NULL Buyer Desc
17 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
18 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
19 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1