ODBC Driver for Certinia

Build 24.0.9060

Contact

This is a table representing the Contact entities in FinancialForce.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the Contact.

IsDeleted Boolean True

Label Deleted corresponds to this field.

MasterRecordId String True

Contact.Id

Label Master Record ID corresponds to this field.

AccountId String False

Account.Id

Label Account ID corresponds to this field.

LastName String False

Label Last Name corresponds to this field.

FirstName String False

Label First Name corresponds to this field.

Salutation String False

Label Salutation corresponds to this field.

Name String True

Label Full Name corresponds to this field.

OtherStreet String False

Label Other Street corresponds to this field.

OtherCity String False

Label Other City corresponds to this field.

OtherState String False

Label Other State/Province corresponds to this field.

OtherPostalCode String False

Label Other Zip/Postal Code corresponds to this field.

OtherCountry String False

Label Other Country corresponds to this field.

OtherLatitude Double False

Label Other Latitude corresponds to this field.

OtherLongitude Double False

Label Other Longitude corresponds to this field.

MailingStreet String False

Label Mailing Street corresponds to this field.

MailingCity String False

Label Mailing City corresponds to this field.

MailingState String False

Label Mailing State/Province corresponds to this field.

MailingPostalCode String False

Label Mailing Zip/Postal Code corresponds to this field.

MailingCountry String False

Label Mailing Country corresponds to this field.

MailingLatitude Double False

Label Mailing Latitude corresponds to this field.

MailingLongitude Double False

Label Mailing Longitude corresponds to this field.

Phone String False

Label Business Phone corresponds to this field.

Fax String False

Label Business Fax corresponds to this field.

MobilePhone String False

Label Mobile Phone corresponds to this field.

HomePhone String False

Label Home Phone corresponds to this field.

OtherPhone String False

Label Other Phone corresponds to this field.

AssistantPhone String False

Label Asst. Phone corresponds to this field.

ReportsToId String False

Contact.Id

Label Reports To ID corresponds to this field.

Email String False

Label Email corresponds to this field.

Title String False

Label Title corresponds to this field.

Department String False

Label Department corresponds to this field.

AssistantName String False

Label Assistant's Name corresponds to this field.

LeadSource String False

Label Lead Source corresponds to this field.

Birthdate Datetime False

Label Birthdate corresponds to this field.

Description String False

Label Contact Description corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CreatedDate Datetime True

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True

Label System Modstamp corresponds to this field.

LastActivityDate Datetime True

Label Last Activity corresponds to this field.

LastCURequestDate Datetime True

Label Last Stay-in-Touch Request Date corresponds to this field.

LastCUUpdateDate Datetime True

Label Last Stay-in-Touch Save Date corresponds to this field.

LastViewedDate Datetime True

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True

Label Last Referenced Date corresponds to this field.

EmailBouncedReason String False

Label Email Bounced Reason corresponds to this field.

EmailBouncedDate Datetime False

Label Email Bounced Date corresponds to this field.

IsEmailBounced Boolean True

Label Is Email Bounced corresponds to this field.

Jigsaw String False

Label Data.com Key corresponds to this field.

JigsawContactId String True

Label Jigsaw Contact ID corresponds to this field.

Languages__c String False

Label Languages corresponds to this field.

Level__c String False

Label Level corresponds to this field.

MyNote__c String False

Label MyNote corresponds to this field.

MyExternalId__c String False

Label MyExternalId corresponds to this field.

MyExternalId2__c String False

Label MyExternalId2 corresponds to this field.

AcctLookup__c String False

Account.Id

Label Account corresponds to this field.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060