---
title: "fbpurchprice (AFAS Profit)"
description: "itgen_aoe_fbpurchprice"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.UpdateConnector.fbpurchprice
original: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.UpdateConnector.fbpurchprice
updated: 2026-11-07T09:24:19Z
license: https://documentation.invantive.eu/en/
---

# 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` |  |

