RO_DISPLAY_TEMP

(SQL Table)
 Index Back

Display Template

Generic display template field

  • Related Language Record: RO_DISPLAY_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TEMPLATE_ID_NUM Number(5,0) INTEGER NOT NULL Template information for catalog used for catalog design
    2 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    3 DEFAULT_DISP_TEMP Character(1) VARCHAR2(1) NOT NULL Default Display Template

    Y/N Table Edit

    Default Value: N

    4 RO_PCTMPPAGENAME Character(4) VARCHAR2(4) NOT NULL Field used in catalog and has translate values.
    MAIN=Catalog Main Page
    PCOM=Product Compare Page
    PDET=Product Details Page
    PDIS=Product Display Page

    Default Value: MAIN

    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    7 RO_PCTMPNEST Character(1) VARCHAR2(1) NOT NULL Field used as checkbox in catalog setup

    Y/N Table Edit

    Default Value: N

    8 RO_PCTMPNESTALL Character(1) VARCHAR2(1) NOT NULL Field used as check box in catalog setup

    Y/N Table Edit

    Default Value: N

    9 RO_PCTMPPRODS Character(1) VARCHAR2(1) NOT NULL Field used as check box and used in product catalog

    Y/N Table Edit

    Default Value: N

    10 RO_PCTMPFILLER Character(1) VARCHAR2(1) NOT NULL This field is used in product catalog to show the borderCatalog

    Y/N Table Edit

    Default Value: N

    11 RO_PCTMPLONG Character(1) VARCHAR2(1) NOT NULL Field used as check box in catalog setup

    Y/N Table Edit

    Default Value: N

    12 PSIMAGEVER Number(10,0) DECIMAL(10) NOT NULL Image Version
    13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    14 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    15 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    16 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    17 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    18 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    19 PROD_IMG_JPG Image / Attachment CLOB Product Image JPG