# ARTICLE: Articles - Name: `ARTICLE` - Catalog: `AccountView` - Label: Articles - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `ARTICLE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ABC_CODE` | `string(1)` | ABC category | ☐ | | | `AG_CODE` | `string(5)` | Item group code | ☐ | | | `ART_CODE` | `string(15)` | Article Code | ☐ | | | `ART_CODE_D` | `string(15)` | Item code (draggable) | ☐ | | | `ART_COLLI` | `decimal` | Number of packages/packaging | ☐ | | | `ART_DESC1` | `string(40)` | Item description | ☐ | | | `ART_DESC2` | `string(40)` | Item description 2 | ☐ | | | `ART_MBM` | `string(20)` | Item type | ☐ | | | `ART_UNIT` | `string(5)` | Sales unit | ☐ | | | `ART_WT` | `decimal` | Net weight in kilograms | ☐ | | | `ART_WTGR` | `decimal` | Gross weight in kilograms | ☐ | | | `ARTQ_WK` | `decimal` | Sales per week | ☐ | | | `ASS_ART` | `boolean` | Licence item | ☐ | | | `ASS_MAIN` | `boolean` | Main edition | ☐ | | | `ASS_MULT` | `boolean` | Multiple licence item | ☐ | | | `ASS_NOEXP` | `boolean` | Do not export | ☐ | | | `BASE_ART` | `string(15)` | Base item | ☐ | | | `C_CRIT_01` | `string(10)` | Item list field 1 | ☐ | | | `C_CRIT_02` | `string(10)` | Item list field 2 | ☐ | | | `C_CRIT_03` | `string(10)` | Item list field 3 | ☐ | | | `C_CRIT_04` | `string(10)` | Item list field 4 | ☐ | | | `C_CRIT_05` | `string(10)` | Item list field 5 | ☐ | | | `CI_ARTQWK` | `decimal` | CI sales per week | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `COMMENT1` | `string(4)` | Item note | ☐ | | | `CORD_INV` | `decimal` | Calculated reorder level | ☐ | | | `CORD_SIZE` | `decimal` | Calculated order size | ☐ | | | `CUR_PCHS` | `string(3)` | Purchase currency code | ☐ | | | `CUR_SELL` | `string(3)` | Sales currency code | ☐ | | | `CUST_SERV` | `decimal` | Service level | ☐ | | | `DECL_DATE` | `datetime` | Decline date | ☐ | | | `DEL_DAYS` | `decimal` | Lead time in days (purchase) | ☐ | | | `DESC_AQWK` | `string(20)` | Reliability weeks of stock | ☐ | | | `END_DATE` | `datetime` | Phase-out date | ☐ | | | `EST_DEM` | `decimal` | Expected demand | ☐ | | | `EST_DEV` | `int32` | Deviation in expected demand | ☐ | | | `GROW_DATE` | `datetime` | Growth date | ☐ | | | `GRP_CODE` | `string(10)` | Shop group code | ☐ | | | `ICOM_CODE` | `string(10)` | IS goods code | ☐ | | | `IMG_L_DATA` | `string(4)` | Binary data large image | ☐ | | | `IMG_LARGE` | `string(4)` | Large image | ☐ | | | `IMG_M_DATA` | `string(4)` | Binary data normal image | ☐ | | | `IMG_MEDIUM` | `string(4)` | Default image | ☐ | | | `IMG_S_DATA` | `string(4)` | Binary data small image | ☐ | | | `IMG_SMALL` | `string(4)` | Small image | ☐ | | | `INFO_URL` | `string(200)` | URL for more info | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `INTR_DATE` | `datetime` | Introduction date | ☐ | | | `INV_COST` | `int64` | Stock costs per piece | ☐ | | | `INV_VAL` | `int64` | Stock value | ☐ | | | `LOC_CODE` | `string(5)` | Warehouse location | ☐ | | | `MAT_DATE` | `datetime` | Maturity date | ☐ | | | `MAX_INV` | `decimal` | Maximum stock | ☐ | | | `MIN_INV` | `decimal` | Minimum stock | ☐ | | | `MIN_SIZE` | `decimal` | Minimum order size | ☐ | | | `NO_EXPL` | `boolean` | Do not explode on sales order | ☐ | | | `NO_MFG` | `boolean` | Do not explode as component in production order | ☐ | | | `ORD_COST` | `int64` | Ordering costs | ☐ | | | `ORD_EXP` | `string(5)` | Formula | ☐ | | | `ORD_INV` | `decimal` | Reorder level | ☐ | | | `ORD_MAX` | `decimal` | Order limit | ☐ | | | `ORD_RND` | `boolean` | Multiple of min. order size | ☐ | | | `ORD_SIZE` | `decimal` | Order size | ☐ | | | `PACK_CODE` | `string(15)` | Packaging | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PC_CODE` | `string(5)` | Cost type code | ☐ | | | `PHASE` | `string(25)` | Life cycle phase | ☐ | | | `PICK_STGY` | `string(25)` | Warehouse picking strategy | ☐ | | | `PO_DAY` | `int32` | Order day | ☐ | | | `PO_FREQ` | `int32` | Order time | ☐ | | | `PO_INTERV` | `int32` | Order interval | ☐ | | | `PO_TYPE` | `decimal` | Order method | ☐ | | | `PU_SIZE` | `int32` | Quantity per package purchase | ☐ | | | `PU_UNIT` | `string(5)` | Purchase unit | ☐ | | | `PX_CALC` | `int64` | Valuation price | ☐ | | | `PX_GR` | `boolean` | Sales price including VAT | ☐ | | | `PX_N_CALC` | `int64` | New standard price | ☐ | | | `PX_PCHS` | `int64` | Purchase price | ☐ | | | `PX_SAAS` | `int64` | Price for monthly service settlement | ☐ | | | `PX_SELL` | `int64` | Sales price | ☐ | | | `PX_TEMP` | `int64` | Amount (calculated field) | ☐ | | | `QT1_GRP` | `string(10)` | Quotation group code | ☐ | | | `QTY_ACT` | `decimal` | Quantity processed | ☐ | | | `QTY_AVAIL` | `decimal` | Quantity available | ☐ | | | `QTY_ECON` | `decimal` | Quantity economic | ☐ | | | `QTY_FREE` | `decimal` | Quantity free | ☐ | | | `QTY_JOUR` | `decimal` | Quantity deferred | ☐ | | | `QTY_MFG` | `decimal` | Quantity in process | ☐ | | | `QTY_ORD_EX` | `decimal` | To be ordered | ☐ | | | `QTY_PO` | `decimal` | Quantity ordered (purchase) | ☐ | | | `QTY_RECD` | `decimal` | Quantity received (purchase) | ☐ | | | `QTY_RES` | `decimal` | Quantity reserved | ☐ | | | `QTY_SBO` | `decimal` | Quantity on backorder (sales) | ☐ | | | `QTY_SHIP` | `decimal` | Quantity shipped (sales) | ☐ | | | `QTY_SO` | `decimal` | Quantity on order (sales) | ☐ | | | `QTY_TBJ` | `decimal` | Number of stock movements | ☐ | | | `QTY_TECH` | `decimal` | Quantity technical | ☐ | | | `QTY_WIP` | `decimal` | Quantity in work in progress | ☐ | | | `QTYB_ACT` | `decimal` | Quantity processed, blocked | ☐ | | | `QTYB_AVAIL` | `decimal` | Quantity available, blocked | ☐ | | | `QTYB_ECON` | `decimal` | Quantity economic, blocked | ☐ | | | `QTYB_FREE` | `decimal` | Quantity free, blocked | ☐ | | | `QTYB_JOUR` | `decimal` | Quantity deferred, blocked | ☐ | | | `QTYB_MFG` | `decimal` | Quantity in process, blocked | ☐ | | | `QTYB_PO` | `decimal` | Quantity ordered, blocked (purchase) | ☐ | | | `QTYB_RECD` | `decimal` | Quantity received, blocked (purchase) | ☐ | | | `QTYB_RES` | `decimal` | Quantity reserved, blocked | ☐ | | | `QTYB_SBO` | `decimal` | Quantity on backorder, blocked (sales) | ☐ | | | `QTYB_SHIP` | `decimal` | Quantity shipped, blocked (sales) | ☐ | | | `QTYB_SO` | `decimal` | Quantity on order, blocked (sales) | ☐ | | | `QTYB_TBJ` | `decimal` | Number of stock movements, blocked | ☐ | | | `QTYB_TECH` | `decimal` | Quantity technical, blocked | ☐ | | | `QTYB_WIP` | `decimal` | Quantity in work in progress, blocked | ☐ | | | `QTYF_ACT` | `decimal` | Quantity processed, not blocked | ☐ | | | `QTYF_AVAIL` | `decimal` | Quantity available, not blocked | ☐ | | | `QTYF_ECON` | `decimal` | Quantity economic, not blocked | ☐ | | | `QTYF_FREE` | `decimal` | Quantity free, not blocked | ☐ | | | `QTYF_JOUR` | `decimal` | Quantity deferred, not blocked | ☐ | | | `QTYF_MFG` | `decimal` | Quantity in process, not blocked | ☐ | | | `QTYF_PO` | `decimal` | Quantity ordered, not blocked (purchase) | ☐ | | | `QTYF_RECD` | `decimal` | Quantity received, not blocked (purchase) | ☐ | | | `QTYF_RES` | `decimal` | Quantity reserved, not blocked | ☐ | | | `QTYF_SBO` | `decimal` | Quantity on backorder, not blocked (sales) | ☐ | | | `QTYF_SHIP` | `decimal` | Quantity shipped, not blocked (sales) | ☐ | | | `QTYF_SO` | `decimal` | Quantity on order, not blocked (sales) | ☐ | | | `QTYF_TBJ` | `decimal` | Number of stock movements, not blocked | ☐ | | | `QTYF_TECH` | `decimal` | Quantity technical, not blocked | ☐ | | | `QTYF_WIP` | `decimal` | Quantity in work in progress, not blocked | ☐ | | | `REC_BLK` | `boolean` | Blocked | ☐ | | | `REC_INV` | `boolean` | Stock item | ☐ | | | `REC_VAL` | `boolean` | Maintain stock value in general ledger | ☐ | | | `RPT_GRP1` | `string(10)` | Reporting group 1 | ☐ | | | `RPT_GRP2` | `string(10)` | Reporting group 2 | ☐ | | | `RPT_GRP3` | `string(10)` | Reporting group 3 | ☐ | | | `SAF_STCK` | `decimal` | Safety stock | ☐ | | | `SBS_ONCE` | `boolean` | Invoice once in subscription | ☐ | | | `SHIP_DAYS` | `decimal` | Lead time in days (sales) | ☐ | | | `SL_CODE1` | `string(10)` | Subledger 1 | ☐ | | | `SL_CODE2` | `string(10)` | Subledger 2 | ☐ | | | `SL_CODE3` | `string(10)` | Subledger 3 | ☐ | | | `STCK_COV` | `decimal` | Weeks of stock based on forecast | ☐ | | | `STCK_TO` | `decimal` | Stock turnover rate | ☐ | | | `STOCK_TYPE` | `decimal` | Stock type quantity display | ☐ | | | `SUP_AC` | `string(15)` | Supplier item code | ☐ | | | `SUP_NR` | `string(10)` | Supplier code | ☐ | | | `SVC_ART` | `boolean` | Service | ☐ | | | `TGT_INV` | `decimal` | Target stock | ☐ | | | `UNIT_SIZE` | `int32` | Quantity per package sales | ☐ | | | `UNT_CODE` | `string(10)` | Base unit | ☐ | | | `UNT_PCHS` | `string(10)` | Purchase unit | ☐ | | | `UNT_PCHSP` | `string(10)` | Purchase price unit | ☐ | | | `UNT_SELL` | `string(10)` | Sales unit | ☐ | | | `UNT_SELLP` | `string(10)` | Sales price unit | ☐ | | | `VAT_PCHS` | `string(2)` | VAT code purchase | ☐ | | | `VAT_SELL` | `string(2)` | VAT code sales | ☐ | | | `WHS_CODE` | `string(5)` | Warehouse code | ☐ | | | `WK_STCK` | `decimal` | Weeks of stock based on history | ☐ | |