SF_EARNCON2_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.PRODUCTION_ID , A.OP_SEQUENCE , A.CONVERSION_TYPE , A.COST_ELEMENT , SUM( A.CONVERSION_AMT) , SUM(A.OH_LAB_MACH_AMT) , 0 , A.INV_ITEM_ID FROM PS_SF_EARNCONCOST A GROUP BY A.BUSINESS_UNIT , A.PRODUCTION_ID , A.OP_SEQUENCE , A.CONVERSION_TYPE , A.COST_ELEMENT , A.INV_ITEM_ID

# 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 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
4 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
5 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
6 CONVERSION_AMT Signed Number(12,4) DECIMAL(10,4) NOT NULL Conversion Amount
7 OH_LAB_MACH_AMT Signed Number(12,4) DECIMAL(10,4) NOT NULL Lab/Mach Amt for Ovhd Cal
8 EARN_COST_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Earned Cost Quantity
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID