PO_CAT_VND_TMP

(SQL Table)
 Index Back

Item Catalog Src Vndr Priority

This table is used by Basic Sourcing (B) if category level options are used, for the CAT_VNDR_PRIORITY. This table is ignored for Flexible Sourcing (F). This table is used by Schedule Split Sourcing (S) if category level options are used, for the percentage splits (PCT_ALLOC). This table is always used by Historic Split Sourcing (H) as historic sourcing does not have an item level option.

  • Parent record: ITM_CAT_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    3 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: SP_SETID_NONVW

    5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VNDR_VNDSET_VW

    6 CAT_VNDR_PRIORITY Number(5,0) INTEGER NOT NULL Supplier Priority
    7 CUM_SRC_RUN_LEVEL Character(1) VARCHAR2(1) NOT NULL Accumulate Level
    R=Run Level
    S=Schedule Level
    8 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
    9 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
    10 MERCH_AMT_CAT_TOT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Category Amount
    11 PCT_ACTUAL Number(3,0) SMALLINT NOT NULL Actual Allocated Percentage
    12 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage