SETIDEOEP_RULE_IDPRICE_LIST_IDCURRENCY_CDA=Active
I=Inactive
Default Value: A
EOEP_RULELST_VW(SQL View) |
Index Back |
|---|---|
Price Rule Price ListPrice Rule Price List |
| SELECT a.setid , a.eoep_rule_id , a.price_list_id , a.currency_cd , b.eff_status FROM ps_eoep_rullst_lnk a , PS_EOEP_PRCLST_HDR b WHERE a.setid = b.setid AND a.price_list_id = b.price_list_id AND a.currency_cd = b.currency_cd AND b.eff_status = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EOEP_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 3 | PRICE_LIST_ID |
Character(10) | VARCHAR2(10) NOT NULL | Price List ID |
| 4 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |