Nominal transactions: posted, pending and deferred — Pro
Three separate period enquiries, recorded company-base values, account context and on-demand account notes.
DOCUMENTARY AND SYNTHETIC VALIDATION ONLY — not tested on a real Sage 200 installation. For finance staff, accountants and managers: choose a transaction-date period and inspect current posted nominal entries with their recorded company-base value, reference, narrative, operator and nominal entry kind. See current account, cost-centre and department references, and open account notes on demand. Two separate Home buttons show pending and deferred waiting postings, including account references that may not exist in the account master yet. Search loaded rows or use Cifru local filters to focus on an account or centre.
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.
Pro: one separately authorised company SQL Server source, three Home screens, four bounded live lists/Details and one lazy related button. SELECT only, at most 2,000 rows per read, no periodic refresh. Each main screen requests a native opening period; SQL uses both the inclusive start and exclusive end for transaction dates. The note button binds the selected account; account notes are current account context, not limited to the transaction-date period. Limits and filters are not an ACL, completeness or cheap-query guarantee. Check installed indexes, execution plans, timeouts and least-privilege reader permissions; SQL does not inherit Sage user roles. Narratives, operator names and account notes may be sensitive. Authorise the scope before connecting.
UNOFFICIAL, not affiliated with Sage. Selected complete physical labels and kind values are documented in the partial Sage 200 2015 database guide, November 2014. This is not full DDL, a complete company schema or current-edition certification. Requires compatible dbo objects: dbo is an adapter requirement, not an observed installed owner. Ask the administrator to verify ownership, exact installed columns/types, key uniqueness, nullability, status meanings and access before import. Not Sage 200 Standard, Evolution, Sage 300 or an API template.
Recorded values are in the company base currency, not assumed GBP. Confirm that currency with the company administrator; no guessed symbol or currency code is displayed. Values and exchange rates preserve source strings rather than force two-decimal rounding. Exchange rates are context only: no conversion is calculated. No document-currency amount, debit/credit inference from signs, aggregation, balances, aging, trial balance, profit-and-loss or tax/payment reconciliation. A native kind named Payment or Receipt does not prove an invoice is paid. Posted, pending and deferred tables are never combined or summed. Current account names and account notes are not historical snapshots of a transaction. Missing account masters, blank references and unknown kind/status values are retained. Inactive notes remain identifiable. No archived nominal records, held journals or guessed cross-module URN joins. Choosing a date period does not make this a historical account balance. No credentials, server addresses or business rows in the package.
Primary physical reference: https://desktophelp.sage.co.uk/sage200/PDF/2015/Understanding%20the%20Sage%20200%202015%20Database.pdf
Nominal transaction enquiry and currency context: https://desktophelp.sage.co.uk/sage200/professional/Content/NL/TransactionEnquiry.htm
Gallery coverage: Eight representative native images show all three selected complete main cards, all four selected populated Details routes, and the actual account-note list/action. All 35 useful Details positions are paired with exact invented input. The posted Details first view is complete; its near-identical overlap view is retained privately rather than duplicated in this gallery. Blank, unknown, negative and inactive examples are retained. Additional private PNG/XML viewports and raw bookmarks are preserved for later film editing. This is not every record/viewport, whole-video approval, a real ERP/SQL Server test, installed currency/ACL/constraint certification or a full accounting report.
Screenshots
What this package creates
3 Home1 Details4 lists1 sources to map
- Home: Nominal: posted
- Home: Nominal: pending
- Home: Nominal: deferred
- Details: Current account notes
- Sub-button: Current account notes
Sources are mapped locally and verified before applying.
Custom queriesPRO4 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT t.NLPostedNominalTranID AS TransactionKey, t.NLNominalAccountID AS AccountKey, t.Reference AS Reference, t.TransactionDate AS TransactionDate, t.GoodsValueInBaseCurrency AS BaseValue, CASE t.NLNominalTranTypeID WHEN 0 THEN N'General' WHEN 1 THEN N'Manual' WHEN 2 THEN N'Prepayment' WHEN 3 THEN N'Accrual' WHEN 4 THEN N'Previous Year' WHEN 5 THEN N'Tax Payment' WHEN 6 THEN N'Tax Receipt' WHEN 7 THEN N'Payment' WHEN 8 THEN N'Receipt' ELSE CASE WHEN t.NLNominalTranTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',t.NLNominalTranTypeID) END END AS Kind, t.ExchangeRate AS ExchangeRate, t.Narrative AS Narrative, t.UserName AS UserName, a.AccountNumber AS AccountNumber, a.AccountName AS AccountName, a.AccountCostCentre AS CostCentre, a.AccountDepartment AS Department, N'Current posted record' AS State FROM dbo.NLPostedNominalTran t LEFT JOIN dbo.NLNominalAccount a ON a.NLNominalAccountID=t.NLNominalAccountID WHERE t.NLPostedNominalTranID IS NOT NULL AND t.TransactionDate>=:date_from AND t.TransactionDate<:date_until
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT t.NLPendNominalTranID AS TransactionKey, t.Reference AS Reference, t.TransactionDate AS TransactionDate, t.GoodsValueInBaseCurrency AS BaseValue, CASE t.NLNominalTranTypeID WHEN 0 THEN N'General' WHEN 1 THEN N'Manual' WHEN 2 THEN N'Prepayment' WHEN 3 THEN N'Accrual' WHEN 4 THEN N'Previous Year' WHEN 5 THEN N'Tax Payment' WHEN 6 THEN N'Tax Receipt' WHEN 7 THEN N'Payment' WHEN 8 THEN N'Receipt' ELSE CASE WHEN t.NLNominalTranTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',t.NLNominalTranTypeID) END END AS Kind, t.ExchangeRate AS ExchangeRate, t.AccountNumber AS AccountNumber, t.AccountCostCentre AS CostCentre, t.AccountDepartment AS Department, t.Narrative AS Narrative, N'Pending — not a posted record' AS State FROM dbo.NLPendNominalTran t WHERE t.NLPendNominalTranID IS NOT NULL AND t.TransactionDate>=:date_from AND t.TransactionDate<:date_until
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT t.NLDeferredNominalTranID AS TransactionKey, t.Reference AS Reference, t.TransactionDate AS TransactionDate, t.GoodsValueInBaseCurrency AS BaseValue, CASE t.NLNominalTranTypeID WHEN 0 THEN N'General' WHEN 1 THEN N'Manual' WHEN 2 THEN N'Prepayment' WHEN 3 THEN N'Accrual' WHEN 4 THEN N'Previous Year' WHEN 5 THEN N'Tax Payment' WHEN 6 THEN N'Tax Receipt' WHEN 7 THEN N'Payment' WHEN 8 THEN N'Receipt' ELSE CASE WHEN t.NLNominalTranTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',t.NLNominalTranTypeID) END END AS Kind, t.ExchangeRate AS ExchangeRate, t.AccountNumber AS AccountNumber, t.AccountCostCentre AS CostCentre, t.AccountDepartment AS Department, N'Deferred — not a posted record' AS State FROM dbo.NLDeferredNominalTran t WHERE t.NLDeferredNominalTranID IS NOT NULL AND t.TransactionDate>=:date_from AND t.TransactionDate<:date_until
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT m.NLAccountMemoID AS MemoKey, m.NLNominalAccountID AS AccountKey, m.MemoText AS MemoText, m.MemoCreatedBy AS MemoCreatedBy, m.TimeAndDateMemoCreated AS MemoCreatedAt, CASE m.Active WHEN 1 THEN N'Yes' WHEN 0 THEN N'No' ELSE N'Not recorded / unknown' END AS MemoActive FROM dbo.NLAccountMemo m WHERE m.NLNominalAccountID=:account AND m.NLAccountMemoID IS NOT NULL
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 200 Professional UK — company SQL Server",
"id": "D87237E9-FBA9-57DA-B15A-D6FE7416AB58",
"kind": "sqlServer",
"requiredObjects": [
"dbo.NLAccountMemo",
"dbo.NLDeferredNominalTran",
"dbo.NLNominalAccount",
"dbo.NLPendNominalTran",
"dbo.NLPostedNominalTran"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "7324391D-8358-5BB4-B75E-1173CCC732B6",
"key": "TransactionDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E090F16D-50C3-5228-91D7-2B1CBABB3A9D",
"key": "TransactionKey",
"type": "text"
}
],
"id": "89EB1145-DBA0-5B34-B1BC-8DBEFEDE009E",
"mappings": [
{
"commonFieldKey": "",
"key": "TransactionKey",
"label": "Internal transaction key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountKey",
"label": "Internal account key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Reference",
"label": "Recorded reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Reference",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BaseValue",
"label": "Value — base currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BaseValue",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Kind",
"label": "Nominal entry kind",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Kind",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ExchangeRate",
"label": "Recorded exchange rate — not a conversion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ExchangeRate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Narrative",
"label": "Recorded narrative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Narrative",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "UserName",
"label": "Recorded operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UserName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountNumber",
"label": "Account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountName",
"label": "Current account name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CostCentre",
"label": "Cost centre reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CostCentre",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Department",
"label": "Department reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Department",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "State",
"label": "Record set",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "State",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Posted nominal transactions",
"primaryKey": "TransactionKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TransactionDate",
"id": "12BCD24A-EC7E-5B31-83AC-982D94F8E802",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TransactionDate",
"id": "349356A4-8021-50E8-BA64-F7A56F3E97F6",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Reference",
"BaseValue",
"Kind",
"ExchangeRate",
"Narrative",
"UserName",
"AccountNumber",
"AccountName",
"CostCentre",
"Department",
"State"
],
"sourceID": "D87237E9-FBA9-57DA-B15A-D6FE7416AB58",
"sqlQuery": "SELECT t.NLPostedNominalTranID AS TransactionKey, t.NLNominalAccountID AS AccountKey, t.Reference AS Reference, t.TransactionDate AS TransactionDate, t.GoodsValueInBaseCurrency AS BaseValue, CASE t.NLNominalTranTypeID WHEN 0 THEN N'General' WHEN 1 THEN N'Manual' WHEN 2 THEN N'Prepayment' WHEN 3 THEN N'Accrual' WHEN 4 THEN N'Previous Year' WHEN 5 THEN N'Tax Payment' WHEN 6 THEN N'Tax Receipt' WHEN 7 THEN N'Payment' WHEN 8 THEN N'Receipt' ELSE CASE WHEN t.NLNominalTranTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',t.NLNominalTranTypeID) END END AS Kind, t.ExchangeRate AS ExchangeRate, t.Narrative AS Narrative, t.UserName AS UserName, a.AccountNumber AS AccountNumber, a.AccountName AS AccountName, a.AccountCostCentre AS CostCentre, a.AccountDepartment AS Department, N'Current posted record' AS State FROM dbo.NLPostedNominalTran t LEFT JOIN dbo.NLNominalAccount a ON a.NLNominalAccountID=t.NLNominalAccountID WHERE t.NLPostedNominalTranID IS NOT NULL AND t.TransactionDate>=:date_from AND t.TransactionDate<:date_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "7324391D-8358-5BB4-B75E-1173CCC732B6",
"key": "TransactionDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E090F16D-50C3-5228-91D7-2B1CBABB3A9D",
"key": "TransactionKey",
"type": "text"
}
],
"id": "9A223DC5-5274-542E-9C45-3B4704E478BD",
"mappings": [
{
"commonFieldKey": "",
"key": "TransactionKey",
"label": "Internal transaction key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Reference",
"label": "Recorded reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Reference",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BaseValue",
"label": "Value — base currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BaseValue",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Kind",
"label": "Nominal entry kind",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Kind",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ExchangeRate",
"label": "Recorded exchange rate — not a conversion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ExchangeRate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountNumber",
"label": "Account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CostCentre",
"label": "Cost centre reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CostCentre",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Department",
"label": "Department reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Department",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Narrative",
"label": "Recorded narrative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Narrative",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "State",
"label": "Record set",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "State",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Pending nominal transactions",
"primaryKey": "TransactionKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TransactionDate",
"id": "D6EEF8FF-D1C6-5E59-B04F-35CD789E2EF2",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TransactionDate",
"id": "FEC036E2-4267-5D1D-846E-607D17DF0EA9",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Reference",
"BaseValue",
"Kind",
"ExchangeRate",
"AccountNumber",
"CostCentre",
"Department",
"Narrative",
"State"
],
"sourceID": "D87237E9-FBA9-57DA-B15A-D6FE7416AB58",
"sqlQuery": "SELECT t.NLPendNominalTranID AS TransactionKey, t.Reference AS Reference, t.TransactionDate AS TransactionDate, t.GoodsValueInBaseCurrency AS BaseValue, CASE t.NLNominalTranTypeID WHEN 0 THEN N'General' WHEN 1 THEN N'Manual' WHEN 2 THEN N'Prepayment' WHEN 3 THEN N'Accrual' WHEN 4 THEN N'Previous Year' WHEN 5 THEN N'Tax Payment' WHEN 6 THEN N'Tax Receipt' WHEN 7 THEN N'Payment' WHEN 8 THEN N'Receipt' ELSE CASE WHEN t.NLNominalTranTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',t.NLNominalTranTypeID) END END AS Kind, t.ExchangeRate AS ExchangeRate, t.AccountNumber AS AccountNumber, t.AccountCostCentre AS CostCentre, t.AccountDepartment AS Department, t.Narrative AS Narrative, N'Pending — not a posted record' AS State FROM dbo.NLPendNominalTran t WHERE t.NLPendNominalTranID IS NOT NULL AND t.TransactionDate>=:date_from AND t.TransactionDate<:date_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "7324391D-8358-5BB4-B75E-1173CCC732B6",
"key": "TransactionDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E090F16D-50C3-5228-91D7-2B1CBABB3A9D",
"key": "TransactionKey",
"type": "text"
}
],
"id": "41370102-D2A0-54B9-8334-95B9B4A76B8A",
"mappings": [
{
"commonFieldKey": "",
"key": "TransactionKey",
"label": "Internal transaction key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Reference",
"label": "Recorded reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Reference",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BaseValue",
"label": "Value — base currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BaseValue",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Kind",
"label": "Nominal entry kind",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Kind",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ExchangeRate",
"label": "Recorded exchange rate — not a conversion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ExchangeRate",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountNumber",
"label": "Account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CostCentre",
"label": "Cost centre reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CostCentre",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Department",
"label": "Department reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Department",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "State",
"label": "Record set",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "State",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Deferred nominal transactions",
"primaryKey": "TransactionKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TransactionDate",
"id": "898309E8-23C6-5F29-B39F-E383F570BA14",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TransactionDate",
"id": "722BB949-A66F-56E9-9B26-B7FE387FAA09",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"Reference",
"BaseValue",
"Kind",
"ExchangeRate",
"AccountNumber",
"CostCentre",
"Department",
"State"
],
"sourceID": "D87237E9-FBA9-57DA-B15A-D6FE7416AB58",
"sqlQuery": "SELECT t.NLDeferredNominalTranID AS TransactionKey, t.Reference AS Reference, t.TransactionDate AS TransactionDate, t.GoodsValueInBaseCurrency AS BaseValue, CASE t.NLNominalTranTypeID WHEN 0 THEN N'General' WHEN 1 THEN N'Manual' WHEN 2 THEN N'Prepayment' WHEN 3 THEN N'Accrual' WHEN 4 THEN N'Previous Year' WHEN 5 THEN N'Tax Payment' WHEN 6 THEN N'Tax Receipt' WHEN 7 THEN N'Payment' WHEN 8 THEN N'Receipt' ELSE CASE WHEN t.NLNominalTranTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',t.NLNominalTranTypeID) END END AS Kind, t.ExchangeRate AS ExchangeRate, t.AccountNumber AS AccountNumber, t.AccountCostCentre AS CostCentre, t.AccountDepartment AS Department, N'Deferred — not a posted record' AS State FROM dbo.NLDeferredNominalTran t WHERE t.NLDeferredNominalTranID IS NOT NULL AND t.TransactionDate>=:date_from AND t.TransactionDate<:date_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "F0AE32E8-1AF9-598D-A24A-7832A40752E0",
"key": "MemoCreatedAt",
"type": "date"
},
{
"direction": "ascending",
"id": "51279B9E-6348-57DB-9A36-9DA427D01CB2",
"key": "MemoKey",
"type": "text"
}
],
"id": "D85172C6-8BE4-5AE7-A0BC-5544B91BC1B7",
"mappings": [
{
"commonFieldKey": "",
"key": "MemoKey",
"label": "Internal memo key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MemoKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AccountKey",
"label": "Internal account key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MemoText",
"label": "Current account note",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MemoText",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MemoCreatedBy",
"label": "Note creator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MemoCreatedBy",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MemoCreatedAt",
"label": "Note creation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MemoCreatedAt",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MemoActive",
"label": "Note active status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MemoActive",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Current account notes",
"primaryKey": "MemoKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "AccountKey",
"id": "746ADF0D-1F90-594C-AF4B-0B3A7609961B",
"name": "account",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"MemoText",
"MemoCreatedBy",
"MemoActive"
],
"sourceID": "D87237E9-FBA9-57DA-B15A-D6FE7416AB58",
"sqlQuery": "SELECT m.NLAccountMemoID AS MemoKey, m.NLNominalAccountID AS AccountKey, m.MemoText AS MemoText, m.MemoCreatedBy AS MemoCreatedBy, m.TimeAndDateMemoCreated AS MemoCreatedAt, CASE m.Active WHEN 1 THEN N'Yes' WHEN 0 THEN N'No' ELSE N'Not recorded / unknown' END AS MemoActive FROM dbo.NLAccountMemo m WHERE m.NLNominalAccountID=:account AND m.NLAccountMemoID IS NOT NULL",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "9A9B372A-7AAC-5E53-B378-872D5A55F206",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "8101A8D9-7643-52D6-9202-FC5398AF1D49",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "D85172C6-8BE4-5AE7-A0BC-5544B91BC1B7",
"title": "Current account notes",
"urlKey": ""
}
],
"badgeKey": "Kind",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransactionDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BaseValue",
"label": "Value — base currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Narrative",
"label": "Recorded narrative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UserName",
"label": "Recorded operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountNumber",
"label": "Account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CostCentre",
"label": "Cost centre reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Department",
"label": "Department reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "89EB1145-DBA0-5B34-B1BC-8DBEFEDE009E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "Reference",
"label": "Recorded reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "TransactionDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored company-base value — no conversions or totals",
"detailRole": "information",
"isVisible": true,
"key": "BaseValue",
"label": "Value — base currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "Kind",
"label": "Nominal entry kind",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored company-base value — no conversions or totals",
"detailRole": "information",
"isVisible": true,
"key": "ExchangeRate",
"label": "Recorded exchange rate — not a conversion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "Narrative",
"label": "Recorded narrative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "UserName",
"label": "Recorded operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current account-master context",
"detailRole": "information",
"isVisible": true,
"key": "AccountNumber",
"label": "Account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current account-master context",
"detailRole": "information",
"isVisible": true,
"key": "AccountName",
"label": "Current account name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current account-master context",
"detailRole": "information",
"isVisible": true,
"key": "CostCentre",
"label": "Cost centre reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current account-master context",
"detailRole": "information",
"isVisible": true,
"key": "Department",
"label": "Department reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "State",
"label": "Record set",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "32F9A2D6-63F5-5325-A3EA-532CF626B0FB",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "ADCEC67E-BDA0-55DB-93BA-0EA36BC6E711",
"includeAllOption": false,
"key": "TransactionDate",
"title": "Choose a transaction-date period",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "7324391D-8358-5BB4-B75E-1173CCC732B6",
"key": "TransactionDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E090F16D-50C3-5228-91D7-2B1CBABB3A9D",
"key": "TransactionKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountName",
"systemImage": "doc.text",
"title": "Nominal: posted",
"titleKey": "Reference"
},
{
"actions": [],
"badgeKey": "Kind",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransactionDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BaseValue",
"label": "Value — base currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CostCentre",
"label": "Cost centre reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Department",
"label": "Department reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Narrative",
"label": "Recorded narrative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "9A223DC5-5274-542E-9C45-3B4704E478BD",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "Reference",
"label": "Recorded reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "TransactionDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored company-base value — no conversions or totals",
"detailRole": "information",
"isVisible": true,
"key": "BaseValue",
"label": "Value — base currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "Kind",
"label": "Nominal entry kind",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored company-base value — no conversions or totals",
"detailRole": "information",
"isVisible": true,
"key": "ExchangeRate",
"label": "Recorded exchange rate — not a conversion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded account references — account may not exist yet",
"detailRole": "information",
"isVisible": true,
"key": "AccountNumber",
"label": "Account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded account references — account may not exist yet",
"detailRole": "information",
"isVisible": true,
"key": "CostCentre",
"label": "Cost centre reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded account references — account may not exist yet",
"detailRole": "information",
"isVisible": true,
"key": "Department",
"label": "Department reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "Narrative",
"label": "Recorded narrative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "State",
"label": "Record set",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "903DD6A0-348D-56A4-9625-94A73EFAA418",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "ADCEC67E-BDA0-55DB-93BA-0EA36BC6E711",
"includeAllOption": false,
"key": "TransactionDate",
"title": "Choose a transaction-date period",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "7324391D-8358-5BB4-B75E-1173CCC732B6",
"key": "TransactionDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E090F16D-50C3-5228-91D7-2B1CBABB3A9D",
"key": "TransactionKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountNumber",
"systemImage": "doc.text",
"title": "Nominal: pending",
"titleKey": "Reference"
},
{
"actions": [],
"badgeKey": "Kind",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TransactionDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BaseValue",
"label": "Value — base currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CostCentre",
"label": "Cost centre reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Department",
"label": "Department reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "41370102-D2A0-54B9-8334-95B9B4A76B8A",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "Reference",
"label": "Recorded reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "TransactionDate",
"label": "Transaction date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored company-base value — no conversions or totals",
"detailRole": "information",
"isVisible": true,
"key": "BaseValue",
"label": "Value — base currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "Kind",
"label": "Nominal entry kind",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stored company-base value — no conversions or totals",
"detailRole": "information",
"isVisible": true,
"key": "ExchangeRate",
"label": "Recorded exchange rate — not a conversion",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded account references — account may not exist yet",
"detailRole": "information",
"isVisible": true,
"key": "AccountNumber",
"label": "Account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded account references — account may not exist yet",
"detailRole": "information",
"isVisible": true,
"key": "CostCentre",
"label": "Cost centre reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded account references — account may not exist yet",
"detailRole": "information",
"isVisible": true,
"key": "Department",
"label": "Department reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded nominal entry",
"detailRole": "information",
"isVisible": true,
"key": "State",
"label": "Record set",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "3392921D-22BD-51FC-B220-AC694FF12CA4",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "ADCEC67E-BDA0-55DB-93BA-0EA36BC6E711",
"includeAllOption": false,
"key": "TransactionDate",
"title": "Choose a transaction-date period",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "7324391D-8358-5BB4-B75E-1173CCC732B6",
"key": "TransactionDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E090F16D-50C3-5228-91D7-2B1CBABB3A9D",
"key": "TransactionKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AccountNumber",
"systemImage": "doc.text",
"title": "Nominal: deferred",
"titleKey": "Reference"
},
{
"actions": [],
"badgeKey": "MemoActive",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MemoCreatedAt",
"label": "Note creation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "D85172C6-8BE4-5AE7-A0BC-5544B91BC1B7",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current account notes — not transaction-date notes",
"detailRole": "information",
"isVisible": true,
"key": "MemoText",
"label": "Current account note",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current account notes — not transaction-date notes",
"detailRole": "information",
"isVisible": true,
"key": "MemoCreatedBy",
"label": "Note creator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current account notes — not transaction-date notes",
"detailRole": "information",
"isVisible": true,
"key": "MemoCreatedAt",
"label": "Note creation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current account notes — not transaction-date notes",
"detailRole": "information",
"isVisible": true,
"key": "MemoActive",
"label": "Note active status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "4E96E44A-9FD3-5297-A4F2-B8A0C4970E37",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "F0AE32E8-1AF9-598D-A24A-7832A40752E0",
"key": "MemoCreatedAt",
"type": "date"
},
{
"direction": "ascending",
"id": "51279B9E-6348-57DB-9A36-9DA427D01CB2",
"key": "MemoKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "MemoCreatedBy",
"systemImage": "doc.text",
"title": "Current account notes",
"titleKey": "MemoText"
}
],
"relations": [
{
"childDatasetID": "D85172C6-8BE4-5AE7-A0BC-5544B91BC1B7",
"childKey": "AccountKey",
"id": "8101A8D9-7643-52D6-9202-FC5398AF1D49",
"name": "Current account notes",
"parentDatasetID": "89EB1145-DBA0-5B34-B1BC-8DBEFEDE009E",
"parentKey": "AccountKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "Sage 200 Professional UK",
"configurationLanguages": [
"en"
],
"countries": [
"GB"
],
"createdAt": "2026-10-10T00:00:00Z",
"description": "DOCUMENTARY AND SYNTHETIC VALIDATION ONLY — not tested on a real Sage 200 installation. For finance staff, accountants and managers: choose a transaction-date period and inspect current posted nominal entries with their recorded company-base value, reference, narrative, operator and nominal entry kind. See current account, cost-centre and department references, and open account notes on demand. Two separate Home buttons show pending and deferred waiting postings, including account references that may not exist in the account master yet. Search loaded rows or use Cifru local filters to focus on an account or centre.\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\nPro: one separately authorised company SQL Server source, three Home screens, four bounded live lists/Details and one lazy related button. SELECT only, at most 2,000 rows per read, no periodic refresh. Each main screen requests a native opening period; SQL uses both the inclusive start and exclusive end for transaction dates. The note button binds the selected account; account notes are current account context, not limited to the transaction-date period. Limits and filters are not an ACL, completeness or cheap-query guarantee. Check installed indexes, execution plans, timeouts and least-privilege reader permissions; SQL does not inherit Sage user roles. Narratives, operator names and account notes may be sensitive. Authorise the scope before connecting.\n\nUNOFFICIAL, not affiliated with Sage. Selected complete physical labels and kind values are documented in the partial Sage 200 2015 database guide, November 2014. This is not full DDL, a complete company schema or current-edition certification. Requires compatible dbo objects: dbo is an adapter requirement, not an observed installed owner. Ask the administrator to verify ownership, exact installed columns/types, key uniqueness, nullability, status meanings and access before import. Not Sage 200 Standard, Evolution, Sage 300 or an API template.\n\nRecorded values are in the company base currency, not assumed GBP. Confirm that currency with the company administrator; no guessed symbol or currency code is displayed. Values and exchange rates preserve source strings rather than force two-decimal rounding. Exchange rates are context only: no conversion is calculated. No document-currency amount, debit/credit inference from signs, aggregation, balances, aging, trial balance, profit-and-loss or tax/payment reconciliation. A native kind named Payment or Receipt does not prove an invoice is paid. Posted, pending and deferred tables are never combined or summed. Current account names and account notes are not historical snapshots of a transaction. Missing account masters, blank references and unknown kind/status values are retained. Inactive notes remain identifiable. No archived nominal records, held journals or guessed cross-module URN joins. Choosing a date period does not make this a historical account balance. No credentials, server addresses or business rows in the package.\n\nPrimary physical reference: https://desktophelp.sage.co.uk/sage200/PDF/2015/Understanding%20the%20Sage%20200%202015%20Database.pdf\nNominal transaction enquiry and currency context: https://desktophelp.sage.co.uk/sage200/professional/Content/NL/TransactionEnquiry.htm\n\nGallery coverage: Eight representative native images show all three selected complete main cards, all four selected populated Details routes, and the actual account-note list/action. All 35 useful Details positions are paired with exact invented input. The posted Details first view is complete; its near-identical overlap view is retained privately rather than duplicated in this gallery. Blank, unknown, negative and inactive examples are retained. Additional private PNG/XML viewports and raw bookmarks are preserved for later film editing. This is not every record/viewport, whole-video approval, a real ERP/SQL Server test, installed currency/ACL/constraint certification or a full accounting report.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "2146ADBD-59A0-5A9E-8A1A-D92BE58369E3",
"rootButtonCount": 3,
"summary": "Three separate period enquiries, recorded company-base values, account context and on-demand account notes.",
"tags": [
"Sage 200 Professional UK",
"SQL Server",
"Accounting",
"Nominal ledger",
"Pending postings",
"Pro"
],
"title": "Nominal transactions: posted, pending and deferred — Pro"
}
}