Phone Calls

Returns calls related to a specific company, contact, etc.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-phone-calls/
SELECT
	PhoneCall.ID,
	PhoneCall.ExternalID, 
	PhoneCall.CreatedDate,
	PhoneCall.StartDate,
	PhoneCall.CompletedDate,
	BUILTIN.DF( PhoneCall.Owner ) AS OwnerName,
	BUILTIN.DF( PhoneCall.Assigned ) As AssignedToName,
	PhoneCall.Company,
	Entity.AltName AS CompanyName,
	PhoneCall.Contact,
	BUILTIN.DF( PhoneCall.Contact ) AS ContactName,
	BUILTIN.DF( PhoneCall.Transaction ) AS TransactionName,
	BUILTIN.DF( PhoneCall.RelatedItem ) AS RelatedItemName,
	BUILTIN.DF( PhoneCall.SupportCase ) AS SupportCaseName,
	PhoneCall.Priority,
	PhoneCall.Status,
	PhoneCall.Phone,
	PhoneCall.Title,
	PhoneCall.Message
FROM 
	PhoneCall
	LEFT OUTER JOIN Entity ON
		( Entity.ID = PhoneCall.Company )
WHERE
	 ( PhoneCall.Company = 359 )
ORDER BY 
	PhoneCall.CreatedDate DESC

Click here to return to the list of available queries.