BUSINESS_UNITPrompt Table: SP_BUIN_NONVW
INV_ITEM_IDPrompt Table: BU_ITM_INV_VW
CONFIG_CODEEFFDTCOST_ELEMENTPrompt Table: CM_ELEMENT
SF_PCOST_DET_VW(SQL View) |
Index Back |
|---|---|
Cost Detail View by Cost Ele10/15/02 COST VIEW |
| SELECT BUSINESS_UNIT , INV_ITEM_ID , CONFIG_CODE , EFFDT , COST_ELEMENT , OP_SEQUENCE , SUM(TL_COST) , SUM(LL_COST) FROM PS_CM_PRODCOST_DET DET WHERE EFFDT = ( SELECT MAX(EFFDT) FROM PS_CM_PRODCOST_DET DT2 WHERE DT2.BUSINESS_UNIT=DET.BUSINESS_UNIT AND DT2.INV_ITEM_ID=DET.INV_ITEM_ID AND DT2.CONFIG_CODE=DET.CONFIG_CODE AND DT2.EFFDT<=%CurrentDateIn) GROUP BY BUSINESS_UNIT , INV_ITEM_ID , CONFIG_CODE , EFFDT , COST_ELEMENT,OP_SEQUENCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITM_INV_VW |
| 3 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | COST_ELEMENT |
Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CM_ELEMENT |
| 6 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 7 | TL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | This Level Cost |
| 8 | LL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Lower Level Cost |