---
title: "ART_LINE (AccountView)"
description: "Item lines"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/vismaaccountview/AccountView..ART_LINE
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..ART_LINE
updated: 2026-11-16T21:12:52Z
license: https://documentation.invantive.eu/nl/
---

# ART_LINE: AccountView Productregels

`read only` `per partition`

- Catalogus: `AccountView`
- Label: Artikellijnen

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `ART_LINE` 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 |
|---|---|---|:---:|---|---|
| `ACT_COST` | `int64` | Werkelijke kosten | [ ] |  |  |
| `ACT_PROC` | `int64` | Werkelijke inkomsten | [ ] |  |  |
| `AG_CODE` | `varchar2(5)` | Artikelgroepcode | [ ] |  |  |
| `AL_PROC` | `char` | Regel verwerkt | [ ] |  |  |
| `ART_AMT` | `int64` | Aantal stuks | [ ] |  |  |
| `ART_BM` | `char` | Composition | [ ] |  |  |
| `ART_CA` | `char` | Samengesteld artikel | [ ] |  |  |
| `ART_CODE` | `varchar2(15)` | Artikelcode | [ ] |  |  |
| `ART_CUR` | `int64` | Verkoop-/aankoopprijs per stuk FC | [ ] |  |  |
| `ART_DATE` | `datetime` | Ontvangst-/leveringsdatum | [ ] |  |  |
| `ART_DESC1` | `varchar2(40)` | Beschrijving van de orderregel | [ ] |  |  |
| `ART_LEVEL` | `int32` | Composition level | [ ] |  |  |
| `ART_PX` | `int64` | Verkoop-/aankoopprijs | [ ] |  |  |
| `ART_QTY` | `decimal` | Ontvangen/geleverde hoeveelheid | [ ] |  |  |
| `ART_QTYP` | `decimal` | Ontvangen/geleverde hoeveelheid (prijs per eenheid) | [ ] |  |  |
| `ART_QTYU` | `decimal` | Ontvangen/geleverde hoeveelheid (eenheid) | [ ] |  |  |
| `ART_WEEK` | `int32` | Ontvangst-/leveringsdatum (week) | [ ] |  |  |
| `BM_TAG` | `varchar2(10)` | Unique key item composition | [ ] |  |  |
| `COGS_AMT` | `int64` | Bedrag aan verkoopkosten | [ ] |  |  |
| `COGS_QTY` | `decimal` | Aantal tegen kostprijs | [ ] |  |  |
| `COGS_SUSP` | `char` | Boeking van de kostprijs uitgesteld | [ ] |  |  |
| `COST_CODE` | `varchar2(10)` | Cost centre code | [ ] |  |  |
| `CST_AMT` | `int64` | Boekingsbedrag | [ ] |  |  |
| `CUR_AMT` | `int64` | Currency amount | [ ] |  |  |
| `DECL_AMT` | `int64` | Factureerbaar bedrag | [ ] |  |  |
| `DISC_AMT` | `int64` | Kortingsbedrag | [ ] |  |  |
| `DISC_CUR` | `int64` | Kortingsbedrag FC | [ ] |  |  |
| `DISC_PCT` | `decimal` | Kortingspercentage | [ ] |  |  |
| `EMP_NR` | `varchar2(10)` | Employee code | [ ] |  |  |
| `HDR_ID` | `varchar2(10)` | Unieke code van het koprecord | [ ] |  |  |
| `HDR_TYPE` | `decimal` | Type voorraadmutatie | [ ] |  |  |
| `ICAT_CODE` | `varchar2(1)` | IS-goederenstroomcategorie | [ ] |  |  |
| `ICNT_SRC` | `varchar2(2)` | Land van herkomst van IS | [ ] |  |  |
| `ICNT_TGT` | `varchar2(2)` | IS-bestemmingsland | [ ] |  |  |
| `INV_DESC` | `varchar2(40)` | Transaction invoice description | [ ] |  |  |
| `INV_NR` | `varchar2(10)` | Document-/factuurnummer | [ ] |  |  |
| `IS_CNTNR` | `decimal` | IS-container | [ ] |  |  |
| `IS_CUSTCD` | `varchar2(2)` | IS TARIC-code (douanecode) | [ ] |  |  |
| `IS_MONTH` | `decimal` | IS-dating | [ ] |  |  |
| `IS_WEIGHT` | `decimal` | IS-gewicht | [ ] |  |  |
| `ISHP_CODE` | `varchar2(1)` | IS-vervoerswijze | [ ] |  |  |
| `ISXF_CODE` | `varchar2(3)` | IS-code voor statistische factor | [ ] |  |  |
| `ISYS_CODE` | `varchar2(2)` | IS-regime | [ ] |  |  |
| `ITEM_DESC` | `varchar2(40)` | Transaction description | [ ] |  |  |
| `ITEM_QTY` | `decimal` | Quantity | [ ] |  |  |
| `ITYP_CODE` | `varchar2(1)` | IS transaction code | [ ] |  |  |
| `LINK_ID` | `varchar2(10)` | Link naar het projectdagboek | [ ] |  |  |
| `LOC_CODE` | `varchar2(5)` | Locatie van het magazijn | [ ] |  |  |
| `ORD_QTY` | `decimal` | Bestelde hoeveelheid | [ ] |  |  |
| `ORD_QTYP` | `decimal` | Bestelde hoeveelheid (prijs per eenheid) | [ ] |  |  |
| `ORD_QTYU` | `decimal` | Bestelde hoeveelheid (eenheid) | [ ] |  |  |
| `ORG_ORDNR` | `varchar2(10)` | Oorspronkelijk ordernummer | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `PC_CODE` | `varchar2(5)` | Kostensoort | [ ] |  |  |
| `PC_DIM` | `varchar2(5)` | Kostensoort als dimensie | [ ] |  |  |
| `PER_PROJ` | `decimal` | Projectperiode | [ ] |  |  |
| `PIP_AMT` | `int64` | Verwacht factuurbedrag van de aankoop | [ ] |  |  |
| `PIP_CUR` | `int64` | Verwacht factuurbedrag aankoop FC | [ ] |  |  |
| `POL_ID` | `varchar2(10)` | Identificatie van bestellijnen | [ ] |  |  |
| `POP_AMT` | `int64` | Verwacht ontvangstbedrag | [ ] |  |  |
| `POP_CUR` | `int64` | Verwacht ontvangstbedrag FC | [ ] |  |  |
| `PREF_DATE` | `datetime` | Beloofde leverdatum | [ ] |  |  |
| `PREF_WEEK` | `int32` | Beloofde leveringsdatum (week) | [ ] |  |  |
| `PROJ_CODE` | `varchar2(10)` | Projectcode | [ ] |  |  |
| `PROJ_ID` | `varchar2(10)` | Identificatie van de claimregel | [ ] |  |  |
| `PROJ_TYPE` | `int32` | Projecttype | [ ] |  |  |
| `PX_CALC` | `int64` | Kostprijs (standaard / laatste / gemiddelde) | [ ] |  |  |
| `PXDIF_AMT` | `int64` | Verschil in aankoopprijs | [ ] |  |  |
| `PXDIF_CUR` | `int64` | Verschil in aankoopprijs FC | [ ] |  |  |
| `REC_BLK` | `char` | Blocked | [ ] |  |  |
| `REC_BLKD` | `varchar2(1)` | Blocked | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Unieke code | [ ] |  |  |
| `REM_QTY` | `decimal` | Resterende voorraadhoeveelheid (LIFO/FIFO) | [ ] |  |  |
| `RES_ID` | `varchar2(12)` | Identificatie van de bron | [ ] |  |  |
| `REVA_AMT` | `int64` | Bedrag van de herwaardering van de voorraad | [ ] |  |  |
| `SELL_AMT` | `int64` | Te factureren bedrag | [ ] |  |  |
| `SELL_QTY` | `decimal` | Te factureren hoeveelheid | [ ] |  |  |
| `SPL_ID` | `varchar2(10)` | Verkoop-/inkoopregelcode | [ ] |  |  |
| `TRN_DATE` | `datetime` | Transactiedatum | [ ] |  |  |
| `UNT_CODE` | `varchar2(10)` | Unit | [ ] |  |  |
| `UNT_CODEP` | `varchar2(10)` | Prijseenheid | [ ] |  |  |
| `UNT_CUR` | `int64` | Verkoop-/aankoopprijs per prijseenheid FC | [ ] |  |  |
| `UNT_PX` | `int64` | Verkoop-/aankoopprijs per prijseenheid | [ ] |  |  |
| `VAT_AMT` | `int64` | BTW-bedrag | [ ] |  |  |
| `VAT_CODE` | `varchar2(2)` | BTW-code | [ ] |  |  |
| `VAT_CUR` | `int64` | BTW-bedrag FC | [ ] |  |  |
| `WHS_CODE` | `varchar2(5)` | Magazijncode | [ ] |  |  |
| `XML_DATA` | `varchar2(4)` | Data in XML format | [ ] |  |  |
