SCR_LOC_ATT_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	SCM_ATTACH_ID	Character(64)	VARCHAR2(64) NOT NULL	The unique ID of each file whose attachment was handled by the attachment utility. Unique across all attachments, all applications.
5	ATT_VERSION	Number(3,0)	SMALLINT NOT NULL	The version of the attached file. Currently always 1, this field will find more use once the attachment utitlity starts supporting versioning of files.
6	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
7	SHOW_APPROVAL	Character(1)	VARCHAR2(1) NOT NULL	Flag for whether something should be shown to the approver Y/N Table Edit
8	ATTACH_DESCR	Character(100)	VARCHAR2(100) NOT NULL	A description of the file being attached. This field is provided as a convenience to app developers and customers. The attachment utility does not interpret its value in any way, simply storing it as set by the application.
9	SERVER_ID	Number(4,0)	SMALLINT NOT NULL	File Server ID
10	SERVER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	One of type ftp or DB, marks each registered attachment server. D=Database server F=FTP server U=URL Server
11	SERVER_PATH	Character(254)	VARCHAR2(254) NOT NULL	For attached files already uploaded to an ftp server, the path under the ftp root directory in which the file is to be found.
12	ATTACHSYSFILENAME	Character(128)	VARCHAR2(128) NOT NULL	Unique Sys Filename
13	ATTACHUSERFILE	Character(64)	VARCHAR2(64) NOT NULL	Attached File
14	SCR_REMOVE	Character(1)	VARCHAR2(1) NOT NULL	Remove Contact
15	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
16	ENTERED_DTTM	DateTime(26)	TIMESTAMP	Entered Datetime