CE_ITEMCOST2_VW(SQL View) |
Index Back |
|---|---|
Item Cost by Cost Type/* Fix bug EPNT084-VQ0OQ , eyz 2/17/98, Select only those items which source_code is not floor stock. */ 05/17/99 Lee CN# EN800-4.0 Excluded source_code 3 (expensed) and 6 (planning) 6/3/99 cel Added bom_code and rtg_code as fields/keys 09/19/00 cel Modified the view to use the tlp and llp cost columns instead of the tl, ll cost columns. Cost rollup now uses these new columns which normally match the other columns except for phantom costs which can have a higher precision. |
| SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CONFIG_CODE , A.CE_COST_TYPE , A.COST_VERSION , A.BOM_CODE , A.RTG_CODE , A.COST_ELEMENT , A.TL_COST , A.LL_COST , A.TLP_COST , A.LLP_COST FROM PS_CE_ITEMCOST A , PS_BU_ITEMS_INV B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND B.SOURCE_CODE NOT IN ('3','5','6') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MG_ITEM_OWN_VW |
| 3 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL |
Product Configurator
Prompt Table: CP_CONFIG_VW |
| 4 | CE_COST_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Cost Type
Prompt Table: CE_TYPE |
| 5 | COST_VERSION |
Character(10) | VARCHAR2(10) NOT NULL |
Cost Version
Prompt Table: CE_VERSION |
| 6 | BOM_CODE |
Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 7 | RTG_CODE |
Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 8 | COST_ELEMENT |
Character(4) | VARCHAR2(4) NOT NULL |
Cost Element
Prompt Table: CM_ELEMENT |
| 9 | TL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | This Level Cost |
| 10 | LL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Lower Level Cost |
| 11 | TLP_COST | Number(19,8) | DECIMAL(18,8) NOT NULL | This Level Cost |
| 12 | LLP_COST | Number(19,8) | DECIMAL(18,8) NOT NULL | Lower Level Cost |