invantive documentation
Invantive SupportforenAnmelden / Eintragen

SuppliersAndCustomersByDomainId: Yuki Lieferanten und Kunden nach Domain-ID

read only XML

  • Katalog: Yuki
  • Schema: Contact
  • Bezeichnung: Lieferanten und Kunden nach Domain-ID

Es können nur Daten abgerufen werden.

API-Quelle

  • XML-Dienst: https://api.yukiworks.nl/ws/Contact.asmx
  • XML-Thema: GetSuppliersAndCustomers
  • XML-Pfad: /tns:GetSuppliersAndCustomersResult/Contacts/Contact

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 31

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Parameter

Name Datentyp Required Default Documentation
active `` Beide oder Aktiv oder Inaktiv
contactType `` Kunde oder Lieferant oder Beide oder Keine
domainId ``
modifiedAfter ``
searchOption `` Alle oder Name oder Ort oder Postleitzahl oder Tag oder E-Mail oder Website oder Telefon oder Code oder CoCNumber oder VATNumber oder BankAccount oder ID oder ContactType oder HID
searchValue ``
sortOrder `` Name oder LastName oder CreatedAsc oder CreatedDesc oder ModifiedAsc oder ModifiedDesc oder HID

Tabellenspalten

Die Spalten der Tabelle SuppliersAndCustomersByDomainId sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
ADDRESSLINE1 varchar2 itgen_yuki_addressline1 /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/AddressLine_1
ADDRESSLINE2 varchar2 Adresszeile 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 Nummer Wirtschaftskammer /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) Domain-ID
DOMAINNAME varchar2(240) Domainname
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 Personen-ID /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 Poststadt /soap11:Envelope/soap11:Body/tns:GetSuppliersAndCustomersResponse/tns:GetSuppliersAndCustomersResult/Contacts/Contact/MailCity
MAILPOSTCODE varchar2 Postleitzahl /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 Postleitzahl /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 Umsatzsteuer-Nummer /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

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

Änderungen an dieser Tabelle, 26.0 bis 27.0

Die Funktion „Yuki.Contact.SuppliersAndCustomersByDomainId“ wurde hinzugefügt

Die Tabelle verfügt über die Spalten 33 und unterstützt die Abfrage „select“.

  • Bedeutung 3

Alle Treiberwechsel, 26.0 bis 27.0