CS_HDRCOM_TMP (SQL Table)	Index Back
Contract Hdr Comment Structure Temp table used to get key structre of Contract Header comments. Nothing is every stored in this table .. just used in Contract Management source transaction mapping. CEL 10/2007 -- Added version_nbr to the record - needs to match cntrct_hdr

CS_HDRCOM_TMP

(SQL Table)

Contract Hdr Comment Structure

Temp table used to get key structre of Contract Header comments. Nothing is every stored in this table .. just used in Contract Management source transaction mapping. CEL 10/2007 -- Added version_nbr to the record - needs to match cntrct_hdr

# 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 COMMENT_ID DateTime(26) TIMESTAMP DtTm Entered

#	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	COMMENT_ID	DateTime(26)	TIMESTAMP	DtTm Entered