---
title: "dbase_f5 (Visual FoxPro)"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/foxpro/dbase_f5
original: https://documentation.invantive.eu/en/datamodels/foxpro/dbase_f5
updated: 2025-09-17T17:51:05Z
license: https://documentation.invantive.eu/en/
---

# dbase_f5: Visual FoxPro

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

- Catalog: ``

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

## Table Columns

The columns of the table `dbase_f5` 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 |
|---|---|---|:---:|---|---|
| `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

What changed per release in the tables, columns, attributes and capabilities of the driver:

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

