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 |