invantive documentation
Invantive Support ForumsLog In / Sign Up

TransactionDetailsByDate: Yuki Transaction Details by Date

read only per partition XML

  • Catalog: Yuki
  • Schema: AccountingInfo
  • Label: Transaction Details by Date

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/AccountingInfo.asmx
  • XML topic: GetTransactionDetails
  • XML path: /tns:GetTransactionDetailsResult/tns:TransactionInfo

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 ``
financialMode `` '1' (default) voor Fiscaal, '0' voor Commercieel.
GLAccountCode ``
StartDate ``

Table Columns

The columns of the table TransactionDetailsByDate 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
COCNUMBER varchar2 CoC Number /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:CoCNumber
COMPANY varchar2 Company /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:company
COMPANY_CODE varchar2(36) Partition Code
COMPANY_NAME varchar2(240) Partition Name
CONTACTCOUNTRY varchar2 Contact Country /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:contactCountry
CONTACTHID int32 Contact HID /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:contactHID
CONTACTID guid Contact ID /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:contactID
CONTACTZIPCODE varchar2 Contact ZIP Code /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:contactZipcode
CURRENCY varchar2 Currency /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:currency
CURRENCYRATE decimal Currency Rate /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:currencyRate
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:description
DOCUMENTFOLDER varchar2 Document Folder /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:documentFolder
DOCUMENTFOLDERTAB varchar2 Document Folder Tab /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:documentFolderTab
DOCUMENTID varchar2 Document ID /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:documentID
DOCUMENTREFERENCE varchar2 Document Reference /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:documentReference
DOCUMENTTYPE varchar2 Document Type /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:documentType
DOMAINID varchar2(36) Domain ID
DOMAINNAME varchar2(240) Domain Name
FULLNAME varchar2 Full Name /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:fullName
GLACCOUNTCODE varchar2 General Ledger Account Code /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:glAccountCode
HID varchar2 Human ID /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:hID
ID varchar2 ID /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:id
MUTATIONUSER varchar2 Mutation User /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:mutationUser
PERIODID varchar2 Period ID /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:periodId
PROJECT varchar2 Project /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:project Project is identical to the concept 'Dossier'.
PROJECTCODE varchar2 Project Code /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:projectCode
TAXCODEDESCRIPTION varchar2 Tax Code Description /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:taxCodeDescription
TRANSACTIONAMOUNT decimal Transaction Amount /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:transactionAmount
TRANSACTIONAMOUNTFOREIGNCURRENCY decimal Transaction Amount Foreign Currency /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:transactionAmountForeignCurrency
TRANSACTIONDATE datetime Transaction Date /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:transactionDate
VATNUMBER varchar2 VAT Number /soap11:Envelope/soap11:Body/tns:GetTransactionDetailsResponse/tns:GetTransactionDetailsResult/tns:TransactionInfo/tns:VATNumber

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: