invantive documentation
Invantive Support ForumsLog In / Sign Up

CONTACTS: Outlook Contacts

insert update delete

  • Catalog: Outlook
  • Schema: Contacts
  • Primary Keys: EntryID
  • Label: Contacts

Can retrieve data and change data using insert, update and delete.

Summary

Outlook contacts.

Parameters

Name Data Type Required Default Documentation
folderEntryId `` Unique ID of the folder as a reference to the table 'FOLDERS'.
storeEntryId `` Unique ID of a store as a reference to the table 'FOLDERS' when queried with include external stores.

Table Columns

The columns of the table CONTACTS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
Account varchar2
Anniversary datetime
AssistantName varchar2
AssistantTelephoneNumber varchar2
BillingInformation varchar2 itgen_outlook_
Birthday datetime
Body varchar2
Business2TelephoneNumber varchar2
BusinessAddress varchar2
BusinessAddressCity varchar2
BusinessAddressCountry varchar2
BusinessAddressPostalCode varchar2
BusinessAddressPostOfficeBox varchar2
BusinessAddressState varchar2
BusinessAddressStreet varchar2
BusinessFaxNumber varchar2
BusinessHomePage varchar2
BusinessTelephoneNumber varchar2
CallbackTelephoneNumber varchar2
CarTelephoneNumber varchar2
Categories varchar2 Categories
CompanyAndFullName varchar2
CompanyMainTelephoneNumber varchar2
CompanyName varchar2
ComputerNetworkName varchar2
ConversationIndex varchar2
ConversationTopic varchar2
CreationTime datetime
CustomerID varchar2
Department varchar2
Email1Address varchar2
Email1AddressType varchar2
Email1DisplayName varchar2
Email2Address varchar2
Email2AddressType varchar2
Email2DisplayName varchar2
Email3Address varchar2
Email3AddressType varchar2
Email3DisplayName varchar2
EntryID varchar2(1024)
FileAs varchar2
FirstName varchar2
FolderID varchar2(1024)
FTPSite varchar2
FullName varchar2
FullNameAndCompany varchar2
Gender numeric
GovernmentIDNumber varchar2
Hobby varchar2
Home2TelephoneNumber varchar2
HomeAddress varchar2
HomeAddressCity varchar2
HomeAddressCountry varchar2
HomeAddressPostalCode varchar2
HomeAddressPostOfficeBox varchar2
HomeAddressState varchar2
HomeAddressStreet varchar2
HomeFaxNumber varchar2
HomeTelephoneNumber varchar2
IMAddress varchar2
Importance numeric
Initials varchar2
InternetFreeBusyAddress varchar2
ISDNNumber varchar2
JobTitle varchar2
Journal boolean
Language varchar2
LastModificationTime datetime
LastName varchar2
LastNameAndFirstName varchar2
MailingAddress varchar2
MailingAddressCity varchar2
MailingAddressCountry varchar2
MailingAddressPostalCode varchar2
MailingAddressPostOfficeBox varchar2
MailingAddressState varchar2
MailingAddressStreet varchar2
ManagerName varchar2
MiddleName varchar2
Mileage varchar2
MobileTelephoneNumber varchar2
NickName varchar2
NoAging boolean
OfficeLocation varchar2
OrganizationalIDNumber varchar2
OtherAddress varchar2
OtherAddressCity varchar2
OtherAddressCountry varchar2
OtherAddressPostalCode varchar2
OtherAddressPostOfficeBox varchar2
OtherAddressState varchar2
OtherAddressStreet varchar2
OtherFaxNumber varchar2
OtherTelephoneNumber varchar2
PagerNumber varchar2
PersonalHomePage varchar2
PrimaryTelephoneNumber varchar2
Profession varchar2
RadioTelephoneNumber varchar2
ReferredBy varchar2
ReminderOverrideDefault boolean
ReminderPlaySound boolean
ReminderSet boolean
ReminderSoundFile varchar2
ReminderTime datetime
SelectedMailingAddress numeric
Sensitivity numeric
Size numeric
Spouse varchar2
StoreID varchar2(1024)
Subject varchar2
Suffix varchar2
TaskCompletedDate datetime
TaskDueDate datetime
TaskStartDate datetime
TelexNumber varchar2
Title varchar2
ToDoTaskOrdinal datetime
TTYTDDTelephoneNumber varchar2
UnRead boolean
User1 varchar2
User2 varchar2
User3 varchar2
User4 varchar2
UserCertificate varchar2
WebPage varchar2
YomiCompanyName varchar2
YomiFirstName varchar2
YomiLastName varchar2

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: