invantive documentation
Invantive Support ForumsLog In / Sign Up

Administrations: Yuki Administrations

read only XML

  • Catalog: Yuki
  • Schema: General
  • Label: Administrations

Can only retrieve data.

API Source

  • XML service: https://api.yukiworks.nl/ws/Accounting.asmx
  • XML topic: Administrations
  • XML path: /tns:AdministrationsResult/Administrations/Administration

Performance Characteristics

Characteristic Value
Average access latency (ms) 31

The result can be cached on the client.

Table Columns

The columns of the table Administrations 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
ACTIVE char itgen_yuki_active /soap11:Envelope/soap11:Body/tns:AdministrationsResponse/tns:AdministrationsResult/Administrations/Administration/Active
ADDRESSLINE varchar2 Address Line /soap11:Envelope/soap11:Body/tns:AdministrationsResponse/tns:AdministrationsResult/Administrations/Administration/AddressLine
ADDRESSLINE2 varchar2 Address Line 2 /soap11:Envelope/soap11:Body/tns:AdministrationsResponse/tns:AdministrationsResult/Administrations/Administration/AddressLine_2
CITY varchar2 City /soap11:Envelope/soap11:Body/tns:AdministrationsResponse/tns:AdministrationsResult/Administrations/Administration/City
COCNUMBER varchar2 CoC Number /soap11:Envelope/soap11:Body/tns:AdministrationsResponse/tns:AdministrationsResult/Administrations/Administration/CoCNumber
COUNTRY varchar2 Country /soap11:Envelope/soap11:Body/tns:AdministrationsResponse/tns:AdministrationsResult/Administrations/Administration/Country
DOMAINID varchar2(36) Domain ID
DOMAINNAME varchar2(240) Domain Name
ID guid ID /soap11:Envelope/soap11:Body/tns:AdministrationsResponse/tns:AdministrationsResult/Administrations/Administration/ID
NAME varchar2 Name /soap11:Envelope/soap11:Body/tns:AdministrationsResponse/tns:AdministrationsResult/Administrations/Administration/Name
POSTCODE varchar2 ZIP Code /soap11:Envelope/soap11:Body/tns:AdministrationsResponse/tns:AdministrationsResult/Administrations/Administration/Postcode
STARTDATE datetime Start Date /soap11:Envelope/soap11:Body/tns:AdministrationsResponse/tns:AdministrationsResult/Administrations/Administration/StartDate
VATNUMBER varchar2 VAT Number /soap11:Envelope/soap11:Body/tns:AdministrationsResponse/tns:AdministrationsResult/Administrations/Administration/VATNumber

Release Notes

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

Changes of This Table, 26.0 to 27.0

  • + ACTIVE (char)
  • + ADDRESSLINE2 (varchar2)

All changes of the driver, 26.0 to 27.0