SCR_IND_CL_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	SIC_CD_QUAL	Character(3)	VARCHAR2(3) NOT NULL	SIC Code Type ANZ=Australia-New Zealand SIC Code CAN=Canadian NAICS Codes GER=German SIC Codes NAF=French SIC Codes SIC=US SIC Codes UK=UK 92 SIC Codes USA=US - NAICS Codes USE=NAICS Exception Codes USP=Primary NAICS Codes
4	SIC_CODE	Character(10)	VARCHAR2(10) NOT NULL	Standard Industry Code
5	SCR_SIC_CD_QUAL	Character(3)	VARCHAR2(3) NOT NULL	SIC Code Type ANZ=Australia-New Zealand SIC Code CAN=Canadian NAICS Codes GER=German SIC Codes NAF=French SIC Codes SIC=US SIC Codes UK=UK 92 SIC Codes USA=US - NAICS Codes USE=NAICS Exception Codes USP=Primary NAICS Codes
6	SCR_SIC_CODE	Character(10)	VARCHAR2(10) NOT NULL	Standard Industry Code
7	SCR_CHNG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Request for Change Type A=Add D=Delete I=Inactivate U=Update
8	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: SCR_VNDUSER1_VW.SETID
9	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Default Value: SCR_VNDUSER1_VW.VENDOR_ID
10	ERR_MSG_NBR	Number(5,0)	INTEGER NOT NULL	Service Purchase Error Number
11	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
12	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
13	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
14	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
15	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.