invantive documentation
Invantive Support ForumsLog In / Sign Up

fbpurchprice: AFAS Profit itgen_aoe_fbpurchprice

insert update delete REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_fbpurchprice

Inkoopprijs

Can retrieve data and change data using insert, update and delete.

API Source

  • Endpoint: /connectors/FbPurchPrice
  • Metadata: metainfo/update/FbPurchPrice

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 fbpurchprice 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
am number Hoeveelheid fetched only when named, Am
baco varchar2(30) BarcodeItemCodeSupplier fetched only when named, BaCo
biun varchar2(15) Eenheid fetched only when named, BiUn
crid varchar2(16) Crediteur fetched only when named, CrId
crpr char Staffelprijs fetched only when named, CrPr
cuid varchar2(3) Valuta fetched only when named, CuId
dabg datetime Begindatum fetched only when named, DaBg
daen datetime Einddatum fetched only when named, DaEn
dsli char Korting op orderregel wijzigen fetched only when named, DsLi
itcd varchar2(40) Itemcode fetched only when named, ItCd
pric number Inkoopprijs fetched only when named, Pric
prid varchar2(15) Project fetched only when named, PrId
prli varchar2(5) Prijslijst fetched only when named, PrLi
sppr char Actieprijs fetched only when named, SpPr
stl1 varchar2(10) Artikeldimensiecode 1 fetched only when named, StL1
stl2 varchar2(10) Artikeldimensiecode 2 fetched only when named, StL2
suco varchar2(30) Itemcodesupplier fetched only when named, SuCo
vaad varchar2(20) Korting toestaan fetched only when named, VaAD
vait varchar2(10) Type item fetched only when named, VaIt