CE_PRDNID_COST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
3	COST_MEASURE	Character(1)	VARCHAR2(1) NOT NULL	Cost Measure 1=As Planned 2=As Produced 3=Other
4	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
7	TIME_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Time / Resource Type 0100=Planning Labor Setup 0200=Planning Labor Fixed Run 0300=Planning Labor Run 0400=Planning Labor Post Prod 0500=Planning Machine Setup 0600=Planning Machine Fixed Run 0700=Planning Machine Run 0800=Planning Machine Post Prod 1100=Costing Labor Setup 1200=Costing Labor Fixed Run 1300=Costing Labor Run 1400=Costing Labor Post Prod 1500=Costing Machine Setup 1600=Costing Machine Fixed Run 1700=Costing Machine Run 1800=Costing Machine Post Prod 2000=Queue Time 3000=Intransit Time
8	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
9	SEQ_NUMBER	Number(3,0)	SMALLINT NOT NULL	Expense Sequence Number
10	CE_RESOURCE	Character(18)	VARCHAR2(18) NOT NULL	Resource
11	MG_OUTPUT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat CP=Primary CS=Co-Product RB=Recycle TD=Teardown WB=Waste
12	CE_COST_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Cost Type Prompt Table: CE_TYPE_VW
13	COST_VERSION	Character(10)	VARCHAR2(10) NOT NULL	Cost Version Prompt Table: CE_VERSION5_VW
14	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
15	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
16	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
17	UNIT_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Unit Cost
18	CE_EXTENDED_COST	Signed Number(32,15)	DECIMAL(30,15) NOT NULL	Extended Cost
19	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
20	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
21	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50