SPF_REQ_SUP_LST

(SQL Table)
 Index Back

SP Req Splr Preference List

Used to link a preferred supplier list to a requisition the requester can request the recruiter to use these suppliers.

  • Parent record: SPF_REQ_LINE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_SP_NONVW

    2 SP_REQ_ID Character(10) VARCHAR2(10) NOT NULL Service Request ID

    Default Value: NEXT

    3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

    Default Value: 1

    4 SERV_VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Services Supplier Id

    Prompt Table: %EDITTABLE2
    Set Control Field: BUSINESS_UNIT

    5 SPM_SOURCETYPE Character(4) VARCHAR2(4) NOT NULL Supplier Network Source Type
    0=Internal
    1=Primary
    2=Secondary
    3=Tertiary
    6 SPF_PAYROLL_RSRC Character(1) VARCHAR2(1) NOT NULL Payroll Resource field

    Y/N Table Edit

    Default Value: N

    7 SRC_PREFERED Character(1) VARCHAR2(1) NOT NULL Source to Preffered Suppliers

    Y/N Table Edit

    8 CHNG_ORD_SEQ Number(3,0) SMALLINT NOT NULL Change Order Sequence Number
    9 COMMENTS Long Character CLOB Comment