SCR_HEADER

(SQL Table)
Index Back

Supplier Change Request Header

Primary record for SCR transactions

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCR_ID Character(15) VARCHAR2(15) NOT NULL Supplier Change Request ID
2 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 LAST_SEQ_NUM Number(5,0) INTEGER NOT NULL Last Sequence Number
6 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
7 SCR_STATUS Character(1) VARCHAR2(1) NOT NULL Status
A=Approved
B=Request Editor More Info..
B=Request Editor More Info..
C=Pending Editor Review
C=Pending Editor Review
E=Update Error
I=Integrity Error
M=Request Additional Information
P=Pending Approval
R=Rejected
S=Save for Later
U=Database Updated
W=Withdrawn
8 MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity
C=Cancel
E=Error
M=Message
W=Warning
9 VNDR_AUDIT_FLG Character(1) VARCHAR2(1) NOT NULL Supplier Audit

Y/N Table Edit

Default Value: N

10 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
11 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
12 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
13 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
14 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
15 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.