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

# av_art_line: 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 `av_art_line` 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 |
|---|---|---|:---:|---|---|
| `AG_CODE` | `varchar2(5)` |  | [ ] |  |  |
| `AL_PROC` | `char` |  | [ ] |  |  |
| `ART_AMT` | `number` |  | [ ] |  |  |
| `ART_BM` | `char` |  | [ ] |  |  |
| `ART_CA` | `char` |  | [ ] |  |  |
| `ART_CODE` | `varchar2(15)` |  | [ ] |  |  |
| `ART_CUR` | `number` |  | [ ] |  |  |
| `ART_DATE` | `datetime` |  | [ ] |  |  |
| `ART_DESC1` | `varchar2(40)` |  | [ ] |  |  |
| `ART_LEVEL` | `int32` |  | [ ] |  |  |
| `ART_PX` | `number` |  | [ ] |  |  |
| `ART_QTY` | `double` |  | [ ] |  |  |
| `ART_QTYU` | `double` |  | [ ] |  |  |
| `BM_TAG` | `varchar2(10)` |  | [ ] |  |  |
| `COGS_AMT` | `number` |  | [ ] |  |  |
| `COGS_SUSP` | `char` |  | [ ] |  |  |
| `COST_CODE` | `varchar2(10)` |  | [ ] |  |  |
| `CUR_AMT` | `number` |  | [ ] |  |  |
| `DISC_AMT` | `number` |  | [ ] |  |  |
| `DISC_CUR` | `number` |  | [ ] |  |  |
| `DISC_PCT` | `number` |  | [ ] |  |  |
| `EMP_NR` | `varchar2(10)` |  | [ ] |  |  |
| `HDR_ID` | `varchar2(10)` |  | [ ] |  |  |
| `HDR_TYPE` | `number` |  | [ ] |  |  |
| `ICAT_CODE` | `varchar2(1)` |  | [ ] |  |  |
| `ICNT_SRC` | `varchar2(2)` |  | [ ] |  |  |
| `ICNT_TGT` | `varchar2(2)` |  | [ ] |  |  |
| `INV_NR` | `varchar2(10)` |  | [ ] |  |  |
| `IS_CNTNR` | `number` |  | [ ] |  |  |
| `IS_CUSTCD` | `varchar2(2)` |  | [ ] |  |  |
| `IS_MONTH` | `number` |  | [ ] |  |  |
| `IS_WEIGHT` | `number` |  | [ ] |  |  |
| `ISHP_CODE` | `varchar2(1)` |  | [ ] |  |  |
| `ISXF_CODE` | `varchar2(3)` |  | [ ] |  |  |
| `ISYS_CODE` | `varchar2(2)` |  | [ ] |  |  |
| `ITYP_CODE` | `varchar2(1)` |  | [ ] |  |  |
| `LINK_ID` | `varchar2(10)` |  | [ ] |  |  |
| `LOC_CODE` | `varchar2(5)` |  | [ ] |  |  |
| `ORD_QTY` | `double` |  | [ ] |  |  |
| `ORD_QTYU` | `double` |  | [ ] |  |  |
| `ORG_ORDNR` | `varchar2(10)` |  | [ ] |  |  |
| `PC_CODE` | `varchar2(5)` |  | [ ] |  |  |
| `PIP_AMT` | `number` |  | [ ] |  |  |
| `PIP_CUR` | `number` |  | [ ] |  |  |
| `POL_ID` | `varchar2(10)` |  | [ ] |  |  |
| `POP_AMT` | `number` |  | [ ] |  |  |
| `POP_CUR` | `number` |  | [ ] |  |  |
| `PREF_DATE` | `datetime` |  | [ ] |  |  |
| `PROJ_CODE` | `varchar2(10)` |  | [ ] |  |  |
| `PROJ_ID` | `varchar2(10)` |  | [ ] |  |  |
| `PROJ_TYPE` | `int32` |  | [ ] |  |  |
| `PX_CALC` | `number` |  | [ ] |  |  |
| `PXDIF_AMT` | `number` |  | [ ] |  |  |
| `PXDIF_CUR` | `number` |  | [ ] |  |  |
| `REC_BLK` | `char` |  | [ ] |  |  |
| `REC_ID` | `varchar2(10)` |  | [ ] |  |  |
| `REM_QTY` | `double` |  | [ ] |  |  |
| `REVA_AMT` | `number` |  | [ ] |  |  |
| `SPL_ID` | `varchar2(10)` |  | [ ] |  |  |
| `UNT_CODE` | `varchar2(10)` |  | [ ] |  |  |
| `UNT_CODEP` | `varchar2(10)` |  | [ ] |  |  |
| `UNT_CUR` | `number` |  | [ ] |  |  |
| `UNT_PX` | `number` |  | [ ] |  |  |
| `VAT_AMT` | `number` |  | [ ] |  |  |
| `VAT_CODE` | `varchar2(2)` |  | [ ] |  |  |
| `VAT_CUR` | `number` |  | [ ] |  |  |
| `WHS_CODE` | `varchar2(5)` |  | [ ] |  |  |
| `XML_DATA` | `varchar2` |  | [ ] |  |  |



## 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)

