CFG_OUTPUT_TBL

(SQL Table)
Index Back

Configurator

Translation field of pricing types for Configurator Price tab

  • Parent Record Of CFG_MAPTO_TBL CFG_RQST_HDR
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CFG_SCHEMA_ID Character(18) VARCHAR2(18) NOT NULL Schema ID displayed on several pages of Configurator
    2 CFG_INCL_PRICE Character(1) VARCHAR2(1) NOT NULL Y/N Value on Configurator Price tab to indicate that the configuration will/will not contain list prices
    N=Product Definition
    Y=Configurator

    Default Value: N

    3 CFG_INCL_CMPDV Character(1) VARCHAR2(1) NOT NULL Check box on Configurator Output tab to indicate that compound level violations should be shown

    Y/N Table Edit

    Default Value: N

    4 CFG_INCL_PKGCMPT Character(1) VARCHAR2(1) NOT NULL Check box on Configurator Output tab to indicate that packaged components should be included

    Y/N Table Edit

    Default Value: N

    5 CFG_INCL_MFGCMPT Character(1) VARCHAR2(1) NOT NULL Check box on Configurator Output tab to indicate that manufactured components should be included

    Y/N Table Edit

    Default Value: N

    6 CFG_INCL_RTGOPR Character(1) VARCHAR2(1) NOT NULL Check box on Configurator Output tab to indicate that routing operations should be included

    Y/N Table Edit

    Default Value: N

    7 CFG_INCL_PRCHCMPT Character(1) VARCHAR2(1) NOT NULL Check box on Configurator Output tab to indicate that purchased components should be included

    Y/N Table Edit

    Default Value: N

    8 CFG_INCL_PRDSELECT Character(1) VARCHAR2(1) NOT NULL Check box on Configurator Output tab to indicate that product selector should be included

    Y/N Table Edit

    Default Value: N

    9 CFG_INCL_RPRICE Character(1) VARCHAR2(1) NOT NULL Recurring List Price Source
    N=Product Definition
    Y=Configurator

    Default Value: N

    10 CFG_INCL_DELTA Character(1) VARCHAR2(1) NOT NULL Check box on Configurator Output tab to indicate that delta information should be included

    Y/N Table Edit

    11 CFG_OUTPUT_TYPE Character(1) VARCHAR2(1) NOT NULL This field is used to specify the output type for the schema. It can be set to either custom or default.
    0=Default XML
    1=Custom XML

    Default Value: 0

    12 CFG_XML_DATA Long Character CLOB Configurator
    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