invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

OutstandingDebtorItemsByDateOutstanding: Yuki itgen_yuki_outstanding_debtor_items_by_date_outstanding

read only per partition XML

  • Catalogus: Yuki
  • Schema: Accounting
  • Label: itgen_yuki_outstanding_debtor_items_by_date_outstanding

De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom COMPANY_CODE.

Kan alleen gegevens ophalen.

API-bron

  • XML-service: https://api.yukiworks.nl/ws/Accounting.asmx
  • XML-onderwerp: OutstandingDebtorItemsByDateOutstanding
  • XML-pad: /tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem

Prestatiekenmerken

Characteristic Value
Gemiddelde toegangsvertraging (ms) 31

Het resultaat kan op de client in de Cache worden opgeslagen.

Parameters

Name Datatype Required Default Documentation
administrationID ``
dateOutstanding ``
includeBankTransactions ``
sortOrder `` ContactAsc of ContactDesc of AmountAsc of AmountDesc of DateAsc of DateDesc

Tabelkolommen

De kolommen van de tabel OutstandingDebtorItemsByDateOutstanding worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
ADDRESSLINE1 varchar2 itgen_yuki_addressline1 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/AddressLine_1
ADDRESSLINE2 varchar2 Adresregel 2 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/AddressLine_2
CITY varchar2 City /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/City
COCNUMBER varchar2 KvK Nummer /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/CoCNumber
COMPANY_CODE varchar2(36) Partitiecode
COMPANY_NAME varchar2(240) Partitie Naam
CONTACTCODE varchar2 Contactpersoon Code /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/ContactCode
CONTACTID guid Contactpersoon ID /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/ContactID
CONTACTNAME varchar2 itgen_yuki_contactname /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Contact
COUNTRY varchar2 Country /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Country
DATE datetime Date /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Date
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Description
DOMAINID varchar2(36) Domein-ID
DOMAINNAME varchar2(240) Domeinnaam
DUEDATE datetime Vervaldag /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/DueDate
EMAILHOME varchar2 itgen_yuki_emailhome /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/EmailHome
EMAILWORK varchar2 itgen_yuki_emailwork /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/EmailWork
ID guid ID /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/ID
MAILADDRESSLINE1 varchar2 itgen_yuki_mailaddressline1 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/MailAddressLine_1
MAILADDRESSLINE2 varchar2 itgen_yuki_mailaddressline2 /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/MailAddressLine_2
MAILCITY varchar2 Poststad /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/MailCity
MAILPOSTCODE varchar2 Post Postcode /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/MailPostcode
OPENAMOUNT decimal Open Bedrag /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/OpenAmount
ORIGINALAMOUNT decimal Oorspronkelijk Bedrag /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/OriginalAmount
PAYMENTMETHOD varchar2 itgen_yuki_paymentmethod /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/PaymentMethod
PHONEHOME varchar2 itgen_yuki_phonehome /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/PhoneHome
PHONEWORK varchar2 itgen_yuki_phonework /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/PhoneWork
POSTCODE varchar2 Postcode /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Postcode
RECIPIENTEMAIL varchar2 itgen_yuki_recipientemail /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/RecipientEmail
REFERENCE varchar2 Reference /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Reference
TYPEDESCRIPTION varchar2 itgen_yuki_typedescription /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Type
TYPEID varchar2 Type ID /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/Type/ID
VATNUMBER varchar2 BTW-nummer /soap11:Envelope/soap11:Body/tns:OutstandingDebtorItemsByDateOutstandingResponse/tns:OutstandingDebtorItemsByDateOutstandingResult/OutstandingDebtorItems/OutstandingDebtorItem/VATNumber

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

Wijzigingen in deze tabel, 26.0 tot 27.0

De tabelfunctie Yuki.Accounting.OutstandingDebtorItemsByDateOutstanding is toegevoegd

De tabel-functie heeft 33 kolommen en kan selecteren.

  • belang 3

Alle wisselingen van de Driver, 26.0 tot 27.0