CS_CNT_CONT_TMP (SQL Table)	Index Back
Document Contacts Structure mapping for document contacts .. temp table just need it for the keys. there is nothing ever in this table .. is purely used to help us know the keys and define bind mapping relationships.

CS_CNT_CONT_TMP

(SQL Table)

Document Contacts Structure

mapping for document contacts .. temp table just need it for the keys. there is nothing ever in this table .. is purely used to help us know the keys and define bind mapping relationships.

# 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 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

5 CS_EXT_CNTCT_FLG Character(1) VARCHAR2(1) NOT NULL External Contact

#	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	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
5	CS_EXT_CNTCT_FLG	Character(1)	VARCHAR2(1) NOT NULL	External Contact