SUP_REGINSTRUCT

(SQL Table)
 Index Back

Supplier Onboard Reg Setup

Supplier Onboarding Registration Template Setup

  • Related Language Record: SUP_REGINST_LNG

    • # 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_REG_INST_DEFLT Character(1) VARCHAR2(1) NOT NULL Required Flag
    D=Always
    O=Allow Override

    Default Value: D

    4 REG_INSTRUCTION Long Character CLOB Registration Instructions
    5 SUP_REG_TERM_DEFLT Character(1) VARCHAR2(1) NOT NULL Required Flag
    D=Always
    O=Allow Override

    Default Value: D

    6 REQUIRED_FLAG Character(1) VARCHAR2(1) NOT NULL Required Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    7 SUP_TRM_DISP_FRMT Character(1) VARCHAR2(1) NOT NULL Display Format
    L=Long Text Field
    P=Printable Page

    Default Value: L

    8 SUP_SCR_INST_DEFLT Character(1) VARCHAR2(1) NOT NULL Required Flag
    D=Always
    O=Allow Override

    Default Value: D

    9 SCR_INSTRUCTION Long Character CLOB Change Request Instructions
    10 REG_ID_INST Character(254) VARCHAR2(254) NOT NULL Identifying Information Instr
    11 REG_ADDR_INST Character(254) VARCHAR2(254) NOT NULL Address Instructional Text
    12 REG_CNTCT_INST Character(254) VARCHAR2(254) NOT NULL Contact Instructional Test
    13 REG_PYMT_INST Character(254) VARCHAR2(254) NOT NULL Payment Instructional Text
    14 REG_CAT_INST Character(254) VARCHAR2(254) NOT NULL Category Instructional Text
    15 REG_SUBMIT_INST Character(254) VARCHAR2(254) NOT NULL Submit Instructional Text
    16 SCR_ID_INST Character(254) VARCHAR2(254) NOT NULL Company Profile Instructions
    17 SCR_ADDR_INST Character(254) VARCHAR2(254) NOT NULL Address Instructional Text
    18 SCR_CNTCT_INST Character(254) VARCHAR2(254) NOT NULL Contact Instructional Text
    19 SCR_PYMT_INST Character(254) VARCHAR2(254) NOT NULL Payment Instructional Text
    20 SCR_CAT_INST Character(254) VARCHAR2(254) NOT NULL Categorization Instructions
    21 SCR_SUBMIT_INST Character(254) VARCHAR2(254) NOT NULL Submit Instructional Text