SCR_EMAIL_DFT

#	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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
5	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
6	EFFDT	Date(10)	DATE	Effective Date
7	SCR_EFFDT	Date(10)	DATE	Approved Changes Take Effect
8	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
9	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 Prompt Table: PYCYCL_MTHD_VW
10	SCR_CHG_EFF_WHEN	Character(1)	VARCHAR2(1) NOT NULL	Change Effective I=Approval Date S=Future Date
11	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
12	SCR_CHNG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Request for Change Type A=Add D=Delete I=Inactivate U=Update
13	ERR_MSG_NBR	Number(5,0)	INTEGER NOT NULL	Service Purchase Error Number
14	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
15	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
16	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
17	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
18	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.
19	SCR_REMOVE	Character(1)	VARCHAR2(1) NOT NULL	Remove Contact