OPRIDSETIDPrompt Table: SP_SETTD_NONVW
PPRC_PROMO_CDPrompt Table: TD_PROM_AUTO_VW
LANGUAGE_CDTD_ALLOW_LNG_VW(SQL View) |
Index Back |
|---|---|
National Allowances Language |
| SELECT D.OPRID , A.SETID , A.PPRC_PROMO_CD , A_LNG.LANGUAGE_CD , A_LNG.DESCR , A_LNG.DESCRSHORT FROM PS_PPRC_PROMO_TBL A , PS_TD_ALLOW_MASTER B , PS_TD_TREE_NODE_VW D , PS_PPRC_PROTBL_LNG A_LNG , PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = A.SETID AND SC.RECNAME = 'PROD_ITEM' AND SC.SETID = D.SETID AND A.TD_TREE_ID_PROD = D.TD_TREE_ID AND %EffdtCheck(TD_TREE_HDR TH, D, %CurrentDateIn) AND A.SETID = B.SETID AND A.PPRC_PROMO_CD = B.PPRC_PROMO_CD AND A.PROMO_TYPE = 'A' AND (B.PROMO_GROUP = D.PROMO_GROUP OR B.PRODUCT_ID = D.PRODUCT_ID) AND A_LNG.SETID = A.SETID AND A_LNG.PPRC_PROMO_CD = A.PPRC_PROMO_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETTD_NONVW |
| 3 | PPRC_PROMO_CD |
Character(20) | VARCHAR2(20) NOT NULL |
Price Promotion Code
Prompt Table: TD_PROM_AUTO_VW |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |