# fbpurchprice Inkoopprijs - Catalog: `AfasOnline` - Schema: `UpdateConnector` Can retrieve data and change data using insert, update and delete. ## 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 | Documentation | |---|:---:|---|:---:|---| | `am` | `number` | Hoeveelheid | | | | `baco` | `varchar2(30)` | BarcodeItemCodeSupplier | | | | `biun` | `varchar2(15)` | Eenheid | | | | `crid` | `varchar2(16)` | Crediteur | | | | `crpr` | `char` | Staffelprijs | | | | `cuid` | `varchar2(3)` | Valuta | | | | `dabg` | `datetime` | Begindatum | | | | `daen` | `datetime` | Einddatum | | | | `dsli` | `char` | Korting op orderregel wijzigen | | | | `itcd` | `varchar2(40)` | Itemcode | | | | `pric` | `number` | Inkoopprijs | | | | `prid` | `varchar2(15)` | Project | | | | `prli` | `varchar2(5)` | Prijslijst | | | | `sppr` | `char` | Actieprijs | | | | `stl1` | `varchar2(10)` | Artikeldimensiecode 1 | | | | `stl2` | `varchar2(10)` | Artikeldimensiecode 2 | | | | `suco` | `varchar2(30)` | Itemcodesupplier | | | | `vaad` | `varchar2(20)` | Korting toestaan | | | | `vait` | `varchar2(10)` | Type item | | |