invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

TransactionsByPeriod: Yuki Transacties per periode

read only per partition XML

  • Catalogus: Yuki
  • Schema: AccountingInfo
  • Label: Transacties per periode

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

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 ``
dataGroups ``
endDate ``
financialMode `` 1 (standaard) voor fiscaal, 0 voor commercieel.
glAccountCode ``
startDate ``

Tabelkolommen

De kolommen van de tabel TransactionsByPeriod 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
AMOUNT decimal Amount /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:amount
COMPANY_CODE varchar2(36) Partitiecode
COMPANY_NAME varchar2(240) Partitie Naam
CONTACTCOCNUMBER varchar2 itgen_yuki_contactcocnumber /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:contact/tns:CoCNumber
CONTACTCODE varchar2 Contactpersoon Code /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:contact/tns:contactCode
CONTACTCOUNTRY varchar2 Contactpersoon Land /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 Contactpersoon HID /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:contact/tns:HID
CONTACTID varchar2 Contactpersoon 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 Contactpersoon Postcode /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 Documentmap /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 Documentmap Tab /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 Document 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 Document Referentie /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:document/tns:reference
DOCUMENTTYPE varchar2 Documentsoort /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) Domein-ID
DOMAINNAME varchar2(240) Domeinnaam
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 Grootboekrekeningcode /soap11:Envelope/soap11:Body/tns:GetTransactionsResponse/tns:GetTransactionsResult/tns:Transaction/tns:glAccountCode
HID varchar2 Menselijke 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 Projectcode /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 Transactiedatum /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

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.AccountingInfo.TransactionsByPeriod is toegevoegd

De tabel-functie heeft 42 kolommen en kan selecteren.

  • belang 3

Alle wisselingen van de Driver, 26.0 tot 27.0