CS_CNT_AG_TXEVW

(SQL View)
 Index Back

SLA Expected Text

SCC 01/01/07 F-AHAYT-S60K7 Agreement Expected Result Text

SELECT %subrec(CS_CNT_AG_T_SBR, A) FROM PS_CS_CNT_AG_LTXT A WHERE A.CS_COMMENT_TYPE = 'E'

# 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

Default Value: 1

4 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
5 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
6 CS_AGREE_SEQ5 Number(5,0) INTEGER NOT NULL Agreement Sequence for Supplier Contract Managment
7 CS_COMMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Comment Type
A=Actual Comments
C=Compliance Comments
E=Expected Comments
8 CS_COMMENTS Long Character CLOB Comment Field for Supplier Contract Managment