CDT_PSPECS_VW

(SQL View)
 Index Back

Product Specifications

This record is used to store the product specification by Inventory Business Unit.

SELECT SETID , PRODUCT_ID , PROD_SPEC_TYPE_SEQ , SEQUENCE_NBR , WS_CONCAT_SPEC , WS_USE_AS_URL , URL_ID , DATETIME_ADDED , LASTUPDDTTM , LAST_MAINT_OPRID , DESCRLONG FROM PS_PROD_SPECS

  • Related Language Record: PROD_SPECS_LNG

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: PROD_ITEM

    3 PROD_SPEC_TYPE_SEQ Number(2,0) SMALLINT NOT NULL Sequence Number
    4 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
    5 WS_CONCAT_SPEC Character(1) VARCHAR2(1) NOT NULL Used on Prod Spec page to denote where two prod spec line should be combined into one.

    Y/N Table Edit

    Default Value: N

    6 WS_USE_AS_URL Character(1) VARCHAR2(1) NOT NULL Used on Prod specs to denote where a URL is used in a product spec line.
    H=Use As HTML
    T=Use As Text
    U=Use As URL

    Default Value: T

    7 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).

    Prompt Table: PSURLDEFN

    8 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
    9 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    10 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
    11 DESCRLONG Long Character CLOB Long Description