EOCM_NEW_OFFCAT

(SQL Table)
Index Back

Relation between prods/cats

Relation between prods/cats after categorization

  • Parent record: EOCM_OFFER_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
    3 EOCM_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID
    4 EOCM_TP_VER_ID Number(3,0) SMALLINT NOT NULL trading partner version id
    5 EOCM_OFFER_ID Character(32) VARCHAR2(32) NOT NULL Offering ID
    6 EOCM_CATEGORY_ID Character(32) VARCHAR2(32) NOT NULL Category ID

    Prompt Table: EOCM_CATEG_VW

    7 EOCM_PRIMARY_CATEG Character(1) VARCHAR2(1) NOT NULL Primary category for Offering

    Y/N Table Edit

    Default Value: N