invantive documentation
Invantive Support ForumsLog In / Sign Up

OutstandingDebtorItems: Yuki Outstanding Debtor Items

read only per partition XML

  • Catalog: Yuki
  • Schema: Accounting
  • Label: Outstanding Debtor Items

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: OutstandingDebtorItems
  • XML path: /tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/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 ``
includeBankTransactions ``
sortOrder `` ContactAsc or ContactDesc or AmountAsc or AmountDesc or DateAsc or DateDesc

Table Columns

The columns of the table OutstandingDebtorItems 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:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/AddressLine_1
ADDRESSLINE2 varchar2 Address Line 2 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/AddressLine_2
CITY varchar2 City /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/City
COCNUMBER varchar2 CoC Number /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/CoCNumber
COMPANY_CODE varchar2(36) Partition Code
COMPANY_NAME varchar2(240) Partition Name
CONTACTCODE varchar2 Contact Code /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/ContactCode
CONTACTID guid Contact ID /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/ContactID
CONTACTNAME varchar2 itgen_yuki_contactname /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/Contact
COUNTRY varchar2 Country /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/Country
DATE datetime Date /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/Date
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/Description
DOMAINID varchar2(36) Domain ID
DOMAINNAME varchar2(240) Domain Name
DUEDATE datetime Due Date /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/DueDate
EMAILHOME varchar2 itgen_yuki_emailhome /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/EmailHome
EMAILWORK varchar2 itgen_yuki_emailwork /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/EmailWork
ID guid ID /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/ID
MAILADDRESSLINE1 varchar2 itgen_yuki_mailaddressline1 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/MailAddressLine_1
MAILADDRESSLINE2 varchar2 itgen_yuki_mailaddressline2 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/MailAddressLine_2
MAILCITY varchar2 Mail City /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/MailCity
MAILPOSTCODE varchar2 Mail ZIP Code /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/MailPostcode
OPENAMOUNT decimal Open Amount /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/OpenAmount
ORIGINALAMOUNT decimal Original Amount /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/OriginalAmount
PAYMENTMETHOD varchar2 itgen_yuki_paymentmethod /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/PaymentMethod
PHONEHOME varchar2 itgen_yuki_phonehome /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/PhoneHome
PHONEWORK varchar2 itgen_yuki_phonework /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/PhoneWork
POSTCODE varchar2 ZIP Code /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/Postcode
RECIPIENTEMAIL varchar2 itgen_yuki_recipientemail /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/RecipientEmail
REFERENCE varchar2 Reference /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/Reference
TYPEDESCRIPTION varchar2 itgen_yuki_typedescription /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/Type
TYPEID varchar2 Type ID /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/Type/ID
VATNUMBER varchar2 VAT Number /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsResponse/tns:OutstandingDebtorItemsResult/OutstandingDebtorItems/Item/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

Yuki.Accounting.OutstandingDebtorItems: table parameters changes

Table parameters of Yuki.Accounting.OutstandingDebtorItems changes from administrationID, includeBankTransactions to administrationID, includeBankTransactions, sortOrder.

  • administrationID, includeBankTransactions → administrationID, includeBankTransactions, sortOrder
  • importance 3
Parameter sortOrder is added to Yuki.Accounting.OutstandingDebtorItems

Optional.

  • importance 2

All changes of the driver, 26.0 to 27.0