Importing Email Templates

The following tables define the field references to be used in the Email Templates section of the MasterGL.DEF file:

Note: This information is only available for A/R Billing and Payroll users.

Table: tblEmailTemplate
Context Section: CONTEXT,EMAILTEMPLATE,HEADER,HEMAILTPLT
Field ID Req'd Field Length Default Value Notes

EMAIL_TYPE

Y

50

 

Email Process Type: Invoice, Statement, or Voucher

EMAIL_PROCESS_
TEMPLATE

Y

50

Default

Email Process Template for the Process Type. Recommend completing a "<Default>" email process template for each email process type imported.

EMAIL_FROM_ADDRESS

Y

2000

 

From Email Address. Must be in email format.

EMAIL_CC_ADDRESS

N

2000

 

Cc Email Address. Must be in email format.

EMAIL_BCC_ADDRESS

N

2000

 

Bcc Email Address. Must be in email format.

EMAIL_SUBJECT N 5000   Subject line for Email Type/Email Process Template.
EMAIL_MESSAGE N 5000   Email Message for Email Type/Email Process Template.