CS_CNT_AG_VY_AT

(SQL Table)
Index Back

SLA Verification Attachments

SCC 01/01/07 F-AHAYT-S60K7 - Contract Agreement Verification Attachments

# 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_VERIFY_SEQ Number(5,0) INTEGER NOT NULL Contract Agreement Verification Step
8 CS_ATTACHMENT_SEQ5 Number(5,0) INTEGER NOT NULL Workflow Sequence for Supplier Contract Managment
9 SCM_ATTACH_ID Character(64) VARCHAR2(64) NOT NULL The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
10 ATT_VERSION Number(3,0) SMALLINT NOT NULL The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
11 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
12 ATTACH_DESCR Character(100) VARCHAR2(100) NOT NULL A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
13 COMMENTS_254 Character(254) VARCHAR2(254) NOT NULL EDI Comments
14 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

Default Value: %DateTime