DFW_SF_VARNCES(SQL View) |
Index Back |
---|
SELECT DISTINCT BUSINESS_UNIT , PRODUCTION_ID , VARIANCE_TYPE , COST_ELEMENT , VARIANCE_SOURCE , TRANS_TIME , VARIANCE_AMOUNT FROM PS_SF_VARIANCES |
# | 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
Prompt Table: CM_ELEMENT |
5 | VARIANCE_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Variance Source
C=Close O=Re-Open R=Report |
6 | TRANS_TIME | Time(15) | TIMESTAMP NOT NULL | Transaction Time |
7 | VARIANCE_AMOUNT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Variance Amount |