# fibudget Budget - Catalog: `AfasOnline` - Schema: `UpdateConnector` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `fibudget` 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 | |---|:---:|---|:---:|---| | `accountnr` | `varchar2(16)` | Grootboekrekening | | | | `autodivide` | `char` | Automatisch verdelen | | | | `budgetscenario` | `varchar2(6)` | Budgetscenario | | | | `budgettype` | `varchar2(16)` | Type budget | | | | `dimcode1` | `varchar2(16)` | Verbijzonderingscode as 1 | | | | `dimcode2` | `varchar2(16)` | Verbijzonderingscode as 2 | | | | `dimcode3` | `varchar2(16)` | Verbijzonderingscode as 3 | | | | `dimcode4` | `varchar2(16)` | Verbijzonderingscode as 4 | | | | `dimcode5` | `varchar2(16)` | Verbijzonderingscode as 5 | | | | `divtable` | `int32` | Periodeverdeeltabel | | | | `periodfrom` | `int32` | PeriodeId van | | | | `periodto` | `int32` | PeriodeId t/m | | | | `readadjustment` | `varchar2(16)` | Aanpassing / Aangepaste waarde | | | | `unitid` | `int32` | Administratie | | | | `year` | `int32` | Jaar | | | | `yearbudget` | `char` | Jaarbudget | | |