SUP_REG_ID_NBRS

(SQL Table)
Index Back

Supplier Reg ID Numbers

Supplier Onboarding Registration Template Setup - ID Numbers

# 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 STD_ID_NUM_QUAL Character(3) VARCHAR2(3) NOT NULL Standard ID Number
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

5 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

Y/N Table Edit