PROCESS_INSTANCEBUSINESS_UNITINV_ITEM_IDCONFIG_CODEREVALUE_TYPE01=Inventory
02=Inspection
03=WIP - Comp
04=WIP - Assy
05=WIP - Waste
CE_ITEMCPST_VW(SQL View) |
Index Back |
|---|---|
Posted Item Cost Variance View |
| select process_instance, business_unit, inv_item_id, config_code, revalue_type, sum(var_tl_cost+var_ll_cost), sum(new_tl_cost+new_ll_cost), sum(prd_tl_cost+prd_ll_cost) from PS_CE_ITEMCVAR_PST group by process_instance, business_unit, inv_item_id, config_code, revalue_type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | CONFIG_CODE |
Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 5 | REVALUE_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
1/25/99 - CRC EN800-6.0 : added revalue type = '05' for co/by product
01=Inventory 02=Inspection 03=WIP - Comp 04=WIP - Assy 05=WIP - Waste |
| 6 | CE_ITEM_VAR_AMT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Item Cost Variance Amount |
| 7 | CE_ITEM_NEW_AMT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Item Cost New Amount |
| 8 | CE_ITEM_PRD_AMT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Prdn Amount |