---
title: "dbase_f5 (Visual FoxPro)"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/foxpro/dbase_f5
original: https://documentation.invantive.eu/en/datamodels/foxpro/dbase_f5
updated: 2026-11-16T21:05:51Z
license: https://documentation.invantive.eu/nl/
---

# dbase_f5: Visual FoxPro

`insert` `update` `delete` `per partition`

- Catalog: ``

Je kunt gegevens ophalen en wijzigen met `insert`, `update` en `delete`.

## Tabelkolommen

De kolommen van de tabel `dbase_f5` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ARXB` | `varchar2(10)` |  | [ ] |  |  |
| `ARXD` | `varchar2(10)` |  | [ ] |  |  |
| `ARXN` | `varchar2(10)` |  | [ ] |  |  |
| `AXC1` | `varchar2(10)` |  | [ ] |  |  |
| `AXC2` | `varchar2(10)` |  | [ ] |  |  |
| `AXC3` | `varchar2(10)` |  | [ ] |  |  |
| `COG1` | `varchar2(15)` |  | [ ] |  |  |
| `COG2` | `varchar2(15)` |  | [ ] |  |  |
| `COMB` | `varchar2(15)` |  | [ ] |  |  |
| `COMN` | `varchar2(15)` |  | [ ] |  |  |
| `DATB` | `datetime` |  | [ ] |  |  |
| `DATD` | `datetime` |  | [ ] |  |  |
| `DATN` | `datetime` |  | [ ] |  |  |
| `DRIB` | `varchar2(30)` |  | [ ] |  |  |
| `DTC1` | `datetime` |  | [ ] |  |  |
| `DTC2` | `datetime` |  | [ ] |  |  |
| `DTC3` | `datetime` |  | [ ] |  |  |
| `GHD` | `varchar2(15)` |  | [ ] |  |  |
| `INAB` | `varchar2(30)` |  | [ ] |  |  |
| `LLC1` | `varchar2(15)` |  | [ ] |  |  |
| `LLC2` | `varchar2(15)` |  | [ ] |  |  |
| `LLC3` | `varchar2(15)` |  | [ ] |  |  |
| `LLOB` | `varchar2(15)` |  | [ ] |  |  |
| `LLOD` | `varchar2(15)` |  | [ ] |  |  |
| `LLON` | `varchar2(15)` |  | [ ] |  |  |
| `MUNB` | `varchar2(15)` |  | [ ] |  |  |
| `MUNN` | `varchar2(15)` |  | [ ] |  |  |
| `NF` | `number` |  | [ ] |  |  |
| `NFC1` | `number` |  | [ ] |  |  |
| `NFC2` | `number` |  | [ ] |  |  |
| `NFC3` | `number` |  | [ ] |  |  |
| `NFM` | `number` |  | [ ] |  |  |
| `NFP` | `number` |  | [ ] |  |  |
| `NOM` | `varchar2(20)` |  | [ ] |  |  |
| `OBS1` | `varchar2(70)` |  | [ ] |  |  |
| `OBS2` | `varchar2(70)` |  | [ ] |  |  |
| `OBS3` | `varchar2(70)` |  | [ ] |  |  |
| `OBS4` | `varchar2(70)` |  | [ ] |  |  |
| `OBSE` | `varchar2` |  | [ ] |  |  |
| `OFIC` | `varchar2(15)` |  | [ ] |  |  |
| `OFNB` | `varchar2(20)` |  | [ ] |  |  |
| `OFND` | `varchar2(20)` |  | [ ] |  |  |
| `OFTB` | `varchar2(10)` |  | [ ] |  |  |
| `OFTD` | `varchar2(10)` |  | [ ] |  |  |
| `ONC1` | `varchar2(20)` |  | [ ] |  |  |
| `ONC2` | `varchar2(20)` |  | [ ] |  |  |
| `ONC3` | `varchar2(20)` |  | [ ] |  |  |
| `OTC1` | `varchar2(10)` |  | [ ] |  |  |
| `OTC2` | `varchar2(10)` |  | [ ] |  |  |
| `OTC3` | `varchar2(10)` |  | [ ] |  |  |
| `PAIB` | `varchar2(15)` |  | [ ] |  |  |
| `PAIN` | `varchar2(15)` |  | [ ] |  |  |
| `PROV` | `varchar2(15)` |  | [ ] |  |  |
| `RENOM` | `varchar2(15)` |  | [ ] |  |  |
| `SEXE` | `varchar2(1)` |  | [ ] |  |  |
| `TCA1` | `varchar2(10)` |  | [ ] |  |  |
| `TCA2` | `varchar2(10)` |  | [ ] |  |  |
| `TCA3` | `varchar2(10)` |  | [ ] |  |  |
| `TELEFON` | `varchar2(9)` |  | [ ] |  |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

- [Visual FoxPro](/nl/release-notes/drivers?driver=visual-foxpro)
