CE_MLOTVARS_VW(SQL View) |
Index Back |
|---|---|
Operation Yield Variance |
| SELECT BUSINESS_UNIT ,PRODUCTION_ID ,VARIANCE_TYPE ,COST_ELEMENT ,COMPONENT_ID ,VAR_PRDN_QTY ,SF_QTY_PER ,ISSUE_QTY ,YIELD ,AOQ ,TL_COST ,LL_COST ,SUM(VARIANCE_AMOUNT) ,SUM(VARIANCE_AMOUNT3) FROM PS_SF_VARS_DETAIL GROUP BY BUSINESS_UNIT ,PRODUCTION_ID ,VARIANCE_TYPE ,COST_ELEMENT ,COMPONENT_ID ,VAR_PRDN_QTY ,SF_QTY_PER ,ISSUE_QTY ,YIELD ,AOQ ,TL_COST ,LL_COST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 3 | VARIANCE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
9/9/02 CRC: added variance type '15' for Yield Variance
01=Configuration Variance 02=Usage Variance 03=Component Yield Variance 04=Labor Lot Size Variance 05=Process Routing Variance 06=Efficiency Variance 07=Rate Variance 08=Material Lot Size Variance 09=Rework Expense 10=Rework Labor Expense 11=Outside Processing PPV 12=Mix Variance 13=Teardown Material Expense 14=Teardown Conversion Expense 15=Yield Variance 16=Co-Product Rate Var 17=Material Rate Variance |
| 4 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 5 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 6 | VAR_PRDN_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Variance Production Quantity This field was created on 05/06/2010 and will be used by the Variance Drilldown inquiry to show how Configuration variance and Material Lot Size variance are calculated during the Production Close. If the user has selected to close Production with remaining assemblies, then this field will be the sum of SF_PRDNID_HEADR.COMPLETED_QTY & SCRAP_QTY. Otherwise, it will be set to the value of SF_PRDNID_HEADR.NEW_PRDN_QTY. |
| 7 | SF_QTY_PER | Number(16,10) | DECIMAL(15,10) NOT NULL | 07/06/99 SCC CN# SF800-9.0: Added label Quantity |
| 8 | ISSUE_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY |
| 9 | YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Component Yield |
| 10 | AOQ | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Average Order Qty |
| 11 | TL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | This Level Cost |
| 12 | LL_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Lower Level Cost |
| 13 | VARIANCE_AMOUNT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Variance Amount |
| 14 | VARIANCE_AMOUNT3 | Signed Number(18,6) | DECIMAL(16,6) NOT NULL | Variance Amount with decimal precision of 6 used by Variance Drilldown. |