# ART_LINE: Item lines - Name: `ART_LINE` - Catalog: `AccountView` - Label: Item lines - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `ART_LINE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACT_COST` | `int64` | Actual costs | ☐ | | | `ACT_PROC` | `int64` | Actual revenues | ☐ | | | `AG_CODE` | `string(5)` | Item group code | ☐ | | | `AL_PROC` | `boolean` | Item line processed | ☐ | | | `ART_AMT` | `int64` | Item amount | ☐ | | | `ART_BM` | `boolean` | Composition | ☐ | | | `ART_CA` | `boolean` | Composite item | ☐ | | | `ART_CODE` | `string(15)` | Article Code | ☐ | | | `ART_CUR` | `int64` | Sales/purchase price per piece FC | ☐ | | | `ART_DATE` | `datetime` | Receipt/delivery date | ☐ | | | `ART_DESC1` | `string(40)` | Order line description | ☐ | | | `ART_LEVEL` | `int32` | Composition level | ☐ | | | `ART_PX` | `int64` | Sales/purchase price | ☐ | | | `ART_QTY` | `decimal` | Quantity received/delivered | ☐ | | | `ART_QTYP` | `decimal` | Quantity received/delivered (price unit) | ☐ | | | `ART_QTYU` | `decimal` | Quantity received/delivered (unit) | ☐ | | | `ART_WEEK` | `int32` | Receipt/delivery date (week) | ☐ | | | `BM_TAG` | `string(10)` | Unique key item composition | ☐ | | | `COGS_AMT` | `int64` | Cost of sales amount | ☐ | | | `COGS_QTY` | `decimal` | Cost price quantity | ☐ | | | `COGS_SUSP` | `boolean` | Cost price posting deferred | ☐ | | | `COST_CODE` | `string(10)` | Cost centre code | ☐ | | | `CST_AMT` | `int64` | Amount posted | ☐ | | | `CUR_AMT` | `int64` | Currency amount | ☐ | | | `DECL_AMT` | `int64` | Chargeable amount | ☐ | | | `DISC_AMT` | `int64` | Discount amount | ☐ | | | `DISC_CUR` | `int64` | Discount amount FC | ☐ | | | `DISC_PCT` | `decimal` | Discount percentage | ☐ | | | `EMP_NR` | `string(10)` | Employee code | ☐ | | | `HDR_ID` | `string(10)` | Unique code of header record | ☐ | | | `HDR_TYPE` | `decimal` | Stock movement type | ☐ | | | `ICAT_CODE` | `string(1)` | IS goods flow category | ☐ | | | `ICNT_SRC` | `string(2)` | IS country of origin | ☐ | | | `ICNT_TGT` | `string(2)` | IS country of destination | ☐ | | | `INV_DESC` | `string(40)` | Transaction invoice description | ☐ | | | `INV_NR` | `string(10)` | Document/invoice number | ☐ | | | `IS_CNTNR` | `decimal` | IS container | ☐ | | | `IS_CUSTCD` | `string(2)` | IS TARIC code (customs code) | ☐ | | | `IS_MONTH` | `decimal` | IS dating | ☐ | | | `IS_WEIGHT` | `decimal` | IS weight | ☐ | | | `ISHP_CODE` | `string(1)` | IS mode of transport | ☐ | | | `ISXF_CODE` | `string(3)` | IS statistical factor code | ☐ | | | `ISYS_CODE` | `string(2)` | IS regime | ☐ | | | `ITEM_DESC` | `string(40)` | Transaction description | ☐ | | | `ITEM_QTY` | `decimal` | Quantity | ☐ | | | `ITYP_CODE` | `string(1)` | IS transaction code | ☐ | | | `LINK_ID` | `string(10)` | Project journal link | ☐ | | | `LOC_CODE` | `string(5)` | Warehouse location | ☐ | | | `ORD_QTY` | `decimal` | Quantity ordered | ☐ | | | `ORD_QTYP` | `decimal` | Quantity ordered (price unit) | ☐ | | | `ORD_QTYU` | `decimal` | Quantity ordered (unit) | ☐ | | | `ORG_ORDNR` | `string(10)` | Original order number | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PC_CODE` | `string(5)` | Cost type | ☐ | | | `PC_DIM` | `string(5)` | Cost type as dimension | ☐ | | | `PER_PROJ` | `decimal` | Project period | ☐ | | | `PIP_AMT` | `int64` | Expected purchase invoice amount | ☐ | | | `PIP_CUR` | `int64` | Expected purchase invoice amount FC | ☐ | | | `POL_ID` | `string(10)` | Order line identification | ☐ | | | `POP_AMT` | `int64` | Expected receipt amount | ☐ | | | `POP_CUR` | `int64` | Expected receipt amount FC | ☐ | | | `PREF_DATE` | `datetime` | Promised delivery date | ☐ | | | `PREF_WEEK` | `int32` | Promised delivery date (week) | ☐ | | | `PROJ_CODE` | `string(10)` | Project code | ☐ | | | `PROJ_ID` | `string(10)` | Claim line identification | ☐ | | | `PROJ_TYPE` | `int32` | Project type | ☐ | | | `PX_CALC` | `int64` | Cost price (standard / last / average) | ☐ | | | `PXDIF_AMT` | `int64` | Purchase price difference | ☐ | | | `PXDIF_CUR` | `int64` | Purchase price difference FC | ☐ | | | `REC_BLK` | `boolean` | Blocked | ☐ | | | `REC_BLKD` | `string(1)` | Blocked | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `REM_QTY` | `decimal` | Remaining lot quantity (LIFO/FIFO) | ☐ | | | `RES_ID` | `string(12)` | Source identification | ☐ | | | `REVA_AMT` | `int64` | Stock revaluation amount | ☐ | | | `SELL_AMT` | `int64` | Amount to be invoiced | ☐ | | | `SELL_QTY` | `decimal` | Quantity to be invoiced | ☐ | | | `SPL_ID` | `string(10)` | Sales/purchase line code | ☐ | | | `TRN_DATE` | `datetime` | Transaction Date | ☐ | | | `UNT_CODE` | `string(10)` | Unit | ☐ | | | `UNT_CODEP` | `string(10)` | Price unit | ☐ | | | `UNT_CUR` | `int64` | Sales/purchase price per price unit FC | ☐ | | | `UNT_PX` | `int64` | Sales/purchase price per price unit | ☐ | | | `VAT_AMT` | `int64` | VAT Amount | ☐ | | | `VAT_CODE` | `string(2)` | VAT Code | ☐ | | | `VAT_CUR` | `int64` | VAT amount FC | ☐ | | | `WHS_CODE` | `string(5)` | Warehouse code | ☐ | | | `XML_DATA` | `string(4)` | Data in XML format | ☐ | |