# ADM_PRF2: Administration settings table 2 - Name: `ADM_PRF2` - Catalog: `AccountView` - Label: Administration settings table 2 - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `ADM_PRF2` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCT_CRED` | `string(10)` | Suppliers control account | ☐ | | | `ACCT_DEB` | `string(10)` | Customers control account | ☐ | | | `ADDRESS1` | `string(80)` | Address | ☐ | | | `ADM_COMPL` | `string(10)` | Reference administration | ☐ | | | `ADM_EMAIL` | `string(50)` | Company email address | ☐ | | | `ADM_FAX` | `string(25)` | Company fax number | ☐ | | | `ADM_PHONE` | `string(25)` | Company telephone number | ☐ | | | `ADM_URL` | `string(60)` | Company website | ☐ | | | `ADV_REBOOK` | `boolean` | 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` | `boolean` | Use customer number in payment reference | ☐ | | | `AP1_PREFIX` | `string(2)` | Supplier number prefix | ☐ | | | `AR1_PREFIX` | `string(2)` | Customer number prefix | ☐ | | | `ATP_DEMO` | `datetime` | Date stock over time | ☐ | | | `AUDIT_ON` | `boolean` | Activate audit trail | ☐ | | | `AUTH_EMP` | `string(10)` | Approving employee | ☐ | | | `AUTO_NUM` | `boolean` | Number customers/suppliers automatically | ☐ | | | `BIV_PROF` | `string(10)` | Capital goods adjustment declaration profile | ☐ | | | `BLK_DAILY` | `boolean` | Adding journals not allowed | ☐ | | | `BLK_HOURS` | `boolean` | Show blocked hours | ☐ | | | `BLK_VAT` | `boolean` | 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` | Last modified | ☐ | | | `CENDR_ART1` | `string(15)` | Item code 500 units for Cendris | ☐ | | | `CENDR_ART2` | `string(15)` | Item code 1000 units for Cendris | ☐ | | | `CENDR_ART3` | `string(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` | `string(35)` | City | ☐ | | | `CLT_LEMP` | `string(10)` | Relation type client representative | ☐ | | | `CLT_MSG` | `string(4)` | Notification text for message | ☐ | | | `CLTA_MAIN` | `string(10)` | Activity main area client request | ☐ | | | `CLTA_SUB` | `string(10)` | Activity sub-area client request | ☐ | | | `CLTO_MAIN` | `string(10)` | Activity main area client | ☐ | | | `CLTO_SUB` | `string(10)` | Activity sub-area client | ☐ | | | `CNT_CODE` | `string(2)` | ISO country code | ☐ | | | `COLL_ADV` | `boolean` | Collect advance note settlements | ☐ | | | `COMP_ID` | `string(10)` | Business unit ID | ☐ | | | `COUNTRY` | `string(30)` | Country | ☐ | | | `CPA_ACCT` | `string(80)` | Office name | ☐ | | | `CPA_ADDR1` | `string(80)` | Office address | ☐ | | | `CPA_CAPPR` | `boolean` | Client must approve return | ☐ | | | `CPA_CITY` | `string(35)` | Office city | ☐ | | | `CPA_CNT` | `string(2)` | Office ISO country code | ☐ | | | `CPA_CTRY` | `string(30)` | Office country | ☐ | | | `CPA_PHONE` | `string(25)` | Office telephone number | ☐ | | | `CPA_POBOX` | `string(80)` | Office postal address | ☐ | | | `CPA_POCITY` | `string(35)` | Office postal address city | ☐ | | | `CPA_POCODE` | `string(10)` | Office postal address postcode | ☐ | | | `CPA_POST` | `string(10)` | Office postcode | ☐ | | | `CPA_STEXT` | `string(10)` | Office address addition | ☐ | | | `CPA_STNR` | `string(10)` | Office house number | ☐ | | | `CPA_STREG` | `string(40)` | Office address region | ☐ | | | `CPA_STRT` | `string(60)` | Office street name | ☐ | | | `DEL_WDAY` | `boolean` | Deliver on working days only | ☐ | | | `DETAX_OFF` | `string(4)` | Tax office | ☐ | | | `DETAX_STAT` | `string(4)` | State | ☐ | | | `DFLT_PAR` | `string(10)` | Default partner | ☐ | | | `DIM_DEF` | `string(4)` | Dimension definition | ☐ | | | `DISP_INV` | `boolean` | Block automatic payments | ☐ | | | `DJ_EXT_SP` | `string(3)` | System journal purchase/sales invoices | ☐ | | | `DOC_FONT` | `string(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` | `boolean` | Update item history multiple years dynamically | ☐ | | | `DYN_HSTTL` | `boolean` | Update hours history multiple years dynamically | ☐ | | | `EDIC_CLT` | `string(25)` | Client relation code | ☐ | | | `EDIC_VADIF` | `string(10)` | VAT differences account (EDI-Circle) | ☐ | | | `EXP_AUTH` | `boolean` | 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` | `boolean` | Print final invoice when generating invoice | ☐ | | | `FDIM_DEF` | `string(4)` | Financial (Dimensions) | ☐ | | | `FNT_ALGN_C` | `int32` | Align text | ☐ | | | `FNT_ALGN_Y` | `int32` | Align amounts | ☐ | | | `FNT_BOLD_C` | `boolean` | Total text bold | ☐ | | | `FNT_BOLD_Y` | `boolean` | Total amounts bold | ☐ | | | `FNT_UNDR_Y` | `int32` | Underline total | ☐ | | | `GRAY_ACTM` | `string(10)` | Graydon activity main area | ☐ | | | `GRAY_ACTS` | `string(10)` | Graydon activity sub-area | ☐ | | | `GRAY_CPLIM` | `boolean` | Adopt credit limit automatically at customer | ☐ | | | `GRAY_CRACT` | `boolean` | Create Graydon activity | ☐ | | | `GRAY_DAYS` | `int32` | Graydon retrieval interval | ☐ | | | `GRP_EMP` | `boolean` | Condensed posting | ☐ | | | `HD1_FONT` | `string(40)` | Heading 1 font | ☐ | | | `HD2_FONT` | `string(40)` | Heading 2 font | ☐ | | | `HD3_FONT` | `string(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` | `boolean` | Stock page approval required | ☐ | | | `INCL_ADD` | `boolean` | Add mandatory items automatically | ☐ | | | `INO_STGY` | `decimal` | Entry method stocktaking order | ☐ | | | `INO_TR_COD` | `string(10)` | Transaction code | ☐ | | | `INT_ASS` | `string(20)` | Name of umbrella organisation of tax service providers | ☐ | | | `INT_BECON` | `string(17)` | BECON number | ☐ | | | `INT_CNAME` | `string(35)` | Intermediary contact person | ☐ | | | `INT_NAME` | `string(35)` | Name of electronic filing office | ☐ | | | `INT_USE` | `boolean` | Returns are handled by intermediary | ☐ | | | `KVK_NR` | `string(10)` | Chamber of Commerce number | ☐ | | | `MSG_BONUS` | `boolean` | Report bonus items | ☐ | | | `MSG_CROSS` | `boolean` | Report cross-selling items | ☐ | | | `MSG_EXCL` | `boolean` | Report exclusion items | ☐ | | | `MSG_INCL` | `boolean` | Report mandatory items | ☐ | | | `MSG_REPLA` | `boolean` | Report alternative items | ☐ | | | `MSG_UP` | `boolean` | Report up-selling items | ☐ | | | `NUM_LEN` | `int32` | Customer/supplier number length | ☐ | | | `OWN_HOURS` | `string(1)` | Hours display | ☐ | | | `OWN_INV` | `string(1)` | Claim proposal display | ☐ | | | `OWN_OI` | `string(1)` | Invoice display | ☐ | | | `OWN_PROJ` | `string(1)` | Project display | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PICK_STGY` | `string(25)` | Warehouse picking strategy | ☐ | | | `PJ_ALL` | `boolean` | Also show cost centres in projects overview | ☐ | | | `PJ_COMM1` | `string(40)` | Draft invoices description | ☐ | | | `PJ_HIER1` | `string(10)` | Project hierarchy 1 | ☐ | | | `PJ_HIER2` | `string(10)` | Project hierarchy 2 | ☐ | | | `PJ_HIER3` | `string(10)` | Project hierarchy 3 | ☐ | | | `PJ_INVAD` | `string(15)` | Invoice item advances | ☐ | | | `PJ_INVDESC` | `string(40)` | Invoice description | ☐ | | | `PJ_INVFA` | `string(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` | `string(2)` | Item number for transit | ☐ | | | `PMT_CHQ` | `boolean` | Payment by cheque | ☐ | | | `PMT_CRECV` | `boolean` | All bank charges for account of beneficiary | ☐ | | | `PMT_CSEND` | `boolean` | Charges of other banks for account of principal | ☐ | | | `PMT_DESC` | `string(80)` | Description for DNB | ☐ | | | `PMT_FAST` | `boolean` | Urgent foreign payment | ☐ | | | `PMT_GOODS` | `string(2)` | Goods code | ☐ | | | `PMT_ORD1` | `string(2)` | Payment instruction code 1 | ☐ | | | `PMT_ORD2` | `string(2)` | Payment instruction code 2 | ☐ | | | `PMT_ORD3` | `string(2)` | Payment instruction code 3 | ☐ | | | `PMT_ORD4` | `string(2)` | Payment instruction code 4 | ☐ | | | `PMT_TYPE` | `string(2)` | Foreign exchange reporting | ☐ | | | `PO_BOX` | `string(80)` | Postal address | ☐ | | | `PO_CITY` | `string(35)` | Postal address city | ☐ | | | `PO_CODE` | `string(10)` | Postal address postcode | ☐ | | | `PO_COMM2` | `string(40)` | Default receipt description | ☐ | | | `PO_COMM3` | `string(40)` | Default purchase invoice description | ☐ | | | `POST_CODE` | `string(10)` | Postcode | ☐ | | | `PRJ_PERIOD` | `int32` | Project period | ☐ | | | `QD_CALC` | `decimal` | Price agreement calculation method | ☐ | | | `QD_SPL` | `boolean` | Merge lines per item code | ☐ | | | `QD_VIEW` | `decimal` | Scale pricing display | ☐ | | | `QT_ACT` | `boolean` | Create quotation activities | ☐ | | | `QT_ACTM` | `string(10)` | Quotation activity main area | ☐ | | | `QT_ACTP` | `string(10)` | Quotation activity priority | ☐ | | | `QT_ACTSACC` | `string(10)` | Quotation activity sub-area accept quotation | ☐ | | | `QT_ACTSCHG` | `string(10)` | Quotation activity sub-area change quotation | ☐ | | | `QT_ACTSDEF` | `string(10)` | Quotation activity sub-area final quotation | ☐ | | | `QT_ACTSORD` | `string(10)` | Quotation activity sub-area create sales order | ☐ | | | `QT_ACTSREJ` | `string(10)` | Quotation activity sub-area reject quotation | ☐ | | | `QT_FILE` | `string(100)` | Quotation file name | ☐ | | | `QT_LNKDEB` | `boolean` | Link quotation document to company | ☐ | | | `QT_QTAPR` | `boolean` | Quotation approval required | ☐ | | | `QTAUTH_CHK` | `string(4)` | Quotation approval checks | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `RELT_CMCM1` | `string(10)` | Head office at company | ☐ | | | `RELT_CMCM2` | `string(10)` | Dealer at company | ☐ | | | `RELT_CMCM3` | `string(10)` | Accountant at company | ☐ | | | `RELT_OPCM1` | `string(10)` | Company at opportunity | ☐ | | | `RELT_OPCM2` | `string(10)` | Competitor at opportunity | ☐ | | | `RELT_OPEMP` | `string(10)` | Employee at opportunity | ☐ | | | `RELT_PJCM1` | `string(10)` | Principal at project | ☐ | | | `RELT_PJEMP` | `string(10)` | Project manager at projects | ☐ | | | `REM_ACT` | `boolean` | Create dunning activity | ☐ | | | `REM_ACTM` | `string(10)` | Dunning activity main area | ☐ | | | `REM_ACTP` | `string(10)` | Dunning activity priority | ☐ | | | `REM_ACTS1` | `string(10)` | Dunning activity sub-area 1 | ☐ | | | `REM_ACTS2` | `string(10)` | Dunning activity sub-area 2 | ☐ | | | `REM_ACTS3` | `string(10)` | Dunning activity sub-area 3 | ☐ | | | `RTF_FNT` | `string(40)` | Free text font | ☐ | | | `SBS_DEL_AO` | `boolean` | Delete one-off items from subscription after invoicing | ☐ | | | `SBS_EXPL` | `boolean` | Explode composite item in subscription | ☐ | | | `SBS_PRNSO` | `boolean` | Print final invoice when generating invoice | ☐ | | | `SBS_TGT` | `int32` | Generate subscription as | ☐ | | | `SG_CODE` | `string(10)` | Default version | ☐ | | | `SI_INVAPR` | `boolean` | Sales invoice approval required | ☐ | | | `SI1_INV` | `int32` | Assign invoice number | ☐ | | | `SIAUTH_CHK` | `string(4)` | Sales invoice approval checks | ☐ | | | `SIGN_METH` | `int32` | Signing method | ☐ | | | `SO_COMM2` | `string(40)` | Default issue order description | ☐ | | | `SO_COMM3` | `string(40)` | Default sales invoice description | ☐ | | | `SO1_PRNSO` | `boolean` | Print final invoice when generating invoice | ☐ | | | `SOAUTH_CHK` | `string(4)` | Sales order approval checks | ☐ | | | `SP_PICAPR` | `boolean` | Issue order approval required | ☐ | | | `SP_PICRET` | `boolean` | Packing list completion required | ☐ | | | `SP_POSTADR` | `boolean` | Use postal address as delivery address | ☐ | | | `SPAUTH_CHK` | `string(4)` | Issue order approval checks | ☐ | | | `ST_EXTRA` | `string(10)` | Address addition | ☐ | | | `ST_NR` | `string(10)` | House number | ☐ | | | `ST_REGION` | `string(40)` | Address region | ☐ | | | `ST_STREET` | `string(60)` | Street Name | ☐ | | | `SW_AANTAL` | `boolean` | Show quantity | ☐ | | | `SW_GEWICHT` | `boolean` | Show weight | ☐ | | | `SW_VENNOOT` | `boolean` | Show partner | ☐ | | | `TAX_ID` | `string(10)` | Citizen service number | ☐ | | | `TAX_NAME` | `string(35)` | Company contact person | ☐ | | | `TAX_PROF` | `string(10)` | Return profile | ☐ | | | `TBL_HD_FNT` | `string(40)` | Table header font | ☐ | | | `TBL_LN_FNT` | `string(40)` | Table text font | ☐ | | | `TIM_APPR` | `boolean` | Project manager must approve hours lines | ☐ | | | `TIM_AUCO` | `decimal` | Complete automatically | ☐ | | | `TIM_AUTOF` | `boolean` | Approve hours page automatically | ☐ | | | `TIM_CHKCOO` | `decimal` | Check overrun | ☐ | | | `TIM_CHKCOU` | `decimal` | Check underrun | ☐ | | | `TIM_EXTHR` | `boolean` | Overtime always external | ☐ | | | `TIM_LNDS` | `boolean` | Use hours entry description when posting | ☐ | | | `TIM_OBLCST` | `boolean` | Project code mandatory on entry | ☐ | | | `TIM_RATESE` | `string(4)` | Sequence external rate | ☐ | | | `TIM_RATESI` | `string(4)` | Sequence internal rate | ☐ | | | `TIME_SHEET` | `decimal` | Hours entry administration | ☐ | | | `TX2_PROF` | `string(10)` | Taxonomy profile | ☐ | | | `UPDT_HSTAL` | `int32` | Update item history multiple years per type | ☐ | | | `VAT_RANGE` | `int32` | VAT return period | ☐ | | | `VAT_RET_NR` | `string(14)` | VAT number VAT return | ☐ | | | `WM_FOOTSHW` | `boolean` | Footer as watermark on all reports | ☐ | | | `WM_FOOTTXT` | `string(40)` | Footer watermark | ☐ | | | `WM_HEADSHW` | `boolean` | Header as watermark on all reports | ☐ | | | `WM_HEADTXT` | `string(40)` | Header watermark | ☐ | | | `WM_IMGFILE` | `string(80)` | Watermark image | ☐ | | | `WM_IMGSHOW` | `boolean` | Image as watermark on all reports | ☐ | | | `WM_TXTCOL` | `int32` | Watermark text colour | ☐ | | | `WM_TXTFONT` | `string(40)` | Watermark text font | ☐ | |