RSF_TR_OPPY_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	REORG_ID_OPP	Character(15)	VARCHAR2(15) NOT NULL	Reorganization ID Opportunity
5	PERSON_ID_MANAGER	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
6	REORG_DATE	Date(10)	DATE	Reorginzation Date
7	TREE_NAME_OPP	Character(18)	VARCHAR2(18) NOT NULL	New Tree Name - Opportunity
8	TREE_EFFDT_OPP	Date(10)	DATE	Tree Effective Date Opp
9	FROM_TREE_OPP	Character(18)	VARCHAR2(18) NOT NULL	Current Tree For Opportunities
10	FROM_TERRITORY_OPP	Character(20)	VARCHAR2(20) NOT NULL	Current Territory Opp
11	FROM_SALES_REP_OPP	Character(15)	VARCHAR2(15) NOT NULL	From Sales Representative Opp
12	SALES_USER_NAME_OP	Character(50)	VARCHAR2(50) NOT NULL	Sales User Name
13	SALES_USER_TYPE_OP	Character(4)	VARCHAR2(4) NOT NULL	Sales User Type
14	TO_SALES_REP_OPP	Character(15)	VARCHAR2(15) NOT NULL	To Sales Representative Opp
15	TO_TERRITORY_OPP	Character(20)	VARCHAR2(20) NOT NULL	New Territory Opportunity
16	OPPORTUNITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Opportunity ID
17	OPPORTUNITY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Opportunity Name - User Enters this field in Mixed Case.
18	PRIMARY_FLG_OP	Character(1)	VARCHAR2(1) NOT NULL	Primary Flag For Opp Reorg
19	SHADOW_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	An amount for a 'shadow' forecast.
20	SHADOW_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Shadow Amount Percent
21	NAME1_OP	Character(40)	VARCHAR2(40) NOT NULL	Name 1
22	EST_CLOSE_DT	Date(10)	DATE	Estimated Close Date of an Opportunity
23	PCT_ALLOC	Number(3,0)	SMALLINT NOT NULL	Allocation Percentage
24	OPPORTUNITY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Opportunity Status. The values are XLat Values 0=Open 1=Closed - Lost 2=Closed - Won 3=Inactive