CE_ACTC_PRM_VW

(SQL View)
 Index Back

ACM WIP Values

Debits and credits for WIP COSTED_FLAG: target = ce_actual_cost to compute total cost. N=total cost was not computed POSTED_FLAG: target = cm_acctg_line to earn costs based on profile CE_POSTED_FLAG: target = ce_actual_cost for overhead calculations

SELECT A.BUSINESS_UNIT , A.PRODUCTION_ID , A.OP_SEQUENCE , A.CE_COST_CATEGORY , A.CE_RESOURCE , A.CM_BOOK , A.DT_TIMESTAMP , A.COST_ELEMENT , SUM(A.CE_RATE) , SUM(A.CE_EXTENDED_COST) , A.SEQ_NBR FROM PS_CE_ACTUAL_COST A WHERE A.CE_COST_CATEGORY = 'PRIM' GROUP BY A.BUSINESS_UNIT , A.PRODUCTION_ID , A.OP_SEQUENCE , A.CE_COST_CATEGORY , A.CE_RESOURCE , A.CM_BOOK , A.DT_TIMESTAMP , A.COST_ELEMENT , A.SEQ_NBR

# 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 CE_COST_CATEGORY Character(4) VARCHAR2(4) NOT NULL 10/07/02 - LLR Added field CE_COST_CATEGORY for Debits to WIP.
%L=% Labor Overhead
%M=% Material Overhead
ADD=Additional Cost
ADJ=Adjustments
CO=Co Product
LAB=Labor Cost
MACH=Machine Cost
MAT=Material Cost
OTH=Other Cost
OVHD=Standard Cost Overhead
PL=Per Labor Overhead
PM=Per Machine Overhead
PO=Subcontracted PO-STD Cost
PRIM=Primary Product
PU=Per Unit Overhead
RB=Recycle By-Products
SCRP=Scrap Cost
STD=Subcontracted Standard Cost
SUBC=Subcontracted Cost
VCHR=Subcontracted VCHR - PO Cost
WB=Waste By-Products
WO=Write-off no cost adj
5 CE_RESOURCE Character(18) VARCHAR2(18) NOT NULL Resource
6 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
7 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
8 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
9 CE_RATE Signed Number(32,15) DECIMAL(30,15) NOT NULL Rate
10 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost
11 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number