SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
RA_OFFER_IDPrompt Table: RA_OFFER
ARCH=Archived
CMPL=Completed
DECL=Declined
IREV=In Review
NEW=New
PLAN=Planning
RA_OFFER_SR_VW(SQL View) |
Index Back |
|---|---|
Offer Search viewOffer Search view |
| SELECT A.SETID , A.RA_OFFER_ID , B.PRICE_SET_ID , A.RA_OFFER_NAME , A.RA_OFFER_STATUS , A.BO_ID_OWNER FROM PS_RA_OFFER A , PS_RA_OFFER_PRCSET B WHERE A.SETID = B.SETID AND A.PRICE_SET_ID = B.PRICE_SET_ID |
| # | 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 | RA_OFFER_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Marketing Offer ID
Prompt Table: RA_OFFER |
| 3 | PRICE_SET_ID | Character(10) | VARCHAR2(10) NOT NULL | Price Rule |
| 4 | RA_OFFER_NAME | Character(50) | VARCHAR2(50) NOT NULL | Marketing Offer Name |
| 5 | RA_OFFER_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Marketing Offer status
ARCH=Archived CMPL=Completed DECL=Declined IREV=In Review NEW=New PLAN=Planning |
| 6 | BO_ID_OWNER | Number(31,0) | DECIMAL(31) NOT NULL | Financial Account Business Object ID |