UPG_CM_3_AET(SQL Table) |
Index Back |
|---|---|
Earned Conversion CostsPSG 10/9/97: If fields are added or deleted from sf_earnconcost, then a new copy of sf_earnconcost2 should be saved from sf_earnconcost. sf_earnconcost2 is used by Accounting COBOL and must always contain the exact same fields as sf_earnconcost. GMG CN# CM750-8.0 Changes for SEQ_NBR field; value assigned by Accounting to achieve unique rows. 02/26/99 SCC CN#SF800-9.0: Add field prdn_split |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MG_PROC_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 5 | 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 |
| 6 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 7 | 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.
Y/N Table Edit |
| 8 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 9 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 10 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 11 | 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 |
| 12 | CONVERSION_AMT | Signed Number(12,4) | DECIMAL(10,4) NOT NULL | Conversion Amount |
| 13 | RATE_AMOUNT | Number(11,4) | DECIMAL(10,4) NOT NULL | Rate Amount |
| 14 | RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Rate Per
HR=Hourly UN=Per Unit |
| 15 | OP_TIME_RATE | Number(9,2) | DECIMAL(8,2) NOT NULL | Operation Time/Rate |
| 16 | OP_TIME_RATE_UNIT | Character(2) | VARCHAR2(2) NOT NULL |
Operation Time/Rate Unit
DY=Days HR=Hours MN=Minutes UD=Units per Day UH=Units per Hour UM=Units per Minute |
| 17 | OVERHEAD_RATE | Number(11,4) | DECIMAL(10,4) NOT NULL | Conversion Overhead Rate |
| 18 | OVERHEAD_PERCENT | Number(5,1) | DECIMAL(4,1) NOT NULL | Conversion Overhead % |
| 19 | OH_RATE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Conversion Ovhd Rate Type
%L=% of Labor Amt %M=% of Mach Amt PL=Amt Per Labor Hr PM=Amt Per Mach Hr PU=Per Unit Amt |
| 20 | OH_LAB_MACH_AMT | Signed Number(12,4) | DECIMAL(10,4) NOT NULL | Lab/Mach Amt for Ovhd Cal |
| 21 | EARN_COST_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Earned Cost Quantity |
| 22 | PRORATE_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Maximum Quantity |
| 23 | PERCENT_COMP | Number(6,2) | DECIMAL(5,2) NOT NULL | Scrap Prdn Pct |
| 24 | DAILY_CAPACITY | Number(5,2) | DECIMAL(4,2) NOT NULL | Average Daily Hours |
| 25 | CREWSIZE | Number(7,2) | DECIMAL(6,2) NOT NULL | Crew Size |
| 26 | MACH_RESOURCES | Number(7,2) | DECIMAL(6,2) NOT NULL | Machine Resources |
| 27 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 28 | DISTRIB_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Distrib. Type |
| 29 | 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 |
| 30 | PRDN_SPLIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
02/26/99 SCC CN#SF800-9.0: New field.
Y/N Table Edit |
| 31 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 32 | TRANS_DATE | Date(10) | DATE | Transaction Date |
| 33 | TRANS_TIME | Time(15) | TIMESTAMP | Transaction Time |
| 34 | PROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All S=Only purge items with at least Y/N Table Edit |
| 35 | 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 |
| 36 | VARIANCE_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Variance Source
C=Close O=Re-Open R=Report |
| 37 | VARIANCE_AMOUNT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Variance Amount |
| 38 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 39 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |