Sales orders: delivery dates, lines and despatch references — Pro
Order and line delivery dates, native statuses, allocations and despatch/invoice references on demand.
DOCUMENTARY AND SYNTHETIC VALIDATION ONLY — not tested on a real Sage 200 installation. For sales, customer service, warehouse coordination and managers: choose an order-date period, find standard sales orders and compare requested and promised delivery dates. Inspect customer references, current customer names, order and print statuses, priority and analysis reference. Open all recorded lines, including free text, additional charges and comments, with their own delivery dates, nominal and analysis references. From a line, inspect allocation dates/operators/picking print values and despatch, receipt and invoice references. This is an operational dates-and-references dossier, not a financial, quantity or fulfilment-completion report.
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 authorised company SQL Server source, four lists, four Details screens and three on-demand related buttons. Custom read-only SELECT; up to 2,000 rows per read, live reads, no periodic refresh. Native opening period filters select order dates, not delivery dates. Local search and filters affect loaded rows only. Row limits do not guarantee complete results or a cheap query; check execution plans and source timeouts. Child reads recheck the internal order and line IDs, never the human document number. The SQL database reader must be separately authorised: navigation filters do not inherit Sage UI permissions. Free-text descriptions and operator names may be sensitive; restrict access accordingly.
UNOFFICIAL, not affiliated with Sage. Physical identifiers and translated native status values are based on the partial Sage 200 2015 database guide (November 2014), not full DDL or a current-installation guarantee. Requires the selected dbo objects and the same documented semantics in a company database. Verify installed version, schema, keys, data types, nullability, status mappings and authorisation before import. Not Sage 200 Standard, Evolution, Sage 300 or an API template.
No quantities, prices, monetary totals, currency assumptions, outstanding-delivery subtraction or cross-unit aggregates are included: their exact SQL basis has not yet been proved. A despatch or recorded invoice reference does not certify posting, payment or full delivery. The native IsInvoiced flag is displayed as such, not as a paid/posted status. Picking-list print values remain untranslated native values. Standard orders only (document type 0 in the selected legacy guide); unknown status values remain visible. Current customer names are not historical document snapshots. Line descriptions remain recorded values, including blanks; they are not silently replaced from the current product master. Linked despatch headers are shown only if they also belong to this selected order; unmatched line records remain visible with blank header fields. The old guide warns migrated Line 50/100 orders may lack this traceability history. Missing dates/references are not invented. No source credentials, server addresses or business rows are packaged. Gallery images are native Cifru captures with wholly fictional DEMO data.
Primary physical reference: https://desktophelp.sage.co.uk/sage200/PDF/2015/Understanding%20the%20Sage%20200%202015%20Database.pdf
Order enquiry: https://desktophelp.sage.co.uk/sage200/professional/Content/SOP/ViewSalesOrder.htm
Gallery coverage: Eight representative images show the complete selected root and three child cards, all four selected Details routes and all three actions. The line continuation includes every non-header Details value and both buttons; its item/type header is shown on the matching selected line card. The other initial line Details viewport, opening list/filter and all private continuations remain retained. All 49 configured useful Details positions are paired with exact fictional input; this is not every record/viewport, raw video approval or a real ERP/SQL Server/current-edition certificate.
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Sales order operations
- Details: Order lines and dates
- Details: Allocation records
- Details: Despatch and invoice references
- Sub-button: Order lines and dates
- Sub-button: Line allocation records
- Sub-button: Line despatch references
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 o.SOPOrderReturnID AS OrderKey, o.DocumentNo AS OrderNo, o.DocumentDate AS OrderDate, a.CustomerAccountNumber AS CustomerRef, a.CustomerAccountName AS CustomerName, o.CustomerDocumentNo AS CustomerDocumentNo, CASE o.DocumentStatusID WHEN 0 THEN N'Live' WHEN 1 THEN N'On Hold' WHEN 2 THEN N'Completed' WHEN 3 THEN N'Dispute' WHEN 4 THEN N'Cancelled' ELSE CASE WHEN o.DocumentStatusID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',o.DocumentStatusID) END END AS OrderStatus, CASE o.DocumentPrintStatusID WHEN 0 THEN N'Not Printed' WHEN 1 THEN N'Printed' WHEN 2 THEN N'Amended Since Last Printed' ELSE CASE WHEN o.DocumentPrintStatusID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',o.DocumentPrintStatusID) END END AS PrintStatus, o.RequestedDeliveryDate AS OrderRequestedDate, o.PromisedDeliveryDate AS OrderPromisedDate, o.Priority AS Priority, o.AnalysisCode1 AS OrderAnalysis FROM dbo.SOPOrderReturn o LEFT JOIN dbo.SLCustomerAccount a ON a.SLCustomerAccountID=o.CustomerID WHERE o.DocumentTypeID=0 AND o.SOPOrderReturnID IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT o.SOPOrderReturnID AS OrderKey, l.SOPOrderReturnLineID AS LineKey, o.DocumentNo AS OrderNo, l.PrintSequenceNumber AS Sequence, CASE l.LineTypeID WHEN 0 THEN N'Standard Item' WHEN 1 THEN N'Free Text Item' WHEN 2 THEN N'Additional Charge' WHEN 3 THEN N'Comment Line' ELSE CASE WHEN l.LineTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',l.LineTypeID) END END AS LineType, l.ItemCode AS ItemCode, l.ItemDescription AS ItemDescription, l.RequestedDeliveryDate AS LineRequestedDate, l.PromisedDeliveryDate AS LinePromisedDate, l.NominalAccountRef AS AccountRef, l.NominalCostCentre AS CostCentre, l.NominalDepartment AS Department, l.AnalysisCode1 AS Analysis1, l.AnalysisCode2 AS Analysis2, l.AnalysisCode3 AS Analysis3, l.AnalysisCode4 AS Analysis4, l.AnalysisCode5 AS Analysis5, l.AnalysisCode6 AS Analysis6, CASE l.ShowOnCustomerDocs WHEN 1 THEN N'Yes' WHEN 0 THEN N'No' ELSE N'Not recorded / unknown' END AS ShowOnDocuments FROM dbo.SOPOrderReturnLine l INNER JOIN dbo.SOPOrderReturn o ON o.SOPOrderReturnID=l.SOPOrderReturnID WHERE o.DocumentTypeID=0 AND o.SOPOrderReturnID=:order AND l.SOPOrderReturnLineID IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT o.SOPOrderReturnID AS OrderKey, l.SOPOrderReturnLineID AS LineKey, o.DocumentNo AS OrderNo, l.ItemCode AS ItemCode, l.ItemDescription AS ItemDescription, v.SOPAllocationLineID AS AllocationKey, v.AllocatedDate AS AllocatedDate, v.UserName AS AllocatedBy, v.OrderNumber AS AllocationOrderNo, v.ItemCode AS AllocationItemCode, v.PickingListPrintStatusID AS PickingPrint FROM dbo.SOPAllocationLine v INNER JOIN dbo.SOPOrderReturnLine l ON l.SOPOrderReturnLineID=v.SOPOrderReturnLineID INNER JOIN dbo.SOPOrderReturn o ON o.SOPOrderReturnID=l.SOPOrderReturnID WHERE o.DocumentTypeID=0 AND o.SOPOrderReturnID=:order AND l.SOPOrderReturnLineID=:line AND v.SOPAllocationLineID IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT o.SOPOrderReturnID AS OrderKey, l.SOPOrderReturnLineID AS LineKey, o.DocumentNo AS OrderNo, l.ItemCode AS ItemCode, l.ItemDescription AS ItemDescription, v.SOPDespatchReceiptLineID AS DespatchLineKey, v.DespatchReceiptNo AS DespatchNo, v.DespatchReceiptDate AS DespatchDate, v.OrderReturnNo AS RecordedOrderNo, v.InvoiceCreditNo AS InvoiceRef, v.UserName AS DespatchBy, CASE v.IsInvoiced WHEN 1 THEN N'Yes' WHEN 0 THEN N'No' ELSE N'Not recorded / unknown' END AS InvoicedFlag, CASE h.SOPDespatchReceiptTypeID WHEN 0 THEN N'Despatch Note' WHEN 1 THEN N'Receipt' ELSE CASE WHEN h.SOPDespatchReceiptTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',h.SOPDespatchReceiptTypeID) END END AS DocumentKind, h.DocumentNo AS HeaderDocumentNo, h.DespatchReceiptDate AS HeaderDate, h.UserName AS HeaderBy FROM dbo.SOPDespatchReceiptLine v INNER JOIN dbo.SOPOrderReturnLine l ON l.SOPOrderReturnLineID=v.SOPOrderReturnLineID INNER JOIN dbo.SOPOrderReturn o ON o.SOPOrderReturnID=l.SOPOrderReturnID LEFT JOIN dbo.SOPDespatchReceipt h ON h.SOPDespatchReceiptID=v.SOPDespatchReceiptID AND h.SOPOrderID=o.SOPOrderReturnID WHERE o.DocumentTypeID=0 AND o.SOPOrderReturnID=:order AND l.SOPOrderReturnLineID=:line AND v.SOPDespatchReceiptLineID 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": "D6CE55B7-44FC-5D95-91BB-05A7DF3DECB2",
"kind": "sqlServer",
"requiredObjects": [
"dbo.SLCustomerAccount",
"dbo.SOPAllocationLine",
"dbo.SOPDespatchReceipt",
"dbo.SOPDespatchReceiptLine",
"dbo.SOPOrderReturn",
"dbo.SOPOrderReturnLine"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "06F66C5F-BEE4-553C-95FB-23A18095B576",
"key": "OrderDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"id": "4904AB3B-00CA-533D-AA89-E5D9A8415AFE",
"mappings": [
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Internal order key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderNo",
"label": "Selected sales order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderDate",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CustomerRef",
"label": "Customer account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerRef",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerName",
"label": "Current customer name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CustomerDocumentNo",
"label": "Customer order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerDocumentNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderStatus",
"label": "Order status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PrintStatus",
"label": "Order print status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PrintStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderRequestedDate",
"label": "Order requested delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderRequestedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderPromisedDate",
"label": "Order promised delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderPromisedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Priority",
"label": "Order priority — native value",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Priority",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderAnalysis",
"label": "Order analysis code 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderAnalysis",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Sales order operations",
"primaryKey": "OrderKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"OrderNo",
"CustomerRef",
"CustomerName",
"CustomerDocumentNo",
"OrderStatus",
"PrintStatus",
"OrderAnalysis"
],
"sourceID": "D6CE55B7-44FC-5D95-91BB-05A7DF3DECB2",
"sqlQuery": "SELECT o.SOPOrderReturnID AS OrderKey, o.DocumentNo AS OrderNo, o.DocumentDate AS OrderDate, a.CustomerAccountNumber AS CustomerRef, a.CustomerAccountName AS CustomerName, o.CustomerDocumentNo AS CustomerDocumentNo, CASE o.DocumentStatusID WHEN 0 THEN N'Live' WHEN 1 THEN N'On Hold' WHEN 2 THEN N'Completed' WHEN 3 THEN N'Dispute' WHEN 4 THEN N'Cancelled' ELSE CASE WHEN o.DocumentStatusID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',o.DocumentStatusID) END END AS OrderStatus, CASE o.DocumentPrintStatusID WHEN 0 THEN N'Not Printed' WHEN 1 THEN N'Printed' WHEN 2 THEN N'Amended Since Last Printed' ELSE CASE WHEN o.DocumentPrintStatusID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',o.DocumentPrintStatusID) END END AS PrintStatus, o.RequestedDeliveryDate AS OrderRequestedDate, o.PromisedDeliveryDate AS OrderPromisedDate, o.Priority AS Priority, o.AnalysisCode1 AS OrderAnalysis FROM dbo.SOPOrderReturn o LEFT JOIN dbo.SLCustomerAccount a ON a.SLCustomerAccountID=o.CustomerID WHERE o.DocumentTypeID=0 AND o.SOPOrderReturnID IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "F36B0E1D-F75F-5D6F-AF7A-A271F48FED7A",
"key": "Sequence",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "24AC0B13-0254-53E7-84EA-CDFA3C2DF15B",
"mappings": [
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Internal order key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Internal line key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderNo",
"label": "Selected sales order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Sequence",
"label": "Printed line sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Sequence",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineType",
"label": "Document line type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Document item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemDescription",
"label": "Recorded line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemDescription",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineRequestedDate",
"label": "Line requested delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineRequestedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LinePromisedDate",
"label": "Line promised delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LinePromisedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountRef",
"label": "Nominal account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountRef",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CostCentre",
"label": "Nominal cost centre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CostCentre",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Department",
"label": "Nominal department",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Department",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Analysis1",
"label": "Line analysis code 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Analysis1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Analysis2",
"label": "Line analysis code 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Analysis2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Analysis3",
"label": "Line analysis code 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Analysis3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Analysis4",
"label": "Line analysis code 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Analysis4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Analysis5",
"label": "Line analysis code 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Analysis5",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Analysis6",
"label": "Line analysis code 6",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Analysis6",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShowOnDocuments",
"label": "Show line on customer documents",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ShowOnDocuments",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Order lines and dates",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderKey",
"id": "7370C123-817C-51DF-92B6-366A5D650814",
"name": "order",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"OrderNo",
"LineType",
"ItemCode",
"ItemDescription",
"AccountRef",
"CostCentre",
"Department",
"Analysis1",
"Analysis2",
"Analysis3",
"Analysis4",
"Analysis5",
"Analysis6",
"ShowOnDocuments"
],
"sourceID": "D6CE55B7-44FC-5D95-91BB-05A7DF3DECB2",
"sqlQuery": "SELECT o.SOPOrderReturnID AS OrderKey, l.SOPOrderReturnLineID AS LineKey, o.DocumentNo AS OrderNo, l.PrintSequenceNumber AS Sequence, CASE l.LineTypeID WHEN 0 THEN N'Standard Item' WHEN 1 THEN N'Free Text Item' WHEN 2 THEN N'Additional Charge' WHEN 3 THEN N'Comment Line' ELSE CASE WHEN l.LineTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',l.LineTypeID) END END AS LineType, l.ItemCode AS ItemCode, l.ItemDescription AS ItemDescription, l.RequestedDeliveryDate AS LineRequestedDate, l.PromisedDeliveryDate AS LinePromisedDate, l.NominalAccountRef AS AccountRef, l.NominalCostCentre AS CostCentre, l.NominalDepartment AS Department, l.AnalysisCode1 AS Analysis1, l.AnalysisCode2 AS Analysis2, l.AnalysisCode3 AS Analysis3, l.AnalysisCode4 AS Analysis4, l.AnalysisCode5 AS Analysis5, l.AnalysisCode6 AS Analysis6, CASE l.ShowOnCustomerDocs WHEN 1 THEN N'Yes' WHEN 0 THEN N'No' ELSE N'Not recorded / unknown' END AS ShowOnDocuments FROM dbo.SOPOrderReturnLine l INNER JOIN dbo.SOPOrderReturn o ON o.SOPOrderReturnID=l.SOPOrderReturnID WHERE o.DocumentTypeID=0 AND o.SOPOrderReturnID=:order AND l.SOPOrderReturnLineID IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "49855B14-FEEF-52AF-AFA1-E61C92968177",
"key": "AllocatedDate",
"type": "date"
},
{
"direction": "ascending",
"id": "05298CA0-52AE-5059-A69C-ACE2FC4F7EFD",
"key": "AllocationKey",
"type": "text"
}
],
"id": "0F9EBE58-D488-5E5A-AFB2-F74BCDA49F8D",
"mappings": [
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Internal order key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Internal line key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderNo",
"label": "Selected sales order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Document item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemDescription",
"label": "Recorded line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemDescription",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocationKey",
"label": "Internal allocation record key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocatedDate",
"label": "Allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocatedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocatedBy",
"label": "Allocation operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocatedBy",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AllocationOrderNo",
"label": "Recorded allocation order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationOrderNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AllocationItemCode",
"label": "Recorded allocation item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AllocationItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PickingPrint",
"label": "Picking list print status — native value",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PickingPrint",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Line allocation records",
"primaryKey": "AllocationKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderKey",
"id": "7370C123-817C-51DF-92B6-366A5D650814",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "LineKey",
"id": "DDFCDCFA-9F6D-56D3-8061-575A74A62041",
"name": "line",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"OrderNo",
"ItemCode",
"ItemDescription",
"AllocatedBy",
"AllocationOrderNo",
"AllocationItemCode",
"PickingPrint"
],
"sourceID": "D6CE55B7-44FC-5D95-91BB-05A7DF3DECB2",
"sqlQuery": "SELECT o.SOPOrderReturnID AS OrderKey, l.SOPOrderReturnLineID AS LineKey, o.DocumentNo AS OrderNo, l.ItemCode AS ItemCode, l.ItemDescription AS ItemDescription, v.SOPAllocationLineID AS AllocationKey, v.AllocatedDate AS AllocatedDate, v.UserName AS AllocatedBy, v.OrderNumber AS AllocationOrderNo, v.ItemCode AS AllocationItemCode, v.PickingListPrintStatusID AS PickingPrint FROM dbo.SOPAllocationLine v INNER JOIN dbo.SOPOrderReturnLine l ON l.SOPOrderReturnLineID=v.SOPOrderReturnLineID INNER JOIN dbo.SOPOrderReturn o ON o.SOPOrderReturnID=l.SOPOrderReturnID WHERE o.DocumentTypeID=0 AND o.SOPOrderReturnID=:order AND l.SOPOrderReturnLineID=:line AND v.SOPAllocationLineID IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "F50F1C6A-6AEA-52A8-A76C-FBD94ED21033",
"key": "DespatchDate",
"type": "date"
},
{
"direction": "ascending",
"id": "40B12BAC-1FA9-5FD6-8DFF-2E1C3382F6B3",
"key": "DespatchLineKey",
"type": "text"
}
],
"id": "28419BD4-73E9-5673-A380-F61DB52593BE",
"mappings": [
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Internal order key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Internal line key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderNo",
"label": "Selected sales order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Document item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemDescription",
"label": "Recorded line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemDescription",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DespatchLineKey",
"label": "Internal despatch line key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DespatchLineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DespatchNo",
"label": "Recorded despatch/receipt reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DespatchNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DespatchDate",
"label": "Recorded line despatch/receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DespatchDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "RecordedOrderNo",
"label": "Recorded despatch line order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RecordedOrderNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceRef",
"label": "Recorded invoice/credit reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceRef",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DespatchBy",
"label": "Despatch line operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DespatchBy",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoicedFlag",
"label": "Line invoiced flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoicedFlag",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocumentKind",
"label": "Linked header document type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentKind",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderDocumentNo",
"label": "Linked header reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderDocumentNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderDate",
"label": "Linked header despatch/receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderBy",
"label": "Linked header operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderBy",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Line despatch references",
"primaryKey": "DespatchLineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderKey",
"id": "7370C123-817C-51DF-92B6-366A5D650814",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "LineKey",
"id": "DDFCDCFA-9F6D-56D3-8061-575A74A62041",
"name": "line",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"OrderNo",
"ItemCode",
"ItemDescription",
"DespatchNo",
"RecordedOrderNo",
"InvoiceRef",
"DespatchBy",
"InvoicedFlag",
"DocumentKind",
"HeaderDocumentNo",
"HeaderBy"
],
"sourceID": "D6CE55B7-44FC-5D95-91BB-05A7DF3DECB2",
"sqlQuery": "SELECT o.SOPOrderReturnID AS OrderKey, l.SOPOrderReturnLineID AS LineKey, o.DocumentNo AS OrderNo, l.ItemCode AS ItemCode, l.ItemDescription AS ItemDescription, v.SOPDespatchReceiptLineID AS DespatchLineKey, v.DespatchReceiptNo AS DespatchNo, v.DespatchReceiptDate AS DespatchDate, v.OrderReturnNo AS RecordedOrderNo, v.InvoiceCreditNo AS InvoiceRef, v.UserName AS DespatchBy, CASE v.IsInvoiced WHEN 1 THEN N'Yes' WHEN 0 THEN N'No' ELSE N'Not recorded / unknown' END AS InvoicedFlag, CASE h.SOPDespatchReceiptTypeID WHEN 0 THEN N'Despatch Note' WHEN 1 THEN N'Receipt' ELSE CASE WHEN h.SOPDespatchReceiptTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',h.SOPDespatchReceiptTypeID) END END AS DocumentKind, h.DocumentNo AS HeaderDocumentNo, h.DespatchReceiptDate AS HeaderDate, h.UserName AS HeaderBy FROM dbo.SOPDespatchReceiptLine v INNER JOIN dbo.SOPOrderReturnLine l ON l.SOPOrderReturnLineID=v.SOPOrderReturnLineID INNER JOIN dbo.SOPOrderReturn o ON o.SOPOrderReturnID=l.SOPOrderReturnID LEFT JOIN dbo.SOPDespatchReceipt h ON h.SOPDespatchReceiptID=v.SOPDespatchReceiptID AND h.SOPOrderID=o.SOPOrderReturnID WHERE o.DocumentTypeID=0 AND o.SOPOrderReturnID=:order AND l.SOPOrderReturnLineID=:line AND v.SOPDespatchReceiptLineID IS NOT NULL",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "964FB15C-40A7-5400-BD8D-4E27366552EA",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "837F0AD0-1730-5E1A-BB45-31E09FA95411",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "24AC0B13-0254-53E7-84EA-CDFA3C2DF15B",
"title": "Order lines and dates",
"urlKey": ""
}
],
"badgeKey": "OrderStatus",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderDate",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CustomerDocumentNo",
"label": "Customer order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PrintStatus",
"label": "Order print status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderRequestedDate",
"label": "Order requested delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderPromisedDate",
"label": "Order promised delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "4904AB3B-00CA-533D-AA89-E5D9A8415AFE",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Order identity and current customer",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected sales order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order identity and current customer",
"detailRole": "information",
"isVisible": true,
"key": "OrderDate",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order identity and current customer",
"detailRole": "information",
"isVisible": true,
"key": "CustomerRef",
"label": "Customer account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order identity and current customer",
"detailRole": "information",
"isVisible": true,
"key": "CustomerName",
"label": "Current customer name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order identity and current customer",
"detailRole": "information",
"isVisible": true,
"key": "CustomerDocumentNo",
"label": "Customer order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order identity and current customer",
"detailRole": "information",
"isVisible": true,
"key": "OrderStatus",
"label": "Order status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order identity and current customer",
"detailRole": "information",
"isVisible": true,
"key": "PrintStatus",
"label": "Order print status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order delivery dates and native defaults",
"detailRole": "information",
"isVisible": true,
"key": "OrderRequestedDate",
"label": "Order requested delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order delivery dates and native defaults",
"detailRole": "information",
"isVisible": true,
"key": "OrderPromisedDate",
"label": "Order promised delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order delivery dates and native defaults",
"detailRole": "information",
"isVisible": true,
"key": "Priority",
"label": "Order priority — native value",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order delivery dates and native defaults",
"detailRole": "information",
"isVisible": true,
"key": "OrderAnalysis",
"label": "Order analysis code 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "BAC51691-5569-5087-BFE1-B775035F1752",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "28F36E55-CFEF-5A84-9350-A3ECF5848E42",
"includeAllOption": false,
"key": "OrderDate",
"title": "Choose an order-date period",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "06F66C5F-BEE4-553C-95FB-23A18095B576",
"key": "OrderDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "CustomerName",
"systemImage": "doc.text",
"title": "Sales order operations",
"titleKey": "OrderNo"
},
{
"actions": [
{
"id": "8BC0699A-57B5-5DE8-9FB0-C45184305564",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "62C36EDD-65E1-5DEE-A6D6-8BE77B4C04AE",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "0F9EBE58-D488-5E5A-AFB2-F74BCDA49F8D",
"title": "Allocation records",
"urlKey": ""
},
{
"id": "A686EBF3-27E6-5C2D-9620-2BFE00732892",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "55BE4CF0-28B2-5BE8-9B49-30E7A110E847",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "28419BD4-73E9-5673-A380-F61DB52593BE",
"title": "Despatch and invoice references",
"urlKey": ""
}
],
"badgeKey": "LineType",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected sales order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Sequence",
"label": "Printed line sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineRequestedDate",
"label": "Line requested delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LinePromisedDate",
"label": "Line promised delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CostCentre",
"label": "Nominal cost centre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Department",
"label": "Nominal department",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "24AC0B13-0254-53E7-84EA-CDFA3C2DF15B",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded document line",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected sales order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded document line",
"detailRole": "information",
"isVisible": true,
"key": "Sequence",
"label": "Printed line sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded document line",
"detailRole": "information",
"isVisible": true,
"key": "LineType",
"label": "Document line type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded document line",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Document item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded document line",
"detailRole": "information",
"isVisible": true,
"key": "ItemDescription",
"label": "Recorded line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded document line",
"detailRole": "information",
"isVisible": true,
"key": "LineRequestedDate",
"label": "Line requested delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded document line",
"detailRole": "information",
"isVisible": true,
"key": "LinePromisedDate",
"label": "Line promised delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "AccountRef",
"label": "Nominal account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "CostCentre",
"label": "Nominal cost centre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "Department",
"label": "Nominal department",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "Analysis1",
"label": "Line analysis code 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "Analysis2",
"label": "Line analysis code 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "Analysis3",
"label": "Line analysis code 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "Analysis4",
"label": "Line analysis code 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "Analysis5",
"label": "Line analysis code 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "Analysis6",
"label": "Line analysis code 6",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded document line",
"detailRole": "information",
"isVisible": true,
"key": "ShowOnDocuments",
"label": "Show line on customer documents",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "79E2298D-E710-53C5-A3C2-4A360D07E00B",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "F36B0E1D-F75F-5D6F-AF7A-A271F48FED7A",
"key": "Sequence",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemCode",
"systemImage": "doc.text",
"title": "Order lines and dates",
"titleKey": "ItemDescription"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected sales order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Document item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocatedDate",
"label": "Allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AllocatedBy",
"label": "Allocation operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PickingPrint",
"label": "Picking list print status — native value",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "0F9EBE58-D488-5E5A-AFB2-F74BCDA49F8D",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded allocation",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected sales order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded allocation",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Document item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded allocation",
"detailRole": "information",
"isVisible": true,
"key": "ItemDescription",
"label": "Recorded line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded allocation",
"detailRole": "information",
"isVisible": true,
"key": "AllocatedDate",
"label": "Allocation date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded allocation",
"detailRole": "information",
"isVisible": true,
"key": "AllocatedBy",
"label": "Allocation operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded allocation",
"detailRole": "information",
"isVisible": true,
"key": "AllocationOrderNo",
"label": "Recorded allocation order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded allocation",
"detailRole": "information",
"isVisible": true,
"key": "AllocationItemCode",
"label": "Recorded allocation item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded allocation",
"detailRole": "information",
"isVisible": true,
"key": "PickingPrint",
"label": "Picking list print status — native value",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "E9DC2A10-F6B3-595A-8264-76A9B27B8230",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "49855B14-FEEF-52AF-AFA1-E61C92968177",
"key": "AllocatedDate",
"type": "date"
},
{
"direction": "ascending",
"id": "05298CA0-52AE-5059-A69C-ACE2FC4F7EFD",
"key": "AllocationKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "AllocationItemCode",
"systemImage": "doc.text",
"title": "Line allocation records",
"titleKey": "AllocationOrderNo"
},
{
"actions": [],
"badgeKey": "DocumentKind",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected sales order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Document item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DespatchDate",
"label": "Recorded line despatch/receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceRef",
"label": "Recorded invoice/credit reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DespatchBy",
"label": "Despatch line operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoicedFlag",
"label": "Line invoiced flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "28419BD4-73E9-5673-A380-F61DB52593BE",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded despatch line",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected sales order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded despatch line",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Document item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded despatch line",
"detailRole": "information",
"isVisible": true,
"key": "ItemDescription",
"label": "Recorded line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded despatch line",
"detailRole": "information",
"isVisible": true,
"key": "DespatchNo",
"label": "Recorded despatch/receipt reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded despatch line",
"detailRole": "information",
"isVisible": true,
"key": "DespatchDate",
"label": "Recorded line despatch/receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded despatch line",
"detailRole": "information",
"isVisible": true,
"key": "RecordedOrderNo",
"label": "Recorded despatch line order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded despatch line",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceRef",
"label": "Recorded invoice/credit reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded despatch line",
"detailRole": "information",
"isVisible": true,
"key": "DespatchBy",
"label": "Despatch line operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded despatch line",
"detailRole": "information",
"isVisible": true,
"key": "InvoicedFlag",
"label": "Line invoiced flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Header belonging to this same selected order",
"detailRole": "information",
"isVisible": true,
"key": "DocumentKind",
"label": "Linked header document type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Header belonging to this same selected order",
"detailRole": "information",
"isVisible": true,
"key": "HeaderDocumentNo",
"label": "Linked header reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Header belonging to this same selected order",
"detailRole": "information",
"isVisible": true,
"key": "HeaderDate",
"label": "Linked header despatch/receipt date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Header belonging to this same selected order",
"detailRole": "information",
"isVisible": true,
"key": "HeaderBy",
"label": "Linked header operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "D0D6BCEF-2D38-5034-B66D-198658D7D8E9",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "F50F1C6A-6AEA-52A8-A76C-FBD94ED21033",
"key": "DespatchDate",
"type": "date"
},
{
"direction": "ascending",
"id": "40B12BAC-1FA9-5FD6-8DFF-2E1C3382F6B3",
"key": "DespatchLineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemDescription",
"systemImage": "doc.text",
"title": "Line despatch references",
"titleKey": "DespatchNo"
}
],
"relations": [
{
"childDatasetID": "24AC0B13-0254-53E7-84EA-CDFA3C2DF15B",
"childKey": "OrderKey",
"id": "837F0AD0-1730-5E1A-BB45-31E09FA95411",
"name": "Order lines and dates",
"parentDatasetID": "4904AB3B-00CA-533D-AA89-E5D9A8415AFE",
"parentKey": "OrderKey"
},
{
"childDatasetID": "0F9EBE58-D488-5E5A-AFB2-F74BCDA49F8D",
"childKey": "LineKey",
"id": "62C36EDD-65E1-5DEE-A6D6-8BE77B4C04AE",
"name": "Allocation records",
"parentDatasetID": "24AC0B13-0254-53E7-84EA-CDFA3C2DF15B",
"parentKey": "LineKey"
},
{
"childDatasetID": "28419BD4-73E9-5673-A380-F61DB52593BE",
"childKey": "LineKey",
"id": "55BE4CF0-28B2-5BE8-9B49-30E7A110E847",
"name": "Despatch and invoice references",
"parentDatasetID": "24AC0B13-0254-53E7-84EA-CDFA3C2DF15B",
"parentKey": "LineKey"
}
],
"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 sales, customer service, warehouse coordination and managers: choose an order-date period, find standard sales orders and compare requested and promised delivery dates. Inspect customer references, current customer names, order and print statuses, priority and analysis reference. Open all recorded lines, including free text, additional charges and comments, with their own delivery dates, nominal and analysis references. From a line, inspect allocation dates/operators/picking print values and despatch, receipt and invoice references. This is an operational dates-and-references dossier, not a financial, quantity or fulfilment-completion report.\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 authorised company SQL Server source, four lists, four Details screens and three on-demand related buttons. Custom read-only SELECT; up to 2,000 rows per read, live reads, no periodic refresh. Native opening period filters select order dates, not delivery dates. Local search and filters affect loaded rows only. Row limits do not guarantee complete results or a cheap query; check execution plans and source timeouts. Child reads recheck the internal order and line IDs, never the human document number. The SQL database reader must be separately authorised: navigation filters do not inherit Sage UI permissions. Free-text descriptions and operator names may be sensitive; restrict access accordingly.\n\nUNOFFICIAL, not affiliated with Sage. Physical identifiers and translated native status values are based on the partial Sage 200 2015 database guide (November 2014), not full DDL or a current-installation guarantee. Requires the selected dbo objects and the same documented semantics in a company database. Verify installed version, schema, keys, data types, nullability, status mappings and authorisation before import. Not Sage 200 Standard, Evolution, Sage 300 or an API template.\n\nNo quantities, prices, monetary totals, currency assumptions, outstanding-delivery subtraction or cross-unit aggregates are included: their exact SQL basis has not yet been proved. A despatch or recorded invoice reference does not certify posting, payment or full delivery. The native IsInvoiced flag is displayed as such, not as a paid/posted status. Picking-list print values remain untranslated native values. Standard orders only (document type 0 in the selected legacy guide); unknown status values remain visible. Current customer names are not historical document snapshots. Line descriptions remain recorded values, including blanks; they are not silently replaced from the current product master. Linked despatch headers are shown only if they also belong to this selected order; unmatched line records remain visible with blank header fields. The old guide warns migrated Line 50/100 orders may lack this traceability history. Missing dates/references are not invented. No source credentials, server addresses or business rows are packaged. Gallery images are native Cifru captures with wholly fictional DEMO data.\n\nPrimary physical reference: https://desktophelp.sage.co.uk/sage200/PDF/2015/Understanding%20the%20Sage%20200%202015%20Database.pdf\nOrder enquiry: https://desktophelp.sage.co.uk/sage200/professional/Content/SOP/ViewSalesOrder.htm\n\nGallery coverage: Eight representative images show the complete selected root and three child cards, all four selected Details routes and all three actions. The line continuation includes every non-header Details value and both buttons; its item/type header is shown on the matching selected line card. The other initial line Details viewport, opening list/filter and all private continuations remain retained. All 49 configured useful Details positions are paired with exact fictional input; this is not every record/viewport, raw video approval or a real ERP/SQL Server/current-edition certificate.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "B8F7E7B7-A5D7-52A3-9F24-55A9FFCEEE3E",
"rootButtonCount": 1,
"summary": "Order and line delivery dates, native statuses, allocations and despatch/invoice references on demand.",
"tags": [
"Sage 200 Professional UK",
"SQL Server",
"Sales orders",
"Delivery dates",
"Despatch",
"Pro"
],
"title": "Sales orders: delivery dates, lines and despatch references — Pro"
}
}