SUP_RSN_CD (SQL Table)	Index Back
Installation Reason code setup

SUP_RSN_CD

(SQL Table)

Installation Reason code setup

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUP_INSTALL_KEY Character(1) VARCHAR2(1) NOT NULL Bid Factor List Items
Default Value: 1

2 SUP_REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason Type
ADR=Deny Registration
CRDR=Provide Additional Information
RFCB=Request Change Bidder Profile
RFCD=Deny Profile Change Request
RFCS=Request Supplier Profile Chg
RFI=Request Additional Information
SARD=Modify Registration Data
SBCR=Modify Change Request Data
WITH=Withdraw Request

3 REASON_CD_REQD Character(1) VARCHAR2(1) NOT NULL Reason Code
N=None
O=Optional
R=Required
Default Value: N

4 COMMENT_REQD Character(1) VARCHAR2(1) NOT NULL Comments Required
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUP_INSTALL_KEY	Character(1)	VARCHAR2(1) NOT NULL	Bid Factor List Items Default Value: 1
2	SUP_REASON_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Reason Type ADR=Deny Registration CRDR=Provide Additional Information RFCB=Request Change Bidder Profile RFCD=Deny Profile Change Request RFCS=Request Supplier Profile Chg RFI=Request Additional Information SARD=Modify Registration Data SBCR=Modify Change Request Data WITH=Withdraw Request
3	REASON_CD_REQD	Character(1)	VARCHAR2(1) NOT NULL	Reason Code N=None O=Optional R=Required Default Value: N
4	COMMENT_REQD	Character(1)	VARCHAR2(1) NOT NULL	Comments Required Y/N Table Edit Default Value: N