{"id":6,"date":"2026-04-11T12:55:40","date_gmt":"2026-04-11T12:55:40","guid":{"rendered":"https:\/\/data.delocht.nl\/?page_id=6"},"modified":"2026-04-20T21:04:56","modified_gmt":"2026-04-20T21:04:56","slug":"kassa","status":"publish","type":"page","link":"https:\/\/data.delocht.nl\/?page_id=6","title":{"rendered":"Kassa"},"content":{"rendered":"\n\t\t\t<div class=\"wpda-pp-container\">\n\t\t\t\t<div\n\t\t\t\t\tclass=\"pp-container-app \"\n\t\t\t\t\tdata-source=\"{ 'id': '6' }\"\n\n\t\t\t\t\t\t\t\t\t><\/div>\n\t\t\t<\/div>\n\n                            <script>\n                                                window.pp_app_6 = {\n                                metadata: {\"app\":{\"app\":[{\"app_id\":\"6\",\"app_name\":\"winkel_boekingen\",\"app_title\":\"winkel_boekingen\",\"app_type\":\"0\",\"app_settings\":\"{\\\"rest_api\\\":{\\\"authorization\\\":\\\"anonymous\\\",\\\"authorized_roles\\\":[],\\\"authorized_users\\\":[]},\\\"settings\\\":{\\\"app_menu_title\\\":\\\"\\\",\\\"app_language\\\":\\\"nl\\\",\\\"app_fullscreen\\\":true,\\\"app_safe_mode\\\":false,\\\"app_title_tag\\\":\\\"h6\\\",\\\"app_server_calls\\\":[]}}\",\"app_theme\":null,\"app_add_to_menu\":\"0\"}],\"container\":[{\"cnt_id\":\"7\",\"cnt_cls\":\"[{\\\"columnName\\\":\\\"order_id\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"order_item_id\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"product_id\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"customer_name\\\",\\\"isSelected\\\":false},{\\\"columnName\\\":\\\"customer_last_name\\\",\\\"isSelected\\\":false},{\\\"columnName\\\":\\\"customer_postcode\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"customer_billing_email\\\",\\\"isSelected\\\":false},{\\\"columnName\\\":\\\"BookingStatus\\\",\\\"isSelected\\\":false},{\\\"columnName\\\":\\\"BookFrom\\\",\\\"isSelected\\\":false},{\\\"columnName\\\":\\\"BookTo\\\",\\\"isSelected\\\":false},{\\\"columnName\\\":\\\"IntervalDetails\\\",\\\"isSelected\\\":false},{\\\"columnName\\\":\\\"no_of_persons\\\",\\\"isSelected\\\":true}]\",\"cnt_title\":\"winkel_boekingen\",\"app_id\":\"6\",\"cnt_seq_nr\":\"0\",\"cnt_table\":\"{\\\"columns\\\":[],\\\"table\\\":{\\\"largeTableSupport\\\":{\\\"saved\\\":2,\\\"actual\\\":1,\\\"useHardEstimate\\\":false},\\\"clientSideProcessing\\\":false,\\\"processing\\\":0,\\\"pagination\\\":{\\\"position\\\":\\\"bottom\\\",\\\"defaultPageSize\\\":10,\\\"rowsPerPage\\\":[5,10,15,20,25,30,50,100],\\\"showFirstButton\\\":true,\\\"showLastButton\\\":true,\\\"showCompactButtons\\\":true},\\\"locale\\\":\\\"en-US\\\",\\\"design\\\":{\\\"overflow\\\":\\\"responsive\\\",\\\"density\\\":{\\\"default\\\":\\\"spacious\\\",\\\"userCanChange\\\":true},\\\"layout\\\":\\\"fixed\\\"},\\\"viewLink\\\":true,\\\"detailLink\\\":false,\\\"detailColumnsVisible\\\":{\\\"small\\\":1,\\\"medium\\\":1,\\\"large\\\":2},\\\"detailColumnSpacing\\\":{\\\"width\\\":0.25,\\\"unit\\\":\\\"rem\\\"},\\\"detailExpandAll\\\":false,\\\"hideExpandIcons\\\":false,\\\"expandIconPosition\\\":\\\"right\\\",\\\"tableDisplayMode\\\":false,\\\"detailPdf\\\":false,\\\"transactions\\\":{\\\"insert\\\":false,\\\"update\\\":false,\\\"delete\\\":false},\\\"formModal\\\":false,\\\"modal\\\":{},\\\"searchSettings\\\":{\\\"enableGlobalSearch\\\":true,\\\"showGlobalSearchOnStartup\\\":false,\\\"globalSearchAlwaysOpen\\\":false,\\\"forceSearch\\\":false,\\\"forceInline\\\":false,\\\"highlightMatches\\\":true,\\\"searchForm\\\":true,\\\"searchFormPosition\\\":0,\\\"searchFormTitleVisible\\\":true,\\\"searchFormCompact\\\":false,\\\"searchFormCompactExpand\\\":true,\\\"searchFormAlwaysOpen\\\":false,\\\"searchFormWidth\\\":340,\\\"searchFormWidthUnit\\\":\\\"px\\\",\\\"searchFormIcon\\\":\\\"default\\\",\\\"cascade\\\":false,\\\"saveFilters\\\":false},\\\"inlineEditing\\\":{\\\"fieldVariant\\\":\\\"outlined\\\",\\\"spacing\\\":{\\\"fieldTop\\\":8,\\\"fieldTopUnit\\\":\\\"px\\\",\\\"fieldBottom\\\":8,\\\"fieldBottomUnit\\\":\\\"px\\\",\\\"fieldLeft\\\":8,\\\"fieldLeftUnit\\\":\\\"px\\\",\\\"fieldRight\\\":8,\\\"fieldRightUnit\\\":\\\"px\\\"},\\\"addColumnButton\\\":false},\\\"bulkActions\\\":{\\\"pdf\\\":true,\\\"csv\\\":true,\\\"json\\\":true,\\\"excel\\\":true,\\\"xml\\\":true,\\\"sql\\\":false,\\\"delete\\\":false},\\\"defaultWhere\\\":\\\"\\\",\\\"defaultOrderBy\\\":[],\\\"tableCode\\\":{},\\\"globalCode\\\":{},\\\"enableColumnHiding\\\":false,\\\"enableColumnOrdering\\\":false,\\\"showHeader\\\":true,\\\"stickyHeader\\\":false,\\\"showFooter\\\":false,\\\"stickyFooter\\\":false,\\\"charts\\\":{\\\"enabled\\\":false,\\\"interactive\\\":false},\\\"maps\\\":{\\\"enabled\\\":false,\\\"apiKey\\\":\\\"\\\",\\\"columnLatitude\\\":\\\"\\\",\\\"columnLongitude\\\":\\\"\\\",\\\"docked\\\":\\\"undocked\\\"},\\\"docking\\\":\\\"beside\\\",\\\"dockFirst\\\":\\\"map\\\",\\\"css\\\":\\\"\\\",\\\"disableToken\\\":false},\\\"state\\\":{\\\"exploring\\\":false,\\\"fullScreen\\\":false,\\\"isUpdated\\\":false,\\\"sortedColumns\\\":[],\\\"computedFieldIndex\\\":-1,\\\"data\\\":{},\\\"showColumnFilters\\\":false,\\\"reloadLookupList\\\":[],\\\"inlineEditingErrors\\\":[],\\\"isRowCountUpdated\\\":false,\\\"permissions\\\":{},\\\"rowColor\\\":{},\\\"rowBgColor\\\":{},\\\"columnColor\\\":{},\\\"columnBgColor\\\":{}}}\",\"cnt_form\":null,\"cnt_rform\":null,\"cnt_relation\":null,\"cnt_chart\":null,\"cnt_map\":null,\"cnt_query\":null,\"cnt_dashboard\":null}],\"apps\":[]},\"columns\":[{\"column_name\":\"order_id\",\"data_type\":\"bigint\",\"extra\":\"\",\"column_type\":\"bigint(20) unsigned\",\"is_nullable\":\"NO\",\"column_default\":null,\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"20\"},{\"column_name\":\"order_item_id\",\"data_type\":\"bigint\",\"extra\":\"\",\"column_type\":\"bigint(20) unsigned\",\"is_nullable\":\"NO\",\"column_default\":\"0\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"20\"},{\"column_name\":\"product_id\",\"data_type\":\"bigint\",\"extra\":\"\",\"column_type\":\"bigint(20) unsigned\",\"is_nullable\":\"NO\",\"column_default\":\"0\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"20\"},{\"column_name\":\"product_name\",\"data_type\":\"text\",\"extra\":\"\",\"column_type\":\"text\",\"is_nullable\":\"NO\",\"column_default\":null,\"character_maximum_length\":\"65535\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"customer_name\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"customer_last_name\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"customer_postcode\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"customer_billing_email\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"Status\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"Datum_tijd\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"IntervalDetails\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"Interval\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"no_of_persons\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null}],\"columns_sorted\":{\"order_id\":{\"column_name\":\"order_id\",\"data_type\":\"bigint\",\"extra\":\"\",\"column_type\":\"bigint(20) unsigned\",\"is_nullable\":\"NO\",\"column_default\":null,\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"20\"},\"order_item_id\":{\"column_name\":\"order_item_id\",\"data_type\":\"bigint\",\"extra\":\"\",\"column_type\":\"bigint(20) unsigned\",\"is_nullable\":\"NO\",\"column_default\":\"0\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"20\"},\"product_id\":{\"column_name\":\"product_id\",\"data_type\":\"bigint\",\"extra\":\"\",\"column_type\":\"bigint(20) unsigned\",\"is_nullable\":\"NO\",\"column_default\":\"0\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"20\"},\"product_name\":{\"column_name\":\"product_name\",\"data_type\":\"text\",\"extra\":\"\",\"column_type\":\"text\",\"is_nullable\":\"NO\",\"column_default\":null,\"character_maximum_length\":\"65535\",\"numeric_scale\":null,\"numeric_precision\":null},\"customer_name\":{\"column_name\":\"customer_name\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},\"customer_last_name\":{\"column_name\":\"customer_last_name\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},\"customer_postcode\":{\"column_name\":\"customer_postcode\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},\"customer_billing_email\":{\"column_name\":\"customer_billing_email\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},\"Status\":{\"column_name\":\"Status\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},\"Datum_tijd\":{\"column_name\":\"Datum_tijd\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},\"IntervalDetails\":{\"column_name\":\"IntervalDetails\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},\"Interval\":{\"column_name\":\"Interval\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null},\"no_of_persons\":{\"column_name\":\"no_of_persons\",\"data_type\":\"longtext\",\"extra\":\"\",\"column_type\":\"longtext\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"4294967295\",\"numeric_scale\":null,\"numeric_precision\":null}},\"table_labels\":{\"order_id\":\"Order Id\",\"order_item_id\":\"Order Item Id\",\"product_id\":\"Product Id\",\"product_name\":\"Product Name\",\"customer_name\":\"Customer Name\",\"customer_last_name\":\"Customer Last Name\",\"customer_postcode\":\"Customer Postcode\",\"customer_billing_email\":\"Customer Billing Email\",\"Status\":\"Status\",\"Datum_tijd\":\"Datum Tijd\",\"IntervalDetails\":\"IntervalDetails\",\"Interval\":\"Interval\",\"no_of_persons\":\"No Of Persons\"},\"form_labels\":{\"order_id\":\"Order Id\",\"order_item_id\":\"Order Item Id\",\"product_id\":\"Product Id\",\"product_name\":\"Product Name\",\"customer_name\":\"Customer Name\",\"customer_last_name\":\"Customer Last Name\",\"customer_postcode\":\"Customer Postcode\",\"customer_billing_email\":\"Customer Billing Email\",\"Status\":\"Status\",\"Datum_tijd\":\"Datum Tijd\",\"IntervalDetails\":\"IntervalDetails\",\"Interval\":\"Interval\",\"no_of_persons\":\"No Of Persons\"},\"primary_key\":[],\"access\":{\"select\":[],\"insert\":[],\"update\":[],\"delete\":[]},\"settings\":{\"env\":{\"ip\":\"216.73.217.73\",\"id\":0,\"user\":\"anonymous\",\"roles\":false,\"login\":false},\"wp\":{\"roles\":{\"administrator\":\"Administrator\",\"editor\":\"Editor\",\"author\":\"Author\",\"contributor\":\"Contributor\",\"subscriber\":\"Subscriber\"},\"users\":{\"Roel Baas\":\"Roel Baas\",\"website_24pyxfvi\":\"admin\"},\"home\":\"https:\\\/\\\/data.delocht.nl\\\/wp-admin\\\/admin.php\",\"tables\":[\"data_users\",\"data_usermeta\",\"data_posts\",\"data_comments\",\"data_links\",\"data_options\",\"data_postmeta\",\"data_terms\",\"data_term_taxonomy\",\"data_term_relationships\",\"data_termmeta\",\"data_commentmeta\"],\"date_format\":\"F j, Y\",\"time_format\":\"g:i a\",\"scroll_offset\":\"120\"}},\"media\":[],\"wp_media\":{\"order_id\":false,\"order_item_id\":false,\"product_id\":false,\"product_name\":false,\"customer_name\":false,\"customer_last_name\":false,\"customer_postcode\":false,\"customer_billing_email\":false,\"Status\":false,\"Datum_tijd\":false,\"IntervalDetails\":false,\"Interval\":false,\"no_of_persons\":false},\"table_info\":{\"type\":\"VIEW\",\"engine\":null,\"count\":\"1\"}}                            }\n                                            <\/script>\n                \n\t\t\t\n\t\t\t<script>\n                if (! window.PP_APP_CONFIG) {\n                    window.PP_APP_CONFIG = {\n                        appDebug: false,\n                        appLocales: \"https:\/\/data.delocht.nl\/wp-content\/plugins\/wp-data-access-premium\/WPDataAccess\/..\/assets\/premium\/dist\/locales\/\",\n                        appSite: {\"id\":\"19871525\",\"updated\":\"2026-04-25 12:06:02\",\"created\":\"2026-04-11 12:24:14\",\"site_id\":\"281102302\",\"blog_id\":null,\"plugin_id\":\"6189\",\"user_id\":\"5139097\",\"title\":\"My Website\",\"url\":\"https:\\\/\\\/data.delocht.nl\",\"version\":\"5.5.71\",\"language\":\"nl-NL\",\"platform_version\":\"6.9.4\",\"sdk_version\":\"2.13.1\",\"programming_language_version\":\"8.3.30\",\"plan_id\":\"10111\",\"license_id\":null,\"trial_plan_id\":\"10588\",\"trial_ends\":\"2026-04-25 12:05:02\",\"is_premium\":true,\"is_disconnected\":false,\"is_active\":true,\"is_uninstalled\":false,\"is_beta\":false},\n                        appLicenses: {\"license\":[],\"local\":false},\n                        appTarget: \"frontend\",\n                        appIp: \"216.73.217.73\",\n                        appUser: \"anonymous\",\n                        appRoles: false,\n                        appLogin: false,\n                        appVars: [],\n                    }\n                }\n                                        window.PP_APP_CONFIG[6] = {\n                            appRoles: false,\n                            appFullscreen: false,\n                            hideTitleBar: false,\n                        }\n                        \t\t\t<\/script>\n\t\t\t<script type=\"module\" src=\"https:\/\/data.delocht.nl\/wp-content\/plugins\/wp-data-access-premium\/WPDataAccess\/..\/assets\/premium\/dist\/app-1.0.69.js\"><\/script>\n\n\t\t\t\n\n\n\n\t\t\t<div class=\"wpda-pp-container\">\n\t\t\t\t<div\n\t\t\t\t\tclass=\"pp-container-app \"\n\t\t\t\t\tdata-source=\"{ 'id': '1' }\"\n\n\t\t\t\t\t\t\t\t\t><\/div>\n\t\t\t<\/div>\n\n                            <script>\n                                                window.pp_app_1 = {\n                                metadata: {\"app\":{\"app\":[{\"app_id\":\"1\",\"app_name\":\"Kassa\",\"app_title\":\"Kassa Omzet per dag\",\"app_type\":\"0\",\"app_settings\":\"{\\\"rest_api\\\":{\\\"authorization\\\":\\\"anonymous\\\",\\\"authorized_roles\\\":[\\\"administrator\\\"],\\\"authorized_users\\\":[]},\\\"settings\\\":{\\\"app_menu_title\\\":\\\"\\\",\\\"app_language\\\":\\\"nl\\\",\\\"app_fullscreen\\\":true,\\\"app_safe_mode\\\":false,\\\"app_title_tag\\\":\\\"h6\\\",\\\"app_server_calls\\\":[]}}\",\"app_theme\":\"{\\\"inheritFontFamily\\\":true,\\\"fontFamily\\\":[\\\"inherit\\\"],\\\"customFontFamily\\\":\\\"\\\",\\\"mode\\\":\\\"light\\\",\\\"color\\\":{\\\"50\\\":\\\"#fafafa\\\",\\\"100\\\":\\\"#f5f5f5\\\",\\\"200\\\":\\\"#eeeeee\\\",\\\"300\\\":\\\"#e0e0e0\\\",\\\"400\\\":\\\"#bdbdbd\\\",\\\"500\\\":\\\"#9e9e9e\\\",\\\"600\\\":\\\"#757575\\\",\\\"700\\\":\\\"#616161\\\",\\\"800\\\":\\\"#424242\\\",\\\"900\\\":\\\"#212121\\\",\\\"A100\\\":\\\"#f5f5f5\\\",\\\"A200\\\":\\\"#eeeeee\\\",\\\"A400\\\":\\\"#bdbdbd\\\",\\\"A700\\\":\\\"#616161\\\"},\\\"colorLabel\\\":\\\"grey\\\",\\\"shade\\\":\\\"900\\\",\\\"borderRadius\\\":\\\"4px\\\",\\\"elevation\\\":4,\\\"inputFontSize\\\":1,\\\"inputFontSizeUnit\\\":\\\"em\\\",\\\"labelFontSize\\\":1,\\\"labelFontSizeUnit\\\":\\\"em\\\",\\\"hintFontSize\\\":0.75,\\\"hintFontSizeUnit\\\":\\\"em\\\",\\\"useCustomColor\\\":false,\\\"customTextColor\\\":\\\"#000000\\\",\\\"customContrastColor\\\":\\\"#ffffff\\\"}\",\"app_add_to_menu\":\"0\"}],\"container\":[{\"cnt_id\":\"1\",\"cnt_cls\":\"[{\\\"columnName\\\":\\\"id\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"source\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"amount\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"vatAmount\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"taxAmount\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"country\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"currency\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"timestamp\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"purchaseNumber\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"globalPurchaseNumber\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"userDisplayName\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"userId\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"organizationId\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"checkoutUUID\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"shoppingCartUuid\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"payment_uuid\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"payment_amount\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"payment_type\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"payment_currency\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"payment_country\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"changeAmount\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"handedAmount\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"refunded\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"refund\\\",\\\"isSelected\\\":true},{\\\"columnName\\\":\\\"created\\\",\\\"isSelected\\\":true}]\",\"cnt_title\":\"Kassa Omzet per dag\",\"app_id\":\"1\",\"cnt_seq_nr\":\"0\",\"cnt_table\":\"{\\\"columns\\\":[{\\\"columnName\\\":\\\"id\\\",\\\"columnLabel\\\":\\\"Id (sleutel)\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"source\\\",\\\"columnLabel\\\":\\\"Source\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"amount\\\",\\\"columnLabel\\\":\\\"Amount\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"vatAmount\\\",\\\"columnLabel\\\":\\\"VatAmount\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"taxAmount\\\",\\\"columnLabel\\\":\\\"TaxAmount\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"country\\\",\\\"columnLabel\\\":\\\"Country\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"currency\\\",\\\"columnLabel\\\":\\\"Currency\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"timestamp\\\",\\\"columnLabel\\\":\\\"Timestamp\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"purchaseNumber\\\",\\\"columnLabel\\\":\\\"PurchaseNumber\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"globalPurchaseNumber\\\",\\\"columnLabel\\\":\\\"GlobalPurchaseNumber\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"userDisplayName\\\",\\\"columnLabel\\\":\\\"UserDisplayName\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"userId\\\",\\\"columnLabel\\\":\\\"UserId\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"organizationId\\\",\\\"columnLabel\\\":\\\"OrganizationId\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"checkoutUUID\\\",\\\"columnLabel\\\":\\\"CheckoutUUID\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"shoppingCartUuid\\\",\\\"columnLabel\\\":\\\"ShoppingCartUuid\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"payment_uuid\\\",\\\"columnLabel\\\":\\\"Payment Uuid\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"payment_amount\\\",\\\"columnLabel\\\":\\\"Payment Amount\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"payment_type\\\",\\\"columnLabel\\\":\\\"Payment Type\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"payment_currency\\\",\\\"columnLabel\\\":\\\"Payment Currency\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"payment_country\\\",\\\"columnLabel\\\":\\\"Payment Country\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"changeAmount\\\",\\\"columnLabel\\\":\\\"ChangeAmount\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"handedAmount\\\",\\\"columnLabel\\\":\\\"HandedAmount\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"refunded\\\",\\\"columnLabel\\\":\\\"Refunded\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"refund\\\",\\\"columnLabel\\\":\\\"Refund\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false},{\\\"columnName\\\":\\\"created\\\",\\\"columnLabel\\\":\\\"Created\\\",\\\"visible\\\":true,\\\"visibleTablet\\\":true,\\\"visibleMobile\\\":true,\\\"queryable\\\":true,\\\"orderable\\\":true,\\\"inlineSearch\\\":false,\\\"inlineSearchEnum\\\":0,\\\"inlineSearchDefault\\\":\\\"\\\",\\\"inlineSearchAutocomplete\\\":false,\\\"inlineSearchShowEmpty\\\":false,\\\"columnFilterOrder\\\":1,\\\"inlineEditing\\\":false,\\\"alignment\\\":\\\"left\\\",\\\"width\\\":180,\\\"prefix\\\":\\\"\\\",\\\"suffix\\\":\\\"\\\",\\\"localize\\\":false,\\\"mysqlFormat\\\":false,\\\"duration\\\":false,\\\"decimals\\\":2,\\\"dateZeros\\\":true,\\\"timeZeros\\\":true,\\\"classNames\\\":\\\"\\\",\\\"allowMarkup\\\":false,\\\"columnCode\\\":[],\\\"isMediaColumn\\\":false}],\\\"table\\\":{\\\"largeTableSupport\\\":{\\\"saved\\\":2,\\\"actual\\\":0,\\\"useHardEstimate\\\":false},\\\"clientSideProcessing\\\":false,\\\"processing\\\":0,\\\"pagination\\\":{\\\"position\\\":\\\"bottom\\\",\\\"defaultPageSize\\\":\\\"20\\\",\\\"rowsPerPage\\\":[5,10,15,20,25,30,50,100],\\\"showFirstButton\\\":true,\\\"showLastButton\\\":true,\\\"showCompactButtons\\\":true},\\\"locale\\\":\\\"en-US\\\",\\\"design\\\":{\\\"overflow\\\":\\\"responsive\\\",\\\"density\\\":{\\\"default\\\":\\\"spacious\\\",\\\"userCanChange\\\":true},\\\"layout\\\":\\\"fixed\\\"},\\\"viewLink\\\":true,\\\"detailLink\\\":true,\\\"detailColumns\\\":{\\\"id\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"source\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"amount\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"vatAmount\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"taxAmount\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"country\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"currency\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"timestamp\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"purchaseNumber\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"globalPurchaseNumber\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"userDisplayName\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"userId\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"checkoutUUID\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"shoppingCartUuid\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"payment_uuid\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"payment_amount\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"payment_type\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"payment_currency\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"changeAmount\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"handedAmount\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"refunded\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"refund\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"},\\\"created\\\":{\\\"enabled\\\":true,\\\"layout\\\":\\\"rendered\\\"}},\\\"detailColumnsVisible\\\":{\\\"small\\\":1,\\\"medium\\\":1,\\\"large\\\":2},\\\"detailColumnSpacing\\\":{\\\"width\\\":0.25,\\\"unit\\\":\\\"rem\\\"},\\\"detailExpandAll\\\":false,\\\"hideExpandIcons\\\":false,\\\"expandIconPosition\\\":\\\"right\\\",\\\"tableDisplayMode\\\":false,\\\"detailPdf\\\":false,\\\"transactions\\\":{\\\"insert\\\":false,\\\"update\\\":false,\\\"delete\\\":false},\\\"formModal\\\":false,\\\"modal\\\":[],\\\"searchSettings\\\":{\\\"enableGlobalSearch\\\":true,\\\"showGlobalSearchOnStartup\\\":false,\\\"globalSearchAlwaysOpen\\\":false,\\\"forceSearch\\\":false,\\\"forceInline\\\":false,\\\"highlightMatches\\\":true,\\\"searchForm\\\":true,\\\"searchFormPosition\\\":0,\\\"searchFormTitleVisible\\\":true,\\\"searchFormCompact\\\":false,\\\"searchFormCompactExpand\\\":true,\\\"searchFormAlwaysOpen\\\":false,\\\"searchFormWidth\\\":340,\\\"searchFormWidthUnit\\\":\\\"px\\\",\\\"searchFormIcon\\\":\\\"default\\\",\\\"cascade\\\":false,\\\"saveFilters\\\":false},\\\"inlineEditing\\\":{\\\"fieldVariant\\\":\\\"outlined\\\",\\\"spacing\\\":{\\\"fieldTop\\\":8,\\\"fieldTopUnit\\\":\\\"px\\\",\\\"fieldBottom\\\":8,\\\"fieldBottomUnit\\\":\\\"px\\\",\\\"fieldLeft\\\":8,\\\"fieldLeftUnit\\\":\\\"px\\\",\\\"fieldRight\\\":8,\\\"fieldRightUnit\\\":\\\"px\\\"},\\\"addColumnButton\\\":true},\\\"bulkActions\\\":{\\\"pdf\\\":false,\\\"csv\\\":true,\\\"json\\\":true,\\\"excel\\\":false,\\\"xml\\\":true,\\\"sql\\\":false,\\\"delete\\\":false},\\\"defaultWhere\\\":\\\"\\\",\\\"defaultOrderBy\\\":[],\\\"tableCode\\\":[],\\\"globalCode\\\":[],\\\"enableColumnHiding\\\":false,\\\"enableColumnOrdering\\\":false,\\\"showHeader\\\":true,\\\"stickyHeader\\\":true,\\\"showFooter\\\":false,\\\"stickyFooter\\\":false,\\\"charts\\\":{\\\"enabled\\\":false,\\\"interactive\\\":false},\\\"maps\\\":{\\\"enabled\\\":false,\\\"apiKey\\\":\\\"\\\",\\\"columnLatitude\\\":\\\"\\\",\\\"columnLongitude\\\":\\\"\\\",\\\"docked\\\":\\\"undocked\\\"},\\\"docking\\\":\\\"beside\\\",\\\"dockFirst\\\":\\\"map\\\",\\\"css\\\":\\\"\\\",\\\"disableToken\\\":false}}\",\"cnt_form\":null,\"cnt_rform\":null,\"cnt_relation\":null,\"cnt_chart\":null,\"cnt_map\":null,\"cnt_query\":null,\"cnt_dashboard\":null}],\"apps\":[]},\"columns\":[{\"column_name\":\"id\",\"data_type\":\"int\",\"extra\":\"auto_increment\",\"column_type\":\"int(11)\",\"is_nullable\":\"NO\",\"column_default\":null,\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},{\"column_name\":\"source\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(50)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"50\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"amount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},{\"column_name\":\"vatAmount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},{\"column_name\":\"taxAmount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},{\"column_name\":\"country\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(5)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"5\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"currency\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(5)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"5\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"timestamp\",\"data_type\":\"datetime\",\"extra\":\"\",\"column_type\":\"datetime\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"purchaseNumber\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},{\"column_name\":\"globalPurchaseNumber\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},{\"column_name\":\"userDisplayName\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(255)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"255\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"userId\",\"data_type\":\"bigint\",\"extra\":\"\",\"column_type\":\"bigint(20)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"19\"},{\"column_name\":\"organizationId\",\"data_type\":\"bigint\",\"extra\":\"\",\"column_type\":\"bigint(20)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"19\"},{\"column_name\":\"checkoutUUID\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(100)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"100\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"shoppingCartUuid\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(100)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"100\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"payment_uuid\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(100)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"100\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"payment_amount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},{\"column_name\":\"payment_type\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(50)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"50\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"payment_currency\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(5)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"5\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"payment_country\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(5)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"5\",\"numeric_scale\":null,\"numeric_precision\":null},{\"column_name\":\"changeAmount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},{\"column_name\":\"handedAmount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},{\"column_name\":\"refunded\",\"data_type\":\"tinyint\",\"extra\":\"\",\"column_type\":\"tinyint(1)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"3\"},{\"column_name\":\"refund\",\"data_type\":\"tinyint\",\"extra\":\"\",\"column_type\":\"tinyint(1)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"3\"},{\"column_name\":\"created\",\"data_type\":\"datetime\",\"extra\":\"\",\"column_type\":\"datetime\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":null,\"numeric_precision\":null}],\"columns_sorted\":{\"id\":{\"column_name\":\"id\",\"data_type\":\"int\",\"extra\":\"auto_increment\",\"column_type\":\"int(11)\",\"is_nullable\":\"NO\",\"column_default\":null,\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},\"source\":{\"column_name\":\"source\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(50)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"50\",\"numeric_scale\":null,\"numeric_precision\":null},\"amount\":{\"column_name\":\"amount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},\"vatAmount\":{\"column_name\":\"vatAmount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},\"taxAmount\":{\"column_name\":\"taxAmount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},\"country\":{\"column_name\":\"country\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(5)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"5\",\"numeric_scale\":null,\"numeric_precision\":null},\"currency\":{\"column_name\":\"currency\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(5)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"5\",\"numeric_scale\":null,\"numeric_precision\":null},\"timestamp\":{\"column_name\":\"timestamp\",\"data_type\":\"datetime\",\"extra\":\"\",\"column_type\":\"datetime\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":null,\"numeric_precision\":null},\"purchaseNumber\":{\"column_name\":\"purchaseNumber\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},\"globalPurchaseNumber\":{\"column_name\":\"globalPurchaseNumber\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},\"userDisplayName\":{\"column_name\":\"userDisplayName\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(255)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"255\",\"numeric_scale\":null,\"numeric_precision\":null},\"userId\":{\"column_name\":\"userId\",\"data_type\":\"bigint\",\"extra\":\"\",\"column_type\":\"bigint(20)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"19\"},\"organizationId\":{\"column_name\":\"organizationId\",\"data_type\":\"bigint\",\"extra\":\"\",\"column_type\":\"bigint(20)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"19\"},\"checkoutUUID\":{\"column_name\":\"checkoutUUID\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(100)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"100\",\"numeric_scale\":null,\"numeric_precision\":null},\"shoppingCartUuid\":{\"column_name\":\"shoppingCartUuid\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(100)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"100\",\"numeric_scale\":null,\"numeric_precision\":null},\"payment_uuid\":{\"column_name\":\"payment_uuid\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(100)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"100\",\"numeric_scale\":null,\"numeric_precision\":null},\"payment_amount\":{\"column_name\":\"payment_amount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},\"payment_type\":{\"column_name\":\"payment_type\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(50)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"50\",\"numeric_scale\":null,\"numeric_precision\":null},\"payment_currency\":{\"column_name\":\"payment_currency\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(5)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"5\",\"numeric_scale\":null,\"numeric_precision\":null},\"payment_country\":{\"column_name\":\"payment_country\",\"data_type\":\"varchar\",\"extra\":\"\",\"column_type\":\"varchar(5)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":\"5\",\"numeric_scale\":null,\"numeric_precision\":null},\"changeAmount\":{\"column_name\":\"changeAmount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},\"handedAmount\":{\"column_name\":\"handedAmount\",\"data_type\":\"int\",\"extra\":\"\",\"column_type\":\"int(11)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"10\"},\"refunded\":{\"column_name\":\"refunded\",\"data_type\":\"tinyint\",\"extra\":\"\",\"column_type\":\"tinyint(1)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"3\"},\"refund\":{\"column_name\":\"refund\",\"data_type\":\"tinyint\",\"extra\":\"\",\"column_type\":\"tinyint(1)\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":\"0\",\"numeric_precision\":\"3\"},\"created\":{\"column_name\":\"created\",\"data_type\":\"datetime\",\"extra\":\"\",\"column_type\":\"datetime\",\"is_nullable\":\"YES\",\"column_default\":\"NULL\",\"character_maximum_length\":null,\"numeric_scale\":null,\"numeric_precision\":null}},\"table_labels\":{\"id\":\"Id (sleutel)\",\"source\":\"Source\",\"amount\":\"Amount\",\"vatAmount\":\"VatAmount\",\"taxAmount\":\"TaxAmount\",\"country\":\"Country\",\"currency\":\"Currency\",\"timestamp\":\"Timestamp\",\"purchaseNumber\":\"PurchaseNumber\",\"globalPurchaseNumber\":\"GlobalPurchaseNumber\",\"userDisplayName\":\"UserDisplayName\",\"userId\":\"UserId\",\"organizationId\":\"OrganizationId\",\"checkoutUUID\":\"CheckoutUUID\",\"shoppingCartUuid\":\"ShoppingCartUuid\",\"payment_uuid\":\"Payment Uuid\",\"payment_amount\":\"Payment Amount\",\"payment_type\":\"Payment Type\",\"payment_currency\":\"Payment Currency\",\"payment_country\":\"Payment Country\",\"changeAmount\":\"ChangeAmount\",\"handedAmount\":\"HandedAmount\",\"refunded\":\"Refunded\",\"refund\":\"Refund\",\"created\":\"Created\"},\"form_labels\":{\"id\":\"Id (sleutel)\",\"source\":\"Source\",\"amount\":\"Amount\",\"vatAmount\":\"VatAmount\",\"taxAmount\":\"TaxAmount\",\"country\":\"Country\",\"currency\":\"Currency\",\"timestamp\":\"Timestamp\",\"purchaseNumber\":\"PurchaseNumber\",\"globalPurchaseNumber\":\"GlobalPurchaseNumber\",\"userDisplayName\":\"UserDisplayName\",\"userId\":\"UserId\",\"organizationId\":\"OrganizationId\",\"checkoutUUID\":\"CheckoutUUID\",\"shoppingCartUuid\":\"ShoppingCartUuid\",\"payment_uuid\":\"Payment Uuid\",\"payment_amount\":\"Payment Amount\",\"payment_type\":\"Payment Type\",\"payment_currency\":\"Payment Currency\",\"payment_country\":\"Payment Country\",\"changeAmount\":\"ChangeAmount\",\"handedAmount\":\"HandedAmount\",\"refunded\":\"Refunded\",\"refund\":\"Refund\",\"created\":\"Created\"},\"primary_key\":[\"id\"],\"access\":{\"select\":[],\"insert\":[],\"update\":[],\"delete\":[]},\"settings\":{\"env\":{\"ip\":\"216.73.217.73\",\"id\":0,\"user\":\"anonymous\",\"roles\":false,\"login\":false},\"wp\":{\"roles\":{\"administrator\":\"Administrator\",\"editor\":\"Editor\",\"author\":\"Author\",\"contributor\":\"Contributor\",\"subscriber\":\"Subscriber\"},\"users\":{\"Roel Baas\":\"Roel Baas\",\"website_24pyxfvi\":\"admin\"},\"home\":\"https:\\\/\\\/data.delocht.nl\\\/wp-admin\\\/admin.php\",\"tables\":[\"data_users\",\"data_usermeta\",\"data_posts\",\"data_comments\",\"data_links\",\"data_options\",\"data_postmeta\",\"data_terms\",\"data_term_taxonomy\",\"data_term_relationships\",\"data_termmeta\",\"data_commentmeta\"],\"date_format\":\"F j, Y\",\"time_format\":\"g:i a\",\"scroll_offset\":\"120\"}},\"media\":[],\"wp_media\":{\"id\":false,\"source\":false,\"amount\":false,\"vatAmount\":false,\"taxAmount\":false,\"country\":false,\"currency\":false,\"timestamp\":false,\"purchaseNumber\":false,\"globalPurchaseNumber\":false,\"userDisplayName\":false,\"userId\":false,\"organizationId\":false,\"checkoutUUID\":false,\"shoppingCartUuid\":false,\"payment_uuid\":false,\"payment_amount\":false,\"payment_type\":false,\"payment_currency\":false,\"payment_country\":false,\"changeAmount\":false,\"handedAmount\":false,\"refunded\":false,\"refund\":false,\"created\":false},\"table_info\":{\"type\":\"BASE TABLE\",\"engine\":\"InnoDB\",\"count\":\"23216\"}}                            }\n                                            <\/script>\n                \n\t\t\t\n\t\t\t<script>\n                if (! window.PP_APP_CONFIG) {\n                    window.PP_APP_CONFIG = {\n                        appDebug: false,\n                        appLocales: \"https:\/\/data.delocht.nl\/wp-content\/plugins\/wp-data-access-premium\/WPDataAccess\/..\/assets\/premium\/dist\/locales\/\",\n                        appSite: {\"id\":\"19871525\",\"updated\":\"2026-04-25 12:06:02\",\"created\":\"2026-04-11 12:24:14\",\"site_id\":\"281102302\",\"blog_id\":null,\"plugin_id\":\"6189\",\"user_id\":\"5139097\",\"title\":\"My Website\",\"url\":\"https:\\\/\\\/data.delocht.nl\",\"version\":\"5.5.71\",\"language\":\"nl-NL\",\"platform_version\":\"6.9.4\",\"sdk_version\":\"2.13.1\",\"programming_language_version\":\"8.3.30\",\"plan_id\":\"10111\",\"license_id\":null,\"trial_plan_id\":\"10588\",\"trial_ends\":\"2026-04-25 12:05:02\",\"is_premium\":true,\"is_disconnected\":false,\"is_active\":true,\"is_uninstalled\":false,\"is_beta\":false},\n                        appLicenses: {\"license\":[],\"local\":false},\n                        appTarget: \"frontend\",\n                        appIp: \"216.73.217.73\",\n                        appUser: \"anonymous\",\n                        appRoles: false,\n                        appLogin: false,\n                        appVars: [],\n                    }\n                }\n                                        window.PP_APP_CONFIG[1] = {\n                            appRoles: false,\n                            appFullscreen: false,\n                            hideTitleBar: false,\n                        }\n                        \t\t\t<\/script>\n\t\t\t<script type=\"module\" src=\"https:\/\/data.delocht.nl\/wp-content\/plugins\/wp-data-access-premium\/WPDataAccess\/..\/assets\/premium\/dist\/app-1.0.69.js\"><\/script>\n\n\t\t\t\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"full-wdth","meta":{"footnotes":""},"class_list":["post-6","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/data.delocht.nl\/index.php?rest_route=\/wp\/v2\/pages\/6","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data.delocht.nl\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/data.delocht.nl\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/data.delocht.nl\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/data.delocht.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6"}],"version-history":[{"count":5,"href":"https:\/\/data.delocht.nl\/index.php?rest_route=\/wp\/v2\/pages\/6\/revisions"}],"predecessor-version":[{"id":19,"href":"https:\/\/data.delocht.nl\/index.php?rest_route=\/wp\/v2\/pages\/6\/revisions\/19"}],"wp:attachment":[{"href":"https:\/\/data.delocht.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}