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

# av_art_line: Visual FoxPro

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

- Catalog: ``

Permite recuperar y modificar datos utilizando `insert`, `update` y `delete`.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `av_art_line`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | 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` |  | [ ] |  |  |


## Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador:

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