---
title: "ADM_PRF2 (AccountView)"
description: "Administration settings table 2"
language: es
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/es/datamodels/vismaaccountview/AccountView..ADM_PRF2
original: https://documentation.invantive.eu/en/datamodels/vismaaccountview/AccountView..ADM_PRF2
updated: 2026-11-16T21:12:46Z
license: https://documentation.invantive.eu/es/
---

# ADM_PRF2: AccountView Administration settings table 2

`read only` `per partition`

- Catálogo: `AccountView`
- Label: Administration settings table 2

Solo puede recuperar datos.

## Columnas de la Tabla

A continuación se muestran las columnas de la tabla `ADM_PRF2`. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `ACCT_CRED` | `varchar2(10)` | Suppliers control account | [ ] |  |  |
| `ACCT_DEB` | `varchar2(10)` | Customers control account | [ ] |  |  |
| `ADDRESS1` | `varchar2(80)` | Address | [ ] |  |  |
| `ADM_COMPL` | `varchar2(10)` | Reference administration | [ ] |  |  |
| `ADM_EMAIL` | `varchar2(50)` | Company email address | [ ] |  |  |
| `ADM_FAX` | `varchar2(25)` | Company fax number | [ ] |  |  |
| `ADM_PHONE` | `varchar2(25)` | Company telephone number | [ ] |  |  |
| `ADM_URL` | `varchar2(60)` | Company website | [ ] |  |  |
| `ADV_REBOOK` | `char` | Advice: repost administration | [ ] |  |  |
| `AG_DEBLEN` | `int32` | Length of customer number in giro payment reference | [ ] |  |  |
| `AG_INVLEN` | `int32` | Length of invoice number in giro payment reference | [ ] |  |  |
| `AG_USEDEB` | `char` | Use customer number in payment reference | [ ] |  |  |
| `AP1_PREFIX` | `varchar2(2)` | Supplier number prefix | [ ] |  |  |
| `AR1_PREFIX` | `varchar2(2)` | Customer number prefix | [ ] |  |  |
| `ATP_DEMO` | `datetime` | Date stock over time | [ ] |  |  |
| `AUDIT_ON` | `char` | Activate audit trail | [ ] |  |  |
| `AUTH_EMP` | `varchar2(10)` | Approving employee | [ ] |  |  |
| `AUTO_NUM` | `char` | Number customers/suppliers automatically | [ ] |  |  |
| `BIV_PROF` | `varchar2(10)` | Capital goods adjustment declaration profile | [ ] |  |  |
| `BLK_DAILY` | `char` | Adding journals not allowed | [ ] |  |  |
| `BLK_HOURS` | `char` | Show blocked hours | [ ] |  |  |
| `BLK_VAT` | `char` | Adding VAT codes not allowed | [ ] |  |  |
| `BUD_PERSRT` | `int32` | Budget per week/month | [ ] |  |  |
| `CC_BBTP` | `decimal` | Default year-end transition value cost centres | [ ] |  |  |
| `CC_STAT` | `decimal` | Default status value cost centres | [ ] |  |  |
| `CCNG_DATE` | `datetime` | Última modificación | [ ] |  |  |
| `CENDR_ART1` | `varchar2(15)` | Item code 500 units for Cendris | [ ] |  |  |
| `CENDR_ART2` | `varchar2(15)` | Item code 1000 units for Cendris | [ ] |  |  |
| `CENDR_ART3` | `varchar2(15)` | Item code 2500 units for Cendris | [ ] |  |  |
| `CENDR_CRED` | `int32` | Number of units to assign to Cendris users | [ ] |  |  |
| `CHK_CLTCNG` | `int32` | Record client changes | [ ] |  |  |
| `CIMP_FMT` | `decimal` | Client import/export exchange format | [ ] |  |  |
| `CITY` | `varchar2(35)` | City | [ ] |  |  |
| `CLT_LEMP` | `varchar2(10)` | Relation type client representative | [ ] |  |  |
| `CLT_MSG` | `varchar2(4)` | Notification text for message | [ ] |  |  |
| `CLTA_MAIN` | `varchar2(10)` | Activity main area client request | [ ] |  |  |
| `CLTA_SUB` | `varchar2(10)` | Activity sub-area client request | [ ] |  |  |
| `CLTO_MAIN` | `varchar2(10)` | Activity main area client | [ ] |  |  |
| `CLTO_SUB` | `varchar2(10)` | Activity sub-area client | [ ] |  |  |
| `CNT_CODE` | `varchar2(2)` | ISO country code | [ ] |  |  |
| `COLL_ADV` | `char` | Collect advance note settlements | [ ] |  |  |
| `COMP_ID` | `varchar2(10)` | Business unit ID | [ ] |  |  |
| `COUNTRY` | `varchar2(30)` | Country | [ ] |  |  |
| `CPA_ACCT` | `varchar2(80)` | Office name | [ ] |  |  |
| `CPA_ADDR1` | `varchar2(80)` | Office address | [ ] |  |  |
| `CPA_CAPPR` | `char` | Client must approve return | [ ] |  |  |
| `CPA_CITY` | `varchar2(35)` | Office city | [ ] |  |  |
| `CPA_CNT` | `varchar2(2)` | Office ISO country code | [ ] |  |  |
| `CPA_CTRY` | `varchar2(30)` | Office country | [ ] |  |  |
| `CPA_PHONE` | `varchar2(25)` | Office telephone number | [ ] |  |  |
| `CPA_POBOX` | `varchar2(80)` | Office postal address | [ ] |  |  |
| `CPA_POCITY` | `varchar2(35)` | Office postal address city | [ ] |  |  |
| `CPA_POCODE` | `varchar2(10)` | Office postal address postcode | [ ] |  |  |
| `CPA_POST` | `varchar2(10)` | Office postcode | [ ] |  |  |
| `CPA_STEXT` | `varchar2(10)` | Office address addition | [ ] |  |  |
| `CPA_STNR` | `varchar2(10)` | Office house number | [ ] |  |  |
| `CPA_STREG` | `varchar2(40)` | Office address region | [ ] |  |  |
| `CPA_STRT` | `varchar2(60)` | Office street name | [ ] |  |  |
| `DEL_WDAY` | `char` | Deliver on working days only | [ ] |  |  |
| `DETAX_OFF` | `varchar2(4)` | Tax office | [ ] |  |  |
| `DETAX_STAT` | `varchar2(4)` | State | [ ] |  |  |
| `DFLT_PAR` | `varchar2(10)` | Default partner | [ ] |  |  |
| `DIM_DEF` | `varchar2(4)` | Dimension definition | [ ] |  |  |
| `DISP_INV` | `char` | Block automatic payments | [ ] |  |  |
| `DJ_EXT_SP` | `varchar2(3)` | System journal purchase/sales invoices | [ ] |  |  |
| `DOC_FONT` | `varchar2(40)` | Document font | [ ] |  |  |
| `DOS_LDP` | `decimal` | Last depreciated period | [ ] |  |  |
| `DSP_COL` | `int32` | Print column total | [ ] |  |  |
| `DSP_COL_H` | `int32` | Print column table header | [ ] |  |  |
| `DYN_HSTAL` | `char` | Update item history multiple years dynamically | [ ] |  |  |
| `DYN_HSTTL` | `char` | Update hours history multiple years dynamically | [ ] |  |  |
| `EDIC_CLT` | `varchar2(25)` | Client relation code | [ ] |  |  |
| `EDIC_VADIF` | `varchar2(10)` | VAT differences account (EDI-Circle) | [ ] |  |  |
| `EXP_AUTH` | `char` | Approve claim proposals | [ ] |  |  |
| `EXP_CHGACT` | `int32` | Cancel/postpone remaining amount to be invoiced after change | [ ] |  |  |
| `EXP_CHGLN` | `int32` | Make change | [ ] |  |  |
| `EXP_DIFDIV` | `int32` | Distribution of line amount | [ ] |  |  |
| `EXP_IMP` | `datetime` | Export date last import | [ ] |  |  |
| `EXP_PRNSO` | `char` | Print final invoice when generating invoice | [ ] |  |  |
| `FDIM_DEF` | `varchar2(4)` | Financial (Dimensions) | [ ] |  |  |
| `FNT_ALGN_C` | `int32` | Align text | [ ] |  |  |
| `FNT_ALGN_Y` | `int32` | Align amounts | [ ] |  |  |
| `FNT_BOLD_C` | `char` | Total text bold | [ ] |  |  |
| `FNT_BOLD_Y` | `char` | Total amounts bold | [ ] |  |  |
| `FNT_UNDR_Y` | `int32` | Underline total | [ ] |  |  |
| `GRAY_ACTM` | `varchar2(10)` | Graydon activity main area | [ ] |  |  |
| `GRAY_ACTS` | `varchar2(10)` | Graydon activity sub-area | [ ] |  |  |
| `GRAY_CPLIM` | `char` | Adopt credit limit automatically at customer | [ ] |  |  |
| `GRAY_CRACT` | `char` | Create Graydon activity | [ ] |  |  |
| `GRAY_DAYS` | `int32` | Graydon retrieval interval | [ ] |  |  |
| `GRP_EMP` | `char` | Condensed posting | [ ] |  |  |
| `HD1_FONT` | `varchar2(40)` | Heading 1 font | [ ] |  |  |
| `HD2_FONT` | `varchar2(40)` | Heading 2 font | [ ] |  |  |
| `HD3_FONT` | `varchar2(40)` | Heading 3 font | [ ] |  |  |
| `HOUR_PX` | `decimal` | Post hourly rate | [ ] |  |  |
| `ICL_RANGE` | `int32` | EC sales list reporting period | [ ] |  |  |
| `ID_COLOR` | `int32` | Administration background colour | [ ] |  |  |
| `IN_PAGEAPR` | `char` | Stock page approval required | [ ] |  |  |
| `INCL_ADD` | `char` | Add mandatory items automatically | [ ] |  |  |
| `INO_STGY` | `decimal` | Entry method stocktaking order | [ ] |  |  |
| `INO_TR_COD` | `varchar2(10)` | Transaction code | [ ] |  |  |
| `INT_ASS` | `varchar2(20)` | Name of umbrella organisation of tax service providers | [ ] |  |  |
| `INT_BECON` | `varchar2(17)` | BECON number | [ ] |  |  |
| `INT_CNAME` | `varchar2(35)` | Intermediary contact person | [ ] |  |  |
| `INT_NAME` | `varchar2(35)` | Name of electronic filing office | [ ] |  |  |
| `INT_USE` | `char` | Returns are handled by intermediary | [ ] |  |  |
| `KVK_NR` | `varchar2(10)` | Número de la Cámara de Comercio | [ ] |  |  |
| `MSG_BONUS` | `char` | Report bonus items | [ ] |  |  |
| `MSG_CROSS` | `char` | Report cross-selling items | [ ] |  |  |
| `MSG_EXCL` | `char` | Report exclusion items | [ ] |  |  |
| `MSG_INCL` | `char` | Report mandatory items | [ ] |  |  |
| `MSG_REPLA` | `char` | Report alternative items | [ ] |  |  |
| `MSG_UP` | `char` | Report up-selling items | [ ] |  |  |
| `NUM_LEN` | `int32` | Customer/supplier number length | [ ] |  |  |
| `OWN_HOURS` | `varchar2(1)` | Hours display | [ ] |  |  |
| `OWN_INV` | `varchar2(1)` | Claim proposal display | [ ] |  |  |
| `OWN_OI` | `varchar2(1)` | Invoice display | [ ] |  |  |
| `OWN_PROJ` | `varchar2(1)` | Project display | [ ] |  |  |
| `partition_code` | `varchar2` | Partition code | [x] |  |  |
| `partition_name` | `varchar2` | Partition name | [x] |  |  |
| `PICK_STGY` | `varchar2(25)` | Warehouse picking strategy | [ ] |  |  |
| `PJ_ALL` | `char` | Also show cost centres in projects overview | [ ] |  |  |
| `PJ_COMM1` | `varchar2(40)` | Draft invoices description | [ ] |  |  |
| `PJ_HIER1` | `varchar2(10)` | Project hierarchy 1 | [ ] |  |  |
| `PJ_HIER2` | `varchar2(10)` | Project hierarchy 2 | [ ] |  |  |
| `PJ_HIER3` | `varchar2(10)` | Project hierarchy 3 | [ ] |  |  |
| `PJ_INVAD` | `varchar2(15)` | Invoice item advances | [ ] |  |  |
| `PJ_INVDESC` | `varchar2(40)` | Invoice description | [ ] |  |  |
| `PJ_INVFA` | `varchar2(15)` | Invoice item fixed amounts | [ ] |  |  |
| `PJ_MIN` | `int64` | Minimum invoice amount projects | [ ] |  |  |
| `PJ1_BBTP` | `decimal` | Default year-end transition value projects | [ ] |  |  |
| `PJ1_BUDTP` | `decimal` | Default budgeting method value projects | [ ] |  |  |
| `PJ1_STAT` | `decimal` | Default status value projects | [ ] |  |  |
| `PJB_DEC` | `decimal` | Number of decimals project monitoring | [ ] |  |  |
| `PMT_ARTS` | `varchar2(2)` | Item number for transit | [ ] |  |  |
| `PMT_CHQ` | `char` | Payment by cheque | [ ] |  |  |
| `PMT_CRECV` | `char` | All bank charges for account of beneficiary | [ ] |  |  |
| `PMT_CSEND` | `char` | Charges of other banks for account of principal | [ ] |  |  |
| `PMT_DESC` | `varchar2(80)` | Description for DNB | [ ] |  |  |
| `PMT_FAST` | `char` | Urgent foreign payment | [ ] |  |  |
| `PMT_GOODS` | `varchar2(2)` | Goods code | [ ] |  |  |
| `PMT_ORD1` | `varchar2(2)` | Payment instruction code 1 | [ ] |  |  |
| `PMT_ORD2` | `varchar2(2)` | Payment instruction code 2 | [ ] |  |  |
| `PMT_ORD3` | `varchar2(2)` | Payment instruction code 3 | [ ] |  |  |
| `PMT_ORD4` | `varchar2(2)` | Payment instruction code 4 | [ ] |  |  |
| `PMT_TYPE` | `varchar2(2)` | Foreign exchange reporting | [ ] |  |  |
| `PO_BOX` | `varchar2(80)` | Postal address | [ ] |  |  |
| `PO_CITY` | `varchar2(35)` | Postal address city | [ ] |  |  |
| `PO_CODE` | `varchar2(10)` | Postal address postcode | [ ] |  |  |
| `PO_COMM2` | `varchar2(40)` | Default receipt description | [ ] |  |  |
| `PO_COMM3` | `varchar2(40)` | Default purchase invoice description | [ ] |  |  |
| `POST_CODE` | `varchar2(10)` | Postcode | [ ] |  |  |
| `PRJ_PERIOD` | `int32` | Project period | [ ] |  |  |
| `QD_CALC` | `decimal` | Price agreement calculation method | [ ] |  |  |
| `QD_SPL` | `char` | Merge lines per item code | [ ] |  |  |
| `QD_VIEW` | `decimal` | Scale pricing display | [ ] |  |  |
| `QT_ACT` | `char` | Create quotation activities | [ ] |  |  |
| `QT_ACTM` | `varchar2(10)` | Quotation activity main area | [ ] |  |  |
| `QT_ACTP` | `varchar2(10)` | Quotation activity priority | [ ] |  |  |
| `QT_ACTSACC` | `varchar2(10)` | Quotation activity sub-area accept quotation | [ ] |  |  |
| `QT_ACTSCHG` | `varchar2(10)` | Quotation activity sub-area change quotation | [ ] |  |  |
| `QT_ACTSDEF` | `varchar2(10)` | Quotation activity sub-area final quotation | [ ] |  |  |
| `QT_ACTSORD` | `varchar2(10)` | Quotation activity sub-area create sales order | [ ] |  |  |
| `QT_ACTSREJ` | `varchar2(10)` | Quotation activity sub-area reject quotation | [ ] |  |  |
| `QT_FILE` | `varchar2(100)` | Quotation file name | [ ] |  |  |
| `QT_LNKDEB` | `char` | Link quotation document to company | [ ] |  |  |
| `QT_QTAPR` | `char` | Quotation approval required | [ ] |  |  |
| `QTAUTH_CHK` | `varchar2(4)` | Quotation approval checks | [ ] |  |  |
| `REC_ID` | `varchar2(10)` | Unique code | [ ] |  |  |
| `RELT_CMCM1` | `varchar2(10)` | Head office at company | [ ] |  |  |
| `RELT_CMCM2` | `varchar2(10)` | Dealer at company | [ ] |  |  |
| `RELT_CMCM3` | `varchar2(10)` | Accountant at company | [ ] |  |  |
| `RELT_OPCM1` | `varchar2(10)` | Company at opportunity | [ ] |  |  |
| `RELT_OPCM2` | `varchar2(10)` | Competitor at opportunity | [ ] |  |  |
| `RELT_OPEMP` | `varchar2(10)` | Employee at opportunity | [ ] |  |  |
| `RELT_PJCM1` | `varchar2(10)` | Principal at project | [ ] |  |  |
| `RELT_PJEMP` | `varchar2(10)` | Project manager at projects | [ ] |  |  |
| `REM_ACT` | `char` | Create dunning activity | [ ] |  |  |
| `REM_ACTM` | `varchar2(10)` | Dunning activity main area | [ ] |  |  |
| `REM_ACTP` | `varchar2(10)` | Dunning activity priority | [ ] |  |  |
| `REM_ACTS1` | `varchar2(10)` | Dunning activity sub-area 1 | [ ] |  |  |
| `REM_ACTS2` | `varchar2(10)` | Dunning activity sub-area 2 | [ ] |  |  |
| `REM_ACTS3` | `varchar2(10)` | Dunning activity sub-area 3 | [ ] |  |  |
| `RTF_FNT` | `varchar2(40)` | Free text font | [ ] |  |  |
| `SBS_DEL_AO` | `char` | Delete one-off items from subscription after invoicing | [ ] |  |  |
| `SBS_EXPL` | `char` | Explode composite item in subscription | [ ] |  |  |
| `SBS_PRNSO` | `char` | Print final invoice when generating invoice | [ ] |  |  |
| `SBS_TGT` | `int32` | Generate subscription as | [ ] |  |  |
| `SG_CODE` | `varchar2(10)` | Default version | [ ] |  |  |
| `SI_INVAPR` | `char` | Sales invoice approval required | [ ] |  |  |
| `SI1_INV` | `int32` | Assign invoice number | [ ] |  |  |
| `SIAUTH_CHK` | `varchar2(4)` | Sales invoice approval checks | [ ] |  |  |
| `SIGN_METH` | `int32` | Signing method | [ ] |  |  |
| `SO_COMM2` | `varchar2(40)` | Default issue order description | [ ] |  |  |
| `SO_COMM3` | `varchar2(40)` | Default sales invoice description | [ ] |  |  |
| `SO1_PRNSO` | `char` | Print final invoice when generating invoice | [ ] |  |  |
| `SOAUTH_CHK` | `varchar2(4)` | Sales order approval checks | [ ] |  |  |
| `SP_PICAPR` | `char` | Issue order approval required | [ ] |  |  |
| `SP_PICRET` | `char` | Packing list completion required | [ ] |  |  |
| `SP_POSTADR` | `char` | Use postal address as delivery address | [ ] |  |  |
| `SPAUTH_CHK` | `varchar2(4)` | Issue order approval checks | [ ] |  |  |
| `ST_EXTRA` | `varchar2(10)` | Address addition | [ ] |  |  |
| `ST_NR` | `varchar2(10)` | House number | [ ] |  |  |
| `ST_REGION` | `varchar2(40)` | Address region | [ ] |  |  |
| `ST_STREET` | `varchar2(60)` | Nombre de la Calle | [ ] |  |  |
| `SW_AANTAL` | `char` | Show quantity | [ ] |  |  |
| `SW_GEWICHT` | `char` | Show weight | [ ] |  |  |
| `SW_VENNOOT` | `char` | Show partner | [ ] |  |  |
| `TAX_ID` | `varchar2(10)` | Citizen service number | [ ] |  |  |
| `TAX_NAME` | `varchar2(35)` | Company contact person | [ ] |  |  |
| `TAX_PROF` | `varchar2(10)` | Return profile | [ ] |  |  |
| `TBL_HD_FNT` | `varchar2(40)` | Table header font | [ ] |  |  |
| `TBL_LN_FNT` | `varchar2(40)` | Table text font | [ ] |  |  |
| `TIM_APPR` | `char` | Project manager must approve hours lines | [ ] |  |  |
| `TIM_AUCO` | `decimal` | Complete automatically | [ ] |  |  |
| `TIM_AUTOF` | `char` | Approve hours page automatically | [ ] |  |  |
| `TIM_CHKCOO` | `decimal` | Check overrun | [ ] |  |  |
| `TIM_CHKCOU` | `decimal` | Check underrun | [ ] |  |  |
| `TIM_EXTHR` | `char` | Overtime always external | [ ] |  |  |
| `TIM_LNDS` | `char` | Use hours entry description when posting | [ ] |  |  |
| `TIM_OBLCST` | `char` | Project code mandatory on entry | [ ] |  |  |
| `TIM_RATESE` | `varchar2(4)` | Sequence external rate | [ ] |  |  |
| `TIM_RATESI` | `varchar2(4)` | Sequence internal rate | [ ] |  |  |
| `TIME_SHEET` | `decimal` | Hours entry administration | [ ] |  |  |
| `TX2_PROF` | `varchar2(10)` | Taxonomy profile | [ ] |  |  |
| `UPDT_HSTAL` | `int32` | Update item history multiple years per type | [ ] |  |  |
| `VAT_RANGE` | `int32` | VAT return period | [ ] |  |  |
| `VAT_RET_NR` | `varchar2(14)` | VAT number VAT return | [ ] |  |  |
| `WM_FOOTSHW` | `char` | Footer as watermark on all reports | [ ] |  |  |
| `WM_FOOTTXT` | `varchar2(40)` | Footer watermark | [ ] |  |  |
| `WM_HEADSHW` | `char` | Header as watermark on all reports | [ ] |  |  |
| `WM_HEADTXT` | `varchar2(40)` | Header watermark | [ ] |  |  |
| `WM_IMGFILE` | `varchar2(80)` | Watermark image | [ ] |  |  |
| `WM_IMGSHOW` | `char` | Image as watermark on all reports | [ ] |  |  |
| `WM_TXTCOL` | `int32` | Watermark text colour | [ ] |  |  |
| `WM_TXTFONT` | `varchar2(40)` | Watermark text font | [ ] |  |  |
