invantive documentation
Invantive Support ForumsLog In / Sign Up

profit_composition: AFAS Profit itgen_aoe_profit_composition

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: itgen_aoe_profit_composition

Can only retrieve data.

Summary

Profit_Composition

API Source

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

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_composition 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
allwaysactive char Verplicht onderdeel fetched only when named, AllwaysActive
artikelgroep varchar2(15) Artikelgroep fetched only when named, Artikelgroep
blocked char Geblokkeerd fetched only when named, Blocked
compositionid varchar2(40) Itemcode fetched only when named, CompositionId
compunique char Unieke onderdelen fetched only when named, CompUnique
compvar char Variabele samenstelling fetched only when named, CompVar
compxpl varchar2(20) Type samenstelling code fetched only when named, CompXpl
createdate datetime Aangemaakt op fetched only when named, CreateDate
createorderlines char Orderregels genereren fetched only when named, CreateOrderLines
description varchar2(100) Omschrijving fetched only when named, Description
itemcode varchar2(40) Itemcode fetched only when named, ItemCode
itemtype varchar2(100) Onderdeel type item fetched only when named, ItemType
modifieddate datetime Gewijzigd op fetched only when named, ModifiedDate
presentationseqno int32 Presentatievolgorde fetched only when named, PresentationSeqno
quantity number Aantal fetched only when named, Quantity
unitid varchar2(15) Basiseenheid fetched only when named, UnitId
unitid2 varchar2(15) Eenheid fetched only when named, UnitId2