RO_CATALOG_VW

(SQL View)
 Index Back

Product Catalog

View of Product Catalog by SetId and Catalog Id. used in oc

SELECT A.SETID , A.CATALOG_ID_NUM , A.DESCR , A.TEMPLATE_ID_NUM , A.CAT_CHANNEL , A.BEGIN_DT , A.END_DATE , A.STATUS FROM PS_RO_PRD_CATALOG A

  • Related Language Record: RO_CATALOG_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 CATALOG_ID_NUM Number(5,0) INTEGER NOT NULL Catalog ID

    Default Value: 0

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 TEMPLATE_ID_NUM Number(5,0) INTEGER NOT NULL Template information for catalog used for catalog design

    Prompt Table: RO_DISTMP_A_VW

    5 CAT_CHANNEL Character(2) VARCHAR2(2) NOT NULL Channel
    01=Internal
    02=Web Self-Service
    03=All Channels

    Default Value: 03

    6 BEGIN_DT Date(10) DATE NOT NULL Begin Date

    Default Value: %date

    7 END_DATE Date(10) DATE End date field to store an end date.
    8 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A