# ADM_PRF3: Administration settings table 3 - Name: `ADM_PRF3` - Catalog: `AccountView` - Label: Administration settings table 3 - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `ADM_PRF3` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACCR_BAL` | `boolean` | Allow accruals and deferrals on balance sheet accounts | ☐ | | | `ACCT_PA_AL` | `string(10)` | Private settlements clearing account | ☐ | | | `ACCT_POPO` | `string(10)` | Orders to be received account | ☐ | | | `ACCT_TBA` | `string(10)` | Costs to be authorised | ☐ | | | `AD_BAT_NR` | `int32` | Advisor import batch number | ☐ | | | `AI_ALLOWPR` | `boolean` | Invoices via print service AutoInvoice possible | ☐ | | | `AI_API` | `string(36)` | API key (admin) AutoInvoice | ☐ | | | `AI_DJP` | `string(3)` | System journal purchase invoices AutoInvoice | ☐ | | | `AI_DJPD` | `string(3)` | System journal purchase invoices AutoInvoice, no workflow | ☐ | | | `APUB_FNAM` | `string(20)` | First name contact person annual accounts publication | ☐ | | | `APUB_LNAM` | `string(40)` | Last name contact person annual accounts publication | ☐ | | | `APUB_MAIL` | `string(60)` | Email contact person annual accounts publication | ☐ | | | `AUTO_AG` | `boolean` | Schedule automatically | ☐ | | | `AUTO_PICK` | `boolean` | Report back automatically when printing delivery note | ☐ | | | `AUTO_RECV` | `boolean` | Receive automatically when processing purchase invoices | ☐ | | | `BLK_LEDGER` | `boolean` | General ledger accounts add/modify/delete not allowed | ☐ | | | `CHK_EFSCOD` | `string(10)` | Taxonomy code | ☐ | | | `CLINK_ACCT` | `string(10)` | Default account new suppliers | ☐ | | | `CRED_ID` | `string(35)` | Creditor ID | ☐ | | | `DAILY_DESC` | `boolean` | Descriptions based on journal settings | ☐ | | | `DCALC_STCK` | `datetime` | Last sales calculation per week | ☐ | | | `DEPR_REG` | `int32` | Depreciation regime | ☐ | | | `DESC_LDG` | `boolean` | Modifying general ledger account description allowed | ☐ | | | `DIS_SEVER2` | `boolean` | Disable Severa Plus link | ☐ | | | `DIS_SEVER3` | `boolean` | Disable Severa Complete link | ☐ | | | `DISC_CRED` | `string(2)` | Payment term new suppliers | ☐ | | | `DISC_DEB` | `string(2)` | Payment term new customers | ☐ | | | `DJ_EXT_SI` | `string(3)` | Sales invoices Invoicing | ☐ | | | `DJ_EXTGOC` | `string(3)` | Write-offs of open items | ☐ | | | `DJ_EXTGOP` | `string(3)` | Purchase invoices | ☐ | | | `DJ_EXTGOS` | `string(3)` | Sales invoices Basic | ☐ | | | `DJ_EXTPUW` | `string(3)` | Payments in transit | ☐ | | | `DJ_NMBRS` | `string(3)` | Payroll journal | ☐ | | | `DJ_WF` | `string(3)` | Journal (purchase) | ☐ | | | `DJIM_NOVAT` | `boolean` | Skip VAT when importing journal messages | ☐ | | | `DJIM_VAT` | `string(2)` | VAT code for journal import | ☐ | | | `DJIMAP_REF` | `boolean` | Take journal message headers from reference administration | ☐ | | | `DLINK_ACCT` | `string(10)` | Default account new customers | ☐ | | | `DPH_CHECK` | `boolean` | Period/date check for projects and hours | ☐ | | | `EBNK_SEPA` | `boolean` | Use SEPA guidelines for direct bank link | ☐ | | | `EIA` | `string(30)` | Electronic Invoice Address | ☐ | | | `EV_DJP` | `string(3)` | Purchase invoices journal (eVerbinding) | ☐ | | | `EV_DJS` | `string(3)` | Sales invoices journal (eVerbinding) | ☐ | | | `EXT_SV_P_P` | `string(250)` | Additional status 'Partially paid' (Severa) | ☐ | | | `EXT_SV_PAD` | `string(250)` | Additional payment statuses (Severa) | ☐ | | | `EXT_SV_REV` | `string(250)` | Additional retrieval statuses (Severa) | ☐ | | | `FAH_AUTO_N` | `boolean` | Number fixed assets automatically | ☐ | | | `GLSTPY_CNG` | `int32` | Change number for comparative annual figures | ☐ | | | `HRS_CNG` | `string(17)` | Last modified time hours registration | ☐ | | | `IN2_EXT` | `boolean` | Extended stock management | ☐ | | | `INCL_OBLI` | `boolean` | Costs and revenues including commitments | ☐ | | | `ISAH_ADMIN` | `string(20)` | Isah administration | ☐ | | | `ISAH_PSWD` | `string(20)` | Isah password | ☐ | | | `ISAH_USR` | `string(20)` | Isah user name | ☐ | | | `KPI_EFS` | `string(10)` | Taxonomy project scorecard controller | ☐ | | | `LEAD_WAGE` | `string(10)` | Heading code payroll total | ☐ | | | `LNG_CRED` | `string(5)` | Language code new suppliers | ☐ | | | `LNG_DEB` | `string(5)` | Language code new customers | ☐ | | | `MAIL_UBL` | `boolean` | Also create UBL format for electronic invoicing | ☐ | | | `NMBRS_LVL` | `int32` | Nmbrs import level | ☐ | | | `OBLI_STAT` | `int32` | Commitment from status | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PAY_DAY` | `int32` | Fixed day | ☐ | | | `PAY_MOMENT` | `int32` | Payment day | ☐ | | | `PRN_PICK` | `boolean` | Print packing list when generating issue order | ☐ | | | `PROF_CODE` | `string(10)` | Email profile | ☐ | | | `PST_ORD` | `boolean` | Post orders to be received | ☐ | | | `REC_ID` | `string(10)` | Primary key | ☐ | | | `REGCH_ACCT` | `string(10)` | Account number system change | ☐ | | | `RELV_CNG` | `string(17)` | Relevance changed | ☐ | | | `RISK_ORG` | `int32` | Organisation risk | ☐ | | | `SCAN_ACCC` | `string(10)` | Credit card payments account | ☐ | | | `SCAN_ACPP` | `string(10)` | Debit card payments account | ☐ | | | `SCAN_DJC` | `string(3)` | System journal cash purchases/sales | ☐ | | | `SCAN_DJCC` | `string(3)` | System journal credit card payments | ☐ | | | `SCAN_DJP` | `string(3)` | System journal purchase invoices | ☐ | | | `SCAN_DJPC` | `string(3)` | System journal debit card payments | ☐ | | | `SCAN_DJS` | `string(3)` | System journal sales invoices | ☐ | | | `SDEL_CON` | `boolean` | Synchronise deleted relations | ☐ | | | `SETUP_CNG` | `string(17)` | Last modified time master data | ☐ | | | `SHIP_CA` | `boolean` | Deliver composite items complete | ☐ | | | `STAT_MAT` | `string(5)` | Status tangible | ☐ | | | `STAT_NAPPL` | `string(5)` | Status n/a | ☐ | | | `STAT_NMAT` | `string(5)` | Status intangible | ☐ | | | `SV_API` | `string(32)` | API key (Severa) | ☐ | | | `SV_BUNIT` | `string(32)` | Department (Severa) | ☐ | | | `SV_C_EMP` | `string(10)` | Employee code (Severa) | ☐ | | | `SV_C_OW` | `string(10)` | Hour type code own work (Severa) | ☐ | | | `SV_C_TMT` | `string(10)` | Hour type code (Severa) | ☐ | | | `SV_C_TMTH` | `string(10)` | Hour type code hours (Severa) | ☐ | | | `SV_C_TRV` | `string(10)` | Hour type code travel expenses (Severa) | ☐ | | | `SV_PAID` | `string(20)` | Invoice status Paid (Severa) | ☐ | | | `SV_PART_P` | `string(20)` | Invoice status 'Partially paid' (Severa) | ☐ | | | `SV_REV` | `string(20)` | Invoice status Retrieve (Severa) | ☐ | | | `SV_SPL_EMP` | `boolean` | Split hours by employee (Severa) | ☐ | | | `SV_SPL_TMH` | `boolean` | Split hours by hour type (Severa) | ☐ | | | `SV_SPL_TRV` | `boolean` | Split travel expenses by hour type (Severa) | ☐ | | | `UBL_TYPE` | `int32` | UBL variant for electronic invoicing | ☐ | | | `WF_DIRECT` | `boolean` | Post directly to cost accounts | ☐ | | | `WF_EMP` | `string(10)` | Invoice distributor | ☐ | | | `WF_STGY` | `string(25)` | Workflow for organisation | ☐ | | | `WKR_PERC` | `decimal` | Work-related costs scheme percentage | ☐ | | | `WKST_RNG` | `int32` | Weeks sales history | ☐ | | | `YEAR_WAGE` | `int64` | Estimated payroll total | ☐ | |