CS_LNCOMM_TMP (SQL Table)	Index Back
Contract Line Commnt Structure Temp table used in Contracts Source Transaction structure .. Will never have anything in table .. used to get structure/keys for heirarchy of binds. CEL 10/2007 -- Added version_nbr to the record - needs to match cntrct_hdr

CS_LNCOMM_TMP

(SQL Table)

Contract Line Commnt Structure

Temp table used in Contracts Source Transaction structure .. Will never have anything in table .. used to get structure/keys for heirarchy of binds. 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 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr

5 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	CNTRCT_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Buying Agreement Line Nbr
5	COMMENT_ID	DateTime(26)	TIMESTAMP	DtTm Entered