SUP_REG_LOCINFO (SQL Table)	Index Back
Supplier Onboard Reg Setup Supplier Onboarding Registration Template Setup

SUP_REG_LOCINFO

(SQL Table)

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_LOC_INFO_CD Character(3) VARCHAR2(3) NOT NULL Supplier Location Information
ATT=Attachment
BAO=Bank Account Options
COM=Comments
GWH=Global1099 Withholding
NAM=Additional ID Numbers
PAY=Payment Notifications
PIR=Payment Terms, Invoice, Remit
SIC=SIC Codes
SUT=Sales/Use Tax
VAT=VAT Registration
WIN=Withholding Information
WRI=Withholding Report Information

4 SUP_LOC_INFO_DESCR Character(50) VARCHAR2(50) 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_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag
Y/N Table Edit
Default Value: N

#	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_LOC_INFO_CD	Character(3)	VARCHAR2(3) NOT NULL	Supplier Location Information ATT=Attachment BAO=Bank Account Options COM=Comments GWH=Global1099 Withholding NAM=Additional ID Numbers PAY=Payment Notifications PIR=Payment Terms, Invoice, Remit SIC=SIC Codes SUT=Sales/Use Tax VAT=VAT Registration WIN=Withholding Information WRI=Withholding Report Information
4	SUP_LOC_INFO_DESCR	Character(50)	VARCHAR2(50) 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_FLG	Character(1)	VARCHAR2(1) NOT NULL	Required Flag Y/N Table Edit Default Value: N