CE_OP_HISTB

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUMGOP_NONVW
2	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book Prompt Table: CM_BU_BOOK_TBL
3	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID Prompt Table: %EDITTABLE
4	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
5	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	CE_COST_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Cost Type
8	COST_VERSION	Character(10)	VARCHAR2(10) NOT NULL	Cost Version Prompt Table: CE_VERSION5_VW
9	COST_SEQ	Number(15,0)	DECIMAL(15) NOT NULL	Cost Sequence Number
10	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area
11	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
12	PRDN_DUE_DATE	Date(10)	DATE	Prdn Due Date
13	PRDN_DUE_SHIFT	Signed Number(2,0)	DECIMAL(1) NOT NULL	Prdn Due Shift
14	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
15	COMPL_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Completed Qty
16	SCRAPPED_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Scrapped Qty
17	PERCENT_COMP	Number(6,2)	DECIMAL(5,2) NOT NULL	Scrap Prdn Pct
18	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
19	CE_POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Posted 6=Cost for 661 N=Cost Pending Calculation Y=Cost Calculated Default Value: N
20	CE_ADD_POSTED	Character(1)	VARCHAR2(1) NOT NULL	Additional Charge Posted Default Value: N
21	CE_BYPROD_POSTED	Character(1)	VARCHAR2(1) NOT NULL	By Products Posted Flag Default Value: N
22	CE_COMP_POSTED	Character(1)	VARCHAR2(1) NOT NULL	Completion Posted Flag Default Value: N
23	CE_LABOR_POSTED	Character(1)	VARCHAR2(1) NOT NULL	Labor Posted Default Value: N
24	CE_MACH_POSTED	Character(1)	VARCHAR2(1) NOT NULL	Machine Posted Flag Default Value: N
25	CE_MATOH_POSTED	Character(1)	VARCHAR2(1) NOT NULL	Material Overhead Posted Default Value: N