RE_CPYMAIL_TMPL (SQL View)	Index Back
Copy Mail Template View View for Copy Mail Template. This is used as a dummy view and values will be assigned to the fields through code.

RE_CPYMAIL_TMPL

(SQL View)

Copy Mail Template View

View for Copy Mail Template. This is used as a dummy view and values will be assigned to the fields through code.

SELECT INSTANCE_NAME ,INSTANCE_DESCR ,MAIL_TEMPLATE FROM PS_RE_OPTION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Option Name

2 INSTANCE_DESCR Character(150) VARCHAR2(150) NOT NULL Generic Description Field for Instances of Generic Entities

3 MAIL_TEMPLATE Long Character(300) VARCHAR2(300) Mail Template Field to store Lease Options Mail Template

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTANCE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Option Name
2	INSTANCE_DESCR	Character(150)	VARCHAR2(150) NOT NULL	Generic Description Field for Instances of Generic Entities
3	MAIL_TEMPLATE	Long Character(300)	VARCHAR2(300)	Mail Template Field to store Lease Options Mail Template