invantive documentation
Invantive Support ForumsLog In / Sign Up

VatReturnsByYear: Yuki VAT Returns by Year

read only per partition XML

  • Catalog: Yuki
  • Schema: Vat
  • Label: VAT Returns by Year

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/Vat.asmx
  • XML topic: VATReturnList
  • XML path: /tns:VATReturnListResult/tns:VATReturnInfo

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 ``
modifiedAfter ``
year ``

Table Columns

The columns of the table VatReturnsByYear 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
ACKNOWLEDGEDATE datetime itgen_yuki_acknowledgedate /soap11:Envelope/soap11:Body/tns:VATReturnListResponse/tns:VATReturnListResult/tns:VATReturnInfo/tns:acknowledgeDate
COMPANY_CODE varchar2(36) Partition Code
COMPANY_NAME varchar2(240) Partition Name
DOCUMENTID varchar2 Document ID /soap11:Envelope/soap11:Body/tns:VATReturnListResponse/tns:VATReturnListResult/tns:VATReturnInfo/tns:documentID
DOMAINID varchar2(36) Domain ID
DOMAINNAME varchar2(240) Domain Name
ENDDATE datetime End Date /soap11:Envelope/soap11:Body/tns:VATReturnListResponse/tns:VATReturnListResult/tns:VATReturnInfo/tns:endDate
MODIFIED datetime itgen_yuki_modified /soap11:Envelope/soap11:Body/tns:VATReturnListResponse/tns:VATReturnListResult/tns:VATReturnInfo/tns:modified
SENDDATE datetime itgen_yuki_senddate /soap11:Envelope/soap11:Body/tns:VATReturnListResponse/tns:VATReturnListResult/tns:VATReturnInfo/tns:sendDate
STARTDATE datetime Start Date /soap11:Envelope/soap11:Body/tns:VATReturnListResponse/tns:VATReturnListResult/tns:VATReturnInfo/tns:startDate
STATUS varchar2 itgen_yuki_status /soap11:Envelope/soap11:Body/tns:VATReturnListResponse/tns:VATReturnListResult/tns:VATReturnInfo/tns:status

Release Notes

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

Changes of This Table, 26.0 to 27.0

Table function Yuki.Vat.VatReturnsByYear is added

The table function has 11 columns and can select.

  • importance 3

All changes of the driver, 26.0 to 27.0