UPG_CM_2_AET(SQL Table) |
Index Back |
|---|---|
Production VariancesPSG 10/9/97: If fields are added or deleted from sf_variances, then a new copy of sf_variances2 should be saved from sf_variances. sf_variances2 is us |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | MG_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 7 | 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 |
| 8 | VARIANCE_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Variance Source
C=Close O=Re-Open R=Report |
| 9 | CONVERSION_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Conversion Type
1100=Lab Setup 1200=Lab Fixed 1300=Labor Run 1400=Lab PostPr 1500=Mach Setup 1600=Mach Fixed 1700=Mach Run 1800=MC PostPrd 2100=Ovhd 1 2200=Ovhd 2 2300=Ovhd 3 2400=Ovhd 4 |
| 10 | 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 |
| 11 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 12 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 13 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 14 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 15 | REVALUE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated. |
| 16 | TRANS_DATE | Date(10) | DATE | Transaction Date |
| 17 | TRANS_TIME | Time(15) | TIMESTAMP | Transaction Time |
| 18 | VARIANCE_AMOUNT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Variance Amount |
| 19 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
| 20 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 21 | PRODUCTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
| 22 | POSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted X=Don't Post Y=Posted |