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 | 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 |