SCR_CNTCT_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCR_ID	Character(15)	VARCHAR2(15) NOT NULL	Supplier Change Request ID
2	SCR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Update Sequence Number
3	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
4	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
5	SCR_EFFDT	Date(10)	DATE	Approved Changes Take Effect
6	SCR_CHG_EFF_WHEN	Character(1)	VARCHAR2(1) NOT NULL	Change Effective I=Approval Date S=Future Date
7	EFFDT	Date(10)	DATE	Effective Date
8	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
9	CONTACT_NAME	Character(50)	VARCHAR2(50) NOT NULL	The individual contact name associated with a given bank/counterparty.
10	CONTACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	An attribute that describes the specific purpose of a given bank/counterparty contact person. B=Billing Contact C=Contract Collaborator D=Commercial Paper Contact E=External Contact F=Cash Forecast G=General I=Internal Corporate Contact L=Line of Credit Contact M=Executive Management O=Investment Pool Contact P=Accounts Payable R=Broker S=Sales Contact V=Service Contact W=Warehousing/Shipping Contact
11	CONTACT_TITLE	Character(35)	VARCHAR2(35) NOT NULL	The professional title for a given bank/counterparty contact person.
12	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
13	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
14	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
15	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
16	SCR_REMOVE	Character(1)	VARCHAR2(1) NOT NULL	Remove Contact
17	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
18	ENTERED_DTTM	DateTime(26)	TIMESTAMP	Entered Datetime