invantive documentation
Forum di supporto InvantiveAccedi / Registrati

SuppliersAndCustomersByDomainId: Fornitori e clienti per ID dominio di Yuki

read only XML

  • Catalogo: Yuki
  • Schema: Contact
  • Etichetta: Fornitori e clienti per ID dominio

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Servizio XML: https://api.yukiworks.nl/ws/Contact.asmx
  • Argomento XML: GetSuppliersAndCustomers
  • Percorso XML: /tns:GetSuppliersAndCustomersResult/Contacts/Contact

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 31

Il risultato può essere memorizzato nella memoria cache sul client.

Parametri

Name Tipo di dati Required Default Documentation
active `` Entrambi o Attivo o Inattivo
contactType `` Cliente o Fornitore o Entrambi o Nessuno
domainId ``
modifiedAfter ``
searchOption `` Tutti o Nome o Città o CAP o Tag o Email o Sito web o Telefono o Codice o CoCNumber o VATNumber o BankAccount o ID o ContactType o HID
searchValue ``
sortOrder `` Nome o LastName o CreatedAsc o CreatedDesc o ModifiedAsc o ModifiedDesc o HID

Colonne della tabella

Di seguito sono riportate le colonne della tabella SuppliersAndCustomersByDomainId. 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
ADDRESSLINE1 varchar2 itgen_yuki_addressline1 /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/AddressLine_1
ADDRESSLINE2 varchar2 Indirizzo 2 /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/AddressLine_2
BACKOFFICESTATUS varchar2 itgen_yuki_backofficestatus /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/BackofficeStatus
CITY varchar2 City /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/City
COCNUMBER varchar2 Numero CoC /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/CoCNumber
CODE varchar2 Code /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/Code
COUNTRY varchar2 Country /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/Country
CREATED datetime itgen_yuki_created /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/Created
DOMAINID varchar2(36) ID dominio
DOMAINNAME varchar2(240) Nome di dominio
EMAILHOME varchar2 itgen_yuki_emailhome /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/EMailHome
EMAILWORK varchar2 itgen_yuki_emailwork /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/EMailWork
HID int32 ID persona /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/HID
ID guid ID /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/ID
INCOMETAXNUMBER varchar2 itgen_yuki_incometaxnumber /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/IncomeTaxNumber
ISCUSTOMER char itgen_yuki_iscustomer /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/IsCustomer
ISSUPPLIER char itgen_yuki_issupplier /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/IsSupplier
MAILADDRESSLINE1 varchar2 itgen_yuki_mailaddressline1 /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/MailAddressLine_1
MAILADDRESSLINE2 varchar2 itgen_yuki_mailaddressline2 /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/MailAddressLine_2
MAILCITY varchar2 Città di posta /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/MailCity
MAILPOSTCODE varchar2 Codice postale /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/MailPostcode
MAINCONTACTPERSON varchar2 itgen_yuki_maincontactperson /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/MainContactPerson
MOBILEHOME varchar2 itgen_yuki_mobilehome /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/MobileHome
MOBILEWORK varchar2 itgen_yuki_mobilework /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/MobileWork
MODIFIED datetime itgen_yuki_modified /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/Modified
NAME varchar2 Name /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/Name
PHONEHOME varchar2 itgen_yuki_phonehome /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/PhoneHome
PHONEWORK varchar2 itgen_yuki_phonework /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/PhoneWork
POSTCODE varchar2 Codice postale /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/Postcode
TAGS varchar2 Tags /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/Tags
TYPE varchar2 Type /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/Type
VATNUMBER varchar2 Numero di partita IVA /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/VATNumber
WEBSITE varchar2 itgen_yuki_website /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/Website

Note di rilascio

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

Modifiche apportate a questa tabella, da 26.0 a 27.0

È stata aggiunta la funzione tabella Yuki.Contact.SuppliersAndCustomersByDomainId

La funzione tabella presenta le colonne 33 e supporta l’operazione SELECT.

  • importanza 3

Tutte le sostituzioni del conducente, da 26.0 a 27.0