G/L account settings and cost dimensions — Free
Search account codes and descriptions; inspect eight stored tracking/matching flags in grouped same-row Details.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. SELECTED XML/STORAGE DOCUMENTATION.
For bookkeepers, financial teams and managers: search the current chart by account code or description and inspect the stored cost-centre, cost-unit, project, item, quantity, resource, asset and matching settings without exposing internal IDs or connecting to the full desktop application.
Why Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorised source and your Cifru plan.
FREE SCOPE: one authorised SQL Server source, one native table, one Home list and ten same-row Detail values in four groups. No custom SQL, joins, related buttons, calculations, widgets or periodic refresh. Existing workspace resources count toward plan limits. Choose the raw stored cost-centre flag or All; the opening choice/local Search inspect only the loaded result, not all accounts or source permissions. Each read caps at 2,000 rows; a cap is not proof of low query cost or a complete chart.
WHAT THE VALUES MEAN: these are CURRENT STORED SETTINGS, not transactions, actual assignments, posting eligibility, authorisation, a trial balance, budget, debit/credit, matched balance or paid status. Source flag values are shown as raw text, with no undocumented 0/1 or Yes/No conversion. Confirm the installed representation before interpretation. Unknown, NULL, blank and zero stay distinct; no default false/true is invented. Cost-centre/cost-unit/project flags do not prove a default value or a particular dimension is available to the current user. Matching is a stored setting, not an actual matched payment. Business account codes, including leading zeros and padding, are retained, not replaced by technical IDs.
DOCUMENTARY SCOPE: ten grtbk fields are explicitly qualified in the public vendor XML/storage reference. Eight mappings belong to their own GLAccount boolean elements, not inferred from nearby XML properties. XML schema 4.0.310.1 is NOT an installed Globe release or SQL DDL version. The Globe+ mandatory mapping separately anchors grtbk.reknr/oms25; account-maintenance help states unique G/L numbers and bases its functional explanation on product update 406. It does not certify the current edition, SQL types, indexes, NULL constraints, collation or binary flag storage. Account type, side, blocked flag, cash-flow category without a code legend, balances, bank/card details, audit/custom payloads and financial-entry fields without qualified storage proof are not guessed.
BEFORE USE AND SECURITY: ask your administrator to verify the actual edition/company database, all ten fields and meanings, full nonempty unique reknr and source representation. Confirm exactly one authorised grtbk object is discovered and resolved consistently on both platforms. The SQL owner is not presumed dbo; remap an ambiguous object to its administrator-confirmed qualified name in Studio and repeat the read-only compatibility test. Use validated TLS and a separate least-privilege SELECT login; never grant administrator access or execute examples from the vendor maintenance manual. Direct SQL does not inherit Globe user roles, division restrictions or SecurityLevel. Enforce permitted company/account access at source; loaded filters are not an ACL. Real account descriptions can remain confidential. No source server, user, password, production row or vendor sample is included.
VALIDATION: documentary and labelled synthetic projection tests only; native Android demonstration checks all ten selected same-row Detail values and the complete selected card with wholly fictional DEMO. Not an observed native SQL/ERP execution. NOT tested on a real ERP, SQL Server or iOS, nor Free purchase entitlements, installed performance or whole security. Run Cifru read/compatibility tests and inspect a real preview after mapping your authorised source. Unofficial; not affiliated with Exact.
Primary documentation:
https://www.exactsoftware.com/docs/XMLDocumentation.aspx?Action=1
https://www.exactsoftware.com/docs/DocView.aspx?DocumentID=%7B9afa6518-6878-42b5-8ac9-d8e912369cb9%7D&NoSubject=1
https://www.exactsoftware.com/docs/DocView.aspx?DocumentID=%7B03ee7443-2d7d-488b-b2c0-d84ca186f596%7D
GALLERY COVERAGE: Two complementary personally viewed native images show the complete selected account card and all ten representative same-row Detail values, with code/name in the header and eight raw flags. No related lists or buttons exist in this Free configuration. This does not certify every source row, real ERP/SQL Server/iOS execution, installed flag encodings or Free purchase entitlements. All rows are wholly fictional DEMO from an explicit SQLite TEXT projection model, not observed Cifru-generated SQL. Every original PNG/XML/input and RAW is retained privately for future videos; approval covers these two exact PNGs only, not the whole RAW. Original APK/test/workspace/cache/English restored through native CLI and owned5570 closed; no independent private-byte equality certification. The gallery deliberately contains two images, not duplicate filler.
Screenshots
What this package creates
- Home: Ledger account settings
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Exact Globe — authorised G/L SQL Server source",
"id": "46220A9B-F7AC-523B-B6BE-54B572934820",
"kind": "sqlServer",
"requiredObjects": [
"grtbk"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "B62D3196-D536-51F4-BDE4-3B3D18FACDB3",
"key": "oms25",
"type": "text"
},
{
"direction": "ascending",
"id": "4D003346-2367-5B2A-B8BA-12305D8DCC3D",
"key": "reknr",
"type": "text"
}
],
"id": "0DDC5DB1-DA5B-51AD-9A78-6568AA164915",
"mappings": [
{
"commonFieldKey": "",
"key": "reknr",
"label": "G/L account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "reknr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "oms25",
"label": "Account description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "oms25",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "act_rek",
"label": "Stored asset flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "act_rek",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "kstplrek",
"label": "Stored cost-centre flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "kstplrek",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "kstdrrek",
"label": "Stored cost-unit flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "kstdrrek",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "aantallen",
"label": "Stored quantity flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "aantallen",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UseItem",
"label": "Stored item flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UseItem",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UseResource",
"label": "Stored resource flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UseResource",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UseProject",
"label": "Stored project flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "UseProject",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "afletteren",
"label": "Stored matching flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "afletteren",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Ledger account settings",
"primaryKey": "reknr",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"reknr",
"oms25",
"act_rek",
"kstplrek",
"kstdrrek",
"aantallen",
"UseItem",
"UseResource",
"UseProject",
"afletteren"
],
"sourceID": "46220A9B-F7AC-523B-B6BE-54B572934820",
"sqlQuery": "",
"tableName": "grtbk"
}
],
"pages": [
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "kstplrek",
"label": "Stored cost-centre flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "kstdrrek",
"label": "Stored cost-unit flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UseProject",
"label": "Stored project flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UseItem",
"label": "Stored item flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "aantallen",
"label": "Stored quantity flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "afletteren",
"label": "Stored matching flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "0DDC5DB1-DA5B-51AD-9A78-6568AA164915",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Account identification",
"detailRole": "information",
"isVisible": true,
"key": "reknr",
"label": "G/L account code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Account identification",
"detailRole": "information",
"isVisible": true,
"key": "oms25",
"label": "Account description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored detail attributes",
"detailRole": "information",
"isVisible": true,
"key": "act_rek",
"label": "Stored asset flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored cost dimensions — not effective permissions",
"detailRole": "information",
"isVisible": true,
"key": "kstplrek",
"label": "Stored cost-centre flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored cost dimensions — not effective permissions",
"detailRole": "information",
"isVisible": true,
"key": "kstdrrek",
"label": "Stored cost-unit flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored detail attributes",
"detailRole": "information",
"isVisible": true,
"key": "aantallen",
"label": "Stored quantity flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored detail attributes",
"detailRole": "information",
"isVisible": true,
"key": "UseItem",
"label": "Stored item flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored detail attributes",
"detailRole": "information",
"isVisible": true,
"key": "UseResource",
"label": "Stored resource flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored cost dimensions — not effective permissions",
"detailRole": "information",
"isVisible": true,
"key": "UseProject",
"label": "Stored project flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Stored matching — not payment or balance",
"detailRole": "information",
"isVisible": true,
"key": "afletteren",
"label": "Stored matching flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "66C9A957-054A-56A0-8234-8DE7275F0400",
"openFilters": [
{
"id": "6C95946C-75B0-5473-8704-FB121BAC223F",
"includeAllOption": true,
"key": "kstplrek",
"title": "Choose stored cost-centre flag",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "B62D3196-D536-51F4-BDE4-3B3D18FACDB3",
"key": "oms25",
"type": "text"
},
{
"direction": "ascending",
"id": "4D003346-2367-5B2A-B8BA-12305D8DCC3D",
"key": "reknr",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "reknr",
"systemImage": "list.bullet.rectangle",
"title": "Ledger account settings",
"titleKey": "oms25"
}
],
"relations": [],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Exact Globe",
"changelog": "First native Free G/L settings dossier: ten same-row values, raw flag choice and two complementary fictional native images. Not real ERP validation.",
"configurationLanguages": [
"en"
],
"countries": [
"GB"
],
"createdAt": "2026-10-12T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. SELECTED XML/STORAGE DOCUMENTATION.\n\nFor bookkeepers, financial teams and managers: search the current chart by account code or description and inspect the stored cost-centre, cost-unit, project, item, quantity, resource, asset and matching settings without exposing internal IDs or connecting to the full desktop application.\n\nWhy Cifru? Adapt configurations to the way you work. Choose the fields, filters and details you need, and bring information to your phone that may not be available in your business software’s own mobile app. Available options depend on the data exposed by your authorised source and your Cifru plan.\n\nFREE SCOPE: one authorised SQL Server source, one native table, one Home list and ten same-row Detail values in four groups. No custom SQL, joins, related buttons, calculations, widgets or periodic refresh. Existing workspace resources count toward plan limits. Choose the raw stored cost-centre flag or All; the opening choice/local Search inspect only the loaded result, not all accounts or source permissions. Each read caps at 2,000 rows; a cap is not proof of low query cost or a complete chart.\n\nWHAT THE VALUES MEAN: these are CURRENT STORED SETTINGS, not transactions, actual assignments, posting eligibility, authorisation, a trial balance, budget, debit/credit, matched balance or paid status. Source flag values are shown as raw text, with no undocumented 0/1 or Yes/No conversion. Confirm the installed representation before interpretation. Unknown, NULL, blank and zero stay distinct; no default false/true is invented. Cost-centre/cost-unit/project flags do not prove a default value or a particular dimension is available to the current user. Matching is a stored setting, not an actual matched payment. Business account codes, including leading zeros and padding, are retained, not replaced by technical IDs.\n\nDOCUMENTARY SCOPE: ten grtbk fields are explicitly qualified in the public vendor XML/storage reference. Eight mappings belong to their own GLAccount boolean elements, not inferred from nearby XML properties. XML schema 4.0.310.1 is NOT an installed Globe release or SQL DDL version. The Globe+ mandatory mapping separately anchors grtbk.reknr/oms25; account-maintenance help states unique G/L numbers and bases its functional explanation on product update 406. It does not certify the current edition, SQL types, indexes, NULL constraints, collation or binary flag storage. Account type, side, blocked flag, cash-flow category without a code legend, balances, bank/card details, audit/custom payloads and financial-entry fields without qualified storage proof are not guessed.\n\nBEFORE USE AND SECURITY: ask your administrator to verify the actual edition/company database, all ten fields and meanings, full nonempty unique reknr and source representation. Confirm exactly one authorised grtbk object is discovered and resolved consistently on both platforms. The SQL owner is not presumed dbo; remap an ambiguous object to its administrator-confirmed qualified name in Studio and repeat the read-only compatibility test. Use validated TLS and a separate least-privilege SELECT login; never grant administrator access or execute examples from the vendor maintenance manual. Direct SQL does not inherit Globe user roles, division restrictions or SecurityLevel. Enforce permitted company/account access at source; loaded filters are not an ACL. Real account descriptions can remain confidential. No source server, user, password, production row or vendor sample is included.\n\nVALIDATION: documentary and labelled synthetic projection tests only; native Android demonstration checks all ten selected same-row Detail values and the complete selected card with wholly fictional DEMO. Not an observed native SQL/ERP execution. NOT tested on a real ERP, SQL Server or iOS, nor Free purchase entitlements, installed performance or whole security. Run Cifru read/compatibility tests and inspect a real preview after mapping your authorised source. Unofficial; not affiliated with Exact.\n\nPrimary documentation:\nhttps://www.exactsoftware.com/docs/XMLDocumentation.aspx?Action=1\nhttps://www.exactsoftware.com/docs/DocView.aspx?DocumentID=%7B9afa6518-6878-42b5-8ac9-d8e912369cb9%7D&NoSubject=1\nhttps://www.exactsoftware.com/docs/DocView.aspx?DocumentID=%7B03ee7443-2d7d-488b-b2c0-d84ca186f596%7D\n\nGALLERY COVERAGE: Two complementary personally viewed native images show the complete selected account card and all ten representative same-row Detail values, with code/name in the header and eight raw flags. No related lists or buttons exist in this Free configuration. This does not certify every source row, real ERP/SQL Server/iOS execution, installed flag encodings or Free purchase entitlements. All rows are wholly fictional DEMO from an explicit SQLite TEXT projection model, not observed Cifru-generated SQL. Every original PNG/XML/input and RAW is retained privately for future videos; approval covers these two exact PNGs only, not the whole RAW. Original APK/test/workspace/cache/English restored through native CLI and owned5570 closed; no independent private-byte equality certification. The gallery deliberately contains two images, not duplicate filler.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "free",
"packageID": "77B2D82A-F2A7-57DD-8DDA-EB8C143EA829",
"rootButtonCount": 1,
"summary": "Search account codes and descriptions; inspect eight stored tracking/matching flags in grouped same-row Details.",
"tags": [
"Exact Globe",
"SQL Server",
"Chart of accounts",
"Accounting",
"Cost centres",
"Free"
],
"title": "G/L account settings and cost dimensions — Free"
}
}