profit_article_basic: AFAS Profit Articles (Basic)
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 |
Artikelgroep | fetched only when named, Art |
||
basicsalesprice |
number |
Basisverkoopprijs | fetched only when named, Basic |
||
blocked |
char |
Geblokkeerd | fetched only when named, Blocked |
||
createdate |
datetime |
Aangemaakt op | fetched only when named, Create |
||
datemodified |
datetime |
Gewijzigd op | fetched only when named, Date |
||
description |
varchar2 |
Omschrijving | fetched only when named, Description |
||
itemcode |
varchar2 |
Itemcode | fetched only when named, Item |
||
stockactual |
number |
Op voorraad | fetched only when named, Stock |
||
unitid |
varchar2 |
Basiseenheid | fetched only when named, UnitId |
||
vatgroup |
varchar2 |
Btw-tariefgroep | fetched only when named, VA |