PW_ATTR_ITEM_VW

(SQL View)
 Index Back

Pricing by Attribute and Item

Pricing by Attribute and Item for pricing key

SELECT RTRIM(ATTRIBUTE_ID) %Concat ':' %Concat RTRIM(ATTR_ITEM_ID) , RTRIM(ATTRIBUTE_ID) %Concat ':' %Concat RTRIM(ATTR_ITEM_VALUE) FROM PS_RB_ATTR_ITEM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ATTR_AND_ITEM Character(254) VARCHAR2(254) NOT NULL Attribute and Item concatenation
2 EOEP_CHAR Character(254) VARCHAR2(254) NOT NULL Long field