LISTPRC_CG_VW(SQL View) |
Index Back |
|---|---|
Cust group price list pricesReturns applicable price list prices for a given customer group for OM_PPRC_OUT. |
| SELECT R.SETID , COND.EOEP_CHAR_VAL , PL.PRICE_LIST_ID , PL.EFF_STATUS , PLD.EFF_STATUS , PLD.START_DT , PLD.END_DATE , PL.CURRENCY_CD , PLD.PRODUCT_ID , PLD.UNIT_OF_MEASURE , PLD.LIST_PRICE FROM PS_EOEP_RULE R , PS_EOEP_COND_VALUE COND , PS_EOEP_COND_GROUP CONJ , PS_EOEP_PRCLST_HDR PL , PS_EOEP_PRICE_LIST PLD , PS_EOEP_RULLST_LNK RL WHERE R.SETID = COND.SETID AND R.EOEP_RULE_ID = COND.EOEP_RULE_ID AND COND.SETID = CONJ.SETID AND COND.EOEP_RULE_ID = CONJ.EOEP_RULE_ID AND COND.EOEP_COND_SEQ = CONJ.EOEP_COND_SEQ AND CONJ.SETID = PL.SETID AND CONJ.EOEP_RULE_ID = RL.EOEP_RULE_ID AND PL.SETID = PLD.SETID AND PL.PRICE_LIST_ID = PLD.PRICE_LIST_ID AND PL.CURRENCY_CD = PLD.CURRENCY_CD AND PLD.SETID = RL.SETID AND PLD.PRICE_LIST_ID = RL.PRICE_LIST_ID AND PLD.CURRENCY_CD = RL.CURRENCY_CD AND R.EOEP_RULE_STATUS = 'D' AND R.EOEP_APP_CD = 'SO' AND COND.FIELDNAME = 'CUSTOMER_GROUP' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EOEP_CHAR_VAL | Character(128) | VARCHAR2(128) NOT NULL | Character value field |
| 3 | PRICE_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL | Price List ID |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | EFF_STATUS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status Flag
N=No Effective Status Y=Effective Status Exists |
| 6 | START_DT | Date(10) | DATE | Start Date |
| 7 | END_DATE | Date(10) | DATE | End Date |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 10 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 11 | LIST_PRICE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | List Price |