Event Log

Event Type

Function: Eventlog_EventType(EventType: Variant): string

Code	Meaning
1	Customer/Prospect
2	Employee/Sales Rep
3	Vendor
4	Todo
(other/invalid)	Unknown

Event Category

Function: Eventlog_EventCategory(EventCategory: Variant): string

Code	Meaning
0	Activity
1	Quote Sent
2	Quote Expiring
3	Ship by Date
4	Invoice Sent
5	Invoice Due
6	Customer Credit Memo
7	Collection Letter
8	Receipt
9	PO Sent
10	PO Expiring
11	Bill Due
12	Check to Vendor
13	Paycheck
(other/invalid)	Unknown

Event Completed Timestamp Field

The Event Completed field is a Unix Timestamp Field so to deal with a SQL select statement you need convert it to a standard Datetime field. Use the following in your SQL Statement so you will not receive errors:

DATEADD(SECOND,EventLogs.completed,'1970-01-01 00:00:00') AS CompletedDT

Example:

SELECT eventdate,DATEADD(SECOND,EventLogs.completed,’1970-01-01 00:00:00′) AS CompletedDT,RecordNumber,
EventIDType FROM EventLogs;