CE_LLOTVARS_VW(SQL View) |
Index Back |
|---|---|
Labor Lot Size VarianceThis is the Cost Manager's view for Material Lot Size Variance. |
| SELECT BUSINESS_UNIT ,PRODUCTION_ID ,VARIANCE_TYPE ,COST_ELEMENT ,VAR_PRDN_QTY ,AOQ ,OP_SEQUENCE ,WORK_CENTER_CODE ,DAILY_CAPACITY ,OP_TIME ,OP_TIME_UNIT ,TIME_TYPE ,QTY_ISS_TO_OP ,RATE_AMOUNT ,RATE_TYPE ,OVHD_RATE_CODE ,OVERHEAD_PERCENT ,OVERHEAD_RATE ,SUM(VARIANCE_AMOUNT) ,SUM(VARIANCE_AMOUNT3) FROM PS_SF_VARS_DETAIL GROUP BY BUSINESS_UNIT ,PRODUCTION_ID ,VARIANCE_TYPE ,COST_ELEMENT ,VAR_PRDN_QTY ,AOQ ,OP_SEQUENCE ,WORK_CENTER_CODE ,DAILY_CAPACITY ,OP_TIME ,OP_TIME_UNIT ,TIME_TYPE ,QTY_ISS_TO_OP ,RATE_AMOUNT ,RATE_TYPE ,OVHD_RATE_CODE ,OVERHEAD_PERCENT ,OVERHEAD_RATE |
| # | 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 | 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. |
| 6 | AOQ | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Average Order Qty |
| 7 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 8 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 9 | DAILY_CAPACITY | Number(5,2) | DECIMAL(4,2) NOT NULL | Average Daily Hours |
| 10 | OP_TIME | Number(9,2) | DECIMAL(8,2) NOT NULL | Op Time |
| 11 | OP_TIME_UNIT | Character(2) | VARCHAR2(2) NOT NULL |
Time Unit
DY=Days HR=Hours MN=Minutes |
| 12 | TIME_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Time / Resource Type
0100=Planning Labor Setup 0200=Planning Labor Fixed Run 0300=Planning Labor Run 0400=Planning Labor Post Prod 0500=Planning Machine Setup 0600=Planning Machine Fixed Run 0700=Planning Machine Run 0800=Planning Machine Post Prod 1100=Costing Labor Setup 1200=Costing Labor Fixed Run 1300=Costing Labor Run 1400=Costing Labor Post Prod 1500=Costing Machine Setup 1600=Costing Machine Fixed Run 1700=Costing Machine Run 1800=Costing Machine Post Prod 2000=Queue Time 3000=Intransit Time |
| 13 | QTY_ISS_TO_OP | Number(12,4) | DECIMAL(11,4) NOT NULL | Quantity Issued to Operation |
| 14 | RATE_AMOUNT | Number(11,4) | DECIMAL(10,4) NOT NULL | Rate Amount |
| 15 | RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly UN=Per Unit |
| 16 | OVHD_RATE_CODE | Character(4) | VARCHAR2(4) NOT NULL | Conversion Ovhd Rate Code |
| 17 | OVERHEAD_PERCENT | Number(5,1) | DECIMAL(4,1) NOT NULL | Conversion Overhead % |
| 18 | OVERHEAD_RATE | Number(11,4) | DECIMAL(10,4) NOT NULL | Conversion Overhead Rate |
| 19 | VARIANCE_AMOUNT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Variance Amount |
| 20 | VARIANCE_AMOUNT3 | Signed Number(18,6) | DECIMAL(16,6) NOT NULL | Variance Amount with decimal precision of 6 used by Variance Drilldown. |