# av_art_hdr 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_hdr` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_NR` | `string(10)` | | | | | `APX_LIST` | `string(5)` | | | | | `ASS_CODE` | `string(10)` | | | | | `AUTH_HIST` | `string` | | | | | `BLK_AMT` | `decimal` | | | | | `BLK_CUR` | `decimal` | | | | | `BV_AMT` | `decimal` | | | | | `BV_CUR` | `decimal` | | | | | `COMMENT1` | `string(40)` | | | | | `COMMENT2` | `string` | | | | | `COMMENT3` | `string` | | | | | `COST_CODE` | `string(10)` | | | | | `CPY_PRN` | `string(100)` | | | | | `CPY_PRTYPE` | `string(40)` | | | | | `CRED_DAYS` | `decimal` | | | | | `CUR_CODE` | `string(3)` | | | | | `DD_ACT` | `boolean` | | | | | `DEL_ADDR` | `string` | | | | | `DEL_CP` | `string(40)` | | | | | `DEL_DATE` | `datetime` | | | | | `DISC_CODE` | `string(2)` | | | | | `DISC_DAYS` | `decimal` | | | | | `DJ_CODE` | `string(3)` | | | | | `DJ_POST` | `boolean` | | | | | `DOC_NR` | `string(10)` | | | | | `EMP_NR` | `string(10)` | | | | | `EXCH_RATE` | `double` | | | | | `EXT_DESC` | `string(40)` | | | | | `EXT_ID` | `string(32)` | | | | | `EXT_TYPE` | `int32` | | | | | `HDR_TYPE` | `decimal` | | | | | `INV_CP` | `string(40)` | | | | | `INV_DATE` | `datetime` | | | | | `INV_NR` | `string(10)` | | | | | `LB_AMT` | `decimal` | | | | | `LB_CUR` | `decimal` | | | | | `MAND_B2B` | `boolean` | | | | | `MAND_DATE` | `datetime` | | | | | `MAND_ID` | `string(35)` | | | | | `MAND_SEQ` | `int32` | | | | | `OC_CUR` | `decimal` | | | | | `ORD_COST` | `decimal` | | | | | `ORD_CUR` | `decimal` | | | | | `ORD_DATE` | `datetime` | | | | | `ORD_NR` | `string(10)` | | | | | `ORD_TOT` | `decimal` | | | | | `PAC_NR` | `string(10)` | | | | | `PAGE_NR` | `string(10)` | | | | | `PAY_AMT` | `decimal` | | | | | `PAY_CUR` | `decimal` | | | | | `PAY_VAT` | `decimal` | | | | | `PAY_VATC` | `string(2)` | | | | | `PCT_LIST` | `string(5)` | | | | | `PD_AMT` | `decimal` | | | | | `PD_PCT` | `decimal` | | | | | `PD_VAT` | `decimal` | | | | | `PDA_CUR` | `decimal` | | | | | `PDV_CUR` | `decimal` | | | | | `PERIOD` | `decimal` | | | | | `PREF_DATE` | `datetime` | | | | | `PROJ_CODE` | `string(10)` | | | | | `QT_ORD_NR` | `string(10)` | | | | | `REC_ID` | `string(10)` | | | | | `RPL_DEL` | `string(10)` | | | | | `RPL_INV` | `string(10)` | | | | | `SBS_NR` | `string(10)` | | | | | `SC_CUR` | `decimal` | | | | | `SEL_CODE` | `string(5)` | | | | | `SG_CODE` | `string(10)` | | | | | `SHIP_COST` | `decimal` | | | | | `SHIP_MTH` | `string(10)` | | | | | `SUB_CUR` | `decimal` | | | | | `SUB_TOT` | `decimal` | | | | | `TRN_BOOK` | `boolean` | | | | | `TRN_CNT` | `int32` | | | | | `TRN_START` | `int32` | | | | | `VAT_CUR` | `decimal` | | | | | `VAT_ORD` | `decimal` | | | | | `VAT_SHIP` | `decimal` | | | | | `VAT_TOT` | `decimal` | | | | | `VC_ORD` | `string(2)` | | | | | `VC_SHIP` | `string(2)` | | | | | `VO_CUR` | `decimal` | | | | | `VS_CUR` | `decimal` | | | |