---
title: "ADM_PRF (AccountView)"
description: "Administration settings"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..ADM_PRF
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..ADM_PRF
updated: 2026-11-16T21:12:45Z
license: https://documentation.invantive.eu/en/
---

# ADM_PRF: AccountView Administration settings

`read only` `per partition`

- Catalog: `AccountView`
- Label: Administration settings

Can only retrieve data.

## Table Columns

The columns of the table `ADM_PRF` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

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

