CS_CNT_AG_LKEY (SQL Table)	Index Back
Cntrct Lin Agreement Structure This is a dummy record to support Binds against LINE level contract agreements. It is used in the Source Structure definition as a source record for cs_cnt_ag but with cntrct_hdr as the parent, rather than cntrct_line. This table should always be empty.

CS_CNT_AG_LKEY

(SQL Table)

Cntrct Lin Agreement Structure

This is a dummy record to support Binds against LINE level contract agreements. It is used in the Source Structure definition as a source record for cs_cnt_ag but with cntrct_hdr as the parent, rather than cntrct_line. This table should always be empty.

# 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_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

#	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_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