SCR_HDR_ATT_DFT

(SQL Table)
Index Back

Supplier Attachments

Supplier Attachments

# 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
5 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.
6 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.
7 SERVER_ID Number(4,0) SMALLINT NOT NULL File Server ID

Prompt Table: PV_ATT_SERVERS

8 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
9 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.
10 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
11 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
12 SCR_CHNG_TYPE Character(1) VARCHAR2(1) NOT NULL Request for Change Type
A=Add
D=Delete
I=Inactivate
U=Update
13 SCR_REMOVE Character(1) VARCHAR2(1) NOT NULL Remove Contact
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.