# av_art_line The data in this table is partitioned per value of the column. 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. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AG_CODE` | `string(5)` | | | | | `AL_PROC` | `boolean` | | | | | `ART_AMT` | `decimal` | | | | | `ART_BM` | `boolean` | | | | | `ART_CA` | `boolean` | | | | | `ART_CODE` | `string(15)` | | | | | `ART_CUR` | `decimal` | | | | | `ART_DATE` | `datetime` | | | | | `ART_DESC1` | `string(40)` | | | | | `ART_LEVEL` | `int32` | | | | | `ART_PX` | `decimal` | | | | | `ART_QTY` | `double` | | | | | `ART_QTYU` | `double` | | | | | `BM_TAG` | `string(10)` | | | | | `COGS_AMT` | `decimal` | | | | | `COGS_SUSP` | `boolean` | | | | | `COST_CODE` | `string(10)` | | | | | `CUR_AMT` | `decimal` | | | | | `DISC_AMT` | `decimal` | | | | | `DISC_CUR` | `decimal` | | | | | `DISC_PCT` | `decimal` | | | | | `EMP_NR` | `string(10)` | | | | | `HDR_ID` | `string(10)` | | | | | `HDR_TYPE` | `decimal` | | | | | `ICAT_CODE` | `string(1)` | | | | | `ICNT_SRC` | `string(2)` | | | | | `ICNT_TGT` | `string(2)` | | | | | `INV_NR` | `string(10)` | | | | | `IS_CNTNR` | `decimal` | | | | | `IS_CUSTCD` | `string(2)` | | | | | `IS_MONTH` | `decimal` | | | | | `IS_WEIGHT` | `decimal` | | | | | `ISHP_CODE` | `string(1)` | | | | | `ISXF_CODE` | `string(3)` | | | | | `ISYS_CODE` | `string(2)` | | | | | `ITYP_CODE` | `string(1)` | | | | | `LINK_ID` | `string(10)` | | | | | `LOC_CODE` | `string(5)` | | | | | `ORD_QTY` | `double` | | | | | `ORD_QTYU` | `double` | | | | | `ORG_ORDNR` | `string(10)` | | | | | `PC_CODE` | `string(5)` | | | | | `PIP_AMT` | `decimal` | | | | | `PIP_CUR` | `decimal` | | | | | `POL_ID` | `string(10)` | | | | | `POP_AMT` | `decimal` | | | | | `POP_CUR` | `decimal` | | | | | `PREF_DATE` | `datetime` | | | | | `PROJ_CODE` | `string(10)` | | | | | `PROJ_ID` | `string(10)` | | | | | `PROJ_TYPE` | `int32` | | | | | `PX_CALC` | `decimal` | | | | | `PXDIF_AMT` | `decimal` | | | | | `PXDIF_CUR` | `decimal` | | | | | `REC_BLK` | `boolean` | | | | | `REC_ID` | `string(10)` | | | | | `REM_QTY` | `double` | | | | | `REVA_AMT` | `decimal` | | | | | `SPL_ID` | `string(10)` | | | | | `UNT_CODE` | `string(10)` | | | | | `UNT_CODEP` | `string(10)` | | | | | `UNT_CUR` | `decimal` | | | | | `UNT_PX` | `decimal` | | | | | `VAT_AMT` | `decimal` | | | | | `VAT_CODE` | `string(2)` | | | | | `VAT_CUR` | `decimal` | | | | | `WHS_CODE` | `string(5)` | | | | | `XML_DATA` | `string` | | | |