PROD_SPECS_TYPE

(SQL Table)
 Index Back

Product Specification type

Product specification type.

  • Related Language Record: PRD_SPECTYP_LNG

  • Parent Record Of PROD_SPECS

    • # 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 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 Product Spec Type Sequence
    4 PROD_SPECS_TYPE Character(30) VARCHAR2(30) NOT NULL Product Specifications Type
    5 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added
    6 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.
    7 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL This field determines the last user or operator that last changed this item.