You are here: Reference Guide > Table Structures > System > EM_Main

EM_Main

Purpose    

Records the details of all emails sent.

Path          

System Email Email Maintenance

Name

Type

Linked To/Supplied

RecID (Primary Key) char (36)  
EmailNo varchar (50)  
LastSavedDateTime datetime  
DateCreated datetime  
DateSent datetime  
StaffID varchar (36)  
Reference varchar (255)  
SourceID varchar (36)  
SourceType varchar (50)  
SourceDisplayNo varchar (50)  
SourceFormNo int  
EmailStatus tinyint  
EmailFrom varchar (255)  
EmailTo varchar (255)  
EmailCC varchar (255)  
EmailBCC varchar (255)  
EmailSubject varchar (1000)  
EmailBody text  
RequestReadReceipt bit  

Copyright © 2012 Jiwa Financials. All rights reserved.