SCR_LOC_SCR_MST

#	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 Prompt Table: VNDR_VNDSET_VW
5	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	SCR_CHNG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Request for Change Type A=Add D=Delete I=Inactivate U=Update
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	FMS_DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the original entry.
20	FMS_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the original entry.
21	FMS_LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry.
22	FMS_LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry.