CM_WIPHIST_1(SQL Table) |
Index Back |
---|---|
WIP History Extract2/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 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
3 | Character(10) | VARCHAR2(10) NOT NULL | Production ID | |
4 | Character(10) | VARCHAR2(10) NOT NULL | Cost Book | |
5 | Character(18) | VARCHAR2(18) NOT NULL | Item ID | |
6 | Character(4) | VARCHAR2(4) NOT NULL | Cost Element | |
7 | 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 | 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 |