PL_EXCPEQOH_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PL_RECORD_DTTM	DateTime(26)	TIMESTAMP	a record timestamp used by PL_RECORD_COUNTS
3	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
6	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
7	PL_ORDER_TYPE	Character(3)	VARCHAR2(3) NOT NULL	RAG# Added filed for Planning Phoneix. BA=Buying Agreement NFC=Net Forecast PDN=Production Order PLN=Planned Order PPO=Planned Purchase Order PPR=Planned Production PSS=Strategic Sourcing Event PTR=Planned Transfer PUR=Purchase Order SO=Sales Order SOH=Starting On Hand Qty SR=Material Stock Request TFR=Transfer XD=Extra Demand
8	PL_ORDER_LINE_ID	Character(45)	VARCHAR2(45) NOT NULL	PL_ORDER_LINE_ID
9	PL_ORDER_DTTM	DateTime(26)	TIMESTAMP	PL_ORDER_DTTM
10	PL_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	PL_QTY
11	PL_SPLY_DMD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	PL_SPLY_DMD_FLAG
12	SPL_KEY_SEPARATOR	Character(1)	VARCHAR2(1) NOT NULL	Key Field Seperator
13	EXCESS_LIMIT	Number(9,0)	DECIMAL(9) NOT NULL	Excess Limit Default Value: 0