invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

CONTACTOS: Contactos de Outlook

insert update delete

  • Catálogo: Outlook
  • Esquema: Contacts
  • Llaves Primarias: EntryID
  • Etiqueta: Contactos

Permite recuperar y modificar datos utilizando insert, update y delete.

Resumen

Contactos de Outlook.

Parámetros

Name Tipo de Datos Required Default Documentation
folderEntryId `` Identificador único de la carpeta como referencia a la tabla «FOLDERS».
storeEntryId `` Identificador único de una tienda como referencia a la tabla «FOLDERS» cuando se realiza una Query que incluye tiendas externas.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla CONTACTS. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: