EOCM_CATALOG

(SQL Table)
 Index Back

Catalog Record

Main Catalog Record

  • Parent Record Of EOCM_CATALOG_TP EOCM_CRMRP_TBL EOCM_CTLG_TP_VW EOCM_ELMRP_TBL EOCM_EPRORP_TBL EOCM_GENTBLC_VW EOCM_GENTBLP_VW EOCM_GENTBL_VW EOCM_GENT_TMP EOCM_GENU_A_TBL EOCM_GENU_P_TBL EOCM_GEN_AET EOCM_GEN_TBL EOCM_GEN_TMP EOCM_GNT2_TMP EOCM_GNTB_A_VW EOCM_GNTB_P_VW EOCM_NEWGEN_TBL EOCM_NEWGN2_TMP EOCM_NEWOFF_TBL EOCM_OFFER_TBL EOCM_OFF_TMP EOCM_WORKFLOW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
    3 EOCM_CATALOG_NM Character(32) VARCHAR2(32) NOT NULL Catalog Name
    4 EOCM_CAT_DESCR Character(254) VARCHAR2(254) NOT NULL Cat description field
    5 EOCM_CATALOG_TYPE Character(1) VARCHAR2(1) NOT NULL Catalog Type
    1=Customer Catalog
    2=Procurement Catalog
    3=Training Catalog
    6 EOCM_CATALOG_DT Date(10) DATE Catalog Creation Date
    7 EOCM_ROW_NUM Number(11,0) DECIMAL(11) NOT NULL Row Number - This field is used to get the mins, secs as the unique tag for the offer id
    8 EOCM_OFFER_NUM Number(11,0) DECIMAL(11) NOT NULL Offer Number
    9 EOCM_EXPRESS_CAT Character(1) VARCHAR2(1) NOT NULL Express Catalog Flag Type

    Y/N Table Edit

    Default Value: N

    10 EOCM_QUICK_ITMLOAD Character(1) VARCHAR2(1) NOT NULL Quick Item Load Flag
    N=Step by Step Load
    Y=Quick Load

    Y/N Table Edit

    Default Value: N

    11 EOCM_PSMSTMAP Character(1) VARCHAR2(1) NOT NULL Use Standard PS Master MAP

    Y/N Table Edit

    Default Value: N

    12 EOCM_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Catalog Management Map Object

    Prompt Table: EOCM_MAP_MST