CE_ACT_RATE_VW

(SQL View)
 Index Back

Acutal Rate View


SELECT BUSINESS_UNIT , CM_BOOK , PRODUCTION_ID , OP_SEQUENCE , CE_COST_CATEGORY , SUM(CE_RATE) , SUM(QTY) FROM PS_CE_ACTUAL_COST WHERE CE_POSTED_FLAG = 'N' GROUP BY BUSINESS_UNIT, CM_BOOK, PRODUCTION_ID, OP_SEQUENCE, CE_COST_CATEGORY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 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
6 CE_RATE Signed Number(32,15) DECIMAL(30,15) NOT NULL Rate
7 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity