invantive documentation
Invantive Support ForumsLog In / Sign Up

ddi_profit_btwcode: AFAS Profit VAT Codes

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: VAT Codes

Can only retrieve data.

Summary

DDI_BTWcode (Profit)

API Source

  • Endpoint: /connectors/DDI_Profit_BTWcode
  • Metadata: metainfo/get/DDI_Profit_BTWcode

Performance Characteristics

Characteristic Value
Average access latency (ms) 353
Full scan rows per minute 65,100
Point query rows per minute 169

The result can be cached on the client.

Table Columns

The columns of the table ddi_profit_btwcode 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
btw_code varchar2(3) Code fetched only when named, BTW-code
btw_percentage number Btw (%) fetched only when named, BTW_percentage
btw_plicht varchar2(3) Btw-plicht fetched only when named, BTW_plicht
btw_rekening varchar2(16) Btw-rekening fetched only when named, BTW_rekening
geblokkeerd char Geblokkeerd fetched only when named, Geblokkeerd
omschrijving varchar2(80) Omschrijving fetched only when named, Omschrijving