invantive documentation
Invantive Support ForumsLog In / Sign Up

TransactionsAndContacts: Yuki Transactions and Contacts

read only per partition XML

  • Catalog: Yuki
  • Schema: Accounting
  • Label: Transactions and Contacts

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/Accounting.asmx
  • XML topic: GLAccountTransactionsAndContact
  • XML path: /tns:GLAccountTransactionsAndContactResult/GLAccountTransactions/GLAccountTransaction

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 ``
GLAccountCode ``
StartDate ``

Table Columns

The columns of the table TransactionsAndContacts 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
AMOUNT decimal Amount /soap11:Envelope/soap11:Body/tns:GLAccountTransactionsAndContactResponse/tns:GLAccountTransactionsAndContactResult/GLAccountTransactions/GLAccountTransaction/Amount
COMPANY_CODE varchar2(36) Partition Code
COMPANY_NAME varchar2(240) Partition Name
CONTACTID guid Contact ID /soap11:Envelope/soap11:Body/tns:GLAccountTransactionsAndContactResponse/tns:GLAccountTransactionsAndContactResult/GLAccountTransactions/GLAccountTransaction/ContactID
CONTACTNAME varchar2 itgen_yuki_contactname /soap11:Envelope/soap11:Body/tns:GLAccountTransactionsAndContactResponse/tns:GLAccountTransactionsAndContactResult/GLAccountTransactions/GLAccountTransaction/Contact
DATE datetime Date /soap11:Envelope/soap11:Body/tns:GLAccountTransactionsAndContactResponse/tns:GLAccountTransactionsAndContactResult/GLAccountTransactions/GLAccountTransaction/Date
DESCRIPTION varchar2 Description /soap11:Envelope/soap11:Body/tns:GLAccountTransactionsAndContactResponse/tns:GLAccountTransactionsAndContactResult/GLAccountTransactions/GLAccountTransaction/Description
DOMAINID varchar2(36) Domain ID
DOMAINNAME varchar2(240) Domain Name
FILENAME varchar2 File Name /soap11:Envelope/soap11:Body/tns:GLAccountTransactionsAndContactResponse/tns:GLAccountTransactionsAndContactResult/GLAccountTransactions/GLAccountTransaction/FileName
GLACCOUNTCODE varchar2 General Ledger Account Code /soap11:Envelope/soap11:Body/tns:GLAccountTransactionsAndContactResponse/tns:GLAccountTransactionsAndContactResult/GLAccountTransactions/GLAccountTransaction/GLAccountCode
ID guid ID /soap11:Envelope/soap11:Body/tns:GLAccountTransactionsAndContactResponse/tns:GLAccountTransactionsAndContactResult/GLAccountTransactions/GLAccountTransaction/ID
PROJECTCODE varchar2 Project Code /soap11:Envelope/soap11:Body/tns:GLAccountTransactionsAndContactResponse/tns:GLAccountTransactionsAndContactResult/GLAccountTransactions/GLAccountTransaction/Project
SALESITEM varchar2 itgen_yuki_salesitem /soap11:Envelope/soap11:Body/tns:GLAccountTransactionsAndContactResponse/tns:GLAccountTransactionsAndContactResult/GLAccountTransactions/GLAccountTransaction/SalesItem

Release Notes

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