CS_CLN_AG_CL_VW

(SQL View)
 Index Back

Contract Line Agreement Clause


SELECT DISTINCT A.SETID ,'0011' ,A.CNTRCT_ID ,A.CNTRCT_LINE_NBR ,A.CS_OBJECT_ID ,A.CS_OBJECT_TYPE ,B.DESCR FROM PS_CS_CNT_AG_CLASE A ,PS_CNTRCT_HDR B WHERE A.SETID = B.SETID AND A.CNTRCT_ID = B.CNTRCT_ID AND A.VERSION_NBR = B.VERSION_NBR AND A.CNTRCT_LINE_NBR > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CS_CONTENT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles 06/25/07 F-AHAYT-XOES6 Added 0016 for Document Format and Options; this type is only used when displayed where a word template is used with doc options. We do not search doc format and options.
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0009=Contract Agreement
0010=Bid Factor
0011=Contract
0012=Sourcing Event
0013=Question Group
0014=Document Type
0015=Word Template
0016=Document Format and Options
3 CS_CONTENT_ID Character(30) VARCHAR2(30) NOT NULL Content ID
4 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
5 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section
6 CS_OBJECT_TYPE Character(4) VARCHAR2(4) NOT NULL 06/08/09 F-AHAYT-XOES6 Add capability to use binds in headers and/or footers of contract document; new translate value added to support Where Used from Document Templates and Styles
0001=Clause
0002=Section
0003=Ad Hoc Clause
0004=Rule
0005=Bind Variables
0006=Wizard Definition
0007=Document Configurator
0008=Document
0015=Word Template
1000=All
7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254