invantive documentation
Invantive SupportforenAnmelden / Eintragen

OutstandingCreditorItemsByDateOutstanding: Yuki itgen_yuki_outstanding_creditor_items_by_date_outstanding

read only per partition XML

  • Katalog: Yuki
  • Schema: Accounting
  • Bezeichnung: itgen_yuki_outstanding_creditor_items_by_date_outstanding

Die Daten in dieser Tabelle sind nach dem Wert der Spalte COMPANY_CODE aufgeteilt.

Es können nur Daten abgerufen werden.

API-Quelle

  • XML-Dienst: https://api.yukiworks.nl/ws/Accounting.asmx
  • XML-Thema: OutstandingCreditorItemsByDateOutstanding
  • XML-Pfad: /tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 31

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Parameter

Name Datentyp Required Default Documentation
administrationID ``
dateOutstanding ``
includeBankTransactions ``
sortOrder `` ContactAsc oder ContactDesc oder AmountAsc oder AmountDesc oder DateAsc oder DateDesc

Tabellenspalten

Die Spalten der Tabelle OutstandingCreditorItemsByDateOutstanding sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
ADDRESSLINE1 varchar2 itgen_yuki_addressline1 /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/AddressLine_1
ADDRESSLINE2 varchar2 Adresszeile 2 /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/AddressLine_2
CITY varchar2 City /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/City
COCNUMBER varchar2 Nummer Wirtschaftskammer /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/CoCNumber
COMPANY_CODE varchar2(36) Partitionscode
COMPANY_NAME varchar2(240) Partitionenamen
CONTACT varchar2 Contact /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/Contact
CONTACTCODE varchar2 Kontakt /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/ContactCode
CONTACTID guid Kontakt-ID /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/ContactID
COUNTRY varchar2 Country /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/Country
DATE datetime Date /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/Date
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/Description
DOMAINID varchar2(36) Domain-ID
DOMAINNAME varchar2(240) Domainname
DUEDATE datetime Fälligkeitsdatum /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/DueDate
EMAILHOME varchar2 itgen_yuki_emailhome /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/EmailHome
EMAILWORK varchar2 itgen_yuki_emailwork /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/EmailWork
ID guid ID /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/ID
MAILADDRESSLINE1 varchar2 itgen_yuki_mailaddressline1 /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/MailAddressLine_1
MAILADDRESSLINE2 varchar2 itgen_yuki_mailaddressline2 /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/MailAddressLine_2
MAILCITY varchar2 Poststadt /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/MailCity
MAILPOSTCODE varchar2 Postleitzahl /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/MailPostcode
OPENAMOUNT decimal Offener Betrag /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/OpenAmount
ORIGINALAMOUNT decimal Ursprünglichen Betrag /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/OriginalAmount
PAYMENTMETHOD varchar2 itgen_yuki_paymentmethod /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/PaymentMethod
PHONEHOME varchar2 itgen_yuki_phonehome /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/PhoneHome
PHONEWORK varchar2 itgen_yuki_phonework /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/PhoneWork
POSTCODE varchar2 Postleitzahl /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/Postcode
RECIPIENTEMAIL varchar2 itgen_yuki_recipientemail /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/RecipientEmail
REFERENCE varchar2 Reference /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/Reference
TYPEDESCRIPTION varchar2 itgen_yuki_typedescription /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/Type
TYPEID varchar2 Typ-ID /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/Type/ID
VATNUMBER varchar2 Umsatzsteuer-Nummer /soap11:Envelope/soap11:Body/tns:OutstandingCreditorItemsByDateOutstandingResponse/tns:OutstandingCreditorItemsByDateOutstandingResult/OutstandingCreditorItems/OutstandingCreditorItem/VATNumber

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

Änderungen an dieser Tabelle, 26.0 bis 27.0

Die Funktion der Tabelle „Yuki.Accounting.OutstandingCreditorItemsByDateOutstanding“ wurde hinzugefügt

Die Tabelle verfügt über die Spalten 33 und unterstützt die Abfrage „select“.

  • Bedeutung 3

Alle Treiberwechsel, 26.0 bis 27.0