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

# av_art_hdr: Visual FoxPro

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

- Catalog: ``

Mit `insert`, `update` und `delete` können Daten abgerufen und geändert werden.

## Tabellenspalten

Die Spalten der Tabelle `av_art_hdr` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCT_NR` | `varchar2(10)` |  | [ ] |  |  |
| `APX_LIST` | `varchar2(5)` |  | [ ] |  |  |
| `ASS_CODE` | `varchar2(10)` |  | [ ] |  |  |
| `AUTH_HIST` | `varchar2` |  | [ ] |  |  |
| `BLK_AMT` | `number` |  | [ ] |  |  |
| `BLK_CUR` | `number` |  | [ ] |  |  |
| `BV_AMT` | `number` |  | [ ] |  |  |
| `BV_CUR` | `number` |  | [ ] |  |  |
| `COMMENT1` | `varchar2(40)` |  | [ ] |  |  |
| `COMMENT2` | `varchar2` |  | [ ] |  |  |
| `COMMENT3` | `varchar2` |  | [ ] |  |  |
| `COST_CODE` | `varchar2(10)` |  | [ ] |  |  |
| `CPY_PRN` | `varchar2(100)` |  | [ ] |  |  |
| `CPY_PRTYPE` | `varchar2(40)` |  | [ ] |  |  |
| `CRED_DAYS` | `number` |  | [ ] |  |  |
| `CUR_CODE` | `varchar2(3)` |  | [ ] |  |  |
| `DD_ACT` | `char` |  | [ ] |  |  |
| `DEL_ADDR` | `varchar2` |  | [ ] |  |  |
| `DEL_CP` | `varchar2(40)` |  | [ ] |  |  |
| `DEL_DATE` | `datetime` |  | [ ] |  |  |
| `DISC_CODE` | `varchar2(2)` |  | [ ] |  |  |
| `DISC_DAYS` | `number` |  | [ ] |  |  |
| `DJ_CODE` | `varchar2(3)` |  | [ ] |  |  |
| `DJ_POST` | `char` |  | [ ] |  |  |
| `DOC_NR` | `varchar2(10)` |  | [ ] |  |  |
| `EMP_NR` | `varchar2(10)` |  | [ ] |  |  |
| `EXCH_RATE` | `double` |  | [ ] |  |  |
| `EXT_DESC` | `varchar2(40)` |  | [ ] |  |  |
| `EXT_ID` | `varchar2(32)` |  | [ ] |  |  |
| `EXT_TYPE` | `int32` |  | [ ] |  |  |
| `HDR_TYPE` | `number` |  | [ ] |  |  |
| `INV_CP` | `varchar2(40)` |  | [ ] |  |  |
| `INV_DATE` | `datetime` |  | [ ] |  |  |
| `INV_NR` | `varchar2(10)` |  | [ ] |  |  |
| `LB_AMT` | `number` |  | [ ] |  |  |
| `LB_CUR` | `number` |  | [ ] |  |  |
| `MAND_B2B` | `char` |  | [ ] |  |  |
| `MAND_DATE` | `datetime` |  | [ ] |  |  |
| `MAND_ID` | `varchar2(35)` |  | [ ] |  |  |
| `MAND_SEQ` | `int32` |  | [ ] |  |  |
| `OC_CUR` | `number` |  | [ ] |  |  |
| `ORD_COST` | `number` |  | [ ] |  |  |
| `ORD_CUR` | `number` |  | [ ] |  |  |
| `ORD_DATE` | `datetime` |  | [ ] |  |  |
| `ORD_NR` | `varchar2(10)` |  | [ ] |  |  |
| `ORD_TOT` | `number` |  | [ ] |  |  |
| `PAC_NR` | `varchar2(10)` |  | [ ] |  |  |
| `PAGE_NR` | `varchar2(10)` |  | [ ] |  |  |
| `PAY_AMT` | `number` |  | [ ] |  |  |
| `PAY_CUR` | `number` |  | [ ] |  |  |
| `PAY_VAT` | `number` |  | [ ] |  |  |
| `PAY_VATC` | `varchar2(2)` |  | [ ] |  |  |
| `PCT_LIST` | `varchar2(5)` |  | [ ] |  |  |
| `PD_AMT` | `number` |  | [ ] |  |  |
| `PD_PCT` | `number` |  | [ ] |  |  |
| `PD_VAT` | `number` |  | [ ] |  |  |
| `PDA_CUR` | `number` |  | [ ] |  |  |
| `PDV_CUR` | `number` |  | [ ] |  |  |
| `PERIOD` | `number` |  | [ ] |  |  |
| `PREF_DATE` | `datetime` |  | [ ] |  |  |
| `PROJ_CODE` | `varchar2(10)` |  | [ ] |  |  |
| `QT_ORD_NR` | `varchar2(10)` |  | [ ] |  |  |
| `REC_ID` | `varchar2(10)` |  | [ ] |  |  |
| `RPL_DEL` | `varchar2(10)` |  | [ ] |  |  |
| `RPL_INV` | `varchar2(10)` |  | [ ] |  |  |
| `SBS_NR` | `varchar2(10)` |  | [ ] |  |  |
| `SC_CUR` | `number` |  | [ ] |  |  |
| `SEL_CODE` | `varchar2(5)` |  | [ ] |  |  |
| `SG_CODE` | `varchar2(10)` |  | [ ] |  |  |
| `SHIP_COST` | `number` |  | [ ] |  |  |
| `SHIP_MTH` | `varchar2(10)` |  | [ ] |  |  |
| `SUB_CUR` | `number` |  | [ ] |  |  |
| `SUB_TOT` | `number` |  | [ ] |  |  |
| `TRN_BOOK` | `char` |  | [ ] |  |  |
| `TRN_CNT` | `int32` |  | [ ] |  |  |
| `TRN_START` | `int32` |  | [ ] |  |  |
| `VAT_CUR` | `number` |  | [ ] |  |  |
| `VAT_ORD` | `number` |  | [ ] |  |  |
| `VAT_SHIP` | `number` |  | [ ] |  |  |
| `VAT_TOT` | `number` |  | [ ] |  |  |
| `VC_ORD` | `varchar2(2)` |  | [ ] |  |  |
| `VC_SHIP` | `varchar2(2)` |  | [ ] |  |  |
| `VO_CUR` | `number` |  | [ ] |  |  |
| `VS_CUR` | `number` |  | [ ] |  |  |


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

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