SCR_LOC_SIC_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 Prompt Table: SETID_TBL
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	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
9	SIC_CODE	Character(10)	VARCHAR2(10) NOT NULL	Standard Industry Code
10	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
11	SCR_SIC_CODE	Character(10)	VARCHAR2(10) NOT NULL	Standard Industry Code
12	SCR_CHG_EFF_WHEN	Character(1)	VARCHAR2(1) NOT NULL	Change Effective I=Approval Date S=Future Date
13	SCR_CHNG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Request for Change Type A=Add D=Delete I=Inactivate U=Update
14	ERR_MSG_NBR	Number(5,0)	INTEGER NOT NULL	Service Purchase Error Number
15	MSG_SEVERITY	Character(1)	VARCHAR2(1) NOT NULL	Message Severity C=Cancel E=Error M=Message W=Warning
16	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
17	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
18	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
19	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.
20	SCR_REMOVE	Character(1)	VARCHAR2(1) NOT NULL	Remove Contact