ITM_CAT_VNDR

(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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 CATEGORY_TYPE Character(3) VARCHAR2(3) NOT NULL Category Type
    PSF=User Def
    UNS=UN/SPSC

    Default Value: INSTALLATION_PO.CATEGORY_TYPE

    3 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: VNDR_VNDSET_VW

    7 CAT_VNDR_PRIORITY Number(5,0) INTEGER NOT NULL Supplier Priority
    8 PCT_ALLOC Number(3,0) SMALLINT NOT NULL Allocation Percentage
    9 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
    10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: ITM_CAT_TBL.CURRENCY_CD