CM_WIPHIST_1

(SQL Table)
Index Back

WIP History Extract

2/7/03 Lee: Original Create. This record is used by CM_WIPHIST, the AE that extracts data for the WIP Value Report.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_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 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
7 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
8 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
9 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost
10 IN_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Row in use flag