SCR_LOC_SCR_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	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
5	EFFDT	Date(10)	DATE	Effective Date
6	SCR_EFFDT	Date(10)	DATE	Approved Changes Take Effect
7	SCR_CHG_EFF_WHEN	Character(1)	VARCHAR2(1) NOT NULL	Change Effective I=Approval Date S=Future Date
8	DEFAULT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Default Location
9	PRIMARY_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Primary Supplier
10	PRIM_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Invoicing Location
11	REMIT_SETID	Character(5)	VARCHAR2(5) NOT NULL	Remit SetID
12	REMIT_VENDOR	Character(10)	VARCHAR2(10) NOT NULL	Remit Vendor
13	REMIT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Remit to Location
14	REMIT_ADDR_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Remitting Location
15	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
16	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
17	COMMENTS	Long Character	CLOB	Comment
18	CCR_ADDR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	SAM Address Type
19	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
20	ENTERED_DTTM	DateTime(26)	TIMESTAMP	Entered Datetime
21	SCR_REMOVE	Character(1)	VARCHAR2(1) NOT NULL	Remove Contact