# ADM_PRF: Administration settings - Name: `ADM_PRF` - Catalog: `AccountView` - Label: Administration settings - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `ADM_PRF` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_BAMT` | `string(10)` | Bank charges account | ☐ | | | `ACCT_CDIF` | `string(10)` | Exchange rate differences account | ☐ | | | `ACCT_CSAP` | `string(10)` | Prepayments account | ☐ | | | `ACCT_CSAR` | `string(10)` | Prepayments account | ☐ | | | `ACCT_DIF` | `string(10)` | Other differences account | ☐ | | | `ACCT_DSAP` | `string(10)` | Supplier payment discount account | ☐ | | | `ACCT_DSAR` | `string(10)` | Customer payment discount account | ☐ | | | `ACCT_DSMS` | `string(10)` | Discounts account (sales) | ☐ | | | `ACCT_EDIF` | `string(10)` | Euro conversion differences account | ☐ | | | `ACCT_INT` | `string(10)` | Interest/costs account | ☐ | | | `ACCT_NAME` | `string(40)` | Administration company name | ☐ | | | `ACCT_PDIF` | `string(10)` | Payment differences account | ☐ | | | `ACCT_POPI` | `string(10)` | Invoices to be received account | ☐ | | | `ACCT_PROF` | `string(10)` | Previous financial year result | ☐ | | | `ACCT_RNDB` | `string(10)` | Balance sheet rounding differences account | ☐ | | | `ACCT_RNDI` | `string(10)` | Profit and loss rounding differences account | ☐ | | | `ACCT_TRCR` | `string(10)` | Accruals and deferrals credit | ☐ | | | `ACCT_TRDT` | `string(10)` | Accruals and deferrals debit | ☐ | | | `ACCT_TRIR` | `string(10)` | Report rounding | ☐ | | | `ACPY_CR` | `string(10)` | Previous financial year items credit | ☐ | | | `ACPY_DT` | `string(10)` | Previous financial year items debit | ☐ | | | `ADD_ORGLD` | `boolean` | Add original heading | ☐ | | | `ADM_ACC` | `decimal` | Status | ☐ | | | `ADM_EXT` | `boolean` | External administration | ☐ | | | `ADM_MODEL` | `string(10)` | Central administration | ☐ | | | `AGE_TERM1` | `decimal` | Ageing analysis term 1 | ☐ | | | `AGE_TERM2` | `decimal` | Ageing analysis term 2 | ☐ | | | `AGE_TERM3` | `decimal` | Ageing analysis term 3 | ☐ | | | `APX_DEC` | `decimal` | Number of decimals prices | ☐ | | | `ART_DEC` | `decimal` | Number of decimals quantities | ☐ | | | `ART_PMSC` | `string(15)` | Miscellaneous purchase item code | ☐ | | | `ART_POORD` | `string(15)` | Purchase order costs item code | ☐ | | | `ART_POSH` | `string(15)` | Purchase transport costs item code | ☐ | | | `ART_SMSC` | `string(15)` | Miscellaneous sales item code | ☐ | | | `ART_SOORD` | `string(15)` | Sales order costs item code | ☐ | | | `ART_SOSH` | `string(15)` | Sales transport costs item code | ☐ | | | `AUTO_CODE` | `boolean` | Use auto-coding | ☐ | | | `AUTO_INV` | `boolean` | Post invoice and payment simultaneously | ☐ | | | `BANK_COST` | `string(10)` | Bank charges account | ☐ | | | `BANK_PROC` | `string(10)` | Interest account | ☐ | | | `BCK_CINV` | `boolean` | Include copy documents in backup | ☐ | | | `BEG_DATE` | `datetime` | Financial year start date | ☐ | | | `CAP_PPS` | `decimal` | Nominal value of share | ☐ | | | `CAP_TOT` | `decimal` | Authorised capital | ☐ | | | `CAP_USED` | `decimal` | Paid-up capital | ☐ | | | `CHK_INI` | `int32` | Stock check stock movements | ☐ | | | `CHK_SOI` | `int32` | Stock check sales orders | ☐ | | | `CINV_PATH` | `string(150)` | Copy documents folder name | ☐ | | | `CLT_CPER` | `string(3)` | Blocked for client use up to period | ☐ | | | `CN_TYPE` | `decimal` | Last consolidation performed | ☐ | | | `CNG_CNT` | `boolean` | Country cannot be changed | ☐ | | | `CNG_DATE` | `datetime` | Date last modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNT_CUR` | `string(3)` | Country currency code | ☐ | | | `COGS_COR` | `boolean` | Post cost price corrections | ☐ | | | `COLL_POB` | `boolean` | Collect draft purchase orders | ☐ | | | `COMP_ACTV` | `string(4)` | Business activity | ☐ | | | `COMP_ATTN` | `string(40)` | Attention of | ☐ | | | `COMP_DEAR` | `string(40)` | Salutation | ☐ | | | `COMP_DIRC` | `string(40)` | Director | ☐ | | | `CON_DEBNK` | `boolean` | Show Bankleitzahl for relations | ☐ | | | `COPY_INV` | `boolean` | Create copy documents | ☐ | | | `CPA_NAME` | `string(40)` | Prepared by | ☐ | | | `CPA_SIGN` | `string(40)` | Signature | ☐ | | | `CTAX_CY` | `decimal` | Corporate income tax current year | ☐ | | | `CTAX_PY` | `decimal` | Corporate income tax previous year | ☐ | | | `CUR_CODE` | `string(3)` | Administration currency code | ☐ | | | `CUR_DEC` | `decimal` | Number of decimals amounts | ☐ | | | `CUR_PNT` | `string(1)` | Decimal separator | ☐ | | | `CUR_SEP` | `string(1)` | Thousands separator | ☐ | | | `DATE_ACT` | `boolean` | Create activity when delivery date changes | ☐ | | | `DATE_LAY` | `string(250)` | Delivery date email layout | ☐ | | | `DATE_MAIL` | `boolean` | Send email to customer when delivery date changes | ☐ | | | `DATE_NOT` | `boolean` | Send email to salesperson when delivery date changes | ☐ | | | `DATE_SUB` | `string(10)` | Activity sub-area delivery date change | ☐ | | | `DATE_TYP` | `string(10)` | Activity main area delivery date change | ☐ | | | `DATE_TYPE` | `decimal` | Date type | ☐ | | | `DEL_ACT` | `boolean` | Create activity when sales order is delivered | ☐ | | | `DEL_LAY` | `string(250)` | Receipts email layout | ☐ | | | `DEL_MAIL` | `boolean` | Send email when sales order is delivered | ☐ | | | `DEL_NOT` | `boolean` | Send email when sales order can be delivered | ☐ | | | `DEL_POL` | `boolean` | Delete fully received order lines | ☐ | | | `DEL_SOL` | `boolean` | Delete delivered order lines | ☐ | | | `DEL_SUB` | `string(10)` | Activity sub-area shipment | ☐ | | | `DEL_TYP` | `string(10)` | Activity main area shipment | ☐ | | | `DISC_DEC` | `decimal` | Number of decimals discount percentage | ☐ | | | `DJ_CASH` | `string(3)` | System journal counter invoices | ☐ | | | `DJ_CORR` | `string(3)` | System journal corrections | ☐ | | | `DJ_DJI` | `string(3)` | System journal journal messages | ☐ | | | `DJ_DJIUBLP` | `string(3)` | System journal UBL invoices (purchase) | ☐ | | | `DJ_DJIUBLS` | `string(3)` | System journal UBL invoices (sales) | ☐ | | | `DJ_EDIC_P` | `string(3)` | System journal EDI-Circle (purchase) | ☐ | | | `DJ_EDIC_S` | `string(3)` | System journal EDI-Circle (sales) | ☐ | | | `DJ_II` | `string(3)` | System journal stock movements | ☐ | | | `DJ_MFG` | `string(3)` | System journal production orders | ☐ | | | `DJ_OI` | `string(3)` | System journal settle open items | ☐ | | | `DJ_PI` | `string(3)` | System journal purchase invoices | ☐ | | | `DJ_PPS` | `string(3)` | System journal receipts | ☐ | | | `DJ_REVA` | `string(3)` | System journal stock revaluation | ☐ | | | `DJ_SI` | `string(3)` | System journal sales invoices | ☐ | | | `DOC_PATH` | `string(150)` | Documents folder name | ☐ | | | `DP_CHECK` | `boolean` | Period/date check | ☐ | | | `DSP_THOU` | `boolean` | Show thousands separator | ☐ | | | `EMP_CY` | `decimal` | Number of employees current year | ☐ | | | `EMP_PY` | `decimal` | Number of employees previous year | ☐ | | | `END_DATE` | `datetime` | Financial year end date | ☐ | | | `EXP_CINV` | `boolean` | Include copy documents when carrying over administration | ☐ | | | `EXP_DATE` | `datetime` | Last export | ☐ | | | `EXPL_CALC` | `decimal` | Price calculation | ☐ | | | `EXPL_INV` | `boolean` | Suppress explosion on invoice | ☐ | | | `EXPL_PSLP` | `boolean` | Suppress explosion on delivery note | ☐ | | | `EXPL_QT` | `boolean` | Suppress explosion on quotation | ☐ | | | `EXPL_RESN` | `float` | Reservation | ☐ | | | `EXPL_SOLB` | `boolean` | Suppress explosion on shipping label | ☐ | | | `EXPL_SOOC` | `boolean` | Suppress explosion on order confirmation | ☐ | | | `EXPL_SOSL` | `boolean` | Suppress explosion on consignment note | ☐ | | | `EXT_COAPP` | `boolean` | Available in AccountView Contact | ☐ | | | `FSL_COST` | `string(10)` | Cost centre code reports | ☐ | | | `FSL_CUR` | `string(3)` | Currency code reports | ☐ | | | `FSL_FUPD` | `boolean` | Update reports quickly | ☐ | | | `FSL_PER1` | `decimal` | Period figures first column | ☐ | | | `FSL_PER2` | `decimal` | Period figures second column | ☐ | | | `FSL_RND` | `decimal` | Round reports | ☐ | | | `GEN_POO` | `boolean` | Create final purchase orders | ☐ | | | `HOME_CNT` | `string(2)` | ISO country code automatic foreign payment | ☐ | | | `HOME_ICUR` | `string(3)` | ISO currency automatic foreign payment | ☐ | | | `ICNT_CODE` | `string(2)` | IS country code | ☐ | | | `ID_ALL` | `boolean` | Import as fully approved | ☐ | | | `ID_APP` | `boolean` | Add to page | ☐ | | | `ID_DIF` | `boolean` | Write off differences | ☐ | | | `ID_DJC` | `string(3)` | Journal code transaction import | ☐ | | | `ID_FILE` | `string(40)` | File name transaction import | ☐ | | | `ID_TYPE` | `float` | File type transaction import | ☐ | | | `IMP_DATE` | `datetime` | Last import | ☐ | | | `IMP_DJP` | `decimal` | Handling of existing journal pages during import | ☐ | | | `IMP_SET` | `decimal` | Overwrite existing master data during import | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INPL_BLK` | `boolean` | Select from free lists only | ☐ | | | `INV_VAL` | `decimal` | Stock valuation method | ☐ | | | `INVDED_CY` | `decimal` | Investment deduction current year | ☐ | | | `INVDED_PY` | `decimal` | Investment deduction previous year | ☐ | | | `IS_DCCNT` | `string(2)` | IS country code customer/supplier | ☐ | | | `IS_DOMPO` | `boolean` | IS customs clearance permit purchase | ☐ | | | `IS_DOMSO` | `boolean` | IS customs clearance permit sales | ☐ | | | `IS_POMIN` | `decimal` | IS declaration threshold purchase | ☐ | | | `IS_SOMIN` | `decimal` | IS declaration threshold sales | ☐ | | | `ISHP_CODE` | `string(1)` | IS mode of transport | ☐ | | | `ISXF_PO` | `string(3)` | IS statistical factor code purchase | ☐ | | | `ISXF_SO` | `string(3)` | IS statistical factor code sales | ☐ | | | `ISYS_CODE` | `string(2)` | IS regime | ☐ | | | `ITYP_CODE` | `string(1)` | IS transaction code | ☐ | | | `LAST_CPER` | `string(3)` | Last blocked period | ☐ | | | `LAST_DEP` | `decimal` | Last depreciated period | ☐ | | | `LAST_FPER` | `string(3)` | Period completed up to and including | ☐ | | | `LAST_PER` | `decimal` | Last closed period | ☐ | | | `LDCOST_CY` | `decimal` | Partially deductible costs current year | ☐ | | | `LDCOST_PY` | `decimal` | Partially deductible costs previous year | ☐ | | | `LNG_CODE` | `string(5)` | Language code | ☐ | | | `LOC_CODE` | `string(5)` | Default warehouse location | ☐ | | | `MRK_CRED` | `boolean` | Mark credit notes | ☐ | | | `NCBEX_LIM` | `decimal` | Exemption limit | ☐ | | | `NCBREG_NR` | `string(8)` | DNB registration number | ☐ | | | `NCBSEC_NR` | `string(4)` | Industry | ☐ | | | `NCBTRD_NR` | `string(4)` | Dealer number | ☐ | | | `NO_DJACHK` | `boolean` | No access control per journal | ☐ | | | `ORD_ACT` | `boolean` | Create activity when sales order is accepted | ☐ | | | `ORD_MAIL` | `boolean` | Send email when sales order is accepted | ☐ | | | `ORD_SUB` | `string(10)` | Activity sub-area order confirmation | ☐ | | | `ORD_TYP` | `string(10)` | Activity main area order confirmation | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PAY_COST` | `string(25)` | Payment method bank charges | ☐ | | | `PAY_PROC` | `string(25)` | Payment method interest | ☐ | | | `PD_GROSS` | `boolean` | Calculate payment discount on gross | ☐ | | | `PD_PFX` | `string(15)` | Payment reference | ☐ | | | `PD_VCAP` | `string(2)` | VAT code credit limit supplier | ☐ | | | `PD_VCAR` | `string(2)` | VAT code credit limit customer | ☐ | | | `PER_YEAR` | `decimal` | Number of periods per year | ☐ | | | `PJ1_QTACC` | `decimal` | Status after quotation accepted | ☐ | | | `PJ1_QTDEF` | `decimal` | Status after final quotation | ☐ | | | `PJ1_QTREJ` | `decimal` | Status after quotation rejected | ☐ | | | `PO_CNFAPR` | `boolean` | Order confirmation approval required | ☐ | | | `PO_CNFCHK` | `boolean` | Order confirmation check required | ☐ | | | `PO_CNFREC` | `boolean` | Receipt of order confirmation required | ☐ | | | `PO_COMM1` | `string(40)` | Default purchase order description | ☐ | | | `PO_GROSS` | `boolean` | Purchase orders gross by default | ☐ | | | `PO_INVAPR` | `boolean` | Purchase invoice approval required | ☐ | | | `PO_INVCHK` | `boolean` | Purchase invoice check required | ☐ | | | `PO_INVREC` | `boolean` | Receipt of purchase invoice required | ☐ | | | `PO_ORDAPR` | `boolean` | Purchase order approval required | ☐ | | | `POL_SOL` | `boolean` | Update backorders automatically | ☐ | | | `POST_PUW` | `boolean` | Post automatic payment to creditors control account | ☐ | | | `POST_RUW` | `boolean` | Post direct debit to debtors control account | ☐ | | | `PST_RECD` | `boolean` | Post invoices to be received | ☐ | | | `QD_CHK` | `boolean` | Check scale pricing | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `REM_METH` | `decimal` | Dunning method | ☐ | | | `REM_RNG1` | `decimal` | Dunning term 1 due period | ☐ | | | `REM_RNG2` | `decimal` | Dunning term 2 due period | ☐ | | | `REM_RNG3` | `decimal` | Dunning term 3 due period | ☐ | | | `RPT_DATE` | `datetime` | Report date | ☐ | | | `RT_DJP` | `boolean` | Direct processing journals | ☐ | | | `RT_PODS` | `boolean` | Direct processing purchase payment discount | ☐ | | | `RT_POP` | `boolean` | Direct processing purchase invoices | ☐ | | | `RT_SODS` | `boolean` | Direct processing sales payment discount | ☐ | | | `RT_SOP` | `boolean` | Direct processing sales invoices | ☐ | | | `SET_POB` | `boolean` | Confirm creation of draft purchase orders | ☐ | | | `SHOW_DDESC` | `boolean` | Show dimension description | ☐ | | | `SHOW_OI60` | `boolean` | Do not update open items display immediately during journal entry | ☐ | | | `SO_CNFREC` | `boolean` | Order confirmation return | ☐ | | | `SO_CNFSND` | `boolean` | Order confirmation printing required | ☐ | | | `SO_COMM1` | `string(40)` | Default sales order description | ☐ | | | `SO_GROSS` | `boolean` | Sales orders/invoices gross by default | ☐ | | | `SO_NULREC` | `boolean` | Reset periodic orders to zero | ☐ | | | `SO_ORDAPR` | `boolean` | Sales order approval required | ☐ | | | `SO_PACAPR` | `boolean` | Delivery approval required | ☐ | | | `SO_PACCHK` | `boolean` | Delivery note completion required | ☐ | | | `SO_PACPRN` | `boolean` | Delivery note printing required | ☐ | | | `SO_SUPNUL` | `boolean` | Suppress zero lines on delivery note | ☐ | | | `SOC_AMT` | `int64` | Max difference amount | ☐ | | | `SOC_DIF` | `string(10)` | Differences account | ☐ | | | `SOC_OPEN` | `boolean` | Sales on account | ☐ | | | `SOC_SUB` | `string(10)` | Counter invoice customer | ☐ | | | `SUP_COST` | `boolean` | Skip cost centre code | ☐ | | | `SUP_CUR` | `boolean` | Skip foreign currency | ☐ | | | `SUP_SUB` | `boolean` | Skip customer/supplier | ☐ | | | `SUP_VAT` | `boolean` | Skip VAT code | ☐ | | | `SX_STGY` | `string(25)` | Intrastat declaration | ☐ | | | `TPL_PATH` | `string(150)` | Templates folder name | ☐ | | | `TRF_ACCT` | `string(10)` | Transfer clearing account | ☐ | | | `VAT_DEC` | `decimal` | Number of decimals VAT return | ☐ | | | `VAT_IC_NR` | `string(14)` | VAT number EC sales list | ☐ | | | `VAT_NR` | `string(14)` | Fiscal VAT number | ☐ | | | `VAT_TERM` | `decimal` | VAT number verification period | ☐ | | | `VERSION` | `string(4)` | Administration version number | ☐ | | | `VERSIONV` | `string(5)` | Administration version number (function) | ☐ | | | `WHS_CODE` | `string(5)` | Default warehouse code | ☐ | |