PL_SO_EXCEP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
2	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
3	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
6	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
7	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
8	KIT_LINE_NBR	Number(3,0)	SMALLINT NOT NULL	Kit Line Number
9	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
11	ORDER_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Order Type QUO=Sales Quote SO=Sales Order
12	PLANNER_CD	Character(12)	VARCHAR2(12) NOT NULL	Planner Code
13	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
14	PL_SEQ_NBR	Number(9,0)	DECIMAL(9) NOT NULL	01/09/02 EGS (CN#PL900-1): Added
15	PLANNING_TIMESTAMP	DateTime(26)	TIMESTAMP	Planning Date and Time
16	PL_SCHED_SHIP_DTTM	DateTime(26)	TIMESTAMP	08/16/01 JNW (CN#PL900-1.0): Added
17	SCHED_SHIP_DTTM	DateTime(26)	TIMESTAMP	Schedule Ship Datetime
18	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
19	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
20	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged
21	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator