RO_PK_OFFER_VW(SQL View) |
Index Back |
---|---|
Pricing Campaign OfferThis view is used for Pricing Campaign Offer Description |
SELECT setid , ra_offer_id , ra_offer_name FROM PS_RA_OFFER |
# | 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 | RA_OFFER_ID | Character(15) | VARCHAR2(15) NOT NULL | Marketing Offer ID |
3 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |