invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

profit_article_basic: AFAS Profit Articles (Basic)

Esta página aún no está disponible en tu idioma; se muestra la versión original.

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: Articles (Basic)

Can only retrieve data.

Summary

Profit_Article_Basic

API Source

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

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 profit_article_basic 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
artgroup varchar2(15) Artikelgroep fetched only when named, ArtGroup
basicsalesprice number Basisverkoopprijs fetched only when named, BasicSalesPrice
blocked char Geblokkeerd fetched only when named, Blocked
createdate datetime Aangemaakt op fetched only when named, CreateDate
datemodified datetime Gewijzigd op fetched only when named, DateModified
description varchar2(100) Omschrijving fetched only when named, Description
itemcode varchar2(40) Itemcode fetched only when named, ItemCode
stockactual number Op voorraad fetched only when named, StockActual
unitid varchar2(15) Basiseenheid fetched only when named, UnitId
vatgroup varchar2(4) Btw-tariefgroep fetched only when named, VATgroup