SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
PRICE_LIST_IDCURRENCY_CDPrompt Table: EOEP_APPCODE_VW
EOEP_RULELST_V2(SQL View) |
Index Back |
|---|---|
Active Price Rule Price ListThis Lists active Price Lists tied to a Price Rule. The Price Rule is not a displayed column. |
| SELECT DISTINCT a.setid , a.price_list_id , a.currency_cd , c.eoep_app_cd FROM ps_eoep_rullst_lnk a , ps_eoep_prclst_hdr b , PS_EOEP_RULE c WHERE a.setid = b.setid AND a.price_list_id = b.price_list_id AND a.setid = c.setid AND a.eoep_rule_id = c.eoep_rule_id AND a.currency_cd = b.currency_cd AND b.eff_status = 'A' AND c.eoep_rule_status = 'D' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | PRICE_LIST_ID |
Character(10) | VARCHAR2(10) NOT NULL | Price List ID |
| 3 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 4 | EOEP_APP_CD | Character(4) | VARCHAR2(4) NOT NULL |
Transaction Code
Prompt Table: EOEP_APPCODE_VW |