RF_IP_PM_1_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COMPONENT_CODE	Character(1)	VARCHAR2(1) NOT NULL	Component 1=Contact 2=Company 3=Site 4=Relationship Viewer 5=Consumer 6=360 Degree View A=Agreement B=Batch I=Installed Product S=Service Order
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
4	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
7	INSTALLED_DATE	Date(10)	DATE	Field used for storing Installed Date of Installed product
8	SETID_AGREEMENT	Character(5)	VARCHAR2(5) NOT NULL	This field is used to represent the SETID of the Agreement
9	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
10	AGR_RENEWAL_NUM	Number(4,0)	SMALLINT NOT NULL	This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
11	AGREEMENT_LINE	Character(10)	VARCHAR2(10) NOT NULL	This field records the value for the agreement line number
12	END_DATE	Date(10)	DATE	End date field to store an end date.
13	SETID_SERVICE	Character(5)	VARCHAR2(5) NOT NULL	This field is used to represent the SETID of the Service
14	SERVICE_ID	Character(20)	VARCHAR2(20) NOT NULL	Service ID
15	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
16	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID
17	PM_DATE	Date(10)	DATE	Date for the customer's next Preventive Maintenance.
18	CREATE_DATE	Date(10)	DATE	Creation Date
19	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
20	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section