SETIDPPRC_PROMO_CDTD_CNSMPTN_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID , A.PPRC_PROMO_CD FROM PS_TD_PRO_MERC_CUS A , PS_TD_MERCH_TYPE B , PS_SET_CNTRL_REC C WHERE A.SETID = C.SETCNTRLVALUE AND C.SETCNTRLVALUE = A.SETID AND C.RECNAME = 'TD_PRO_MERC_CUS' AND B.MERCH_TYPE = A.MERCH_TYPE AND B.MERCH_ACTIVITY = 'C' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PPRC_PROMO_CD |
Character(20) | VARCHAR2(20) NOT NULL | Price Promotion Code |