SUP_REG_ID_NBRS(SQL Table) |
Index Back |
|---|---|
Supplier Reg ID NumbersSupplier 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 |