CM_INQ_LPRC_VW(SQL View) |
Index Back |
|---|---|
List Price View |
| SELECT A.SETID , B.INV_ITEM_ID , A.PRODUCT_ID , A.UNIT_OF_MEASURE , A.BUSINESS_UNIT_IN , A.CURRENCY_CD , A.EFFDT , A.EFF_STATUS , A.LIST_PRICE , A.UNIT_COST , A.SERVICE_COST , A.REPAIR_COST , A.MFG_SUG_RTL_PRC FROM PS_PROD_PRICE A , PS_PROD_ITEM B WHERE %Join(COMMON_KEYS, PROD_PRICE A, PROD_ITEM B) AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_PROD_PRICE C WHERE %Join(COMMON_KEYS, PROD_PRICE C, PROD_PRICE A) AND C.EFFDT <= %CurrentDateIn AND A.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: PRICSET_PROD_VW |
| 4 | UNIT_OF_MEASURE |
Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: PROD_UOM |
| 5 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
| 6 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 7 | EFFDT |
Date(10) | DATE | Effective Date |
| 8 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 9 | LIST_PRICE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | List Price |
| 10 | UNIT_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Unit Cost |
| 11 | SERVICE_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Service Cost |
| 12 | REPAIR_COST | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Repair Cost |
| 13 | MFG_SUG_RTL_PRC | Number(16,4) | DECIMAL(15,4) NOT NULL | Manufactures's Suggested Retai |