SUP_OB_TEMPLATE_IDSUPOB_REG_OPT_TYPEAD=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
LANGUAGE_CDSUP_REGINST_LNG(SQL Table) |
Index Back |
|---|
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | REG_INSTRUCTION | Long Character | CLOB | Registration Instructions |
| 5 | SCR_INSTRUCTION | Long Character | CLOB | Change Request Instructions |
| 6 | SCR_ID_INST | Character(254) | VARCHAR2(254) NOT NULL | Company Profile Instructions |
| 7 | SCR_ADDR_INST | Character(254) | VARCHAR2(254) NOT NULL | Address Instructional Text |
| 8 | SCR_CNTCT_INST | Character(254) | VARCHAR2(254) NOT NULL | Contact Instructional Text |
| 9 | SCR_PYMT_INST | Character(254) | VARCHAR2(254) NOT NULL | Payment Instructional Text |
| 10 | SCR_CAT_INST | Character(254) | VARCHAR2(254) NOT NULL | Categorization Instructions |
| 11 | SCR_SUBMIT_INST | Character(254) | VARCHAR2(254) NOT NULL | Submit Instructional Text |
| 12 | REG_ID_INST | Character(254) | VARCHAR2(254) NOT NULL | Identifying Information Instr |
| 13 | REG_ADDR_INST | Character(254) | VARCHAR2(254) NOT NULL | Address Instructional Text |
| 14 | REG_CNTCT_INST | Character(254) | VARCHAR2(254) NOT NULL | Contact Instructional Test |
| 15 | REG_PYMT_INST | Character(254) | VARCHAR2(254) NOT NULL | Payment Instructional Text |
| 16 | REG_CAT_INST | Character(254) | VARCHAR2(254) NOT NULL | Category Instructional Text |
| 17 | REG_SUBMIT_INST | Character(254) | VARCHAR2(254) NOT NULL | Submit Instructional Text |