invantive documentation
Forum di supporto InvantiveAccedi / Registrati

CONTATTI: Contatti di Outlook

insert update delete

  • Catalogo: Outlook
  • Schema: Contacts
  • Chiavi primarie: EntryID
  • Etichetta: Contatti

È possibile recuperare e modificare i dati utilizzando insert, update e delete.

Contatti di Outlook.

Parametri

Name Tipo di dati Required Default Documentation
folderEntryId `` ID univoco della cartella come riferimento alla tabella 'FOLDERS'.
storeEntryId `` ID univoco di un negozio come riferimento alla tabella "FOLDERS" quando si esegue una Query che include negozi esterni.

Colonne della tabella

Di seguito sono riportate le colonne della tabella CONTACTS. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: