CS_DOC_PO_KEYS (SQL Table)	Index Back
Keys for PO Contract Keys for PO Contract in Supply Contract Mgmt. Note: There really can only be one doc id per setid/contract id .. but in order to to simplify pages, etc .. it was easier to keep the doc id as the key to make it appear as a sibling to the document tables.

CS_DOC_PO_KEYS

(SQL Table)

Keys for PO Contract

Keys for PO Contract in Supply Contract Mgmt. Note: There really can only be one doc id per setid/contract id .. but in order to to simplify pages, etc .. it was easier to keep the doc id as the key to make it appear as a sibling to the document tables.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CS_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

4 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
Default Value: 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CS_DOC_ID	Character(25)	VARCHAR2(25) NOT NULL	Document ID
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
4	VERSION_NBR	Number(5,0)	INTEGER NOT NULL	Contract Version number Default Value: 1