invantive documentation
Invantive Support ForumsLog In / Sign Up

CheckOutstandingItemsByReference: Yuki Check Outstanding Items by Reference

read only per partition XML

  • Catalog: Yuki
  • Schema: Accounting
  • Label: Check Outstanding Items by Reference

The data in this table is partitioned per value of the COMPANY_CODE column.

Can only retrieve data.

API Source

  • XML service: https://api.yukiworks.nl/ws/Accounting.asmx
  • XML topic: CheckOutstandingItem
  • XML path: /tns:CheckOutstandingItemResult/CheckOutstandingItems/Item

Performance Characteristics

Characteristic Value
Average access latency (ms) 31

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
administrationID ``
Reference ``

Table Columns

The columns of the table CheckOutstandingItemsByReference 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
ADDRESSLINE1 varchar2 itgen_yuki_addressline1 /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/AddressLine_1
ADDRESSLINE2 varchar2 Address Line 2 /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/AddressLine_2
CITY varchar2 City /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/City
COCNUMBER varchar2 CoC Number /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/CoCNumber
COMPANY_CODE varchar2(36) Partition Code
COMPANY_NAME varchar2(240) Partition Name
CONTACTCODE varchar2 Contact Code /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/ContactCode
CONTACTID guid Contact ID /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/ContactID
CONTACTNAME varchar2 itgen_yuki_contactname /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/Contact
COUNTRY varchar2 Country /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/Country
DATE datetime Date /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/Date
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/Description
DOMAINID varchar2(36) Domain ID
DOMAINNAME varchar2(240) Domain Name
DUEDATE datetime Due Date /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/DueDate
ID guid ID /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/ID
MAILADDRESSLINE1 varchar2 itgen_yuki_mailaddressline1 /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/MailAddressLine_1
MAILADDRESSLINE2 varchar2 itgen_yuki_mailaddressline2 /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/MailAddressLine_2
MAILCITY varchar2 Mail City /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/MailCity
MAILPOSTCODE varchar2 Mail ZIP Code /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/MailPostcode
OPENAMOUNT decimal Open Amount /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/OpenAmount
ORIGINALAMOUNT decimal Original Amount /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/OriginalAmount
POSTCODE varchar2 ZIP Code /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/Postcode
REFERENCE varchar2 Reference /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/Reference
TYPEDESCRIPTION varchar2 itgen_yuki_typedescription /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/Type
TYPEID varchar2 Type ID /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/Type/ID
VATNUMBER varchar2 VAT Number /soap11:Envelope/soap11:Body/tns:CheckOutstandingItemResponse/tns:CheckOutstandingItemResult/CheckOutstandingItems/Item/VATNumber

Release Notes

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