CS_CNT_AG_LTXT

(SQL Table)
Index Back

SLA Text

SCC 01/01/07 F-AHAYT-S60K7 - Contract Agreements Long Text

# 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