Files
Database/FAC/FAC_SET.SRC
2025-11-26 14:20:43 +00:00

1012 lines
190 KiB
Plaintext

/*
* $Id$
* $Revision$
*
* All general Facilitor settings
* Synchronises completely with any upgrade, whilst keeping the customer-overruled values
*
*/
CREATE GLOBAL TEMPORARY TABLE tmp_set (
fac_setting_module
VARCHAR2(3) NOT NULL,
fac_setting_flags
NUMBER(10) DEFAULT 0, -- invisible
fac_functie_key
NUMBER(10) NOT NULL,
fac_setting_name
VARCHAR2(64) UNIQUE NOT NULL,
fac_setting_type
VARCHAR2(32) NOT NULL,
fac_setting_default
VARCHAR2(4000),
fac_setting_description
VARCHAR2(250) UNIQUE NOT NULL,
fac_setting_comment
VARCHAR2(2000)
) ON COMMIT PRESERVE ROWS;
// LET OP: naam wordt altijd naar lowercase geconverteerd
#define DEFINE_SETTING(m, f, fn, n, t, v, d, c)\
INSERT INTO tmp_set (fac_setting_module, fac_setting_flags, fac_functie_key, fac_setting_name, fac_setting_type, fac_setting_default, fac_setting_description, fac_setting_comment) \
SELECT m, f, fac_functie_key, LOWER(n), t, v, COALESCE(d, n), NULL \
FROM fac_functie WHERE fac_functie_code = fn;
DELETE FROM tmp_set;
COMMIT;
// _FACILITOR ziet altijd alles en mag alles wijzigen
// 0 = Onzichtbaar, alleen via script te wijzigen
// 1 = PRSSYS zichtbaar
// 8 = Default waarde wordt gezet in ASP (met name custpath afhankelijk)
// WEB_FACFAC Door FACILITOR medewerker te wijzigen. Meestal 'licentie' en 'future use' settings
// WEB_FACTAB Technisch applicatie beheer, server instellingen
// WEB_PRSSYS Functioneel Applicatie Beheer, mag klant zelf wijzigen
// Alles als een enorme BEGIN/END is over het netwerk immens sneller
WHENEVER SQLERROR EXIT;
BEGIN
-- Unused; remove in 2025.3
-- \Unused
DEFINE_SETTING('FAC', 0000, 'WEB_FACFAC', 'fac_otap' , 'string' , 'P' , 'OTAP environment. custenv.wsc overrule only')
DEFINE_SETTING('FAC', 0000, 'WEB_FACFAC', 'fac_portalert_XD' , 'string' , '', , 'Hot news text on portal Cross Domain!')
DEFINE_SETTING('FAC', 0000, 'WEB_FACFAC', 'helppage_secret' , 'string' , 'yuszkRZXlGqjOgyE' , 'Helppage hmac secret')
DEFINE_SETTING('FAC', 0000, 'WEB_FACFAC', 'idp_internal_anyuser' , 'boolean' , 'false' , 'AUT_IDP_INTERNAL sso can be used to login for any user')
DEFINE_SETTING('FAC', 0000, 'WEB_FACFAC', 'logcenter_secret' , 'string' , 'd1RLxRhQMvuU7MkdVeLlcBdYKZkUNh7N', 'Logcenter jwt secret')
DEFINE_SETTING('FAC', 0000, 'WEB_FACFAC', 'sys_ip_restrict_internal' , 'string' , '172.20.48.|80.250.128.5|80.250.128.6|80.250.129.195|31.161.17.4|80.250.129.2|80.250.129.1', 'Regexp ip-restriction internal')
DEFINE_SETTING('FAC', 0000, 'WEB_FACFAC', 'fac_imagecharts_account_id' , 'string' , '' , 'Image-charts account_id (future use)')
DEFINE_SETTING('FAC', 0000, 'WEB_FACFAC', 'fac_imagecharts_secret_key' , 'string' , '' , 'Image-charts secret_key (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'licensed_fe_users' , 'number' , '0' , 'Number of licensed frontend users')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'licensed_key_users' , 'number' , '0' , 'Number of licensed key users')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'licensed_device_users' , 'number' , '0' , 'Number of licensed device users')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'licensed_passive_users' , 'number' , '0' , 'Number of licensed passive users')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'licensed_templates' , 'string' , 'basic,generic' , 'Licensed bedrijfadres templates (comma separated)')
DEFINE_SETTING('PUO', 0000, 'WEB_FACTAB', 'tsk_master_schema' , 'string' , '' , 'Tasker master schema name (not necessarily customerId)')
DEFINE_SETTING('PUO', 0000, 'WEB_FACTAB', 'tsk_extra_folders' , 'array' , '' , 'Tasker extra folders to start CUST tasks (future use))')
DEFINE_SETTING('FAC', 0000, 'WEB_FACTAB', 'noti_delay_mode' , 'number' , '0' , '0=Notification to bedrijfadres always zero delay, 1=honor fac_srtnotificatie_delay, >1=fixed delay in seconds (eg. 5)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_api2_compatibility' , 'number' , '0' , '0=latest and greatest, bit 1=backwards compatible')
DEFINE_SETTING('ALG', 0001, 'WEB_FACFAC', 'alg_ruimte_comm_opp_key' , 'number' , '-1' , 'Key to be used for commercial ruimte oppervlakte')
DEFINE_SETTING('ALG', 0001, 'WEB_FACFAC', 'alg_terrein_comm_opp_key' , 'number' , '-1' , 'Key to be used for commercial terrein oppervlakte')
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_alg' , 'string' , '../cad/rap_alg.asp' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_alg2' , 'string' , '../cad/rap_alg2.asp' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_algc' , 'string' , '../cad/rap_algc.asp' , 'concept')
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_cnt' , 'string' , '../cad/rap_cnt.asp' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_cnt2' , 'string' , '../cad/rap_cnt.asp' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_ins' , 'string' , '../cad/rap_ins.asp' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_ins2' , 'string' , '../cad/rap_ins2.asp' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_mld' , 'string' , '../cad/rap_mld.asp' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_mov' , 'string' , '../cad/rap_move.asp' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_prs' , 'string' , '../cad/rap_prs.asp' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_sch' , 'string' , '' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_rap_sle' , 'string' , '../cad/rap_sle.asp' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_syncruimteview' , 'string' , 'cad_v_sync_alg_ruimte' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_syncterreinview' , 'string' , 'cad_v_sync_alg_terrein' , NULL)
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_move_origin' , 'number' , '0' , 'Move all dwf to logical (0,0) to prevent overflow')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_minmergedistance' , 'number' , '-1' , 'Distance (mm) allowed when merging ARC''s into contours')
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_slnkdwf_flags' , 'number' , '0' , 'Flags for SLNKDWF')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'MaxDownloadSize' , 'number' , '-1' , 'Should match IIS Metabase AspBufferingLimit for download warning (Future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'alg_loc_string' , 'string' , ' l.alg_locatie_omschrijving || '' ('' || l.alg_locatie_code || '')'' ' , 'Presentation of location while selecting')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'alg_geb_string' , 'string' , ' g.alg_gebouw_code ||'' ''||g.alg_gebouw_naam ' , 'Presentation of building while selecting')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'alg_ter_string' , 'string' , ' t.alg_terreinsector_code ||'' ''||t.alg_terreinsector_naam ' , 'Presentation of terrain while selecting')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'alg_ver_string' , 'string' , ' v.alg_verdieping_omschrijving ' , 'Presentation of floor while selecting')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'alg_rui_string' , 'string' , ' r.alg_ruimte_nr || NVL2(r.alg_ruimte_omschrijving, '' - ''|| r.alg_ruimte_omschrijving, '''')', 'Presentation of room while selecting')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'asp_max_download' , 'number' , '-1' , 'Copy the IIS configuration setting AspBufferingLimit (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'asp_max_upload' , 'number' , '-1' , 'Copy the IIS configuration setting AspMaxRequestEntityAllowed (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'asp_timeout' , 'number' , '-1' , 'Copy the IIS configuration asp AspScriptTimeout setting (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'basic_auth_realm' , 'string' , '' , 'Realm for Basic Authentication (API only) (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'cache_changecounter' , 'number' , '0' , 'Increment by one to reset FCLT caching.')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'fac_allow_jsonp' , 'boolean' , 'false' , 'Allow jsonp')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'crypto_provider' , 'number' , '1' , '0=JavaScript, 1=Slnkdwf.dll')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'cssfordesktop' , 'string' , '' , 'jQuery themeroller desktop replacement')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'cssformobile' , 'string' , '' , 'jQuery themeroller mobile replacement')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'fac_api_allow_impersonate' , 'boolean' , 'false' , 'Allow impersonation through X-Facilitor-Switch-user (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_api_key_in_url' , 'boolean' , 'false' , 'Is APIKEY= in url also allowed (unsafe)? Default is header X-Facilitor-API-Key only')
DEFINE_SETTING('ALG', 0001, 'WEB_FACFAC', 'fac_betafeatures' , 'number' , '0' , 'Bits for enabling release specific experimental features')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'fac_pdf_printer' , 'number' , '0' , 'PDF Printer support bits (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_usrrap_mode' , 'number' , '0' , 'User reports mode {0=default, 1=advanced (UDR)}')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'fac_usrrap_safe_view_regexp' , 'string' , '' , 'User reports safe views regexp')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'fclt_web_url' , 'string' , '' , 'Url to the Facilitor software (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'hiresTimer' , 'number' , '1' , 'internal use only')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'iLearning_enabled' , 'number' , '0' , 'Is iLearning available {0 | 1} licensed separately')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'language_toggles' , 'array' , 'NL' , 'Allow language toggle for alternate languages')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'login_pda_url' , 'string' , 'appl/aut/login.asp' , 'url providing login-services when pda detected. Future use')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'login_url' , 'string' , 'appl/aut/login.asp' , 'url providing login-services')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'm2m_enabled' , 'number' , '0' , 'Is Facilitor Mail2Melding configured {0=disabled | 1=enabled}')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'mobile_enabled' , 'number' , '0' , 'Is Facilitor Mobile available {0=disabled | 1=web only enabled | 2=Nativescript app only enabled | 3=web+app enabled}')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'multi_language_option' , 'number' , '0' , 'Enable multi language')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'prs_allow_impersonate' , 'boolean' , 'false' , 'Allow impersonation by PRSSYS')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'prs_password_hash_length' , 'number' , '20' , 'Password hash length')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'prs_password_otp_window2' , 'number' , '600' , 'OTP windows for resync (x seconds early/late allowed, future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'prs_password_otp_window' , 'number' , '60' , 'OTP windows (x seconds early/late allowed)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'refreshfromdumpfile' , 'string' , '' , 'Path to Oracle EXP DMP-file for autorefresh test-environments')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'refreshfromdumppostsql' , 'string' , '' , 'SQL file to execute after refreshfromdump (often upgrade script)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'refreshfromdumpscriptfolder' , 'string' , '' , 'Folder to create refresh-from-dump batchfile')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'refreshfromdumptarget' , 'string' , 'FCLTACCEPT' , 'Oracle target server for refresh')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'res_plan_max_bezet' , 'number' , '0' , 'Maximum planbord ''occupied'' fields. AiAi timeout prevention (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'sys_ip_jail' , 'string' , '' , 'Regexp ip-jail to prevent roaming (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'xd_add2deeplinkurl' , 'string' , '&sso=2' , 'parameters to be added to the XD-deeplink calls (for XD-module)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'xd_primary_bedrijfkey' , 'number' , '-1' , 'bedrijf_key of this Service Organisation (for XD-module)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACFAC', 'xd_secundarydomains' , 'json' , '' /* moet leeg!*/ , 'Object of related secondary domains {id: {name, url}} (for XD-module)')
DEFINE_SETTING('FIN', 0001, 'WEB_FACFAC', 'fin_import_app_key' , 'number' , '-1' , 'fac_import_app_key of customer ''FACTUUR'' import: -1=Facilitor standard')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_import_btwmarge' , 'float' , '0.01' , 'Invoice import allowed BTW rounding margin')
DEFINE_SETTING('INS', 0001, 'WEB_FACFAC', 'mjb_enabled' , 'number' , '0' , 'Is Preventive Maintenance (MJOB) available {0=no | 1=yes}')
DEFINE_SETTING('PHB', 0001, 'WEB_FACFAC', 'locfax_kenmerk_key' , 'number' , '-1' , NULL)
DEFINE_SETTING('PHB', 0001, 'WEB_FACFAC', 'locphone_kenmerk_key' , 'number' , '-1' , NULL)
DEFINE_SETTING('PHB', 0001, 'WEB_FACFAC', 'phone_usrrap_key' , 'number' , '-1' , 'userrap key for optional custom phonebook report')
DEFINE_SETTING('PHB', 0001, 'WEB_FACFAC', 'prs_plaats_key' , 'number' , '-1' , 'PRS_KENMERK_KEY of property location, if -1, the workplace is used for the location')
DEFINE_SETTING('PRJ', 0001, 'WEB_FACTAB', 'fg_prj_syncruimteview' , 'string' , 'cad_v_sync_prj_ruimte' , NULL)
DEFINE_SETTING('PRS', 0001, 'WEB_FACTAB', 'prs_contactpers_string' , 'string' , 'cp.prs_contactpersoon_naam || NVL2(cp.prs_contactpersoon_voorletters, '', '' || cp.prs_contactpersoon_voorletters, '''')|| NVL2(cp.prs_contactpersoon_tussenv, '' '' || cp.prs_contactpersoon_tussenv, '''')|| NVL2(cp.prs_contactpersoon_voornaam, '' ('' || cp.prs_contactpersoon_voornaam || '')'', '''')', NULL)
DEFINE_SETTING('PRS', 0001, 'WEB_FACTAB', 'prs_dep_string' , 'string' , 'd.prs_afdeling_naam' , 'Define how to identify a department {d.prs_afdeling_naam[1-6], d.prs_afdeling_omschrijving}')
DEFINE_SETTING('PRS', 0001, 'WEB_FACTAB', 'prs_kpn_string' , 'string' , ' NVL2(k.prs_kostenplaats_nr, prs_kostenplaats_nr || '' ''|| lcl.x(''prs_kostenplaats_omschrijving'', k.prs_kostenplaats_key, k.prs_kostenplaats_omschrijving), '''')', NULL)
DEFINE_SETTING('PRS', 0001, 'WEB_FACTAB', 'prs_pers_string' , 'string' , ' p.prs_perslid_naam|| NVL2( p.prs_perslid_voorletters, '', '' || p.prs_perslid_voorletters, '''')|| NVL2( p.prs_perslid_tussenvoegsel, '' '' || p.prs_perslid_tussenvoegsel, '''')|| NVL2( p.prs_perslid_voornaam, '' ('' || p.prs_perslid_voornaam || '')'', '''')', NULL)
DEFINE_SETTING('PRS', 0001, 'WEB_FACTAB', 'scim_default_bedrijf' , 'number' , '-1' , 'Default company (prs_bedrijf_key) for SCIM new organisation units')
DEFINE_SETTING('RES', 0001, 'WEB_FACFAC', 'res_remoteurl_refuse' , 'string' , '' , 'Regexp, do not jump to these remote url (future use)')
DEFINE_SETTING('PRS', 0001, 'WEB_FACFAC', 'prs_purge_inactief' , 'number' , '1' , 'Purge prs_perslid_inactief users {1=daily, 0=disable}')
DEFINE_SETTING('FAC', 0000, 'WEB_FACTAB', '_optimizer_use_feedback' , 'string' , '' , '_optimizer_use_feedback (Future use)')
DEFINE_SETTING('FAC', 0000, 'WEB_FACTAB', 'cursor_sharing' , 'string' , '' , 'cursor_sharing (Future use)')
DEFINE_SETTING('FAC', 0000, 'WEB_FACTAB', 'flexFilesPath' , 'string' , '*_DATA' , 'Path for Flexbestanden type ''F'' en ''M'', zonder eindslash')
DEFINE_SETTING('FAC', 0000, 'WEB_FACTAB', 'max_logfile_size' , 'number' , '262144' , 'Start new logfile after it reaches this size')
DEFINE_SETTING('FAC', 0000, 'WEB_FACTAB', 'optimizer_features_enable' , 'string' , '' , 'optimizer_features_enable (Future use)')
DEFINE_SETTING('FAC', 0000, 'WEB_FACTAB', 'tempfilespath' , 'string' , NULL , 'Path for temp files (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'style_image_path' , 'string' , NULL , 'path to folder storing styling template pictures')
DEFINE_SETTING('ALG', 0001, 'WEB_PRSSYS', 'alg_ruimtenr_aut_use' , 'number' , '0' , 'WEB_RUIUSE may change alg_ruimte_nr/omschrijving {0=WEB_RUIMAN required | 1=WEB_RUIUSE allowed too}')
DEFINE_SETTING('BES', 0001, 'WEB_FACTAB', 'bes_image_path' , 'string' , NULL , 'path to folder storing bes_srtdeel pictures')
DEFINE_SETTING('BES', 0001, 'WEB_FACTAB', 'besd_image_path' , 'string' , NULL , 'path to folder storing bes discipline pictures')
DEFINE_SETTING('BEZ', 0001, 'WEB_FACTAB', 'vis_afspraak_host_uses_keys' , 'number' , '0' , 'Use free text for host or select an existing user for visitor (0=free text, 1=list, 2=required list)')
DEFINE_SETTING('BEZ', 0001, 'WEB_FACTAB', 'vis_afspraak_onrgoed_uses_keys' , 'number' , '0' , 'Use free text room or select an existing room as destination for visitor (0=free text, 1=list)')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_afspraak_tel_required' , 'number' , '2' , '0=optional with value, 1=required with value, 2=optional and empty, 3=required and empty')
DEFINE_SETTING('BEZ', 0001, 'WEB_FACTAB', 'vis_parking_key' , 'number' , '-1' , 'Catalog key (res_discipline_key) for Parking places')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_fo_default_user' , 'number' , '0' , 'Use current user as default appointment host, { 1=user | 0=empty (default) }')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_fobo_default_locatie_empty' , 'boolean' , 'false' , 'No auto fill location when selecting host for new appointment back/front-office')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_import_column3' , 'number' , '0' , 'Third column input when importing visitors (0=none,1=telefoon,2=email,3=kenteken,4=kenmerk)')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_import_column4' , 'number' , '0' , 'Fourth column input when importing visitors (0=none,1=telefoon,2=email,3=kenteken,4=kenmerk)')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_import_column5' , 'number' , '0' , 'Fifth column input when importing visitors (0=none,1=telefoon,2=email,3=kenteken,4=kenmerk)')
DEFINE_SETTING('BGT', 0001, 'WEB_FACTAB', 'bgt_enabled' , 'number' , '0' , 'Is Facilitor Budgetting module (BGT) available {0 | 1}')
DEFINE_SETTING('BGT', 0001, 'WEB_FACTAB', 'bgtd_image_path' , 'string' , NULL , 'path to folder storing bgt discipline pictures')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_themaalpha' , 'number' , '224' , 'Default roomcontour transparancy. 255=solid')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_wpscale' , 'float' , '1' , 'Relative scale for workplace symbol')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_antialias' , 'number' , '2' , 'Antialias, 1=off, 2=pleasant, 4=slower')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_contouralpha' , 'number' , '0' , 'Default roomcontour transparancy. 0=invisible')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_dobbeldist' , 'number' , '1400' , 'Distance for dice symbols (mm)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_dobbelscale' , 'float' , '0.5' , 'Relative scale for dice symbols')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_maximize' , 'boolean' , 'true' , 'Maximize drawings to visible area (otherwise as saved in AutoCAD)') // in begrijpelijke taal=?
DEFINE_SETTING('CAD', 0001, 'WEB_FACTAB', 'fg_translateprintcolor' , 'json' , '[]' , 'Color-translations for printing of plans')
DEFINE_SETTING('CNT', 0001, 'WEB_FACTAB', 'cnt_srttype_rental' , 'number' , '2' , 'cnt_srtcontract_type of room rental contract type')
DEFINE_SETTING('CNT', 0001, 'WEB_FACTAB', 'cntd_image_path' , 'string' , NULL , 'path to folder storing cnt discipline pictures')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'NotifyMessageInterval' , 'number' , '0' , 'time (seconds) between NotifyMessage.asp [=Check for popups] refreshes. 0=disable')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'PerformInterval' , 'number' , '0' , 'time (seconds) between shared/performancetester.asp refreshes 0=disable')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'allow_framed_facilitor' , 'boolean' , 'false' , 'Is it allowed to use Facilitor in an (i)frame?')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'allowedLinkRegex' , 'string' , '^((ftp|http|https):\/\/|(mailto|tel):)' , 'Allowed link-regex in between [link][/link]-tags')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'auto_https' , 'number' , '3' , '0=not https, 1=http redirects to https, (3=also all cookies ;Secure)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_html_strictness' , 'number' , '0' , '0=allow html in messages, res-room descriptions, flex-labels, 1=do not allow (strict, more secure)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'cal_showOn' , 'string' , 'button' , '''button'' or ''focus'' or ''both''')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'csp_header' , 'string' , 'default-src ''self''; script-src ''self'' ''unsafe-eval'' ''unsafe-inline''; style-src ''self'' ''unsafe-inline''; frame-src ''self'' mailto: tel: callto:; img-src ''self'' data: {0}; block-all-mixed-content;', 'Content-Security-Policy header')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'csp_header_extradata' , 'string' , '*.tile.openstreetmap.org', 'Content-Security-Policy header extra image source')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'well_known_security_txt' , 'string' , 'https://facilitor.nl/.well-known/security.txt', 'Redirect url for /.well-known/security.txt')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_lfmap_tileprovider' , 'string' , 'https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png', 'Tile provider voor map-projection of data')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'referrer_policy_header' , 'string' , 'same-origin' , 'Referrer-Policy header')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'cssenvcust' , 'string' , '' , 'Custom css environment overrules')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'csstemplate' , 'json' , '{}' , 'Color scheme.')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fontawesomestyle' , 'string' , 'fal' , 'Icons style. Options are far (regular), fas (solid), fal (light)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'custfunctionspath' , 'string' , NULL , 'path to custfunctions.wsc')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'email_regexp' , 'string' , '^\s*[A-Z0-9&\._%+-]+@[A-Z0-9\.-]+\.[A-Z]{2,}\s*([,;]\s*[A-Z0-9&\._%+-]+@[A-Z0-9\.-]+\.[A-Z]{2,}\s*)*$', 'Meerdere gescheiden door , of ;')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'email_regexp_single' , 'string' , '^\s*[A-Z0-9&\._%+-]+@[A-Z0-9\.-]+\.[A-Z]{2,}\s*$', 'E n email adres')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'email_cc_allowed' , 'number' , '0' , 'Allow use of Cc and Bcc {0 | 1} in sending email')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_accept_terms' , 'number' , '0' , '0 (default) no accept, 1=must accept L("lcl_terms_filename")')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_emailtoken_auth_expire' , 'number' , '0' , 'Minutes e-mail login token is valid (default 0)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_logo_file' , 'string' , 'tmpl_logo.gif' , 'Customer logo file (Future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_msxml2domdocument' , 'number' , '0' , '0=FreeThreadedDOMDocument, 1=DOMDocument')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_tamper_check' , 'number' , '255' , 'Perform tampercheck on save')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_reserved_number1' , 'number' , '0' , 'reserved_number1 (reserved and unused)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_reserved_number2' , 'number' , '0' , 'reserved_number2 (reserved and unused)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_reserved_number3' , 'number' , '0' , 'reserved_number3 (reserved and unused)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_reserved_string1' , 'string' , '' , 'reserved_string1 (reserved and unused)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_reserved_string2' , 'string' , '' , 'reserved_string2 (reserved and unused)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_reserved_string3' , 'string' , '' , 'reserved_string3 (reserved and unused)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_server_timezone' , 'string' , 'Europe/Amsterdam' , 'The timezone of the database-server')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_t_endofworkday' , 'float' , '17' , 'End time (hour, decimal) of a working day')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_t_startofworkday' , 'float' , '8' , 'Start time (hour, decimal) of a working day')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'flexAllowedExt' , 'string' , '.*\.(doc|docx|xls|xlsx|jpg|jpeg|png|gif|bmp|dwg|dwf|eml|pdf|msg|zip|vsd|txt|ppt|pptx|oft|rtf|tif|tiff|csv|dot|xml|mcw|rar|encrypted|gz|gzip|7z|mp4|mov|m4v|3gp|avi)$', 'Allowed extensions')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'imgAllowedExt' , 'string' , 'jpg|jpeg|png|gif|bmp' , 'Allowed image extensions')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'flexPreviewExt' , 'string' , '.*\.(jpg|jpeg|png|gif|bmp)$' , 'Extentions of attachments to preview in show_mld')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'flex_mimetypes' , 'json' , '{ "jpg": "image/jpeg", "jpeg": "image/jpeg" , "png": "image/png", "bmp": "image/bmp", "gif": "image/gif", "pdf": "application/pdf", "html": "text/html", "eml": "message/rfc822" }', 'Supported streaming mimetypes')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'flex_min_size' , 'number' , '64' , 'E-mail attachments smaller (in bytes) than this are silently ignored')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'flex_min_imgsize' , 'number' , '64' , 'E-mail image attachments smaller (in bytes) than this are silently ignored')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'flex_min_imgsize_ext' , 'string' , '.*\.(jpg|jpeg|png|gif|bmp)$' , 'Small (flex_min_imgsize) E-mail attachments are ignored')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'mail_subject_undeliverable' , 'string' , '^(Undeliverable:|Message undeliverable:|Onbestelbaar:|Bericht onbestelbaar:)', 'Undeliverable E-mails with bounced this subject are silently ignored')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'mail_subject_ignore' , 'string' , '^(Automatic reply:|Automatisch antwoord:)', 'E-mails with this subject are silently ignored')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'mld_instemmer_self' , 'number' , '0' , 'Fallback option for approving a concept if no consenter is defined or if you are the consenter { 0=No consent needed | 1=Budgetholder | 2=Objectmanager | 4=Departmentmanager | 8=Manager | 16=Buildingmanager}')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'hsts_maxage' , 'number' , '31536000' , 'HTTP Strict Transport Security max-age (0=off, eg. 31536000 for one year)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'http_meta_head' , 'string' , '<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">', 'Submitted in each html <head>')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'cookie_samesite' , 'string' , 'lax' , '(future use) Cookie Samesite setting (none/lax/strict). Set to ''none'' for return-from-punchout problems')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'image_path_local' , 'string' , '\\' , 'path used by LAN for flexproperties of type X (fclt.ini:Documentdir)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'image_path_local_regexp' , 'string' , NULL , 'Reguliere expressie, bijvoorbeed /^G:/i')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'image_path_virtual' , 'string' , NULL , 'path used by WEB for flexproperties of type X')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'impAllowedExt' , 'string' , '.*\.(txt|csv|xml)$' , 'Allowed importfile extensions')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'kto_srtdiscipline_key' , 'number' , '-1' , 'key van KTO (klanttevredenheidsonderzoek) vakgroeptype')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'logcenter_url' , 'string' , 'https://logcentre.facilitor.nl/?SSO=CUSTOMER', 'Logcenter url')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'menu_image_path' , 'string' , NULL , 'relative! path to folder storing menu pictures and files')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'menu_image_url_path' , 'string' , NULL , 'relative! path to folder storing menu files which are used as url')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'mobile_favorite_menu_items' , 'number' , '3' , 'This is how many of the favorite menuitems are shown on the mobile portal')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'mobile_password_exp' , 'number' , '15' , 'time to enter the login code received on the mobile in minutes.')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'os_logon' , 'boolean' , 'false' , 'enable NT domain logon {true | false}')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'os_logon_exclude' , 'array' , '' , 'Disable NT domain logon, for example "HTTP_VIA,HTTP_REVERSE_VIA,HTTP_X_BLUECOAT_VIA"')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'p3p_header' , 'string' , '' , 'P3P privacy policy (deprecated)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'perfmon_threshold' , 'number' , '-1' , 'time threshold for statements to be monitored for performance {milliseconds | -1}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'personal_satisfaction_period' , 'number' , '100' , 'Number of days for which the personal satisfaction rating is calculated')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'prs_login_attempts' , 'number' , '5' , 'Lockout username after this many failed attempts')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'prs_login_lockout_delay' , 'float' , '0.2' , 'Lockout seconds after each failed attempt (exponential)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'prs_login_lockout_expire' , 'number' , '15' , 'Lockout minutes after prs_login_attempts failed attempts')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'prs_login_lockout_delayfactor' , 'float' , '2' , 'Exponent base for prs_login_lockout_delay')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'prs_password_hash_factor' , 'number' , '17' , 'Password hash workfactor (2^x)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'prs_password_otp_mode' , 'number' , '0' , 'OTP mode (0=off,+1=prssys only, +2=everyone with password, +4=force 2-factor auth)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'qr_auth_expire' , 'number' , '5' , 'Minutes QRC-code is valid (default 5)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'qr_color' , 'number' , '5452544' , 'QRC color')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'qr_bggray_color' , 'number' , '255' , 'QRC background gray color (0-255)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'qrc_enable' , 'number' , '0' , 'Enable QRC-authentication feature (1) or not (0)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'refreshfromdump_oracle_login' , 'string' , '' , 'oracle login un/pw')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'self_register' , 'number' , '0' , 'Can user self-register? ( 0 disable )')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'self_register_afdeling_key' , 'number' , '-1' , 'Default afdeling key')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'self_register_email_whitelist' , 'string' , '' , 'Regexp email-restriction eg. \@facilitor\.nl$')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'self_register_expire' , 'number' , '60' , 'Minutes to respond to confirmation e-mail ( default 60 )')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'self_register_groep_keys' , 'array' , '' , 'Custom fac_groep options for the self_registerscreen, 1 option: auto pick that one, 2+ gives a dropdown menu')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'self_register_srtperslid_key' , 'number' , '-1' , 'Default srtperslid key')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'sys_ip_lockmode' , 'number' , '0' , 'Automatic logoff on ip-change (0 disable)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'sys_ip_restrict' , 'string' , '' , 'Regexp ip-restriction')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'use_capacity_planning' , 'number' , '0' , 'De inzetbaarheid van personen en uitvoerbaarheid bij opdrachten kan worden aangegeven (0=nee {default}, 1=ja)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'view_dwf_with_slnkdwf' , 'boolean' , 'false' , 'View DWF document files using SLNKDWF')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'widgetportal' , 'number' , '0' , 'Key of widgetpage to use as startpage (key) or the standard page (0)')
DEFINE_SETTING('FAQ', 0001, 'WEB_FACTAB', 'faq_enabled' , 'number' , '0' , 'Is kennisbank available {0 | 1} licensed separately')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_defaultboekmaand' , 'number' , '1' , 'How to determine default "boekmaand" for entered invoice with an order: 1=sysdate, 2=orderdate, 3=enddate')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_defaultboekmaand_cnt' , 'number' , '1' , 'How to determine default "boekmaand" for entered invoice with a contract: 1=sysdate, 2=invoicedate')
DEFINE_SETTING('INS', 0001, 'WEB_FACTAB', 'cnd_gebreken_srtdisc_key' , 'number' , '-1' , 'Key of the mld_srtdiscipline of the condition measurement calls')
DEFINE_SETTING('INS', 0001, 'WEB_FACTAB', 'ins_history' , 'string' , '1' , 'historymode for flexproperties {0 | 1}')
DEFINE_SETTING('INS', 0001, 'WEB_FACTAB', 'ins_image_path' , 'string' , NULL , 'path to folder storing ins_srtdeel pictures')
DEFINE_SETTING('INS', 0001, 'WEB_FACTAB', 'insd_image_path' , 'string' , NULL , 'path to folder storing ins discipline pictures')
DEFINE_SETTING('INS', 0001, 'WEB_FACTAB', 'ins_score_enabled' , 'number' , '0' , 'Is conditie meting aanwezig {0 | 1}')
DEFINE_SETTING('INS', 0001, 'WEB_FACTAB', 'inspect_enabled' , 'number' , '0' , 'Is Facilitor Inspect available {0 | 1} (future use)')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'mjb_show_ruimte' , 'number' , '0' , 'Show "Room" column in the MJOB console at groupings "Object" and "Tasks" {0=no | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'defaultstdmelding' , 'number' , '-1' , 'The stdmeldingkey for generic calls received by e-mail')
DEFINE_SETTING('MLD', 0001, 'WEB_FACTAB', 'mld_contract_startdate_key' , 'number' , '-1' , 'key of flex prop in rental contract mutation call')
DEFINE_SETTING('MLD', 0001, 'WEB_FACTAB', 'mld_meldbron_key' , 'number' , '5' , 'The default mld_meldbron_key for non-frontoffice calls. {5=Internet}')
DEFINE_SETTING('MLD', 0001, 'WEB_FACTAB', 'mld_opdr_discipline_mode' , 'number' , '1' , 'Autorisation discipline for orders. { 1=(default) use issue discipline 2=follow treatment team }')
DEFINE_SETTING('MLD', 0001, 'WEB_FACTAB', 'mld_opdr_minuren' , 'boolean' , 'false' , 'registreren min uren toegestaan')
DEFINE_SETTING('MLD', 0001, 'WEB_FACTAB', 'mld_ordermaterial_fac_usrtab_key' , 'number' , '-1' , 'fac_usrtab_key of ordermaterials')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_ordermaterial_frame' , 'number' , '0' , 'Show order materiallist in a separate frame {0=no (default} | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_ordermaterial_editable' , 'boolean' , 'true' , 'ordermaterials can be edited (true) or are always readonly/remotely managed (false)')
DEFINE_SETTING('MLD', 0001, 'WEB_FACTAB', 'mld_reply_subject_regexp' , 'string' , '[[:alpha:]]*[[:digit:]]{3,}' , 'The regexp for recognizing reply melding numbers (future use)')
DEFINE_SETTING('MLD', 0001, 'WEB_FACTAB', 'mldg_image_path' , 'string' , NULL , 'path to folder storing stdmeldinggroep symbols pictures')
DEFINE_SETTING('MLD', 0001, 'WEB_FACTAB', 'mlds_image_path' , 'string' , NULL , 'path to folder storing stdmelding symbols pictures')
DEFINE_SETTING('MLD', 0001, 'WEB_FACTAB', 'mldd_image_path' , 'string' , NULL , 'path to folder storing mld discipline pictures')
DEFINE_SETTING('MLD', 0001, 'WEB_FACTAB', 'mldsd_image_path' , 'string' , NULL , 'path to folder storing mld srtdiscipline pictures')
DEFINE_SETTING('MRK', 0001, 'WEB_FACTAB', 'mrk_image_path' , 'string' , NULL , 'path to folder storing marketplace pictures')
DEFINE_SETTING('PHB', 0001, 'WEB_FACTAB', 'ph_cust_flexsearch_key' , 'number' , '-1' , 'custom flexsearchfield for phonebook. Must be ''Suggest'' type!')
DEFINE_SETTING('PHB', 0001, 'WEB_FACTAB', 'ph_persliddetails_page' , 'string' , 'appl/fac/fac_user_info_phone.asp', NULL)
DEFINE_SETTING('PHB', 0001, 'WEB_FACTAB', 'photo_kenmerk_key' , 'number' , '-1' , 'ALG_KENMERK_KEY of property Room picture')
DEFINE_SETTING('PHB', 0001, 'WEB_FACTAB', 'prs_image_path' , 'string' , NULL , 'path to folder storing person pictures')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'prs_ph_bedrijf' , 'number' , '1' , 'Bedrijven selectbox aanwezig in informatiegids overzichtscherm {0=no | 1=yes (default)}')
DEFINE_SETTING('PHB', 0001, 'WEB_FACTAB', 'prs_photo_kenmerk_key' , 'number' , '-1' , 'PRS_KENMERK_KEY of property Person picture tonen Ja/Nee')
DEFINE_SETTING('PHB', 0001, 'WEB_FACTAB', 'prs_photo_kenmerk_showval' , 'string' , '-1' , 'PRS_KENMERK_WAARDE indicating ''Yes''')
DEFINE_SETTING('PRS', 0001, 'WEB_FACTAB', 'badgenum_kenmerk_key' , 'number' , '-1' , 'DEPRECATED prs_kenmerk_key of badgenumber flexprop')
DEFINE_SETTING('PRS', 0001, 'WEB_FACTAB', 'prs_collegas_groep' , 'number' , '15' , 'Maximum number of group collegues (15=default)')
DEFINE_SETTING('PRS', 0001, 'WEB_FACTAB', 'prs_dep_all' , 'boolean' , 'false' , 'allow attaching persons on all department level { true | false }')
DEFINE_SETTING('PRS', 0001, 'WEB_FACTAB', 'prs_max_dep_level' , 'number' , '2' , 'number of levels between prs_bedijf and prs_perslid (max = 5)')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_mgt_edit_login' , 'boolean' , 'false' , 'WEB_FACMGT may change login')
DEFINE_SETTING('PRS', 0001, 'WEB_FACTAB', 'prs_werkplek_implicit' , 'number' , '1' , 'Are workplaces treated as separate entitities (0) or implicitly/invisible used in person-room relations(1)')
DEFINE_SETTING('RES', 0001, 'WEB_FACTAB', 'res_image_path' , 'string' , NULL , 'path to folder storing res_ruimte pictures')
DEFINE_SETTING('RES', 0001, 'WEB_FACTAB', 'resd_image_path' , 'string' , NULL , 'path to folder storing res discipline pictures')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'max_report_zip_uncompressed' , 'number' , '250' , 'Maximum uncompressed size (MB) for zipping attachments by UDR report')
DEFINE_SETTING('ALG', 0001, 'WEB_PRSSYS', 'alg_fg_remote_maps' , 'string' , '' , 'API Key. if not empty use Google Maps for locations en buildings in Facilitor Graphics')
DEFINE_SETTING('ALG', 0001, 'WEB_PRSSYS', 'alg_onrgoed_recent' , 'number' , '60' , 'Tijdsinterval voor de recente onroerendgoed wijzigingen in minuten')
DEFINE_SETTING('ALG', 0001, 'WEB_FACTAB', 'alg_image_path' , 'string' , NULL , 'path to folder storing alg pictures')
DEFINE_SETTING('ALG', 0001, 'WEB_PRSSYS', 'alg_photo_size' , 'string' , 'r512x512' , 'Resize uploads to this maximum ALG photo size. Ex: r200x150')
DEFINE_SETTING('ALG', 0001, 'WEB_PRSSYS', 'fg_maps_distance_apikey' , 'string' , '' , 'API Key for Google Maps distance API requests')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_afleverruimte_verplicht' , 'number' , '0' , 'Afleverruimte visable and/or required {0=visable and not required (default) | 1=visable and required | 2=not visable and not required}')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_approval_all' , 'number' , '0' , 'Goedkeuring bestelling vereist t.o.v. eerstvolgende limiet (=0 default) of t.o.v. totale kosten (in n keer)(=1)')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_bestelling_prefix' , 'string' , '' , 'prefix voor het aanvraagnummer van de bestelling')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_bestelopdr_flags' , 'number' , '0' , 'Number of flags that can be defined on purchase orders. Max 10')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_bestelopdr_prefix' , 'string' , '' , 'prefix voor het opdrachtnummer van de bestelling')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_confirm_order_before_submit' , 'boolean' , 'false' , 'Bevestig bestelaanvraag voordat het uitgevoerd wordt')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_datum_limiet' , 'number' , '90' , 'max days in the future')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_fo_default_user' , 'number' , '0' , 'Use current user as default purchaser { 0=empty (default) | &1=user | &2=issuer (from MLD) }')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_pgb_fe_fiat' , 'number' , '0' , 'Een bestelling van FE-er moet naast PGB/AGB fiattering ook altijd gefiatteerd worden, anders altijd afwijzen {0=no | 1=yes}')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_pgb_fiattering' , 'number' , '0' , 'Algemene fiatteringsproces noodzakelijk naast PGB/AGB fiatering? {0=no | 1=yes}')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_photo_size' , 'string' , 'r512x512' , 'Resize uploads to this maximum BES photo size. Ex: r200x150')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_retour_need_approval' , 'number' , '0' , 'retourbestelaanvraag wel(=1)/niet(=0) langs de BO laten gaan voor fiattering')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_show_RFO_price' , 'number' , '2' , 'show prices {0=no support | 1=FO support | 2=FE&FO support}')
DEFINE_SETTING('BES', 0001, 'WEB_PRSSYS', 'bes_show_inkprijs' , 'number' , '0' , 'show inkoopprijs column with BES management info {0=no | 1=yes}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_bezoekers_flags' , 'number' , '0' , 'Number of flags fo/bo can define for visitors. Max 10')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_bezoekers_recent' , 'number' , '60' , 'Tijdsinterval voor de recente bezoekers wijzigingen in minuten')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_bo_orderby' , 'number' , '0' , 'Bezoekersbalie na datumtijd sorteren op { 0=Naam van de bezoeker | 1=Naam van de gastheer}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_can_send_sms' , 'boolean' , 'false' , 'Option to send sms to host from visitors list')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_closeafteradd' , 'number' , '0' , '0=not, 1=bo, 2=fo, 3=bo&fo')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_gastheer_telfnr' , 'number' , '1' , 'In bezoekersbalie telfoon nummer van gastheer ook tonen { 0=Nee | 1=Ja}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_hide_tracking' , 'number' , '0' , 'Exclude from visitor tracking subtab; { 0=No one (default), +1=FE, +2=FO }')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_max_flex_on_line' , 'number' , '0' , 'Max aantal flexkenmerken op een bezoekersregel')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_multiday' , 'number' , '0' , 'Can user enter an end-date for an appointment')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_sel_contactpersoon' , 'number' , '1' , 'can I select contactpersonen { 0=no | 1=yes | 2=yes, but depending on location}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_sel_internpersoon' , 'number' , '0' , 'can I select internal persons { 0=no | 1=yes }')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_set_remote_flags' , 'number' , '0' , 'Flags to set with remote-checkbox')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_show_flex_in_list' , 'number' , '7' , 'Show flex properties in visitor-lists { 0=none | 1=FE | 2=FO | 3=FE&FO | 4=BO | 5=FE&BO | 6=FO&BO | 7=FE&FO&BO }')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_show_progress_prop' , 'number' , '1' , 'Tonen afhandelings kenmerken (>900) voor bezoekers {0=nooit | 1=popup tijdens inchecken bezoekers(default) | 2=Inline actie | 4=Uitsluitend tonen in popup}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_show_resname' , 'boolean' , 'false' , 'Show room name instead of real estate name {false=show real estate name | true=show room name}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_use_buildinghours' , 'number' , '0' , 'Gebouwtijden als tijdgrenzen van afspraken gebruiken {0=Nee (default), 1=Ja, 2=weekend niet, 3=volgens gebouwtijden maar weekends niet}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_change_range' , 'number' , '0' , 'minutes before & after start time that bezbof can change visitors')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'bez_chat_message' , 'string' , 'https://teams.microsoft.com/l/chat/0/0?users={0}&message={1}', 'Link to start Microsoft Teams chat')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'csscust' , 'string' , '' , 'Custom css overrules')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_afspraak_limiet' , 'number' , '-1' , 'max number of days from now that visitors are allowed, in past or future {-1 = no limit}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_allow_check_all' , 'number' , '1' , 'multiple-checkin visitors { 0=no | 1=yes }')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_allow_uncheck' , 'number' , '0' , 'allow uncheck visitors { 0=no | 1=yes }')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_autobadgelength' , 'number' , '3' , 'Autobadge digits')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_autobadgeletters' , 'string' , '' , 'eg. ABCDEFG: Cycle through these letters daily')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_autobadgestart' , 'number' , '1' , 'Daily autobadge start')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_badgeprint_enable' , 'number' , '1' , 'print {0=no | 1=print at check in | 2=show print button | 4=only when bez_actie autobadge, 3=both 1 and 2 etc. | 8=location/building}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_bo_end_interval' , 'float' , '12' , 'standard bo end time interval')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_bo_search_host' , 'number' , '0' , 'Show field ''Host'' for VIS BO to search on')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_bo_show_all' , 'number' , '0' , 'On entry: Are all checkboxes selected')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_bo_uses_badgenrs' , 'number' , '0' , 'the BO enters and uses badgenr registration { 0=no | 1=yes }')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_checkout_enable' , 'number' , '1' , 'register checkout of visitors by BO {0=no | 1=yes}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_default_number' , 'number' , '4' , 'Default number of visitors (= nr of lines to be filled out) for new appointment')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_expire' , 'number' , '0' , 'number of days in the future from which the FE can delete de visitors')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_fe_afspraak_limiet' , 'number' , '180' , 'max number of days from now that visitors are allowed by FE, in past or future {-1 = no limit}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_future_checkin' , 'number' , '0' , 'How many days before visit can a visitor be checked in (days)')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_h' , 'float' , '0.25' , 'time stepsize')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_increment_number' , 'number' , '1' , 'Number of visitors (= nr of lines to be filled out) to be added with one click')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_mandatory_alg_level' , 'string' , 'L' , 'alg level ''L'' (location), ''G'' (building, ''V'' (floor) or ''R'' (room)')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_park_text' , 'string' , '' , 'Text to replace image in register_input')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_remark' , 'number' , '0' , 'Show field remark for visitor {0=dont show | 1=show | 2=show at register visitor | 3=readonly}')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_show_alg_level' , 'string' , 'L' , 'Show alg level ''L'' (location), ''G'' (building, ''V'' (floor) or ''R'' (room)')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_t1' , 'float' , '8' , 'visitors day start (hour)')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_t1_fo' , 'float' , '-1' , 'visitors day start (hour) frontoffice')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_t1_std' , 'float' , '8' , 'standard visiting begin time of visitors (hour)')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_t2' , 'float' , '18' , 'visitors day end (hour, max. 23.99)')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_t2_fo' , 'float' , '-1' , 'visitors day end (hour) frontoffice')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_t2_std' , 'float' , '18' , 'standard visiting end time of visitors (hour)')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_user_history' , 'number' , '7' , 'number of days in the past the FE can see his vistors')
DEFINE_SETTING('BEZ', 0001, 'WEB_PRSSYS', 'vis_warning_limit' , 'string' , '-1' , 'After this time, show alert when visitor reservation is for the next day after this day, which is actually too late (-1 = geen tijdswaarde, format = 16:00)')
DEFINE_SETTING('BGT', 0001, 'WEB_PRSSYS', 'bgt_extra_report_param' , 'boolean' , 'false' , 'Extra parameter aan xml toevoegen waarop niet gefilterd wordt')
DEFINE_SETTING('BGT', 0001, 'WEB_PRSSYS', 'bgt_usrtab_vaste_factuurnummer' , 'string' , '' , 'Naam van usertable waarin de standaard (niet unieke) factuurnummers in staan')
DEFINE_SETTING('BGT', 0001, 'WEB_PRSSYS', 'bgt_photo_size' , 'string' , 'r512x512' , 'Resize uploads to this maximum BGT photo size. Ex: r200x150')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_areathreshold' , 'float' , '2.0' , 'Minimal contour area (m2) to display a full size label')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_bitmapsymbolsize' , 'number' , '1000' , 'Symbol height for bitmap symbols')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_symbolfont' , 'string' , 'Font Awesome 6 Pro Regular' , 'Fontname for font symbols. Must be installed on webserver!')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_contourcolor' , 'number' , '65280' , 'Default roomcontour coloring')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_contourcolorcpt' , 'number' , '16776960' , 'Default roomcontour coloring new rooms in concept drawings')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_contourweight' , 'number' , '100' , 'Roomcontour width (mm)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_contour_minArea' , 'number' , '200010' , 'Minimal area (mm2) to be recognised as a relevant contour')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_contourlayers' , 'string' , '{CONT!.}|{CONT\|.*}' , 'Regexp for contourlayernames default areas')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_contourlayers_floor' , 'string' , '' , 'Regexp for contourlayernames floors')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_contourlayers_alt1' , 'string' , '' , 'Regexp for contourlayernames alternative areas 1')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_contourlayers_alt2' , 'string' , '' , 'Regexp for contourlayernames alternative areas 2')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_dwgscale' , 'float' , '1000' , 'AutoCAD Drawing scale units/meter (future use)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_hilitebordercolor' , 'number' , '0xF59D04' , 'Default contour hilite border coloring')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_hilitefillcolor' , 'number' , '0xE02D93' , 'Default contour hilite fill coloring')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_hilitesymbolfillcolor' , 'number' , '0xFFFF00' , 'Default symbol hilite fill coloring')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_infobordthema_key' , 'number' , '-1' , 'Default colortheme (key) for Graphics Infobord')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_infobordlabel_key' , 'number' , '-1' , 'Default labeltheme (key) for Graphics Infobord')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_infobordreport_key' , 'number' , '-1' , 'Default report (key) for Graphics Infobord')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_ininslabelSize' , 'number' , '250' , 'Default labelsize for objects inside (mm)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_inlabelsize' , 'number' , '800' , 'Default labelsize for rooms inside (mm)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_inwplabelsize' , 'number' , '400' , 'Default labelsize for worplaces inside (mm)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_ins_symbols' , 'boolean' , 'true' , 'Show objects as symbols on floorplans')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_labelposition' , 'number' , '1' , 'Labelposition of roomlabels 1=original, 2=center, 3=topleft')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_labellayers' , 'string' , '{CONT!.}|{CONT\|.*}' , 'Regexp for contourlabellayernames default areas')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_labellayers_alt1' , 'string' , '' , 'Regexp for contourlabellayernames alternative areas 1')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_labellayers_alt2' , 'string' , '' , 'Regexp for contourlabellayernames alternative areas 2')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_mobile_label' , 'number' , '-1' , 'Standard labels to use on Mobile plans (key)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_mobile_thema' , 'number' , '-1' , 'Standard theme to use on Mobile plans (key, -1=user select)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_outinslabelsize' , 'number' , '8000' , 'Default labelsize for objects outside (mm)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_outlabelsize' , 'number' , '16000' , 'Default labelsize for terrains outside (mm)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_papercolor' , 'number' , '15462399' , 'Background color (-1=as published)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_planforcecolor' , 'number' , '-1' , 'Plan forced color (-1=as published, future use)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_papercolorcpt' , 'number' , '13684944' , 'Background color for concept drawings')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_publiclayers' , 'array' , '' , 'Discipline keys for layers to be visible even without WEB_INSUSE authorisation')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_symbolweight' , 'number' , '60' , 'Linewidth for symbols (mm)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_werkpleksymbool' , 'string' , 'WERKPLEK' , 'Workplace symbol name (dwf-file, must exist in symbols dwf folder)')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'fg_dwfviewer_installed' , 'boolean' , 'false' , 'True when dwf viewer installed')
DEFINE_SETTING('CAD', 0001, 'WEB_PRSSYS', 'cad_symbols_snap' , 'number' , '1' , 'Snap objects to grid (grid in mm), <1=off')
DEFINE_SETTING('CHT', 0001, 'WEB_PRSSYS', 'cht_bo_naam' , 'number' , '0' , 'Toon naam van servicedesk medewerker 0=eigen naam 1=algemene term')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_all_kostenplaats' , 'number' , '0' , 'show all (1) active kostenplaats values or only the one i have mandate for (0) in list')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_approval_all' , 'number' , '0' , 'Goedkeuring contract vereist t.o.v. eerstvolgende limiet (=0 default) of t.o.v. totale kosten (in n keer)(=1)')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_contract_approval' , 'number' , '0' , 'Het contract approval mechanisme is wel (=1) of niet (=0) ingeschakeld')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_contract_limit3' , 'number' , '125000' , 'De derde limiet van het contract approval mechanisme')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_contract_limit2' , 'number' , '5000' , 'De tweede limiet van het contract approval mechanisme')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_contract_limit5' , 'number' , '9999999' , 'De vijfde limiet van het contract approval mechanisme')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_contract_limit4' , 'number' , '1000000' , 'De vierde limiet van het contract approval mechanisme')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_contract_limit1' , 'number' , '0' , 'De eerste limiet van het contract approval mechanisme')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_contract_recent' , 'number' , '60' , 'Tijdsinterval voor de recente contract wijzigingen in minuten')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_contract_requestor_required' , 'boolean' , 'false' , 'Set the contract requestor field as required (true) or optional (false)')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_enable_kostensoort' , 'number' , '1' , 'can contract kostensoort be changed?')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_factuur_totaalmarge' , 'number' , '0' , 'De toegestane marge op de totaal factuur (default 0)')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_inactivate_mode' , 'number' , '0' , 'inactivate contract with WEB_CNTMAN/WEB_CNTUSE read rights and WEB_CNTMSU rights (0) or with extra WEB_CNTMAN write rights (1) and WEB_CNTMAN may edit older, inactive contract versions (2)')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_internalnr_readonly' , 'number' , '0' , 'Het interne contractnummer wordt automatisch bepaalt en is niet wijzigbaar')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_rappel_abonnement' , 'number' , '3' , 'Rappel termijn van een abonnement contract')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_scopeverdeling' , 'number' , '0' , '0|1, cost distribution by scope weights 0=relative weight, 1=absolute amount')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_with_mld' , 'number' , '0' , 'Contract kan meldingen hebben {0=Nee (default) | 1=Ja}')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_photo_size' , 'string' , 'r512x512' , 'Resize uploads to this maximum CNT photo size. Ex: r200x150')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cntuse_can_edit_datum' , 'boolean' , 'false' , 'Can cntuse edit contract date(s) or not')
DEFINE_SETTING('CNT', 0001, 'WEB_PRSSYS', 'cnt_grace_period' , 'number' , '30' , 'Show contract this number of days after end of contract')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'ProxyServerIPAddress' , 'string' , NULL , 'For webserver to reach outside world')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'interface_toggles' , 'number' , '1' , 'To keep track of the interface that is being used')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'ReplyAddress' , 'string' , '' , 'ReplyTo Address when e-mailing manually')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fin_replyaddress' , 'string' , '' , 'Financial ReplyTo Address when e-mailing manually')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'anonymize_period' , 'number' , '365' , 'Period before data will be [GDPR] anonymized (days)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'anonymize_mode' , 'number' , '13' , 'Data that will be [GDPR] anonymized (0=nothing, 1=tracking,2=notes,4=flexproperties,8=descriptions)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'datapurge_period' , 'number' , '99' , 'Period (years) to keep dynamic data stored in database. Older data wil be permanently purged')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'aut_login_strip_domain' , 'number' , '1' , 'Strip AD domain from login name { 0=no, 1=yes (default) } (Future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'auth_edit_advanced' , 'boolean' , 'false' , 'Start autorisation popup dialog in advanced mode')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'buttons_in_hamburger' , 'array' , 'fa-print,fa-envelope,fa-table,fa-fclt-refresh,fa-columns,fa-share-square,fa-file-download,fa-file-upload,fa-megaphone,fa-trash-can-xmark', 'Hide these frameheader buttons behind a hamburger.')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'can_selfapprove' , 'number' , '999999' , 'I can approve myself below or equal this limit or someone else must approve always above this limit')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'checkBrowser' , 'number' , '0' , 'Check for IE6 at login (1) or not.')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'currency_icon' , 'string' , 'fa-euro-sign' , 'Currency icon. Use fa-money-bill-wave for generic')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'currency_pref' , 'string' , 'EUR ' , 'Currency prefix')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'currency_suff' , 'string' , '' , 'Currency suffix')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'email_password' , 'number' , '0' , 'Show ''wachtwoord vergeten'' optie (1=voor mensen met wachtwoord, 2=voor iedereen)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'excel_mode' , 'number' , '2' , 'Save Excel as {0=html-table (deprecated)| 1=as CSV (not supported)| 2=native XLS}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_api_limit' , 'number' , '100' , 'Default maximum number of records to return using the REST API')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_api_limit2' , 'number' , '5000' , 'Ultime maximum number of records to return using the REST API')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_bes_deeplike_expire' , 'number' , '0' , 'Number of days bestelling deeplike bookmark is valid (default 0 is disabled) future use')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_favicon_folder' , 'string' , 'appl/pictures/' , 'Folder for favorite/bookmark icons')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'fac_hide_fields' , 'string' , '' , 'Hide fields in the interface (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_firstlogin_expire' , 'number' , '14' , 'Remove firstlogin_url automatically after nn days')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_firstlogin_url' , 'string' , 'appl/fac/welcome.asp' , 'Url to show upon first login of user')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_gui_counter_menu_daily' , 'number' , '1' , 'Compress menu usage count {0=don''t, 1=per user per day(favorites), 2=per day}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_like_bad' , 'number' , '2' , 'Rating for bad service')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_like_excellent' , 'number' , '10' , 'Rating for excellent service')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_like_good' , 'number' , '8' , 'Rating for good service')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_like_normal' , 'number' , '6' , 'Rating for normal service')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_like_poor' , 'number' , '4' , 'Rating for poor service')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_max_initial_attachments' , 'number' , '10' , 'Initial number of attachments on show. 0 = show all.')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_mld_deeplike_expire' , 'number' , '0' , 'Number of days melding deeplike bookmark is valid (default 0 is disabled)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_phone_protocol' , 'string' , 'callto' , 'Desktop protocol to use for phone links')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_res_deeplike_expire' , 'number' , '0' , 'Number of days reservation deeplike bookmark is valid (default 0 is disabled) future use')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'fac_usrrap_keepfilter' , 'number' , '1' , 'User reports remember filters globally. 1=Remember 0=Do not remember')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'facilities_flike_past' , 'number' , '7' , 'Number of days in the past to show my facilities for rating')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'facilitiesfuture' , 'number' , '365' , 'Number of days in the future to show my facilities (Lopende Zaken)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'facilitiesfuture_mld' , 'number' , '31' , 'DEPRECATED Number of days in the future to show my facilities for calls')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'facilitiesfuture_bes' , 'number' , '31' , 'DEPRECATED Number of days in the future to show my facilities for orders')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'facilitiesfuture_bez' , 'number' , '31' , 'DEPRECATED Number of days in the future to show my facilities for visitors')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'facilitiesfuture_res' , 'number' , '31' , 'DEPRECATED Number of days in the future to show my facilities for reservations')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'facilitiespast_bez' , 'number' , '2' , 'Number of days in the past to show my facilities for visitors')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'facilitiespast_bes' , 'number' , '2' , 'Number of days in the past to show my facilities for orders')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'facilitiespast_ins' , 'number' , '2' , 'Number of days in the past to show my facilities for lent objects')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'facilitiespast_mld' , 'number' , '2' , 'Number of days in the past to show my facilities for calls')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'facilitiespast_res' , 'number' , '2' , 'Number of days in the past to show my facilities for reservations')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'favorites_on_portal_menu' , 'number' , '1' , 'Display pinned favorites on the -desktop- portal menu { 0=no, 1=yes (default) } ')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'flexExtensionFilter' , 'string' , NULL , 'All files can be uploaded. "PDF DOC TIFF XLS" would filter')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'flexFilesOrdering' , 'number' , '0' , 'Ordering for list of flexfiledates {0=ascending | 1=descending}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'helppage_url' , 'string' , 'https://help.facilitor.nl/fac_wrapper.php', 'Helppage')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'iconcolumns' , 'number' , '6' , 'number of columns in an iconmenu page.')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'inline_actions_hamburger' , 'number' , '0' , 'Use a hamburger-icon to view the inline actions {0=No | 1=Yes, onClick | 2=Yes, onMouseOver}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'inline_actions_mld' , 'number' , '1' , 'Show inline actions in MLD-list {0=No | 1=Yes | 2=Yes, but suppress in embedded lists}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'kosten_klant_default' , 'number' , '1' , 'initial status of kosten klant checkbox { 0 - unchecked | 1 - checked }')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'login_remember_days' , 'number' , '30' , 'Days to remember login. { 0 disable }')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'login_use_email' , 'number' , '0' , 'Add users to the _Default authorisation group when ''Login'' { 1 = Or ''E-mail'' } is filled out')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'logoff_return_url' , 'string' , '../../' , 'Return url to go to after log off')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'max_horizontal_blocks' , 'number' , '3' , 'Max. horizontal blocks in detail-frames')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'max_tracking_length' , 'number' , '30' , 'Max. displayed length of single value in a tracking line, longer values are summarized')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'menu_collapse_threshold' , 'number' , '5' , 'Max number menugroups in a tab before we will collapse')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'menu_photo_size' , 'string' , 'r512x512' , 'Resize uploads to this maximum MENU photo size. Ex: r200x150')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'menu_start_open' , 'boolean' , 'true' , 'Menu is open by default')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'menu_tab_toggles_portalmenu' , 'number' , '0' , 'Also activate corresponding portal_menu in body (1) or not (0)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'menu_use_menuicons' , 'number' , '1' , 'Use the images of the portalmenu in the regular menu as well (1) or do not (0)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'mobile_alg_filterlevel' , 'string' , '' , 'Level to use for mobile filtering: A(Alles), D(District), L(ocatie), G(ebouw) of V(erdieping)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'mobile_alg_level' , 'string' , 'G' , 'Level to use for mobile scoping: L(ocatie), G(ebouw) of V(erdieping)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'werklocatie_alg_scope' , 'number' , '-1' , 'Mijn werklocatie/standplaats moet liggen binnen mijn:' || CHR(10) || '-1: Alles is toegestaan (=default)' || CHR(10) || '0: Regio' || CHR(10) || '1: District' || CHR(10) || '2: Locatie' || CHR(10) || '3: Gebouw' || CHR(10) || '4: Verdieping' || CHR(10) || '5: Ruimte' || CHR(10) || '6: Ik mag alleen mijn eigen werkplekken kiezen')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'mobile_password' , 'number' , '0' , 'get the login password sent to your mobile')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'mobile_password_pda' , 'number' , '0' , 'get the login password sent your mobile when using a mobile')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'mobile_position_required' , 'number' , '1' , 'A current position is required for geo-scoping (1) or not (0)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'note_collapsed' , 'number' , '1' , 'Notes overview collapsed/fold up (=1 default) or unfold (=0)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'note_autocollapse' , 'string' , '' , 'Regexp note text that will allways start collapsed in note overviews (for technical system notes)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'note_sort_ascending' , 'number' , '0' , 'Ordering of notes for FO and BO in note overviews {0 = descending | 1 = ascending}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'note_draft_history_days' , 'number' , '30' , 'Save drafts of notes for this many days (-1 = do not save)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'portalmenu_combine_single' , 'number' , '0' , '0: default, 1:If a portalmenukop consists of 1 item, should the image be moved in between the menukop and the menuitem? 2:only header')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'portalmenucols' , 'number' , '3' , 'Number of columns in portal menu')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'portalmenulines' , 'number' , '5' , 'Max. number of lines in portalmenu (incl. "More..."')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'portalmsgmax' , 'number' , '5' , 'Max. number of messages in messages frame {-1=unlimited | n=limit to n most recent messages | 0=no messages}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'portalnewslength' , 'number' , '96' , 'Max. length of a line in statusinfo frame for hyperlinked messages {0..512}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'portalnewsmax' , 'number' , '25' , 'Max. number of messages in statusinfo frame {-1=unlimited | n=limit to n most recent messages}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'prodsearch_rank' , 'array' , 'faq,besartikel,resruimte,mldstdm,prsperslid,resartikel,resdeel', 'Ranking in product search')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'progress_notification_for' , 'boolean' , 'false' , 'Send progress notification to [false=prs_perslid_key | true=prs_perslid_key_voor]')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'prs_bulk_mail_max' , 'number' , '0' , 'Maximum number of persons to be mailed')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'prs_einddatum_login_grace' , 'number' , '-1' , 'Disallow login after prs_einddatum. (-1=disabled, >=0 disallow after einddatum+nnn days')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'prs_password_expiration' , 'number' , '-1' , 'Password expire days {-1 = does not expire}, existing password will not expire autmatically after adjusting this')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'prs_password_fail_limit' , 'number' , '999' , 'Lockout after many password failures (Future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'prs_password_validation' , 'string' , '.{8,}' , 'At least 8 characters')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'prs_password_validation_mode' , 'number' , '255' , 'Password validation +1=+prs_password_validation regexp, +2=wordlist, +4=charsets')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'prs_common_passwords' , 'array' , 'facilitor,aareon' , 'Extra banned words for password validation')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'prs_personal_noti_options' , 'number' , '15' , 'Options that are provided for personal notification overrules (+8:popup,+4:sms,+2:mail,+1:portal)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'qp_maxrows' , 'number' , '100' , 'Maximum number of rows to show, displays ''lcl_qp_maxrows1/2'' if exceeded')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'qp_maxrows2' , 'number' , '1000' , 'Maximum number of rows to show, displays ''lcl_qp_maxrows3'' if exceeded')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'qp_maxgridrows' , 'number' , '250' , 'Maximum number of objects to show per discipline in reservations planboard')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'qp_maxgridrows2' , 'number' , '1200' , 'Maximum number of rows to show for all selected locations together in reservations planboard')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'qp_maxrows_mobile' , 'number' , '50' , 'Maximum number of rows to show mobile, displays ''lcl_qp_maxrows'' if exceeded')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'qp_maxrows_suggest' , 'number' , '1500' , 'Maximum number of rows to show suggest, displays ''lcl_shared_suggest_toomany_multi'' if exceeded')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'queuemail_sender_order' , 'string' , 'URC' , 'Order in which senders are shown {default URC: Useraddress, Replyaddress, Catalogaddress}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'refresher_doubleauto' , 'number' , '3' , 'Double buffering delay (seconds)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'rs_maxchar' , 'number' , '150' , 'vanaf hier afgekapt en ''Meer...'' tonen.')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'rs_mobile_maxchar' , 'number' , '80' , 'vanaf hier afgekapt en ''...'' tonen.')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'self_fromaddress' , 'string' , 'Facilitor registratie <no_reply@xxxx.facilitor.nl>', 'From-address for confirmation e-mail self-registration')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'self_replyaddress' , 'string' , 'no_reply@xxxx.facilitor.nl' , 'Reply-address for confirmation e-mail self-registration')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'show_header_productsearch' , 'boolean' , 'true' , 'Display the product search bar in the header')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'show_issuer_phone' , 'number' , '0' , 'Show the issuer/requestor phone number. {0=never; &1=only MLD; &2=only BES; 3=always}')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'show_ordernr' , 'number' , '0' , '0=never,>0=always, 3=also bo-list')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'sml_photo_size' , 'string' , 'r200x150' , 'Resize uploads to this maximum SML photo size. Ex: r200x150')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'submenu_open_delay' , 'number' , '-1' , 'Delay in milliseconds after which the submenu appears for an open menu (-1 = never)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'timepickercolumns' , 'number' , '4' , 'Nr of columns for timepicker (increase for long days or short intervals)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'udr_graph_colors1' , 'string' , '[''#003478'',''#6685ae'',''#e37b00'',''#0b94f9'',''#81ce58'',''#f3d736'',''#acaa65'',''#a222c4'',''#5b9bc3'',''#1c40eb'',''#037011'',''#d192e7'',''#f88625'',''#93b89f'',''#bf6b87'',''#a2b41a'',''#f76979'',''#f41181'',''#73eb59'',''#32d1d0'',''#a00bed'',''#66fe6b'',''#b94d5b'']' , 'Color used for single bar /line graphs (string!)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'udr_graph_colors2' , 'string' , '[''#003478'',''#6685ae'',''#e37b00'',''#0b94f9'',''#81ce58'',''#f3d736'',''#acaa65'',''#a222c4'',''#5b9bc3'',''#1c40eb'',''#037011'',''#d192e7'',''#f88625'',''#93b89f'',''#bf6b87'',''#a2b41a'',''#f76979'',''#f41181'',''#73eb59'',''#32d1d0'',''#a00bed'',''#66fe6b'',''#b94d5b'']' , 'Colors used for stacked bar /line graphs (string!)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'udr_graph_bar_json' , 'string' , '' , 'Default json options for report graphs bar (string!)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'udr_graph_gauge_json' , 'string' , '' , 'Default json options for report graphs gauge (string!)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'udr_graph_pie_json' , 'string' , '' , 'Default json options for report graphs pie (string!)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'udr_graph_line_json' , 'string' , '' , 'Default json options for report graphs line (string!)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'udr_graph_block_json' , 'string' , '' , 'Default json options for report graphs block (string!)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'udr_graph_gauge_colors' , 'string' , '[''#CC6666'', ''#E7E658'', ''#66CC66'']' , 'Colors being used for gaugemeter charts (string!)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'udr_graph_pie_colors' , 'string' , '[''#003478'',''#6685ae'',''#e37b00'',''#0b94f9'',''#81ce58'',''#f3d736'',''#acaa65'',''#a222c4'',''#5b9bc3'',''#1c40eb'',''#037011'',''#d192e7'',''#f88625'',''#93b89f'',''#bf6b87'',''#a2b41a'',''#f76979'',''#f41181'',''#73eb59'',''#32d1d0'',''#a00bed'',''#66fe6b'',''#b94d5b'']' , 'Colors being used for pie charts (string!)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'use_wildcard_with_suggests' , 'number' , '2' , 'Use wildcards for all sugest fields (0=no wildcard, 1=text*, 2=*text*)')
DEFINE_SETTING('FAC', 0001, 'WEB_PRSSYS', 'usrrap_refreshrate' , 'number' , '60' , 'time between auto refresh of selected usrraps (seconds)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'ai_enabled' , 'number' , '0' , 'Enable AI (65535=all (incl. future) AI features) to generate;' || CHR(10) || '&1; subjects for calls from their description (configuration needed)' || CHR(10) || '&2; FAQs for calls' || CHR(10) || '&4; text for closing calls' || CHR(10) || '&8; new order descriptions' || CHR(10) || '&16; portal messages when publishing calls')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'ai_endpoint' , 'string' , 'https://general-foundry-prod.cognitiveservices.azure.com/openai/deployments/general-gpt4o/chat/completions?api-version=2025-01-01-preview', 'AI API endpoint url')
DEFINE_SETTING('FAC', 0000, 'WEB_FACFAC', 'ai_apikey' , 'string' , '3XUVnWTMwxOhKEj4Jnu4hj0Ifr8B9lt0PLCdhjAVxb2krGD99wpiJQQJ99BJACfhMk5XJ3w3AAAAACOGEWSl', 'APIKEY for AI services')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'ai_mail_base_prompt_outputformat' , 'string' , '' , 'AI base prompt for e-mails. Describes desired output format 0 (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'ai_mail_base_prompt1' , 'string' , '' , 'AI base prompt for e-mails. Describes format 1 (future use)')
DEFINE_SETTING('FAC', 0001, 'WEB_FACTAB', 'ai_mail_base_prompt2' , 'string' , '' , 'AI base prompt for e-mails. Describes format 2 (future use)')
DEFINE_SETTING('MSG', 0001, 'WEB_PRSSYS', 'msg_photo_size' , 'string' , 'r512x512' , 'Resize uploads to this maximum MSG photo size. Ex: r200x150')
DEFINE_SETTING('MSG', 0001, 'WEB_PRSSYS', 'msg_max_history' , 'number' , '30' , 'Show messages no longer than msg_max_history days ago')
DEFINE_SETTING('FAQ', 0001, 'WEB_PRSSYS', 'faq_kennisbank_popup' , 'number' , '3' , 'Show kennisbank popup {0=no | 01=1=FE | 10=2=FO | 11=3=FE+FO}')
DEFINE_SETTING('FAQ', 0001, 'WEB_PRSSYS', 'faq_max_results' , 'number' , '25' , 'Limit the FAQ results to this number')
DEFINE_SETTING('FAQ', 0001, 'WEB_PRSSYS', 'faq_max_results_mld' , 'number' , '0' , 'Initial number of faq items when editing an issue. 0 = show all.')
DEFINE_SETTING('FAQ', 0001, 'WEB_PRSSYS', 'faq_max_results_bez' , 'number' , '0' , 'Initial number of faq items when editing an appointment. 0 = show all.')
DEFINE_SETTING('FAQ', 0001, 'WEB_PRSSYS', 'faq_search_hints_only' , 'number' , '0' , 'When searching through the Knowledge base, only find matching hints {1=true | 0=false}')
DEFINE_SETTING('FAQ', 0001, 'WEB_PRSSYS', 'faq_default_visibility' , 'number' , '3' , 'Set default visibility when creating a new knowledgebase item {1 = Selfservice | 2 = Professionals | 3 = Selfservice and Professionals}')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_bof_mag_editen' , 'number' , '1' , 'Users/Approvers with FINBOF rights have edit possibilities {0=no edit (only approve) | 1=edit (default)}')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_btw_default' , 'number' , '3' , 'Standaard btw tarief (1=NL|Nul, 2=NL|Laag, 3=NL|Hoog, enz.)')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_enable_afwijzen' , 'number' , '1' , 'Is it possible to reject an invoice or not {0=Afwijzen unavailable | 1=Afwijzen available}')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_enable_goedkeuren' , 'number' , '0' , 'Is it possible to validate (''goedkeuren'') an invoice {0=validation unavailable | 1=validation optional | 2=validation required}')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_enable_kostensoort' , 'number' , '1' , 'can factuur kostensoort be changed?')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_factuur_flags' , 'number' , '0' , 'Number of flags that can be defined on invoices. Max 10')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_factuur_flags_list_usage' , 'number' , '0' , 'Set rights that readonly can/cannot edit markings (bolletjes) toe {0=no | 1=yes}')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_factuur_verlegdmode' , 'number' , '0' , 'Use and validation of field fin_factuur_gbedrag: {0=field invisible | &1=visible and enterable | &2=required if invoicelines has a shifted VAT-value | &4=all invoicelines must have shifted VAT-value or must have standard VAT values (=not shifted)}')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_kostensoort_verplicht' , 'number' , '0' , 'Is kostensoort required? {0=not required | 1=required}')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_factuur_import_sanitize_id' , 'string' , '([A-Za-z]{0,3}\d{1,10}(\/\d+)?)', 'Regexp for sanitizing imported invoice ID''s (removes unwanted characters)')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_match_lowerlimit' , 'number' , '0' , 'Check lowerlimit also for matching {0=Only upperlimit (invoice<order+tolerance | 1=Upper and lowerlimit (order-tolerance<invoice<order+tolerance)}')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_new_after_save' , 'number' , '0' , 'Na het opslaan terugkomen met de factuur in de showmode of met nieuw leeg invulformulier (0=showmode || 1=nieuw formulier)')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_splitsen_omschr' , 'number' , '0' , 'Split up the discription of the invoice lines? {0=no (default) | 1=yes}')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_use_verkoopfacturen' , 'number' , '0' , 'Provide direct access to generated salesinvoices (if any) from contract/order/reservation details {0=no | 1=yes}')
DEFINE_SETTING('FIN', 0001, 'WEB_PRSSYS', 'fin_invoice_check_total' , 'number' , '0' , 'Compare invoice lines with total invoice: [0||4]=no | &1=excl. VAT | &2=incl. VAT | &3=optional/required')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'cnd_usage_model' , 'number' , '1' , 'Model used for condition measuring {1=defects are for score inventory/preventive maintenance, 2=defects are for immediate recovery}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'cnd_scoremethod' , 'number' , '1' , 'Calculation method of condition score of objects when multiple defects {1=according to NEN-2767, 2=use worst score}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'cnd_use_halfscores' , 'number' , '0' , 'Use 0,5 intervals for aggregated condition scores (0=use 1/2/3/4/5/6, 1=use 1/1,5/2/2,5/../6}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'cnd_autoaccept' , 'number' , '0' , 'Automatically accept defects (1) or defects must be accepted explicitly (0)')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_attach_obj_cntpers' , 'number' , '0' , 'Een object koppelen aan een contactpersoon {0=Alleen tijdens bezoek(default) | 1=Altijd}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_auth_obj_lendout' , 'number' , '0' , 'Authorization scope for objects which are lent out for lending registration (INSFOF/fo) {0=owner(borrower) (default) | 1=basic place/owner}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_can_edit_own_objects' , 'number' , '0' , 'Owner can edit objects {0|1, default 0}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_element_description' , 'string' , '' , 'SQL voor de objectomschrijving achter de "heeft betrekking op" knop voor het selecteren van elementen')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_explode_objects' , 'number' , '1' , 'Explode the nummer of (new) object {0=no | 1=yes (default) | 2=choice: default no | 3=choice: default yes}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_fg_remote_maps' , 'string' , '' , 'API Key. if not empty use Google Maps instead of FG if x,y coordinates of an object are available')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_flex_uitgifte_empty' , 'number' , '0' , 'Flexvelden die geen meetwaarden zijn leeg maken bij uitgifte {0=no (default) | 1=yes}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_inspect_service_depend' , 'number' , '0' , 'Company depends on the {0=servicecompanylocation {default} 1=contract scope 2=both}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_inspect_soon_days' , 'number' , '30' , 'Days margin for needs inspection ''soon''')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_occupationsensors_srtgroep_key' , 'number' , '-1' , 'INS_SRTGROEP_KEY of sensor objects to be used for occupation/availability')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_photo_size' , 'string' , 'r512x512' , 'Resize uploads to this maximum INS photo size. Ex: r200x150')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_xcp_active_cost' , 'number' , '15' , 'Active cost fields used/shown {+1=kosten, +2=kosten2, +4=kosten3, +8=materiaal}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_srtdeelsuggest_info' , 'number' , '1' , 'Show parent info of Object type in Suggest: 1=group, 2=discipline, 3=both')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_state_history' , 'number' , '30' , 'Number of days to keep ins_deel_state_history records')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_deel_flags' , 'number' , '0' , 'Number of flags that can be defined on objects. Max 10')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_nr_separator' , 'string' , '' , 'Separator between prefix and number for ranges of objectcodes that are numbered automatically')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_related_diagram_depth_min' , 'number' , '1' , 'The related objects diagram shows objects of this many levels back')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'ins_related_diagram_depth_max' , 'number' , '2' , 'The related objects diagram shows objects of this many levels forward')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'mjb_freeze_year' , 'number' , '2023' , 'Frozen (approved/activated) year of Preventive Maintenance (MJOB)')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'mjb_inflation' , 'float' , '0' , 'Default annual inflation rate (%) for Preventive Maintenance (MJOB)')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'mjb_operation_external' , 'number' , '0' , 'Operational handling of Preventive Maintenance (MJOB) tasks {0=internal | 1=external}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'mjb_show_years' , 'number' , '5' , 'Default number of years to be shown in the Preventive Maintenance (MJOB) console')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'mjb_start_year' , 'number' , '2023' , 'Start/First year of freezing of Preventive Maintenance (MJOB)')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'mjb_enable_moveup' , 'number' , '0' , 'Enable moveup of (MJOB) tasks {0=moveup disabled | 1=moveup enabled}')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'mjb_approvedmelding_description' , 'number' , '1' , 'Subject for MJOB generated ticket {1=object type (default), 2=task description, 3=task description (object type). }')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'mjb_total_add_pct1' , 'float' , '0' , 'Fixed percentage of column total to add #1 (0=None, <percentage>=percentage')
DEFINE_SETTING('INS', 0001, 'WEB_PRSSYS', 'mjb_total_add_pct2' , 'float' , '0' , 'Fixed percentage of column total to add #2 (0=None, <percentage>=percentage')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'cnt_autolink_regexp' , 'string' , '(?:((?:contract)\s+)([\w-/]*))', 'Automatically turn CNT-references in texts into clickable links eg. (?:((?:contract)\s+)([\w-/]*))')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'faq_autolink_regexp' , 'string' , '(?:(?:FAQ\s?)|(?:\WKB\s?))(\d+)', 'Automatically turn FAQ-references in texts into clickable links eg. (?:(?:FAQ\s?)|(?:KB\s?))(\d+) gives valid links for FAQ981, FAQ 981, KB981 and KB 981')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'fac_flags_visible_for_fe' , 'number' , '1' , 'An FE-user may see the flag-status of calls, reservations etc {0=No | 1=Yes(default)}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_accept_confirm' , 'boolean' , 'true' , 'bij accepteren melding direct afhandelingsveld in kunnen vullen')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'pda_melding_quick_note' , 'number' , '1' , 'Snelle notitie mogelijkheid bij het aanpassen van een melding binnen de mobile omgeving (0=geen quicknote mogelijk | 1=wel een quicknote mogelijk)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'pda_order_quick_note' , 'number' , '1' , 'Snelle notitie mogelijkheid bij het aanpassen van een opdracht binnen de mobile omgeving (0=geen quicknote mogelijk | 1=wel een quicknote mogelijk)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_add_mldopmerk_on_opdrclose' , 'number' , '0' , 'Automatically copy remark from order to call when supplier close last order {1=Yes | 0=No}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_afhandeling_required_for_close' , 'number' , '0' , 'Het veld afhandeling verplicht bij het afmelden van een melding (0=no, 1=yes)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_afhandeling_restrict_edit' , 'number' , '0' , 'Het veld afhandeling alleen in te vullen bij afmelden/afwijzen (0=no, 1=yes)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_afmelden_extern' , 'number' , '0' , 'Are external orders visible and/or changeble by ORDBO2 (0=not visible | 1=visible for ORDBO2 | 2=visible and changeble by ORDBO2)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_afmelden_popup_for_all_km' , 'number' , '0' , 'Toon afmeldkenmerken in het opdracht-afmeld-scherm (0=Alleen ontbrekende verplichte kenmerken | 1=Ja, allemaal')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_afrond_canflex' , 'boolean' , 'false' , 'Change flex of completed issue with MLDAFR ')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_afrond_canremark' , 'boolean' , 'false' , 'Change remark of completed issue with MLDAFR ')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_allow_for_others' , 'number' , '0' , 'Can i make calls for others ? {0=no | 1=yes | 2=yes, initial empty}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_allow_parentmelding' , 'number' , '0' , 'Allow attaching a call to another manually (0=not | 1=allow without orders | 2=allow with closed orders')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_archive_by_gui' , 'boolean' , 'false' , 'Can a call be archived by a button (true) or just by export (false)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_archive_by_gui' , 'boolean' , 'false' , 'Can an order be archived by a button (true) or not (false)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_ask_for_orders' , 'boolean' , 'true' , 'ask for immediate order input after call entry { true | false }')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_assume_ok_days' , 'number' , '0' , 'Number of days after the call will be automatically closed, if no response is given')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_autolink_regexp' , 'string' , '(?:(?:melding [A-Z]*)|(?:[A-Z \,]+\#[A-Z]*))(\d+)', 'Automatically turn MLD-references in texts into clickable links eg. (?:(?:melding [A-Z]*)|(?:[A-Z\,\n]+\#[A-Z]*))(\d+)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_behandelteam_canclose' , 'number' , '1' , 'Close authorization depending on (0=discipline | 1=discipline en treatment team (default))')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_bo_sort_descending' , 'number' , '0' , 'Sort ordering of mld_melding for BO (0 = most urgent first | 1 = last made first | 2 = most recent activity first)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_can_change_prio_and_place_while_issued', 'boolean' , 'false' , 'Allow to change [prio] and [place] while issue is issued')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_can_reopen_call' , 'number' , '0' , 'Calls can be reopened {0=no(default), +1=Yes Issuer, +2=Yes FO/BO, +4=By WEB_MLDREO authorisation}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_clear_on_close' , 'number' , '0' , 'Clear when closing call (0=just close call | +1=reset attention, +2=reset Assigned to, +4=reset Back office groups, +8=reset Processor)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_close_noti_default_off' , 'number' , '0' , 'Checkbox [melder notificeren] at cancel is default off (0=no interference, 1=default off)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_close_opdr_default' , 'number' , '0' , 'De checkbox met de vraag of de open opdrachten ook afgemeld moeten worden is standaard niet(0=default) of wel(1) aangevinkt')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_close_ctr_default' , 'number' , '0' , 'De checkbox met de vraag of de open inspecties ook afgemeld moeten worden is standaard niet(0=default) of wel(1) aangevinkt')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_continue_edit_issuer' , 'boolean' , 'false' , '[DEPRECATED] Edit the issuer false= (default) of a continued complain')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_copy_objects_in_workflow' , 'number' , '0' , 'Copy object-references to the next step in workflow (0=do not copy | 1=copy)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_disable_continuation' , 'boolean' , 'false' , 'Disable creating continuation calls { false | true }')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_layout' , 'array' , 'A,B,C,D,E,F,G,H,I,J,K' , 'De volgorde van de blokken in het meldingen scherm' || CHR(10) || 'A: Aanvrager' || CHR(10) || 'B: Categorie' || CHR(10) || 'C: Plaats' || CHR(10) || 'D: Afleveradres' || CHR(10) || 'E: Behandeling' || CHR(10) || 'F: Actieve behandeling' || CHR(10) || 'G: Kennisbank' || CHR(10) || 'H: Heeft betrekking op' || CHR(10) || 'I: Aanvullende gegevens' || CHR(10) || 'J: Omschrijving' || CHR(10) || 'K: Afhandeling')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_afmeldtekst_compact_threshold' , 'number' , '10' , 'Threshold for compact view of closing texts into a single dropdown')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_enable_workflow' , 'number' , '1' , 'enable workflow in call handling {0=workflow disabled | 1=workflow enabled }')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_endate_ordbo2' , 'number' , '1' , 'Enddate can be editted by MLDORD/ORDBO2 {0=no | 1=yes (default)}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_enforce_orderdates' , 'number' , '0' , 'Enforce order start/ending dates to be within call start/ending dates')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_fe_show_statusnames' , 'number' , '1' , 'Show name to FE of the users who changed the status of a melding {0=no | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_first_close_orders' , 'number' , '0' , 'Eerst alle opdrachten afmelden voordat de melding afgemeld kan worden (0=nee(default) || 1=ja)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_fixdatums_marge' , 'number' , '7' , 'WEB_MLDMSU can fix invoer/afgemeld dates')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_fo_can_assign_team' , 'number' , '0' , 'Allow assignment of a new call to a treatment team by the frontoffice {0=no | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_fo_default_user' , 'boolean' , 'false' , 'Use current user as default caller, { true=user default | false=empty default }')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_fof_canFlexChange' , 'boolean' , 'false' , 'TODO is dit het dan? ***MLDFOF kan FE-flexkenmerken ook na acceptatie nog wijzigen***')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_forward_all' , 'number' , '1' , 'Forward a complain 0= to a complain with the same srtdiscipline 1= (default) to a complain for all srtdisciplines')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_forward_auto_fill' , 'number' , '0' , 'Use current discipline and call (and "assigned to") as defaults while forwarding. {0=no | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_forward_can_assign' , 'number' , '0' , 'Allow assignment to a specific handler-person while forwarding a call {0=no | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_forward_if_active' , 'number' , '0' , 'A melding can be forwarded until status accept (0) of until afgemeld (1).')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_forward_opm_flags' , 'number' , '0' , 'A note is required when forwarding a call {0=Optional (default) | 1=Required}.')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_hide_fe_tracking' , 'number' , '0' , '0=default, 1=hide all tracking for fe (might contain ''secrets'')')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_listagg_object_delimiter' , 'string' , 'comma' , 'Delimiter of objects in call-list {"comma" (default) | "newline"}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_listagg_object_count' , 'number' , '20' , 'Maximum number of objects to show in call-list {default=20}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_locked_expire' , 'number' , '30' , 'Minutes after which edit-lock automatically released')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_max_history' , 'number' , '0' , 'Show calls and orders not longer then mld_max_history days ago (FE/FO/BO) ((mld_max_history <= 0) : show all finished calls and orders (default))')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_max_kosten_extern' , 'float' , '9999999' , 'limit order amount to be entered by external handlers')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_actiecode' , 'number' , '0' , 'Use active backoffice/contractor flow {0=no default | 1=yes | 2=yes, but immutable through notes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_melding_autoprint' , 'number' , '0' , 'auto print melding form after insert by FO 2=unconditionally print complain | 1=print if ask_for_orders=0 | 0=no print')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_melding_oms_maxlen' , 'number' , '4000' , 'Maximum length of issue description')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_melding_close' , 'number' , '0' , 'Can close complain with orders in complain overview window without seeing complain details? {0=yes default | 1=no}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_melding_flags' , 'number' , '0' , 'Number of flags fo/bo can define on complaint. Max 10')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_melding_recent' , 'number' , '60' , 'Tijdsinterval voor de recente wijzigingen in minuten')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_mobile_place_handler' , 'number' , '1' , '1=always location to required level, 2=workplace level to required level')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_msu_can_stop_workflows' , 'boolean' , 'false' , 'mld_msu mag een nog actieve workflow afbreken')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_note_change_threshold' , 'number' , '30' , 'Minutes an author can change a note when it is no longer the last note')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_note_default_notifyFE' , 'number' , '0' , 'Default value for "<melder> hierover notificeren" and "Actie bij aanvrager <melder> laten" for notes {0=off(default) | 1=both on | 2=notificeren=on, actie=off}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_note_hidden_action2FE' , 'number' , '0' , 'Is setting action to FE allowed for hidden notes')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_note_sort_ascending' , 'number' , '1' , 'DEPRECATED: Sort (of time) ordering of melding notes for FO and BO {0 = descending | 1 = ascending }')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_notify_retract' , 'number' , '1' , 'Retract the MLDNEW notification on mld_accept, if still in queue {0=no|1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_notify_workflowsteps' , 'number' , '1' , 'Notify each workflowstep to caller {0=do not notify steps (blackbox) | 1=notify each step (whitebox)}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_num_prefix_mode' , 'number' , '0' , 'Prefix to issue numbers {0=default none, 1=costcentre/department')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_object_filled_in_alert' , 'number' , '1' , '{0=geen, 1=wel} alert tonen als er automatisch een object wordt ingevuld bij een melding.')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_omschrijving_restrict_edit' , 'number' , '0' , 'Het veld omschrijving alleen in te vullen als nog te accepteren (0=no, 1=yes)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_alt_kostensoort' , 'number' , '0' , 'Enable use of alternative cost category {0|1} default 0')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_approval_all' , 'number' , '0' , 'Goedkeuring opdracht vereist t.o.v. eerstvolgende limiet (=0 default) of t.o.v. totale kosten (in n keer)(=1)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_pessismistisch_hergoedkeuren' , 'number' , '0' , 'Hergoedkeuren als de opdrachtkosten boven de bestellimiet, of boven de goedkeuringsvrijstelling komen {1=ja | 0=alleen als beiden waar zijn}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_validate_by_substitute' , 'number' , '1' , 'Validate by substitute {0=no | 1=yes default}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_ask_mail_if_unknown' , 'number' , '0' , 'Workaround for sending order by e-mail to ''externe relatie'' if address unknown (0=disabled default | 1=enabled)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_close' , 'number' , '0' , 'Can close orders in order overview window without seeing order details? {0=yes default | 1=no}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_ignore_caller_profile' , 'number' , '0' , 'Ignore profile of caller in approving process {0=No (default) | 1=Yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_kpg_fin_limit2' , 'number' , '100000' , 'De tweede kpg limiet van het opdracht fiattering mechanisme')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_kpg_fin_limit1' , 'number' , '15000' , 'De eerste kpg limiet van het opdracht fiattering mechanisme')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_pref_contractors_only' , 'number' , '0' , 'Show only preferred contractors (=1), all contractors (=0), or all contractors only for offers (=2)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_refiat_preference' , 'number' , '0' , 'Bij herfiattering opnieuw fiatteren {0=(default) fiatteur moet opnieuw fiatteren, 1=goedkeurder kan aangeven of dat moet}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_reapproval_rate' , 'float' , '-1' , 'Re-approval rate (%) {-1 = based on profile-limit (default) | >=0 }')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_sel_intern_uitv' , 'number' , '0' , 'Internal contractors can be selected for all services {0=no (default) | 1=Yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_show_requestor_in_list' , 'number' , '1' , 'Show requestor (melder) column in opdr search list {0=no | 1=print only | 2=view only | 3=both}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_costs_readonly_after_rfc' , 'number' , '0' , 'Cost fields of follow-up orders become readonly for suppliers when issued {0=no (default) | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_note_default_notifyBO' , 'number' , '0' , 'Default value for "Behandelaar hierover notificeren" for order-notes {0=off(default) | &1; on | &2; immutable & hidden}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdracht_flags' , 'number' , '0' , 'Number of flags fo/bo can define for orders. Max 10')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdracht_recent' , 'number' , '60' , 'Tijdsinterval voor de recente opdracht wijzigingen in minuten')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_ord_afmeld_future' , 'number' , '1' , 'Opdracht einddatum niet controleren bij afmelden {0=opdracht einddatum mag niet in de toekomst liggen, 1=default niets controleren)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_ord_bo_sort_descending' , 'number' , '0' , 'Sort ordering of mld_opdr for BO/B2 (0 = most urgent first | 1 = last made first );')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_ord_change_type' , 'number' , '1' , 'Can change opdr_type (0=no, 1=yes, 2=undefined)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_ord_flexsummary' , 'number' , '1' , 'User summary of melding-flexprop in initial order description {0=no | 1=yes | 2=by property}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_ord_show_kostenplaats' , 'number' , '1' , 'show kostenplaats field for orders {0=don''t show | 1=editable | 2=show}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_ord_show_ordernr' , 'number' , '0' , 'show ordernr field for orders {0=don''t show(&use mld_melding_ordernr) | 1=show}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_order_autoprint' , 'number' , '3' , 'When to autoprint orders {0=print new order for extern and intern | 1=print with any save | 2=print new order for extern | 3=never print}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_performer_can_change_flags' , 'boolean' , 'false' , 'Executor can change the flags of his orders.')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_pgb_fiattering' , 'number' , '0' , 'Voor een opdracht is het algemene fiatteringsproces noodzakelijk naast PGB/AGB fiatering? {0=no | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_photo_size' , 'string' , 'r512x512' , 'Resize uploads to this maximum MLD photo size. Ex: r200x150')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_plandate_in_list' , 'number' , '0' , '*Show Planned Date as a column in backoffice overview orders {0=no | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_print_loc_address' , 'number' , '0' , 'Show location address details in backoffice overview calls {0=no | 1=on print | 2=address+postal code+building} | 3=address+postal code+city')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_uses_requestor_location' , 'number' , '1' , 'Use the location of the requestor to overwrite the location of a new issue {0=no | 1=yes(default)}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_processing_group_all' , 'number' , '1' , 'Een behandelteam mag gekozen worden uit dezelfde srtdiscipline {0} of uit alle srtdiscipline {1=default})')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_reference_days' , 'number' , '100' , 'Het aantal dagen terug in de tijd van waaraf eigen referentie getoond dienen te worden')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_rejected_is_open' , 'number' , '0' , 'show rejected meldingen as Open FE/FO {1=Open | 0=Closed}.')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_restrict_mobile_to_me' , 'number' , '0' , 'For mobile, show calls within scope (0) or only list calls assigned to me (1) with scope')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_sel_single_closingtext' , 'number' , '1' , 'Auto select closing text when just one available {2=yes | 1=no (default)}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_selector_mode' , 'number' , '0' , 'Selector mode vakgroep/melding voor de frontend. {0(=default)=vakgroep en melding (beide eerst te kiezen), 1=vakgroep readonly, 2=alleen melding}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_show_cards' , 'number' , '5' , 'Number of order cards shown under a contractor in order plan board {nn=number | -1=all}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_bord_compact_threshold_columns' , 'number' , '6' , 'Number of columns after which the board will suppress empty columns {-1=never | 0=always | nn=number of columns}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_show_endtime' , 'number' , '1' , 'Show endtime for complaints (0=only date, 1=with endtime)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_show_parent_attachments' , 'boolean' , 'true' , 'Show the attachments of parent calls {true (default) | false}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_show_search_similar' , 'number' , '0' , 'Show a link to similar calls with call details {0=no | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_show_urgent_as_new' , 'boolean' , 'false' , 'Show urgent calls as new calls')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_show_workflowstep_as_followup' , 'boolean' , 'false' , 'Laat worflowstappen zien als vervolgmelding.')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_sla_indult_for_mldafr_only' , 'number' , '0' , 'Uitsluiten voor SLA alleen beschikbaar voor MLDAFR (afronden) {0=no | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_negatief_respijt' , 'number' , '0' , 'Sta negatieve respijt toe {0=no | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_suppress_directklaar_notification' , 'number' , '0' , 'Suppress de notificatie bij DirectKlaar {0=no (default) | 1=yes}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_typeopdr_key' , 'number' , '5' , 'Default order type or -1 to select default (at order-creation) from most to least specific per vakgroep')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_uren_more' , 'boolean' , 'true' , 'Access to other orders with hour registration {true=show link | false=do not show link}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_uren_omschrijving' , 'number' , '1' , 'Description to show with hour registration {1=melder | 2=vakgroep/stdmelding | 3=opdrachtomschrijving | 4=opdrachttype-melder}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_uren_weeks_back' , 'number' , '8' , 'Show this number of weeks in the overview, ending at the selected date')
DEFINE_SETTING('MLD', 0000, 'WEB_PRSSYS', 'mld_use_department' , 'number' , '0' , 'MLD also registers a department. You can see MLD of your department scope and below (0=don''t use | 1=use)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_use_order_approval' , 'number' , '0' , 'Approval (costcentre/fiattering) mechanism is used for mld orders (0=disabled | 1=enabled)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_use_plandate2' , 'number' , '0' , '*Allow use of planned end date {0=no | 1=only show in list | 2=yes, but don''t show in list | 3=yes and show in list}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_ord_edit_plandates' , 'number' , '1' , 'Edit plandates { 1=in order (default), 2=with buttons, 3=both }')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_workflow_set_defaults' , 'number' , '0' , 'Set defaults for flexkenmerken if they weren''t set by the predecessor (0=do not set | 1=set defaults)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_workflowstep_in_xml' , 'number' , '0' , 'Include all data of all other workflowsteps in XML for prints of a call from a workflow (0=no | 1=yes)')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'nightly_mld2bo_emailaddress' , 'string' , '' , 'Notification email address outside office hours')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'show_perslidselector_by_mail' , 'number' , '1' , 'Show person selector at sending mail {1=true | 0=false}')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_copy_order_attachment_from_call' , 'boolean' , 'true' , 'On new order, copy attachments from the call by default')
DEFINE_SETTING('MLD', 0001, 'WEB_PRSSYS', 'mld_opdr_hours_approve_monthly' , 'boolean' , 'false' , 'Approve houres within month (false=whole weeks only (default) | true=within month)')
DEFINE_SETTING('MRK', 0001, 'WEB_PRSSYS', 'mrk_message_expire_days' , 'number' , '30' , 'Message automatically expires after ')
DEFINE_SETTING('MRK', 0001, 'WEB_PRSSYS', 'mrk_photo_size' , 'string' , 'r512x512' , 'Resize uploads to this maximum MRK photo size. Ex: r200x150')
DEFINE_SETTING('PDA', 0001, 'WEB_PRSSYS', 'pda_list_show_filter_from' , 'number' , '7' , 'PDA result sets will include a filter from this many results on')
DEFINE_SETTING('PDA', 0001, 'WEB_PRSSYS', 'pda_phone_protocol' , 'string' , 'tel' , 'Mobile protocol to use for phone links')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'ph_bedr_search' , 'boolean' , 'true' , 'Provide search on Companies in phonebook (true|false)')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'ph_export_advanced' , 'boolean' , 'false' , 'do not show advanced export button')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'ph_loc_search' , 'boolean' , 'true' , 'Provide search on Locations in phonebook (true|false)')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'ph_placeFG' , 'number' , '0' , 'Show Graphics floorplan popup when click on place (0|1)')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'ph_rowdetails' , 'number' , '1' , 'Show phonebook details when click-on-row (0|1)')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'ph_showfunctie' , 'number' , '0' , 'Show function of a person in phonebook (0|1)')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'ph_showparentafdeling' , 'number' , '0' , 'Show parent department in phonebook (0|1)')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'phone_show_functie' , 'boolean' , 'true' , 'Provide search on Functions in phonebook (true|false)')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'prs_phonebook_info' , 'string' , '' , 'Message to be shown at the top of the phonebook')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'prs_phonebook_maxresults' , 'number' , '0' , 'Absolute maximum result lines for phonebook, disables Excel export')
DEFINE_SETTING('PHB', 0001, 'WEB_PRSSYS', 'prs_phonebook_audit_floor' , 'number' , '10' , 'Audit this phonebook request when more than ## results')
DEFINE_SETTING('PRJ', 0001, 'WEB_PRSSYS', 'prj_discipline_key' , 'number' , '-1' , 'mld_discipline_key of discipline for moves')
DEFINE_SETTING('PRJ', 0001, 'WEB_PRSSYS', 'prj_fg_paperColor' , 'number' , '16777215' , 'Backgroundcolor for scenario-floorplans {nn=color | -1=''as published''}')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_approvemethod' , 'number' , '1' , 'Approval tree: 1 = kp.budgethouder, kpngroep.verantwoordelijke, 2 = traverse up departments if kp.budgethouder undefined, 3=traverse up departments for budgethouder with adequate profile')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_bedrijf_leveranciernr_unique' , 'number' , '0' , 'leveranciernr or prs_bedrijf unique (1) or not unique (0)')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_collegas_used' , 'number' , '9' , 'Can FE users indicate collegues for replacement. Use value as autlevel scope: everything (-1) ... nothing (9=default)')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_default_kpn_empty' , 'number' , '0' , 'Costcentre always default empty {0=no | 1=yes}')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_dep_default_kpn' , 'number' , '5' , 'A user can make costs for his own department by default {0=no | 1=yes | 2=all departments of company | 4=personal | &8=only department cost centres | &16=only project cost centres | &32=only building cost centres }')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_dep_default_kpn_voor' , 'number' , '0' , 'Gebruik de kostenplaatsen van de prs_perslid_voor indien gezet samen met mld_allow_for_others/bes_allow_for_others')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_fof_show_belongings' , 'number' , '1' , '0=hide belongings, 1=show belongings')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_h' , 'float' , '0.25' , 'Employability time stepsize')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_hide_fixed_fields' , 'number' , '0' , 'Do not (1) display phonenumber/tarif fields with person details')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_mandaterequiresprofiel' , 'number' , '0' , 'Alleen personen met een profiel kunnen worden (onder)gemandateerd (1) of iedereen (0)')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_perslid_datums' , 'number' , '0' , 'show contract dates with perslid details {0=don''t show| 1=show}')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_restrict_kpedit' , 'number' , '0' , 'Wijzigen van de kostenplaats? {0=volgens autorisatie (default) | 1=alleen eigen kp/kpg wijzigen}')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_t1' , 'float' , '8' , 'Employability day start (hour)')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_t2' , 'float' , '18' , 'Employability day end (hour)')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_telefoonnr_aut_use' , 'number' , '0' , 'WEB_PRSUSE may change prs_perslid_telefoonnr {0=WEB_PRSMAN required | 1=WEB_PRSUSE allowed too}')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_use_edit_photo' , 'number' , '0' , 'enduser can upload own photo?')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_use_edit_werkplek' , 'number' , '9' , 'enduser can change own location (9=no, 2=within location, 3=within building etc.)')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'pda_prefer_current_werkplek' , 'number' , '1' , 'Use enduser own location as preferred default on mobile { 0=No | 1=Yes (default) }')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_use_mld_wijzigkey' , 'number' , '-1' , 'enduser can create this ''melding'' to request change in information')
DEFINE_SETTING('PRS', 0001, 'WEB_PRSSYS', 'prs_wpprefix_objectid' , 'number' , '0' , 'Workplace description as prefix in front of object id (at calls and contractscope) {0=no | 1=yes}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_lookhistory_days' , 'number' , '29' , 'Days to look back to sort DESC on reservations per room. 0= no sort on historic reservations.')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_is_closed_after_days' , 'number' , '0' , 'Days after which a reservation is considered closed')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_release_equipment_on_close' , 'number' , '0' , 'Propose to release reserved equipment when closing a reservation prematurely {0=no | 1=yes}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'fac_xml_max_factuur' , 'number' , '500' , 'Maximum number of lines for invoice in sales-invoice node')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_247organisation' , 'number' , '0' , '24/7 organisation (0= weekends are holidays | 1= weekends are working days | 2= weekends are holidays STRICT)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_allow_for_others' , 'number' , '1' , 'Can I make reservations for others ? {0=no | 1=yes}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_allow_multi_cat' , 'boolean' , 'false' , 'Can catering be done on multi day reservation {false | true}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_allow_undelete' , 'boolean' , 'false' , 'Deleted reservations can be undeleted {false | true}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_appointment_action' , 'boolean' , 'false' , 'Visitor action at reservation available')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_approval' , 'number' , '0' , 'Reserveringsgoedkeuring door aanvrager {0=Uit (default) | 1=Na afloop | 2=Na Afmelden}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_bez_desk_refresh' , 'number' , '180' , 'Seconds for autorefresh res_bez_desk.asp')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_block' , 'float' , '1' , 'Minimal reservation duration (hours)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_bo_show_host' , 'number' , '1' , 'Show host column in res bo list (0=no show | 1=show)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_bo_show_kpn' , 'number' , '1' , 'Show account number column in res bo list (0=no show | 1=show)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_bo_show_telnr' , 'number' , '1' , 'Show telephonenumber column in res bo list (0=no show | 1=show)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_bo_status_key' , 'number' , '5' , 'DEPRECATED Status of reservations to be considered as Closed')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_cat_reject_stdmld' , 'number' , -1 , 'Standard call key when rejecting catering')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_cat_t1' , 'float' , '-1' , 'Catering day start (hour), -1 is take res_t1')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_cat_t2' , 'float' , '-1' , 'Catering day end (hour), -1 is take res_t2')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_cat_with_expired_room' , 'boolean' , 'false' , 'Can catering be edited when room is expired {false | true}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_copy_all_time_frame' , 'number' , '0' , 'Can copy full reservation when all reservation parts within this number of days')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_copy_to_bez' , 'number' , '3' , 'Duplicate properties to visitors {0=none | 1=remark | 2=flex | 3=remark and flex | &4=at all changes}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_copy_flag' , 'number' , '1' , 'Copy status flag from current reservation {0=No | 1=Yes (default)}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_default_CVAB_mode' , 'number' , '1' , '0 (00)=Te kiezen&default Afhalen, 1 (01)=Te kiezen, default Bezorgen (default), 2 (10)=Vast &default Afhalen 3 (11)=Vast, default Bezorgen')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_default_alg_ruimte_key' , 'number' , '-1' , 'Standard roomkey for catering')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_default_fe_status_key' , 'number' , '2' , '(5i)Default reservation status for FE (1=optie, 2=definitief)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_default_fo_status_key' , 'number' , '2' , 'Default reservation status for FO (1=optie, 2=definitief)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_delete_ask_kosten' , 'number' , '1' , 'Aks for recharge costs at delete (0=never ask, 1=ask after, 2=ask only final, 3=ask only final after)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_delete_charge_perc' , 'array' , '' , 'Aks for charge costs percentage at delete (array of integer values)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_descript_required' , 'boolean' , 'false' , 'require description field for reservation')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_dur' , 'float' , '2' , 'initial reserving duration (hours)')
DEFINE_SETTING('RES', 0001, 'WEB_FACFAC', 'res_plantable_version' , 'number' , '2' , '2=use modern planning board for reservations (required css-grid support), 1=classic planboard')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_planbord_options' , 'number' , '0' , '0=default:show image and text; no tooltips, +1=no plantable image, +2=tooltip on mouse-over, +4=room description on mouse-over, +8=no text in plantable')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_forselect_options' , 'number' , '0' , 'for selecting rooms: 0=default:show image and text; no tooltips, +1=no plantable image, +2=tooltip on mouse-over, +4=room description on mouse-over, +8=no text in plantable')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_plantable_condensed_from' , 'number' , '3' , 'Number of days where plantable switches to condensed mode')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_fe_allow_dirty' , 'number' , '1' , '0=fe kan niets opslaan wat iets dirty zou maken, 1=het mag wel')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_fe_discs_only_in_res' , 'number' , '-1' , 'List of disciplines that can only be reserved in RES_ROOMS')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_fe_edit_option_only' , 'number' , '0' , 'FE can only edit ''Optional'' reservations (0=opties+definitieve (default) 1=alleen opties)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_fe_init_host_empty' , 'boolean' , 'false' , 'Define how FE reservation host is set initially { false=same as user/caller | true=empty }')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_fe_late_edit_vis' , 'number' , '0' , 'FE can edit visitors and (room-)configuration after the room expires {0=No (default) | 1=Yes}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_fe_list_days' , 'number' , '5' , 'Default number of days in FE overview')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_fe_reservering_limiet' , 'number' , '-1' , 'possible overrule of res_reservering_limiet for fe users')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_fo_catering_scopeless' , 'boolean' , 'false' , 'Ignore catering-scope for FO-users {true=yes | false=no (default)}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_fo_default_user' , 'boolean' , 'true' , 'Use current user as default contact/host, { true=user default | false=empty default }')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_fo_list_days' , 'number' , '0' , 'Default number of days in FO overview (working days)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_hide_tracking' , 'number' , '0' , 'Exclude from reservation tracking subtab; { 0=No one (default), +1=FE, +2=FO }')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_upwards_search_alg' , 'number' , '5' , 'Upwards search level allowed 1=all, 2=loc, 3=bld, 4=floor, 5=room')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_h' , 'float' , '0.5' , 'reservation interval (hours)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_hide_remark' , 'number' , '0' , 'Hide remark field in reservation screen ( 0=show | 1=hide | 2=hide only at add)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_max_flex_on_line' , 'number' , '0' , 'Max aantal flexkenmerken op een artikelregel')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_noshow_detailed' , 'number' , '1' , 'No-show is a checkbox (0) or a number (1)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_photo_size' , 'string' , 'r512x512' , 'Resize uploads to this maximum RES photo size. Ex: r200x150')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_pool_early' , 'number' , '30' , 'Minutes for early pool-visitors')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_pool_late' , 'number' , '30' , 'Minutes for late pool-visitors')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_rap_t1' , 'float' , '-1' , 'Occupation report day start (hour), -1 is take res_t1')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_rap_t2' , 'float' , '-1' , 'Occupation report day end (hour), -1 is take res_t2')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_reminder_noti_blocked' , 'boolean' , 'true' , 'Notification when reservation blocked {true=yes (default) | false=no}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_reservering_flags' , 'number' , '0' , 'Number of flags fo/bo can define on reservation. Max 10')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_reservering_limiet' , 'number' , '-1' , 'max number of days from now that reservations are allowed, in past or future {-1 = no limit}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_reservering_maxpast' , 'number' , '-1' , 'max number of days from now that reservations are allowed in the past {-1 = same as res_reservering_limiet (default) | >=0 }')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_reservering_recent' , 'number' , '60' , 'Tijdsinterval voor de recente reserverings wijzigingen in minuten')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_room_order' , 'number' , '0' , 'Planbord sorted by capacity or description (0=capacity (default) | 1=description)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_roompricingkorting' , 'number' , '0' , 'Show editable korting field (0=hide, +1=FO, +2=BO, +4=catering too)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_roompricingmethod' , 'number' , '1' , 'Method for room price calculation {1|2|3|n}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_roompricingtotaal' , 'number' , '0' , 'Show fixed totaal field (0=hide, +1=FO, +2=BO, +4=catering too)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_search_require_locatie' , 'number' , '0' , '(5i)Require selection of a location (for large users) for res_search or not (1=require | 0=dont require)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_show_alg_level' , 'string' , 'L' , 'Show alg res level ''L'' (location), ''G'' (building)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_strict_locfilter' , 'boolean' , 'false' , 'Do not show locations without catering. Can be extremely slow!')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_suppress_warnbo' , 'boolean' , 'false' , 'Suppress the warning popup lcl_res_warnBO {true=suppress | false=dont suppress (default)}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_t1' , 'float' , '8' , 'reservation day start (hour)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_t2' , 'float' , '18' , 'reservation day end (hour)')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_t_avond' , 'float' , '-1' , 'Start time for evening tarif for rooms (hour), -1 is one price over the day')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_t_middag' , 'float' , '-1' , 'Start time for afternoon tarif for rooms (hour), -1 is one price over the day')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_vcalendar_link' , 'number' , '1' , 'Download naar ''Outlook''')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_with_mld' , 'number' , '0' , 'Reservering kan meldingen hebben {0=Nee (default) | 1=Ja}')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_xml_max_rsv_ruimte' , 'number' , '60' , 'Maximum number of non-concise rsv_ruimte nodes in reserering node')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_planboard_inline_info' , 'boolean' , 'false' , 'Show reservation description in occupied ruler')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_pda_deel_times' , 'array' , '15,30,60,120,240' , 'Mobile poposed reservation times for objects')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_pda_room_times' , 'array' , '30,60,120' , 'Mobile proposed reservation times for rooms')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'res_adhoc_threshold' , 'number' , '10' , 'The amount of time (in minutes) before the end of a reservation before an adhoc reservation can be made')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'msgraph_sync_level' , 'number' , '0' , 'Level of synchronization (Sufficient rights required); { 0: No sync, +1: Facilitor reads from Exchange, +2: Facilitor writes only to Exchange rooms, +4: Facilitor writes to all Exchange users }')
DEFINE_SETTING('RES', 0001, 'WEB_PRSSYS', 'exchange_internal_email_regexp' , 'string' , '*' , 'Regular expression to match internal visitors by; internal visitors are not registered in Facilitor (All visitors are internal by default)')
DEFINE_SETTING('RES', 0001, 'WEB_FACTAB', 'exchange_max_concurrent_notifications' , 'number' , '50' , 'The maximum number of concurrent notifications in progress')
DEFINE_SETTING('SLE', 0001, 'WEB_PRSSYS', 'cil_ins_srt_groep_key' , 'number' , '-1' , 'INS_SRTDEEL_KEY of object type Cylinders')
DEFINE_SETTING('SLE', 0001, 'WEB_PRSSYS', 'sle_cil_koppelen' , 'number' , '1' , 'Sleutels en cilinders zijn door bo handmatig te koppelen {0=nee, 1=ja(default)}')
DEFINE_SETTING('SLE', 0001, 'WEB_PRSSYS', 'sle_ins_srt_groep_key' , 'number' , '-1' , 'INS_SRTDEEL_KEY of object type Keys')
---- Fac_Settings voor PutOrders --
DEFINE_SETTING('PUO', 0000, 'WEB_FACTAB', 'puo_pwd' , 'string' , '' , 'SMS provider user password')
DEFINE_SETTING('PUO', 0000, 'WEB_FACTAB', 'puo_sendpassword' , 'string' , '' , 'Password when puo_smtpauthenticate=cdoBasic')
DEFINE_SETTING('PUO', 0000, 'WEB_FACTAB', 'puo_uid' , 'string' , '' , 'SMS provider user id')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'bdradrfiles_path' , 'string' , NULL , 'Technische adressen bijlagen folder')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_apppushurl' , 'string' , '' , 'URL for pushing APP1 notifications')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_app2pushurl' , 'string' , 'https://fcm.googleapis.com/v1/projects/facilitor-165209/messages:send' , 'URL for pushing APP2 notifications')
DEFINE_SETTING('PUO', 0000, 'WEB_FACFAC', 'puo_app2secret' , 'string' , '#included in next line', 'Google JSONKey secret for APP2 notifications')
UPDATE tmp_set
SET fac_setting_default = '
#include "facilitor-165209-firebase-adminsdk-xts0z-042cb975b9.json"
' WHERE fac_setting_name = 'puo_app2secret';
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_bcc' , 'string' , '' , 'Blind copy email address for ORDERS only')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_cc' , 'string' , '' , 'Copy email address for ORDERS only')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_connectionflag' , 'number' , '0' , 'INTERNET_FLAG_PASSIVE = 0x8000000, else = 0')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_emergencymailaddress' , 'string' , '' , 'E-mail address for system notifications')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_failalert_threshold' , 'number' , '240' , 'Minimum minutes after first failed send-attempts before an alert is sent to the (PRSSYS) application manager(s)')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_faildelayincrement' , 'number' , '10' , 'Delay retry of failed orders up to failures*10 minutes')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_faildelaymax' , 'number' , '120' , 'Maximum delay of failed orders in minutes')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_failextralogging' , 'number' , '3' , 'At the 3rd failure logging is increased automatically once')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_faillimit' , 'number' , '336' , 'After this time (hours) stop trying failed orders')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_fclt_web_apikey' , 'string' , '' , 'Putorders APIKEY to the Facilitor software')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_fclt_web_url' , 'string' , '' , 'Url to the Facilitor software (webserver internal address)')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_flags' , 'number' , '255' , '+1=send notifications to people, +2=send orders to technical addresses')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_forceapppushtoken' , 'string' , '' , 'Force this pushtoken for test purposes')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_forcefromaddress' , 'string' , '' , 'Force the from and reply address for test purposes eg john@example.com')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_forcemailaddress' , 'string' , '' , 'Force this email address for test purposes eg john@example.com')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_forcemobile' , 'string' , '' , 'Force this mobile number for test purposes eg 31612345678')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_forcenotiaddress' , 'string' , '' , 'Force the notification adress for test purposes eg. "https://facilitordev.azurewebsites.net')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_forceorderaddress' , 'string' , '' , 'Force this order address for test purposes eg mailto://john@example.com')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_forceallowedgroep' , 'string' , '_TESTERS' , 'When mailto belongs to person in named authorisation group then dont force the mail address')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_fromaddress' , 'string' , '' , 'The fixed From address for Facilitor orders')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_logdestination' , 'number' , '1' , 'Where to log: 1=detailed file, 2=csv file, 3=both')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_loglevel' , 'number' , '1' , 'Level of logging (0-3) for troubleshooting purposes')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_schedule_putorders' , 'number' , '0' , 'Force putorders run at least every ## minutes even with empty queue (for pre_putorders)')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_mailbodycharset' , 'string' , 'unicode-1-1-utf-8' , 'Putorders e-mail charset')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_notificationinmailbody' , 'boolean' , 'true' , 'false = as attachments, true = in body (deprecated)')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_notificationxsl' , 'string' , '' , 'stylesheet to be applied for notifications')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_order_flexfiles' , 'number' , '0' , 'System default for attachments with orders as defined in the technical address (0=don''t send, 1=attach))')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_proxyserveripaddress' , 'string' , '127.0.0.1:8888' , 'Proxy Server IP Address, only used when UseProxy = true')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_receiptto' , 'string' , '' , 'Address to send the receipt confirmation to for ORDERS only')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_receivetimeout' , 'number' , '30' , 'Default receive timeout for http-communication. Increase for slow servers')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_replyaddress' , 'string' , '' , 'Optional reply address if that is different from FromAddress')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_replyphone' , 'string' , 'Facilitor' , 'Include country code')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_scheduled_delay' , 'number' , '15' , 'Minutes setting before scheduled putorders picks up failed immediate sending of orders')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_sendtimeout' , 'number' , '30' , 'Default send timeout for http-communication. Increase for large attachments')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_sendusername' , 'string' , '' , 'Username when puo_smtpauthenticate=cdoBasic')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_sendusing' , 'number' , '2' , '1=cdoSendUsingPickup (IIS SMTP Service must be installed), 2=cdoSendUsingPort')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_smsaccount' , 'string' , '' , 'SMS email address for protocol SMTP')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_smsprotocol' , 'string' , 'HTTP' , 'HTTP or SMTP(*)')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_smsprovider' , 'number' , '0' , '0=unused, 1=aareon.nl')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_smtpauthenticate' , 'number' , '0' , 'Authentication when sendusing cdoSendUsingPort 0=cdoAnonymous, 1=cdoBasic, 2=cdoNTLM')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_smtpconnectiontimeout' , 'number' , '30' , 'SMTP timeout in seconds (future use)')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_smtpserver' , 'string' , 'localhost' , 'Server when sendusing cdoSendUsingPort')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_smtpserverport' , 'number' , '25' , 'Serverport when sendusing cdoSendUsingPort')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_smtpusessl' , 'boolean' , 'false' , 'Use SSL when sending to port')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_system2systemxsl' , 'string' , 'xsl/system2system.xsl' , 'Stylesheet to be applied for system 2 system notifications')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_useproxy' , 'boolean' , 'false' , 'true = Use Proxy Server (recognizes TIS FTP gateway only), false = don''t use Proxy')
DEFINE_SETTING('PUO', 0001, 'WEB_FACTAB', 'puo_usesenderasreplyto' , 'boolean' , 'true' , 'If true mail-From is always forced to puo_fromaddress and mail-Reply will be the sender')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_lcl_friendly_file' , 'string' , 'Opdracht in bestand klaargezet' , 'Friendly text for file tracking')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_lcl_friendly_ftp' , 'string' , 'Opdracht per ftp gestuurd naar {0}' , 'Friendly text for ftp tracking, also port {1} folder {2}')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_lcl_friendly_sftp' , 'string' , 'Opdracht per sftp gestuurd naar {0}' , 'Friendly text for sftp tracking, also port {1} folder {2}')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_lcl_friendly_http' , 'string' , 'Opdracht per SOAP gestuurd naar {0}' , 'Friendly text for http tracking')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_lcl_friendly_mailto' , 'string' , 'Opdracht per e-mail gestuurd naar {0}' , 'Friendly text for mail tracking')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_lcl_tracknoti' , 'string' , 'Notificatie {0} verstuurd aan {1}' , 'Friendly text for notification mail tracking')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_lcl_tracknoti_sys' , 'string' , 'Notificatie {0} verstuurd naar {1}' , 'Friendly text for system tracking {0} is notification, {1} is company')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_lcl_tracknoti_sys_fail' , 'string' , ' (na {0} gefaalde poging(en))' , 'Friendly text for system tracking failing')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_subjectprefix' , 'string' , 'Facilitor bestelling: Bestelopdracht nr.' , 'Mail subject prefix for BES orders (to be followed by ordernr)')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_subjectprefixcnt' , 'string' , 'Facilitor contract nr.' , 'Mail subject prefix for CNT')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_subjectprefixres' , 'string' , 'Facilitor reservering nr.' , 'Mail subject prefix for RES')
DEFINE_SETTING('PUO', 0001, 'WEB_PRSSYS', 'puo_subjectprefixmld' , 'string' , 'Facilitor opdracht: Opdracht nr.' , 'Mail subject prefix for MLD orders')
DEFINE_SETTING('PUO', 0000, 'WEB_FACFAC', 'puo_chilkat_secret' , 'string' , 'AAREON.CB1062021_zK6SGtth69oK' , 'Facilitor Chilkat licence')
// Alles als een enorme BEGIN/END is over het netwerk immens sneller
END;
/
WHENEVER SQLERROR CONTINUE;
// Vervallen settings opruimen
SELECT 'Dropping old setting ' || fac_setting_name
FROM fac_setting
WHERE fac_setting_name NOT IN
(SELECT fac_setting_name FROM tmp_set);
DELETE FROM fac_setting
WHERE fac_setting_name NOT IN
(SELECT fac_setting_name FROM tmp_set);
COMMIT;
// Gewijzigde settings bijwerken
UPDATE fac_setting fs
SET (fac_setting_module,
fac_setting_flags,
fac_functie_key,
fac_setting_type,
fac_setting_default,
fac_setting_description,
fac_setting_comment
) =
(SELECT fac_setting_module,
fac_setting_flags,
fac_functie_key,
fac_setting_type,
fac_setting_default,
fac_setting_description,
fac_setting_comment
FROM tmp_set
WHERE fs.fac_setting_name = tmp_set.fac_setting_name)
WHERE fs.fac_setting_name IN (SELECT fac_setting_name FROM tmp_set);
COMMIT;
// Nieuwe settings toevoegen
INSERT INTO fac_setting (fac_setting_module,
fac_setting_flags,
fac_functie_key,
fac_setting_name,
fac_setting_type,
fac_setting_default,
fac_setting_description,
fac_setting_comment)
SELECT fac_setting_module,
fac_setting_flags,
fac_functie_key,
fac_setting_name,
fac_setting_type,
fac_setting_default,
fac_setting_description,
fac_setting_comment
FROM tmp_set
WHERE tmp_set.fac_setting_name NOT IN
(SELECT fac_setting_name
FROM fac_setting);
COMMIT;
TRUNCATE TABLE tmp_set;
DROP TABLE tmp_set PURGE;
REGISTERONCE('$Id$')