Supplier allocations and sessions — Pro
Choose an allocation-date period; inspect supplier allocations, due dates and recorded discounts, with two on-demand session/transaction enquiries.
DOCUMENTARY AND SYNTHETIC VALIDATION ONLY — not tested on a real Sage 200 installation. For purchase-ledger, finance teams and managers: choose a session allocation-date period, inspect current supplier allocations, session date/operator, exact raw allocation value and the linked current transaction's due date, recorded discount and allocated value. Two on-demand sub-buttons show same-supplier entries in that selected session, or other current allocations of the selected transaction across sessions. Compare recorded values without repeating invoice totals across allocations.
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, one Home screen, three bounded live lists with same-row Details and two lazy related actions; up to 2,000 records per read, no periodic refresh. The opening period filters SESSION ALLOCATION DATE before the limit, not invoice date or due date. Child dates may lie outside it. One current allocation is one card, not an invoice or complete session summary. All physical identities are hidden; full identities and uniqueness checks bind and revalidate the selected allocation, header, transaction and supplier. Session entries are limited to the selected supplier; unavailable, ambiguous or different-supplier transaction contexts are not exposed in that sub-list. The transaction-allocations sub-list retains missing/ambiguous header context without inventing a date or operator. The main period register requires a unique existing header; orphan/ambiguous-header allocations cannot be reliably placed in a period and are excluded. Missing or ambiguous current transaction/supplier context is marked, not fabricated.
This is CURRENT allocation-session context, not archived transactions, revaluations, allocation reversals, an as-of creditor balance, an aged-debt report or a bank reconciliation. Raw values preserve source precision as text; verify the installed monetary basis. No currency, total, outstanding/paid status, netting or conversion is inferred. Current transaction AllocatedValue and discounts can repeat on several allocation cards: never sum them as independent values. Allocation date, record creation timestamp and current due date are different facts. Operator names may be confidential.
The independent Purchase Ledger diagram does NOT fully expose current transaction reference/date/kind/tax/query columns or header supplier/kind/completion fields. None are copied from Sales Ledger or inferred from archival columns. This template deliberately does not offer invoice references, invoice type, query status, header completion or payment-kind decoding. The official PL kind legend is recorded separately, not used without a proven source column.
UNOFFICIAL, not affiliated with Sage. Selected complete physical labels/edges come from the partial Sage 200 2015 database guide, November 2014, not full DDL or current-version certification. Compatible dbo objects are an adapter prerequisite, not an observed installed owner. Verify installed owner, columns/types, keys/nullability, data, monetary basis, indexes, execution plans, timeout and permissions before import. A row limit is not a cheap-query guarantee. SQL does not inherit Sage UI permissions; filters and relationship validation are not access control. Use approved least-privilege read-only access to one authorised company. Not Sage 200 Standard/Evolution, Sage 300 or an API template. No credentials, server addresses or business rows in this package.
Primary physical reference: https://desktophelp.sage.co.uk/sage200/PDF/2015/Understanding%20the%20Sage%20200%202015%20Database.pdf
Functional enquiry only, not SQL DDL: https://desktophelp.sage.co.uk/sage200/professional/Content/PL/TransactionEnquiry.htm
Gallery coverage: 7 complementary native Cifru Android DEMO images show the complete main card, all 32 configured useful Details positions across three selected records, and both opened child lists. Session allocation-date period on the main register does not clip other current transaction allocations. Raw allocation values are exact fictional examples, not assumed totals, currency, paid status or bank confirmation. Native dates follow the interface format; the shown creation timestamp is checked exactly as recorded. No internal identity or credential is displayed. Private Home/repeated-list viewports and RAW remain preserved but not approved. Not a real ERP/SQL Server/iOS, installed-key, performance, permissions or purchase test.
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Supplier allocations
- Details: Session entries
- Details: Other allocations
- Sub-button: Session entries
- Sub-button: Other allocations
Sources are mapped locally and verified before applying.
Custom queriesPRO3 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.PLSupplierAccountID AS SupplierKey, a.PLPostedSupplierTranID AS TransactionKey, a.PLAllocationHeaderID AS HeaderKey, a.PLAllocationTranID AS AllocationKey, c.SupplierAccountName AS SupplierName, c.SupplierAccountNumber AS SupplierReference, h.AllocationDate AS AllocationDate, h.UserName AS AllocationOperator, a.AllocationValue AS AllocationValue, a.DateTimeCreated AS AllocationCreatedAt, t.AllocatedValue AS AllocatedValue, t.DueDate AS DueDate, t.DiscountValue AS DiscountValue, t.DiscountPercentage AS DiscountPercentage, t.DaysDiscountValid AS DiscountDays, CASE WHEN c.PLSupplierAccountID IS NULL THEN N'Missing or non-unique supplier master' ELSE N'Current supplier master' END AS SupplierContext, CASE WHEN t.PLPostedSupplierTranID IS NULL THEN N'Missing or non-unique current transaction' ELSE N'Current posted transaction' END AS TransactionContext, CASE WHEN h.PLAllocationHeaderID IS NULL THEN N'Missing or non-unique session header' ELSE N'Current session — not bank confirmation' END AS HeaderContext FROM dbo.PLAllocationTran a INNER JOIN dbo.PLAllocationHeader h ON h.PLAllocationHeaderID=a.PLAllocationHeaderID AND (SELECT COUNT(1) FROM dbo.PLAllocationHeader j WHERE j.PLAllocationHeaderID=a.PLAllocationHeaderID)=1 LEFT JOIN dbo.PLPostedSupplierTran t ON t.PLPostedSupplierTranID=a.PLPostedSupplierTranID AND (SELECT COUNT(1) FROM dbo.PLPostedSupplierTran x WHERE x.PLPostedSupplierTranID=a.PLPostedSupplierTranID)=1 LEFT JOIN dbo.PLSupplierAccount c ON c.PLSupplierAccountID=t.PLSupplierAccountID AND (SELECT COUNT(1) FROM dbo.PLSupplierAccount v WHERE v.PLSupplierAccountID=t.PLSupplierAccountID)=1 WHERE a.PLAllocationTranID IS NOT NULL AND (SELECT COUNT(1) FROM dbo.PLAllocationTran u WHERE u.PLAllocationTranID=a.PLAllocationTranID)=1
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(LEN(CONCAT(o.PLAllocationTranID)), N':', o.PLAllocationTranID, N':', a.PLAllocationTranID) AS RelatedKey, o.PLAllocationTranID AS OriginAllocationKey, o.PLAllocationHeaderID AS OriginHeaderKey, p.PLPostedSupplierTranID AS OriginTransactionKey, p.PLSupplierAccountID AS OriginSupplierKey, t.PLSupplierAccountID AS SupplierKey, a.PLPostedSupplierTranID AS TransactionKey, a.PLAllocationHeaderID AS HeaderKey, a.PLAllocationTranID AS AllocationKey, c.SupplierAccountName AS SupplierName, c.SupplierAccountNumber AS SupplierReference, h.AllocationDate AS AllocationDate, h.UserName AS AllocationOperator, a.AllocationValue AS AllocationValue, a.DateTimeCreated AS AllocationCreatedAt, t.AllocatedValue AS AllocatedValue, t.DueDate AS DueDate, t.DiscountValue AS DiscountValue, t.DiscountPercentage AS DiscountPercentage, t.DaysDiscountValid AS DiscountDays, CASE WHEN c.PLSupplierAccountID IS NULL THEN N'Missing or non-unique supplier master' ELSE N'Current supplier master' END AS SupplierContext, CASE WHEN t.PLPostedSupplierTranID IS NULL THEN N'Missing or non-unique current transaction' ELSE N'Current posted transaction' END AS TransactionContext, CASE WHEN h.PLAllocationHeaderID IS NULL THEN N'Missing or non-unique session header' ELSE N'Current session — not bank confirmation' END AS HeaderContext FROM dbo.PLAllocationTran a INNER JOIN dbo.PLAllocationTran o ON o.PLAllocationTranID=:allocation INNER JOIN dbo.PLPostedSupplierTran p ON p.PLPostedSupplierTranID=o.PLPostedSupplierTranID INNER JOIN dbo.PLAllocationHeader h ON h.PLAllocationHeaderID=a.PLAllocationHeaderID AND (SELECT COUNT(1) FROM dbo.PLAllocationHeader j WHERE j.PLAllocationHeaderID=a.PLAllocationHeaderID)=1 INNER JOIN dbo.PLPostedSupplierTran t ON t.PLPostedSupplierTranID=a.PLPostedSupplierTranID AND t.PLSupplierAccountID=p.PLSupplierAccountID AND (SELECT COUNT(1) FROM dbo.PLPostedSupplierTran x WHERE x.PLPostedSupplierTranID=a.PLPostedSupplierTranID)=1 LEFT JOIN dbo.PLSupplierAccount c ON c.PLSupplierAccountID=t.PLSupplierAccountID AND (SELECT COUNT(1) FROM dbo.PLSupplierAccount v WHERE v.PLSupplierAccountID=t.PLSupplierAccountID)=1 WHERE a.PLAllocationHeaderID=o.PLAllocationHeaderID AND a.PLAllocationTranID IS NOT NULL AND (SELECT COUNT(1) FROM dbo.PLAllocationTran u WHERE u.PLAllocationTranID=a.PLAllocationTranID)=1 AND o.PLAllocationTranID=:allocation AND o.PLAllocationHeaderID=:header AND o.PLPostedSupplierTranID=:transaction AND p.PLSupplierAccountID=:supplier AND (SELECT COUNT(1) FROM dbo.PLAllocationTran z WHERE z.PLAllocationTranID=o.PLAllocationTranID)=1 AND (SELECT COUNT(1) FROM dbo.PLPostedSupplierTran k WHERE k.PLPostedSupplierTranID=p.PLPostedSupplierTranID)=1
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(LEN(CONCAT(o.PLAllocationTranID)), N':', o.PLAllocationTranID, N':', a.PLAllocationTranID) AS RelatedKey, o.PLAllocationTranID AS OriginAllocationKey, o.PLAllocationHeaderID AS OriginHeaderKey, p.PLPostedSupplierTranID AS OriginTransactionKey, p.PLSupplierAccountID AS OriginSupplierKey, t.PLSupplierAccountID AS SupplierKey, a.PLPostedSupplierTranID AS TransactionKey, a.PLAllocationHeaderID AS HeaderKey, a.PLAllocationTranID AS AllocationKey, c.SupplierAccountName AS SupplierName, c.SupplierAccountNumber AS SupplierReference, h.AllocationDate AS AllocationDate, h.UserName AS AllocationOperator, a.AllocationValue AS AllocationValue, a.DateTimeCreated AS AllocationCreatedAt, t.AllocatedValue AS AllocatedValue, t.DueDate AS DueDate, t.DiscountValue AS DiscountValue, t.DiscountPercentage AS DiscountPercentage, t.DaysDiscountValid AS DiscountDays, CASE WHEN c.PLSupplierAccountID IS NULL THEN N'Missing or non-unique supplier master' ELSE N'Current supplier master' END AS SupplierContext, CASE WHEN t.PLPostedSupplierTranID IS NULL THEN N'Missing or non-unique current transaction' ELSE N'Current posted transaction' END AS TransactionContext, CASE WHEN h.PLAllocationHeaderID IS NULL THEN N'Missing or non-unique session header' ELSE N'Current session — not bank confirmation' END AS HeaderContext FROM dbo.PLAllocationTran a INNER JOIN dbo.PLAllocationTran o ON o.PLAllocationTranID=:allocation INNER JOIN dbo.PLPostedSupplierTran p ON p.PLPostedSupplierTranID=o.PLPostedSupplierTranID INNER JOIN dbo.PLPostedSupplierTran t ON t.PLPostedSupplierTranID=a.PLPostedSupplierTranID AND t.PLSupplierAccountID=p.PLSupplierAccountID AND (SELECT COUNT(1) FROM dbo.PLPostedSupplierTran x WHERE x.PLPostedSupplierTranID=a.PLPostedSupplierTranID)=1 LEFT JOIN dbo.PLAllocationHeader h ON h.PLAllocationHeaderID=a.PLAllocationHeaderID AND (SELECT COUNT(1) FROM dbo.PLAllocationHeader j WHERE j.PLAllocationHeaderID=a.PLAllocationHeaderID)=1 LEFT JOIN dbo.PLSupplierAccount c ON c.PLSupplierAccountID=t.PLSupplierAccountID AND (SELECT COUNT(1) FROM dbo.PLSupplierAccount v WHERE v.PLSupplierAccountID=t.PLSupplierAccountID)=1 WHERE a.PLPostedSupplierTranID=o.PLPostedSupplierTranID AND a.PLAllocationTranID IS NOT NULL AND (SELECT COUNT(1) FROM dbo.PLAllocationTran u WHERE u.PLAllocationTranID=a.PLAllocationTranID)=1 AND o.PLAllocationTranID=:allocation AND o.PLAllocationHeaderID=:header AND o.PLPostedSupplierTranID=:transaction AND p.PLSupplierAccountID=:supplier AND (SELECT COUNT(1) FROM dbo.PLAllocationTran z WHERE z.PLAllocationTranID=o.PLAllocationTranID)=1 AND (SELECT COUNT(1) FROM dbo.PLPostedSupplierTran k WHERE k.PLPostedSupplierTranID=p.PLPostedSupplierTranID)=1 AND (SELECT COUNT(1) FROM dbo.PLAllocationHeader w WHERE w.PLAllocationHeaderID=o.PLAllocationHeaderID)=1
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "Sage 200 Professional UK — authorised company SQL Server",
"id": "63C23246-7F5E-5373-B85A-053CF5EF1FB0",
"kind": "sqlServer",
"requiredObjects": [
"dbo.PLAllocationHeader",
"dbo.PLAllocationTran",
"dbo.PLPostedSupplierTran",
"dbo.PLSupplierAccount"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "40BA2E5B-F167-5A36-AE4D-362F809A344D",
"key": "AllocationDate",
"type": "date"
},
{
"direction": "ascending",
"id": "05298CA0-52AE-5059-A69C-ACE2FC4F7EFD",
"key": "AllocationKey",
"type": "text"
}
],
"id": "18727DD9-2751-5179-BB6C-A487C96FC16A",
"mappings": [
{
"commonFieldKey": "",
"key": "SupplierKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocationKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Current supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierReference",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierReference",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationDate",
"label": "Session allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationOperator",
"label": "Recorded session operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationOperator",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocationValue",
"label": "Allocation · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationValue",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationCreatedAt",
"label": "Allocation record created",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationCreatedAt",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocatedValue",
"label": "Transaction allocated · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocatedValue",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DueDate",
"label": "Transaction due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DiscountValue",
"label": "Discount · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountValue",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountPercentage",
"label": "Discount percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountPercentage",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountDays",
"label": "Discount validity · days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountDays",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierContext",
"label": "Current supplier context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionContext",
"label": "Current transaction context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderContext",
"label": "Current session context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Supplier allocations",
"primaryKey": "AllocationKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"SupplierName",
"SupplierReference",
"AllocationOperator",
"AllocationValue",
"AllocatedValue",
"DiscountValue",
"DiscountPercentage",
"DiscountDays",
"SupplierContext",
"TransactionContext",
"HeaderContext"
],
"sourceID": "63C23246-7F5E-5373-B85A-053CF5EF1FB0",
"sqlQuery": "SELECT t.PLSupplierAccountID AS SupplierKey, a.PLPostedSupplierTranID AS TransactionKey, a.PLAllocationHeaderID AS HeaderKey, a.PLAllocationTranID AS AllocationKey, c.SupplierAccountName AS SupplierName, c.SupplierAccountNumber AS SupplierReference, h.AllocationDate AS AllocationDate, h.UserName AS AllocationOperator, a.AllocationValue AS AllocationValue, a.DateTimeCreated AS AllocationCreatedAt, t.AllocatedValue AS AllocatedValue, t.DueDate AS DueDate, t.DiscountValue AS DiscountValue, t.DiscountPercentage AS DiscountPercentage, t.DaysDiscountValid AS DiscountDays, CASE WHEN c.PLSupplierAccountID IS NULL THEN N'Missing or non-unique supplier master' ELSE N'Current supplier master' END AS SupplierContext, CASE WHEN t.PLPostedSupplierTranID IS NULL THEN N'Missing or non-unique current transaction' ELSE N'Current posted transaction' END AS TransactionContext, CASE WHEN h.PLAllocationHeaderID IS NULL THEN N'Missing or non-unique session header' ELSE N'Current session — not bank confirmation' END AS HeaderContext FROM dbo.PLAllocationTran a INNER JOIN dbo.PLAllocationHeader h ON h.PLAllocationHeaderID=a.PLAllocationHeaderID AND (SELECT COUNT(1) FROM dbo.PLAllocationHeader j WHERE j.PLAllocationHeaderID=a.PLAllocationHeaderID)=1 LEFT JOIN dbo.PLPostedSupplierTran t ON t.PLPostedSupplierTranID=a.PLPostedSupplierTranID AND (SELECT COUNT(1) FROM dbo.PLPostedSupplierTran x WHERE x.PLPostedSupplierTranID=a.PLPostedSupplierTranID)=1 LEFT JOIN dbo.PLSupplierAccount c ON c.PLSupplierAccountID=t.PLSupplierAccountID AND (SELECT COUNT(1) FROM dbo.PLSupplierAccount v WHERE v.PLSupplierAccountID=t.PLSupplierAccountID)=1 WHERE a.PLAllocationTranID IS NOT NULL AND (SELECT COUNT(1) FROM dbo.PLAllocationTran u WHERE u.PLAllocationTranID=a.PLAllocationTranID)=1",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "40BA2E5B-F167-5A36-AE4D-362F809A344D",
"key": "AllocationDate",
"type": "date"
},
{
"direction": "ascending",
"id": "093216C6-BE60-55DF-A117-99E4B19E7D16",
"key": "RelatedKey",
"type": "text"
}
],
"id": "89FD3CF2-2F8B-5A0B-B063-5581D38F0A27",
"mappings": [
{
"commonFieldKey": "",
"key": "RelatedKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RelatedKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginAllocationKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginAllocationKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginHeaderKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginHeaderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginTransactionKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginTransactionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginSupplierKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginSupplierKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocationKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Current supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierReference",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierReference",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationDate",
"label": "Session allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationOperator",
"label": "Recorded session operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationOperator",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocationValue",
"label": "Allocation · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationValue",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationCreatedAt",
"label": "Allocation record created",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationCreatedAt",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocatedValue",
"label": "Transaction allocated · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocatedValue",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DueDate",
"label": "Transaction due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DiscountValue",
"label": "Discount · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountValue",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountPercentage",
"label": "Discount percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountPercentage",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountDays",
"label": "Discount validity · days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountDays",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierContext",
"label": "Current supplier context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierContext",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionContext",
"label": "Current transaction context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderContext",
"label": "Current session context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Session entries",
"primaryKey": "RelatedKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "AllocationKey",
"id": "C963B1A3-D255-5611-AE86-DB19AABBF8C7",
"name": "allocation",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "HeaderKey",
"id": "E2F2927F-D61D-5056-B816-0A83C428C59E",
"name": "header",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TransactionKey",
"id": "3EFBF63A-91C4-5D7D-BBB7-D9D3FBE0918F",
"name": "transaction",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "SupplierKey",
"id": "ED4A0FF4-3521-52E5-AC7E-A32292114E7B",
"name": "supplier",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"SupplierName",
"SupplierReference",
"AllocationOperator",
"AllocationValue",
"AllocatedValue",
"TransactionContext",
"HeaderContext"
],
"sourceID": "63C23246-7F5E-5373-B85A-053CF5EF1FB0",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(o.PLAllocationTranID)), N':', o.PLAllocationTranID, N':', a.PLAllocationTranID) AS RelatedKey, o.PLAllocationTranID AS OriginAllocationKey, o.PLAllocationHeaderID AS OriginHeaderKey, p.PLPostedSupplierTranID AS OriginTransactionKey, p.PLSupplierAccountID AS OriginSupplierKey, t.PLSupplierAccountID AS SupplierKey, a.PLPostedSupplierTranID AS TransactionKey, a.PLAllocationHeaderID AS HeaderKey, a.PLAllocationTranID AS AllocationKey, c.SupplierAccountName AS SupplierName, c.SupplierAccountNumber AS SupplierReference, h.AllocationDate AS AllocationDate, h.UserName AS AllocationOperator, a.AllocationValue AS AllocationValue, a.DateTimeCreated AS AllocationCreatedAt, t.AllocatedValue AS AllocatedValue, t.DueDate AS DueDate, t.DiscountValue AS DiscountValue, t.DiscountPercentage AS DiscountPercentage, t.DaysDiscountValid AS DiscountDays, CASE WHEN c.PLSupplierAccountID IS NULL THEN N'Missing or non-unique supplier master' ELSE N'Current supplier master' END AS SupplierContext, CASE WHEN t.PLPostedSupplierTranID IS NULL THEN N'Missing or non-unique current transaction' ELSE N'Current posted transaction' END AS TransactionContext, CASE WHEN h.PLAllocationHeaderID IS NULL THEN N'Missing or non-unique session header' ELSE N'Current session — not bank confirmation' END AS HeaderContext FROM dbo.PLAllocationTran a INNER JOIN dbo.PLAllocationTran o ON o.PLAllocationTranID=:allocation INNER JOIN dbo.PLPostedSupplierTran p ON p.PLPostedSupplierTranID=o.PLPostedSupplierTranID INNER JOIN dbo.PLAllocationHeader h ON h.PLAllocationHeaderID=a.PLAllocationHeaderID AND (SELECT COUNT(1) FROM dbo.PLAllocationHeader j WHERE j.PLAllocationHeaderID=a.PLAllocationHeaderID)=1 INNER JOIN dbo.PLPostedSupplierTran t ON t.PLPostedSupplierTranID=a.PLPostedSupplierTranID AND t.PLSupplierAccountID=p.PLSupplierAccountID AND (SELECT COUNT(1) FROM dbo.PLPostedSupplierTran x WHERE x.PLPostedSupplierTranID=a.PLPostedSupplierTranID)=1 LEFT JOIN dbo.PLSupplierAccount c ON c.PLSupplierAccountID=t.PLSupplierAccountID AND (SELECT COUNT(1) FROM dbo.PLSupplierAccount v WHERE v.PLSupplierAccountID=t.PLSupplierAccountID)=1 WHERE a.PLAllocationHeaderID=o.PLAllocationHeaderID AND a.PLAllocationTranID IS NOT NULL AND (SELECT COUNT(1) FROM dbo.PLAllocationTran u WHERE u.PLAllocationTranID=a.PLAllocationTranID)=1 AND o.PLAllocationTranID=:allocation AND o.PLAllocationHeaderID=:header AND o.PLPostedSupplierTranID=:transaction AND p.PLSupplierAccountID=:supplier AND (SELECT COUNT(1) FROM dbo.PLAllocationTran z WHERE z.PLAllocationTranID=o.PLAllocationTranID)=1 AND (SELECT COUNT(1) FROM dbo.PLPostedSupplierTran k WHERE k.PLPostedSupplierTranID=p.PLPostedSupplierTranID)=1",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "40BA2E5B-F167-5A36-AE4D-362F809A344D",
"key": "AllocationDate",
"type": "date"
},
{
"direction": "ascending",
"id": "093216C6-BE60-55DF-A117-99E4B19E7D16",
"key": "RelatedKey",
"type": "text"
}
],
"id": "F1B734C5-4744-5E0B-9EF8-D220F526DD62",
"mappings": [
{
"commonFieldKey": "",
"key": "RelatedKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RelatedKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginAllocationKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginAllocationKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginHeaderKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginHeaderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginTransactionKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginTransactionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OriginSupplierKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OriginSupplierKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocationKey",
"label": "Internal identity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Current supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierReference",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierReference",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationDate",
"label": "Session allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationOperator",
"label": "Recorded session operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationOperator",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocationValue",
"label": "Allocation · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationValue",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationCreatedAt",
"label": "Allocation record created",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationCreatedAt",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocatedValue",
"label": "Transaction allocated · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocatedValue",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DueDate",
"label": "Transaction due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DueDate",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountValue",
"label": "Discount · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountValue",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountPercentage",
"label": "Discount percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountPercentage",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountDays",
"label": "Discount validity · days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountDays",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierContext",
"label": "Current supplier context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierContext",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransactionContext",
"label": "Current transaction context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransactionContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderContext",
"label": "Current session context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderContext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Other allocations",
"primaryKey": "RelatedKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "AllocationKey",
"id": "C963B1A3-D255-5611-AE86-DB19AABBF8C7",
"name": "allocation",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "HeaderKey",
"id": "E2F2927F-D61D-5056-B816-0A83C428C59E",
"name": "header",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "TransactionKey",
"id": "3EFBF63A-91C4-5D7D-BBB7-D9D3FBE0918F",
"name": "transaction",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "SupplierKey",
"id": "ED4A0FF4-3521-52E5-AC7E-A32292114E7B",
"name": "supplier",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"SupplierName",
"SupplierReference",
"AllocationOperator",
"AllocationValue",
"TransactionContext",
"HeaderContext"
],
"sourceID": "63C23246-7F5E-5373-B85A-053CF5EF1FB0",
"sqlQuery": "SELECT CONCAT(LEN(CONCAT(o.PLAllocationTranID)), N':', o.PLAllocationTranID, N':', a.PLAllocationTranID) AS RelatedKey, o.PLAllocationTranID AS OriginAllocationKey, o.PLAllocationHeaderID AS OriginHeaderKey, p.PLPostedSupplierTranID AS OriginTransactionKey, p.PLSupplierAccountID AS OriginSupplierKey, t.PLSupplierAccountID AS SupplierKey, a.PLPostedSupplierTranID AS TransactionKey, a.PLAllocationHeaderID AS HeaderKey, a.PLAllocationTranID AS AllocationKey, c.SupplierAccountName AS SupplierName, c.SupplierAccountNumber AS SupplierReference, h.AllocationDate AS AllocationDate, h.UserName AS AllocationOperator, a.AllocationValue AS AllocationValue, a.DateTimeCreated AS AllocationCreatedAt, t.AllocatedValue AS AllocatedValue, t.DueDate AS DueDate, t.DiscountValue AS DiscountValue, t.DiscountPercentage AS DiscountPercentage, t.DaysDiscountValid AS DiscountDays, CASE WHEN c.PLSupplierAccountID IS NULL THEN N'Missing or non-unique supplier master' ELSE N'Current supplier master' END AS SupplierContext, CASE WHEN t.PLPostedSupplierTranID IS NULL THEN N'Missing or non-unique current transaction' ELSE N'Current posted transaction' END AS TransactionContext, CASE WHEN h.PLAllocationHeaderID IS NULL THEN N'Missing or non-unique session header' ELSE N'Current session — not bank confirmation' END AS HeaderContext FROM dbo.PLAllocationTran a INNER JOIN dbo.PLAllocationTran o ON o.PLAllocationTranID=:allocation INNER JOIN dbo.PLPostedSupplierTran p ON p.PLPostedSupplierTranID=o.PLPostedSupplierTranID INNER JOIN dbo.PLPostedSupplierTran t ON t.PLPostedSupplierTranID=a.PLPostedSupplierTranID AND t.PLSupplierAccountID=p.PLSupplierAccountID AND (SELECT COUNT(1) FROM dbo.PLPostedSupplierTran x WHERE x.PLPostedSupplierTranID=a.PLPostedSupplierTranID)=1 LEFT JOIN dbo.PLAllocationHeader h ON h.PLAllocationHeaderID=a.PLAllocationHeaderID AND (SELECT COUNT(1) FROM dbo.PLAllocationHeader j WHERE j.PLAllocationHeaderID=a.PLAllocationHeaderID)=1 LEFT JOIN dbo.PLSupplierAccount c ON c.PLSupplierAccountID=t.PLSupplierAccountID AND (SELECT COUNT(1) FROM dbo.PLSupplierAccount v WHERE v.PLSupplierAccountID=t.PLSupplierAccountID)=1 WHERE a.PLPostedSupplierTranID=o.PLPostedSupplierTranID AND a.PLAllocationTranID IS NOT NULL AND (SELECT COUNT(1) FROM dbo.PLAllocationTran u WHERE u.PLAllocationTranID=a.PLAllocationTranID)=1 AND o.PLAllocationTranID=:allocation AND o.PLAllocationHeaderID=:header AND o.PLPostedSupplierTranID=:transaction AND p.PLSupplierAccountID=:supplier AND (SELECT COUNT(1) FROM dbo.PLAllocationTran z WHERE z.PLAllocationTranID=o.PLAllocationTranID)=1 AND (SELECT COUNT(1) FROM dbo.PLPostedSupplierTran k WHERE k.PLPostedSupplierTranID=p.PLPostedSupplierTranID)=1 AND (SELECT COUNT(1) FROM dbo.PLAllocationHeader w WHERE w.PLAllocationHeaderID=o.PLAllocationHeaderID)=1",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "BC88A92A-603E-585C-ADE5-892267739576",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "7BF22812-AE10-54CA-8833-44FB397FA0D4",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "89FD3CF2-2F8B-5A0B-B063-5581D38F0A27",
"title": "Session entries",
"urlKey": ""
},
{
"id": "7E583672-EA5B-57A5-AB04-F5D462009AFD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "F28346B1-901A-5955-98BD-D43295502B56",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "F1B734C5-4744-5E0B-9EF8-D220F526DD62",
"title": "Other allocations",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocationDate",
"label": "Session allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocationValue",
"label": "Allocation · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocatedValue",
"label": "Transaction allocated · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Transaction due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "18727DD9-2751-5179-BB6C-A487C96FC16A",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current supplier",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Current supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current supplier",
"detailRole": "information",
"isVisible": true,
"key": "SupplierReference",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationDate",
"label": "Session allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationOperator",
"label": "Recorded session operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationValue",
"label": "Allocation · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationCreatedAt",
"label": "Allocation record created",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current transaction context",
"detailRole": "information",
"isVisible": true,
"key": "AllocatedValue",
"label": "Transaction allocated · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current transaction context",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Transaction due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current transaction context",
"detailRole": "information",
"isVisible": true,
"key": "DiscountValue",
"label": "Discount · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current transaction context",
"detailRole": "information",
"isVisible": true,
"key": "DiscountPercentage",
"label": "Discount percentage",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current transaction context",
"detailRole": "information",
"isVisible": true,
"key": "DiscountDays",
"label": "Discount validity · days",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current supplier",
"detailRole": "information",
"isVisible": true,
"key": "SupplierContext",
"label": "Current supplier context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current transaction context",
"detailRole": "information",
"isVisible": true,
"key": "TransactionContext",
"label": "Current transaction context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "HeaderContext",
"label": "Current session context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "33A1BFF0-0080-5E99-A7F9-A89154FC7890",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "B4B78FDF-1C6C-5A15-8B88-975F185BA444",
"includeAllOption": false,
"key": "AllocationDate",
"title": "Choose a session allocation-date period",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "40BA2E5B-F167-5A36-AE4D-362F809A344D",
"key": "AllocationDate",
"type": "date"
},
{
"direction": "ascending",
"id": "05298CA0-52AE-5059-A69C-ACE2FC4F7EFD",
"key": "AllocationKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "SupplierReference",
"systemImage": "doc.text",
"title": "Supplier allocations",
"titleKey": "SupplierName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SupplierReference",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocationDate",
"label": "Session allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocatedValue",
"label": "Transaction allocated · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Transaction due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "89FD3CF2-2F8B-5A0B-B063-5581D38F0A27",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current supplier",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Current supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current supplier",
"detailRole": "information",
"isVisible": true,
"key": "SupplierReference",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationDate",
"label": "Session allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationOperator",
"label": "Recorded session operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationValue",
"label": "Allocation · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationCreatedAt",
"label": "Allocation record created",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current transaction context",
"detailRole": "information",
"isVisible": true,
"key": "AllocatedValue",
"label": "Transaction allocated · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current transaction context",
"detailRole": "information",
"isVisible": true,
"key": "DueDate",
"label": "Transaction due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current transaction context",
"detailRole": "information",
"isVisible": true,
"key": "TransactionContext",
"label": "Current transaction context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "HeaderContext",
"label": "Current session context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "1146E5A0-6A19-5A74-9903-D854EE05A4D4",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "40BA2E5B-F167-5A36-AE4D-362F809A344D",
"key": "AllocationDate",
"type": "date"
},
{
"direction": "ascending",
"id": "093216C6-BE60-55DF-A117-99E4B19E7D16",
"key": "RelatedKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "SupplierName",
"systemImage": "doc.text",
"title": "Session entries",
"titleKey": "AllocationValue"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SupplierReference",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocationDate",
"label": "Session allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "F1B734C5-4744-5E0B-9EF8-D220F526DD62",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Current supplier",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Current supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current supplier",
"detailRole": "information",
"isVisible": true,
"key": "SupplierReference",
"label": "Supplier account",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationDate",
"label": "Session allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationOperator",
"label": "Recorded session operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationValue",
"label": "Allocation · raw",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "AllocationCreatedAt",
"label": "Allocation record created",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Current transaction context",
"detailRole": "information",
"isVisible": true,
"key": "TransactionContext",
"label": "Current transaction context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "This allocation and session",
"detailRole": "information",
"isVisible": true,
"key": "HeaderContext",
"label": "Current session context",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "1FF632E9-1A0C-57DE-B191-F54DD21E8CBE",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "40BA2E5B-F167-5A36-AE4D-362F809A344D",
"key": "AllocationDate",
"type": "date"
},
{
"direction": "ascending",
"id": "093216C6-BE60-55DF-A117-99E4B19E7D16",
"key": "RelatedKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "SupplierName",
"systemImage": "doc.text",
"title": "Other allocations",
"titleKey": "AllocationValue"
}
],
"relations": [
{
"childDatasetID": "89FD3CF2-2F8B-5A0B-B063-5581D38F0A27",
"childKey": "OriginAllocationKey",
"id": "7BF22812-AE10-54CA-8833-44FB397FA0D4",
"name": "Session entries",
"parentDatasetID": "18727DD9-2751-5179-BB6C-A487C96FC16A",
"parentKey": "AllocationKey"
},
{
"childDatasetID": "F1B734C5-4744-5E0B-9EF8-D220F526DD62",
"childKey": "OriginAllocationKey",
"id": "F28346B1-901A-5955-98BD-D43295502B56",
"name": "Other allocations",
"parentDatasetID": "18727DD9-2751-5179-BB6C-A487C96FC16A",
"parentKey": "AllocationKey"
}
],
"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 purchase-ledger, finance teams and managers: choose a session allocation-date period, inspect current supplier allocations, session date/operator, exact raw allocation value and the linked current transaction's due date, recorded discount and allocated value. Two on-demand sub-buttons show same-supplier entries in that selected session, or other current allocations of the selected transaction across sessions. Compare recorded values without repeating invoice totals across allocations.\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, one Home screen, three bounded live lists with same-row Details and two lazy related actions; up to 2,000 records per read, no periodic refresh. The opening period filters SESSION ALLOCATION DATE before the limit, not invoice date or due date. Child dates may lie outside it. One current allocation is one card, not an invoice or complete session summary. All physical identities are hidden; full identities and uniqueness checks bind and revalidate the selected allocation, header, transaction and supplier. Session entries are limited to the selected supplier; unavailable, ambiguous or different-supplier transaction contexts are not exposed in that sub-list. The transaction-allocations sub-list retains missing/ambiguous header context without inventing a date or operator. The main period register requires a unique existing header; orphan/ambiguous-header allocations cannot be reliably placed in a period and are excluded. Missing or ambiguous current transaction/supplier context is marked, not fabricated.\n\nThis is CURRENT allocation-session context, not archived transactions, revaluations, allocation reversals, an as-of creditor balance, an aged-debt report or a bank reconciliation. Raw values preserve source precision as text; verify the installed monetary basis. No currency, total, outstanding/paid status, netting or conversion is inferred. Current transaction AllocatedValue and discounts can repeat on several allocation cards: never sum them as independent values. Allocation date, record creation timestamp and current due date are different facts. Operator names may be confidential.\n\nThe independent Purchase Ledger diagram does NOT fully expose current transaction reference/date/kind/tax/query columns or header supplier/kind/completion fields. None are copied from Sales Ledger or inferred from archival columns. This template deliberately does not offer invoice references, invoice type, query status, header completion or payment-kind decoding. The official PL kind legend is recorded separately, not used without a proven source column.\n\nUNOFFICIAL, not affiliated with Sage. Selected complete physical labels/edges come from the partial Sage 200 2015 database guide, November 2014, not full DDL or current-version certification. Compatible dbo objects are an adapter prerequisite, not an observed installed owner. Verify installed owner, columns/types, keys/nullability, data, monetary basis, indexes, execution plans, timeout and permissions before import. A row limit is not a cheap-query guarantee. SQL does not inherit Sage UI permissions; filters and relationship validation are not access control. Use approved least-privilege read-only access to one authorised company. Not Sage 200 Standard/Evolution, Sage 300 or an API template. No credentials, server addresses or business rows in this package.\n\nPrimary physical reference: https://desktophelp.sage.co.uk/sage200/PDF/2015/Understanding%20the%20Sage%20200%202015%20Database.pdf\nFunctional enquiry only, not SQL DDL: https://desktophelp.sage.co.uk/sage200/professional/Content/PL/TransactionEnquiry.htm\n\nGallery coverage: 7 complementary native Cifru Android DEMO images show the complete main card, all 32 configured useful Details positions across three selected records, and both opened child lists. Session allocation-date period on the main register does not clip other current transaction allocations. Raw allocation values are exact fictional examples, not assumed totals, currency, paid status or bank confirmation. Native dates follow the interface format; the shown creation timestamp is checked exactly as recorded. No internal identity or credential is displayed. Private Home/repeated-list viewports and RAW remain preserved but not approved. Not a real ERP/SQL Server/iOS, installed-key, performance, permissions or purchase test.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "4C1E7FCF-E323-56DA-B7EA-D6D441628176",
"rootButtonCount": 1,
"summary": "Choose an allocation-date period; inspect supplier allocations, due dates and recorded discounts, with two on-demand session/transaction enquiries.",
"tags": [
"Sage 200 Professional UK",
"SQL Server",
"Purchase ledger",
"Supplier allocations",
"Accounting",
"Pro"
],
"title": "Supplier allocations and sessions — Pro"
}
}