RB_PROD_ATTR_VW

(SQL View)
 Index Back

attributes


SELECT A.SETID , A.PRODUCT_ID , A.ATTRIBUTE_ID , B.ATTR_NAME , A.ATTR_ITEM_ID , A.ATTRIBUTE_VALUE , A.ATTR_DATE , A.ATTR_NUMBER , B.ATTR_GROUP_ID , C.DESCR60 , C.ATTR_USAGE , A.MARKET FROM PS_PROD_ATTR A , PS_RB_ATTRIBUTE B , PS_RB_ATTR_GRP_VW C WHERE A.ATTRIBUTE_ID = B.ATTRIBUTE_ID AND B.ATTR_GROUP_ID = C.ATTR_GROUP_ID AND C.ATTR_GRP_MARKET = A.MARKET

  • Related Language Record: RB_PROD_ATTRLNG

    • # 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.
    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    3 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
    4 ATTRNAME Character(30) VARCHAR2(30) NOT NULL Pub/Sub Attribute Name
    5 ATTR_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Attribute Item ID
    6 ATTRIBUTE_VALUE Character(254) VARCHAR2(254) NOT NULL Attribute value
    7 ATTR_DATE Date(10) DATE Attribute Capture Date
    8 ATTR_NUMBER Signed Number(30,6) DECIMAL(28,6) NOT NULL Attribute Number
    9 ATTR_GROUP_ID Character(15) VARCHAR2(15) NOT NULL attribute group id field used by applications
    10 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    11 ATTR_USAGE Character(4) VARCHAR2(4) NOT NULL Attribute usage
    CONF=Configuration
    INFO=Information
    12 MARKET Character(3) VARCHAR2(3) NOT NULL Market