BUSINESS_UNITPPRC_PROMO_CDPrompt Table:
PPRC_PROMO_TBL
Set Control Field: BUSINESS_UNIT
MERCH_TYPEPrompt Table:
TD_MERCH_TYPE
Set Control Field: BUSINESS_UNIT
RMA_MERTYPE_VW(SQL View) |
Index Back |
|---|---|
RMA Merch Type ViewRMA Merch Type View |
| SELECT U.BUSINESS_UNIT , P.PPRC_PROMO_CD , P.MERCH_TYPE , M.DESCR FROM PS_BUS_UNIT_TBL_FS U , PS_TD_PRO_MERC_CUS P , PS_TD_MERCH_TYP_VW M , PS_SET_CNTRL_REC SA WHERE SA.RECNAME = 'PPRC_PROMO_TBL' AND SA.SETCNTRLVALUE = U.BUSINESS_UNIT AND SA.SETID = P.SETID AND P.SETID = M.SETID AND P.MERCH_TYPE = M.MERCH_TYPE AND P.EOEP_RULE_ID <> ' ' AND P.TD_ADJUST_TYPE <> 'LS' AND M.MERCH_ACTIVITY = 'P' AND P.RETURN_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PPRC_PROMO_CD |
Character(20) | VARCHAR2(20) NOT NULL |
Price Promotion Code
Prompt Table:
PPRC_PROMO_TBL
|
| 3 | MERCH_TYPE |
Character(10) | VARCHAR2(10) NOT NULL |
Merchandising Type
Prompt Table:
TD_MERCH_TYPE
|
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |