SUP_REG_HDRINFO

(SQL Table)
Index Back

Supplier Onboard Reg Setup

Supplier Onboarding Registration Template Setup

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id
2 SUPOB_REG_OPT_TYPE Character(2) VARCHAR2(2) NOT NULL On boarding manage invite options
AD=Ad-hoc Tasks
NB=Register New Bidders
NS=Register New Suppliers
NU=Register New User Accounts
PC=Profile Change Request
RB=Request Change for Bidder
RS=Request Supplier Change
3 SUP_HDR_INFO_CD Character(3) VARCHAR2(3) NOT NULL Supplier Header Information
ADN=Additional ID Numbers
ATT=Attachments
CLS=Classification
DUP=Duplicate Invoice Settings
GOV=Government Classifications
LOG=Logos
NAM=Additional Name
OPO=Open for PO
PRT=Persistence
RAT=Supplier Rating
RPT=Additional Reporting Elements
SIC=SIC Codes
SNA=Short Name
SRE=Supplier Relationships
STA=Supplier Status
VAT=VAT Registration
WTH=Withholding
4 SUP_HDR_INFO_DESCR Character(30) VARCHAR2(30) NOT NULL Attribute Description
5 SUP_DATA_ENTRY_OPT Character(1) VARCHAR2(1) NOT NULL Data Entry Option
N=Do Not Display
Y=Allow User Entry

Default Value: N

6 SUP_USER_TYPE Character(1) VARCHAR2(1) NOT NULL User Type
I=Internal
P=Public
7 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
N=No
Y=Yes

Y/N Table Edit

Default Value: N