RF_WARRANTY

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	WARRANTY_NAME	Character(40)	VARCHAR2(40) NOT NULL	This field is used to store the name of the warranty.
3	WARRANTY_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field is intended to represent the type of warranty CALL=Named Caller Upgrade CASE=Case Upgrade HOUR=Hour Upgrade REG=Region Upgrade
4	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
5	WRTY_LENGTH	Character(4)	VARCHAR2(4) NOT NULL	This field stores the value for the length (duration) of the warranty
6	WRTY_LENGTH_UOM	Character(4)	VARCHAR2(4) NOT NULL	This field indicates the unit of measurement for the warranty length (duration). DAY=Day MON=Month WK=Week YR=Year
7	WRTY_DAYS	Number(4,0)	SMALLINT NOT NULL	This field is intended to indicate the duration of the warranty expressed in days.
8	WRTY_XFER_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field is intended to indicate whether the warranty is transferable N=No Y=Yes
9	WRTY_COVERS	Character(4)	VARCHAR2(4) NOT NULL	This field is intended to indicate warranty coverage
10	WRTY_LOAN_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field is intended to indicate whether the warranty covers provision of a loaned item to the customer while the defective item is being repaired. N=No Y=Yes
11	WRTY_REFUND_DAYS	Number(4,0)	SMALLINT NOT NULL	This field is intended to indicate the number of days during which an item can be returned for a refund.
12	WRTY_RETURN_DAYS	Number(4,0)	SMALLINT NOT NULL	This field is intended to indicate the number of days during which the covered item can be returned for credit
13	WRTY_REPLACE_DAYS	Number(4,0)	SMALLINT NOT NULL	This field is intended to indicate the number of days during which the item can be returned for replacement with a similar item.
14	WRTY_PROVIDER	Character(4)	VARCHAR2(4) NOT NULL	This field is intended to indicate what type of entity is providing the warranty MANF=Manufacturer RET=Retailer SO=Service Organization
15	WRTY_START	Character(4)	VARCHAR2(4) NOT NULL	This field is used to indicate the type of event associated with when the warranty begins INST=Install Date ORD=Order Date PURC=Purchase Date SHIP=Shipment Date
16	WRTY_RMA_REQ_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field is intended to indicate whether a request for material authorization is required under the warranty N=No Y=Yes
17	WRTY_INVOICE_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field is intended to indicate whether an invoice is required to perform service under the warranty N=No Y=Yes
18	WRTY_WALK_IN_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field is intended to indicate whether the warranty covers a walk-in replacement N=No Y=Yes
19	WRTY_SHIP_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field is intended to indicate whether shipment of the replacement item is covered under the warranty. N=No Y=Yes
20	WRTY_ON_SITE_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field is intended to indicate whether the warranty covers on-site repair. N=No Y=Yes
21	ACTIVE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Event Status N=Inactive Y=Active
22	ENTITLE_PLAN_NAME	Character(10)	VARCHAR2(10) NOT NULL	This field represents the Entitlement Plan Name Prompt Table: RF_ENT_PL_HDR
23	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	This is the holiday schedule field. Prompt Table: HOLIDAY_TBL
24	NOTE	Long Character(256)	VARCHAR2(256)	This is a generic field to store the note.
25	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
26	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
27	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
28	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
29	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
30	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time