invantive documentation
Invantive Support ForumsLog In / Sign Up

OutstandingCreditorItemsWithPaymentReference: Yuki itgen_yuki_outstanding_creditor_items_with_payment_reference

read only per partition XML

  • Catalog: Yuki
  • Schema: Accounting
  • Label: itgen_yuki_outstanding_creditor_items_with_payment_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: OutstandingCreditorWithPaymentReference
  • XML path: /tns:OutstandingCreditorWithPaymentReferenceResult/OutstandingCreditorItems/OutstandingCreditorItem

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 ``
endDate ``
includeBankTransactions ``
sortOrder `` ContactAsc or ContactDesc or AmountAsc or AmountDesc or DateAsc or DateDesc
startDate ``

Table Columns

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

Table function Yuki.Accounting.OutstandingCreditorItemsWithPaymentReference is added

The table function has 33 columns and can select.

  • importance 3

All changes of the driver, 26.0 to 27.0