SCR_EMAIL_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	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
5	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
6	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
7	EFFDT	Date(10)	DATE	Effective Date
8	SCR_EFFDT	Date(10)	DATE	Approved Changes Take Effect
9	SCR_CHG_EFF_WHEN	Character(1)	VARCHAR2(1) NOT NULL	Change Effective I=Approval Date S=Future Date
10	SCR_PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check DD=Direct Debit DFT=Draft - Supplier Initiated EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
11	SCR_REMOVE	Character(1)	VARCHAR2(1) NOT NULL	Remove Contact
12	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
13	ENTERED_DTTM	DateTime(26)	TIMESTAMP	Entered Datetime