invantive documentation
Invantive SupportforenAnmelden / Eintragen

TransactionsByPeriod: Yuki Buchungen nach Periode

read only per partition XML

  • Katalog: Yuki
  • Schema: AccountingInfo
  • Label: Buchungen nach Periode

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/AccountingInfo.asmx
  • XML-Thema: GetTransactions
  • XML-Pfad: /tns:GetTransactionsResult/tns:Transaction

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 ``
dataGroups ``
endDate ``
financialMode `` 1 (Standard) für fiskal, 0 für kommerziell.
glAccountCode ``
startDate ``

Tabellenspalten

Die Spalten der Tabelle TransactionsByPeriod 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
AMOUNT decimal Amount /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:amount
COMPANY_CODE varchar2(36) Partitionscode
COMPANY_NAME varchar2(240) Partitionenamen
CONTACTCOCNUMBER varchar2 itgen_yuki_contactcocnumber /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:contact/tns:CoCNumber
CONTACTCODE varchar2 Kontakt /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:contact/tns:contactCode
CONTACTCOUNTRY varchar2 Kontaktland /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:contact/tns:country
CONTACTFULLNAME varchar2 itgen_yuki_contactfullname /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:contact/tns:fullName
CONTACTHID int32 Kontaktieren Sie HID /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:contact/tns:HID
CONTACTID varchar2 Kontakt-ID /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:contact/id
CONTACTVATNUMBER varchar2 itgen_yuki_contactvatnumber /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:contact/tns:VATNumber
CONTACTZIPCODE varchar2 Kontakt-Postleitzahl /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:contact/tns:zipCode
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:description
DOCUMENTCREATED datetime itgen_yuki_documentcreated /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:created
DOCUMENTFOLDER varchar2 Dokumentenordner /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:folder
DOCUMENTFOLDERID int32 itgen_yuki_documentfolderid /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:folderId
DOCUMENTFOLDERTAB varchar2 Registerkarte „Dokumentenordner“ /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:folderTab
DOCUMENTFOLDERTABID int32 itgen_yuki_documentfoldertabid /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:folderTabId
DOCUMENTHID int32 itgen_yuki_documenthid /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:HID
DOCUMENTID varchar2 Dokument-ID /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/id
DOCUMENTMATCHDATE datetime itgen_yuki_documentmatchdate /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:documentMatched/tns:matchDate
DOCUMENTMATCHEDBY varchar2 itgen_yuki_documentmatchedby /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:documentMatched/tns:matchedBy
DOCUMENTMODIFIED datetime itgen_yuki_documentmodified /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:modified
DOCUMENTPROCESSEDBY varchar2 itgen_yuki_documentprocessedby /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:documentProcessed/tns:processedBy
DOCUMENTPROCESSEDDATE datetime itgen_yuki_documentprocesseddate /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:documentProcessed/tns:processedDate
DOCUMENTREFERENCE varchar2 Dokumentreferenz /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:reference
DOCUMENTTYPE varchar2 Dokument-Art /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:type
DOCUMENTTYPEDESCRIPTION varchar2 itgen_yuki_documenttypedescription /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:typeDescription
DOCUMENTUPLOADMETHOD varchar2 itgen_yuki_documentuploadmethod /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:uploadMethod
DOMAINID varchar2(36) Domain-ID
DOMAINNAME varchar2(240) Domainname
FOREIGNAMOUNT decimal itgen_yuki_foreignamount /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:foreignCurrency/tns:amountFC
FOREIGNCURRENCY varchar2 itgen_yuki_foreigncurrency /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:foreignCurrency/tns:currency
FOREIGNRATE decimal itgen_yuki_foreignrate /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:foreignCurrency/tns:rate
GLACCOUNTCODE varchar2 Hauptbuch Konto-Code /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:glAccountCode
HID varchar2 Personen-ID /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:hID
ID varchar2 ID /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:id
PROJECTCODE varchar2 Projekt /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:project/tns:code
PROJECTDESCRIPTION varchar2 itgen_yuki_projectdescription /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:project/tns:description
TRANSACTIONDATE datetime Verhandlung-Datum /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:transactionDate
VATCODEDESCRIPTION varchar2 itgen_yuki_vatcodedescription /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:vat/tns:codeDescription
VATCODEPERCENTAGE decimal itgen_yuki_vatcodepercentage /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:vat/tns:codePercentage
VATCODETYPE int32 itgen_yuki_vatcodetype /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:vat/tns:codeType

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

Funktion Yuki.AccountingInfo.TransactionsByPeriodxml-ph-0002 wurde hinzugefügt

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

  • Bedeutung 3

Alle Treiberwechsel, 26.0 bis 27.0