RF_ENTL_LIST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AGR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Used to temporarily store the setid for the agreement or entitlements.
2	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
3	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)
4	AGREEMENT_CATEGORY	Character(1)	VARCHAR2(1) NOT NULL	Field for defining the Category for the Agreement, to be used in the Agreement Header Record. 1=External 2=Internal 3=External - No Pricing
5	AGREEMENT_LINE	Character(10)	VARCHAR2(10) NOT NULL	This field records the value for the agreement line number
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	SERVICE_ID	Character(20)	VARCHAR2(20) NOT NULL	Service ID
8	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
9	WARRANTY_NAME	Character(40)	VARCHAR2(40) NOT NULL	This field is used to store the name of the warranty.
10	AG_SVC_LINE_PRICE	Number(12,2)	DECIMAL(11,2) NOT NULL	Transaction price for service on an agreement line
11	PURCHASE_OPTN	Character(4)	VARCHAR2(4) NOT NULL	This field is used to represent the purchase option (used in agreement pricing) FLAT=Flat Rate PRPD=Prepaid Cases/Services TM=Time & Material
12	SVC_UNIT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field is used to represent the transaction price unit type CASE=Case DAY=Day HOUR=Hour MON=Month SO=Service Order WEEK=Week YEAR=Year
13	PREPAID_QTY	Number(6,0)	INTEGER NOT NULL	This field is used to store the Prepaid Quantity.
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
15	SERVICE_CTR	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	This field is used to represent the remaining quantity available for pre-paid services
16	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
17	GRP_MEMBER_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to store the PERSON_ID of each group member in the provider group.
18	PRPD_UNIT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field is used to represent the prepaid unit type CASE=Case DAY=Day HOUR=Hour MON=Month SO=Service Order WEEK=Week YEAR=Year
19	SETID_WARRANTY	Character(5)	VARCHAR2(5) NOT NULL	This field is used to represent the SETID of the Warranty
20	ENTITLE_MINUTES	Number(6,0)	INTEGER NOT NULL	This field represents the number of minutes for the response or restore time of an entitlement
21	ENTITLE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field represents the type of entitlement COV=Guaranteed Coverage PPM=Service Level RESP=Guaranteed Response REST=Guaranteed Restore
22	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	This is the holiday schedule field. Prompt Table: HOLIDAY_TBL
23	HDR_PREPAID_QTY	Number(6,0)	INTEGER NOT NULL	This field is used to store the Prepaid Quantity.
24	HDR_PREPAID_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Prepaid Unit. The field is used to store prepaid unit options for agreement of category External - No Pricing. CASE=Case HOUR=Hour SO=Service Order
25	HDR_SERVICE_CTR	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	This field is used to represent the remaining quantity available for pre-paid services
26	SO_PREPAID_QTY	Number(6,0)	INTEGER NOT NULL	Prepaid quantity for service on agreement line setup.
27	SO_PREPAID_UNIT	Character(4)	VARCHAR2(4) NOT NULL	Prepaid Unit. The field is used to store prepaid unit options on agreement line for service - agreement of category External - No Pricing. HOUR=Hour SO=Service Order
28	SO_REMAINING_QTY	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	Service Order Remaining Quantity used in agreement line setup.
29	DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field is a flag field to indicate default or not. N=No Y=Yes