RS_MYSO_ORDERS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
3	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
4	SO_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Service Order Status C=Closed D=Draft I=In Process N=New O=Open X=Canceled
5	ASSIGNED_TO	Character(30)	VARCHAR2(30) NOT NULL	Assigned To Prompt Table: RS_OPR_NAME_VW
6	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
7	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	START_DT	Date(10)	DATE	Start Date
10	END_DT	Date(10)	DATE	End Date
11	PART_TIME_FLG	Character(1)	VARCHAR2(1) NOT NULL	Part Time
12	QTY_INTEGER	Number(11,0)	DECIMAL(11) NOT NULL	Quantity Rounded to 0 Decimals
13	PERIOD_DAYS	Number(5,0)	INTEGER NOT NULL	Number of Work Days
14	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role
15	SO_PRIORITY	Character(10)	VARCHAR2(10) NOT NULL	Service Order Priority Prompt Table: RS_PRIORITY_TBL
16	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
17	EST_DAYS	Number(5,0)	INTEGER NOT NULL	Estimated number of days
18	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Task Category