Purchase orders: lines, receipts and invoice references — Pro
Order delivery dates, supplier parts, recorded line receipts and invoice/dispute references on demand.
DOCUMENTARY AND SYNTHETIC VALIDATION ONLY — not tested on a real Sage 200 installation. For purchasing, receiving, supplier-invoice coordination and managers: choose an order-date period, find purchase orders and inspect the requested delivery date, supplier reference, current supplier name, native order/print statuses, originator and analysis references. Open all recorded lines, including free text, charges and comments. Follow each line to its receipt and invoice/credit references, dates, operators and optional dispute context. An operational enquiry, not a complete financial, quantity, outstanding or payment 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 separately authorised company SQL Server reader, four bounded live lists/Details and three lazy related buttons. Read-only SELECT, at most 2,000 results per read, no periodic refresh. Native opening period selects order dates, not historical balances or all receipt/invoice dates. Child reads revalidate both internal order and line keys, never a human document number. Row caps/filters are not an ACL, completeness or cheap-query guarantee. Check installed indexes, execution plans and timeouts. SQL does not inherit Sage UI permissions. Operator names, references and free text may be sensitive; authorise only the required scope.
UNOFFICIAL, not affiliated with Sage. Selected physical identifiers and status legends are from the partial Sage 200 2015 database guide, November 2014. Not full DDL or current-version compatibility certification. Requires compatible dbo objects; verify installed edition, ownership, keys/uniqueness, types, status meanings and permissions before import. Not Sage 200 Standard, Evolution, Sage 300 or an API template.
No quantities, prices, monetary totals, currency, conversions, outstanding subtraction or cross-unit aggregates. Authorisation/dispute codes remain raw native values, not decoded guesses. Missing, blank and unknown values are preserved. Current supplier names are not historical snapshots; recorded line descriptions and supplier part references are not replaced from a current stock master. Only type-0 purchase orders in the legacy guide; returns/archives/cancelled-line history are not included. A recorded invoice/credit line is not an A/P invoice, paid/posted proof or a complete matching report. The receipt header may cover lines from several orders and is not incorrectly restricted to a nonexistent header order key. Its dates/reference/narrative are distinct from those of the receipt line. Invoice dispute headers are optional: absent or foreign-supplier dispute context does not remove the invoice line or certify no dispute/payment. No receipt-to-invoice cross join or totals across unrelated records. Traceable batch/serial records and bridge matching are not included. No source credentials, server addresses or business rows in the package. Gallery images are native Cifru with wholly fictional DEMO data.
Primary physical reference: https://desktophelp.sage.co.uk/sage200/PDF/2015/Understanding%20the%20Sage%20200%202015%20Database.pdf
Purchase enquiry: https://desktophelp.sage.co.uk/sage200/professional/Content/POP/POP%20enquiries.htm
Gallery coverage: Eight representative images show the complete selected order, order-line and invoice-reference cards, all four selected Details routes and all three actions. The order and order-line continuations use their own matching complete cards for header values. Receipt Details includes its continuation with the complete narrative; the receipt-list card is retained privately, not shown in this gallery. All 61 useful Details positions are paired with exact fictional input. All 14 private PNG/XML viewports and raw pending footage remain retained. This is not every record/viewport, whole-video approval or real ERP/SQL Server/current-edition certification.
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Purchase order operations
- Details: Purchase order lines
- Details: Receipt references
- Details: Invoice and dispute references
- Sub-button: Purchase order lines
- Sub-button: Line receipt references
- Sub-button: Line invoice and dispute 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.POPOrderReturnID AS OrderKey, o.DocumentNo AS OrderNo, o.DocumentDate AS OrderDate, a.SupplierAccountNumber AS SupplierRef, a.SupplierAccountName AS SupplierName, o.SupplierDocumentNo AS SupplierOrderRef, 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 RequestedDate, o.DocumentCreatedBy AS CreatedBy, o.AuthorisationStatusID AS Authorisation, o.SourceDocumentNo AS SourceDocumentNo, o.AnalysisCode1 AS OrderAnalysis1, o.AnalysisCode2 AS OrderAnalysis2, o.AnalysisCode3 AS OrderAnalysis3, o.AnalysisCode4 AS OrderAnalysis4, o.AnalysisCode5 AS OrderAnalysis5, o.AnalysisCode6 AS OrderAnalysis6 FROM dbo.POPOrderReturn o LEFT JOIN dbo.PLSupplierAccount a ON a.PLSupplierAccountID=o.SupplierID WHERE o.DocumentTypeID=0 AND o.POPOrderReturnID IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT o.POPOrderReturnID AS OrderKey, l.POPOrderReturnLineID 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.SupplierPartRef AS SupplierPartRef, l.NominalAccountRef AS AccountRef, l.NominalCostCentre AS CostCentre, l.NominalDepartment AS Department, l.AnalysisCode1 AS LineAnalysis1, l.AnalysisCode2 AS LineAnalysis2, l.AnalysisCode3 AS LineAnalysis3, l.AnalysisCode4 AS LineAnalysis4, l.AnalysisCode5 AS LineAnalysis5, l.AnalysisCode6 AS LineAnalysis6, CASE l.ShowOnSupplierDocs WHEN 1 THEN N'Yes' WHEN 0 THEN N'No' ELSE N'Not recorded / unknown' END AS ShowOnDocuments FROM dbo.POPOrderReturnLine l INNER JOIN dbo.POPOrderReturn o ON o.POPOrderReturnID=l.POPOrderReturnID WHERE o.DocumentTypeID=0 AND o.POPOrderReturnID=:order AND l.POPOrderReturnLineID IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT o.POPOrderReturnID AS OrderKey, l.POPOrderReturnLineID AS LineKey, o.DocumentNo AS OrderNo, l.ItemCode AS ItemCode, l.ItemDescription AS ItemDescription, v.POPReceiptReturnLineID AS ReceiptLineKey, v.ReceiptReturnNo AS ReceiptNo, v.ReceiptReturnDate AS ReceiptDate, v.UserName AS ReceiptBy, v.OrderReturnNo AS RecordedOrderNo, v.BinName AS BinName, CASE v.POPRcptRtnLineSourceID WHEN 0 THEN N'GRN' WHEN 1 THEN N'Invoice or Credit' ELSE CASE WHEN v.POPRcptRtnLineSourceID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',v.POPRcptRtnLineSourceID) END END AS ReceiptSource, h.DocumentNo AS HeaderNo, CASE h.POPReceiptReturnTypeID WHEN 0 THEN N'Receipt' WHEN 1 THEN N'Despatch' ELSE CASE WHEN h.POPReceiptReturnTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',h.POPReceiptReturnTypeID) END END AS HeaderKind, h.DocumentDate AS HeaderDate, h.SupplierDocumentNo AS SupplierReceiptRef, h.SupplierDocumentDate AS SupplierReceiptDate, h.Narrative AS ReceiptNarrative, h.UserName AS HeaderBy FROM dbo.POPReceiptReturnLine v INNER JOIN dbo.POPOrderReturnLine l ON l.POPOrderReturnLineID=v.POPOrderReturnLineID INNER JOIN dbo.POPOrderReturn o ON o.POPOrderReturnID=l.POPOrderReturnID LEFT JOIN dbo.POPReceiptReturn h ON h.POPReceiptReturnID=v.POPReceiptReturnID WHERE o.DocumentTypeID=0 AND o.POPOrderReturnID=:order AND l.POPOrderReturnLineID=:line AND v.POPReceiptReturnLineID IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT o.POPOrderReturnID AS OrderKey, l.POPOrderReturnLineID AS LineKey, o.DocumentNo AS OrderNo, l.ItemCode AS ItemCode, l.ItemDescription AS ItemDescription, v.POPInvoiceCreditLineID AS InvoiceLineKey, v.POPInvoiceCreditNo AS InvoiceNo, v.InvoiceCreditDate AS InvoiceDate, v.UserName AS InvoiceBy, CASE v.IsDisputed WHEN 1 THEN N'Yes' WHEN 0 THEN N'No' ELSE N'Not recorded / unknown' END AS Disputed, h.DocumentNo AS DisputeNo, h.DocumentDate AS DisputeDate, h.DocumentDueDate AS DisputeDueDate, h.DisputeComment AS DisputeComment, h.POPDisputeCodeID AS DisputeCode FROM dbo.POPInvoiceCreditLine v INNER JOIN dbo.POPOrderReturnLine l ON l.POPOrderReturnLineID=v.POPOrderReturnLineID INNER JOIN dbo.POPOrderReturn o ON o.POPOrderReturnID=l.POPOrderReturnID LEFT JOIN dbo.POPInvCredDispute h ON h.POPInvCredDisputeID=v.POPInvCredDisputeID AND h.SupplierID=o.SupplierID WHERE o.DocumentTypeID=0 AND o.POPOrderReturnID=:order AND l.POPOrderReturnLineID=:line AND v.POPInvoiceCreditLineID 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": "15DDCB92-FEA1-5F43-86D0-121353271E07",
"kind": "sqlServer",
"requiredObjects": [
"dbo.PLSupplierAccount",
"dbo.POPInvCredDispute",
"dbo.POPInvoiceCreditLine",
"dbo.POPOrderReturn",
"dbo.POPOrderReturnLine",
"dbo.POPReceiptReturn",
"dbo.POPReceiptReturnLine"
],
"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": "879D0937-A604-5D36-B11B-CD7845612195",
"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 purchase 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": "SupplierRef",
"label": "Current supplier account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierRef",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Current supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SupplierOrderRef",
"label": "Supplier document reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierOrderRef",
"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": "RequestedDate",
"label": "Order requested delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RequestedDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CreatedBy",
"label": "Order originator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CreatedBy",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Authorisation",
"label": "Authorisation status — native value",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Authorisation",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SourceDocumentNo",
"label": "Recorded source document reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SourceDocumentNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderAnalysis1",
"label": "Order analysis code 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderAnalysis1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderAnalysis2",
"label": "Order analysis code 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderAnalysis2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderAnalysis3",
"label": "Order analysis code 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderAnalysis3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderAnalysis4",
"label": "Order analysis code 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderAnalysis4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderAnalysis5",
"label": "Order analysis code 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderAnalysis5",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderAnalysis6",
"label": "Order analysis code 6",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderAnalysis6",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Purchase order operations",
"primaryKey": "OrderKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"OrderNo",
"SupplierRef",
"SupplierName",
"SupplierOrderRef",
"OrderStatus",
"PrintStatus",
"CreatedBy",
"Authorisation",
"SourceDocumentNo",
"OrderAnalysis1",
"OrderAnalysis2",
"OrderAnalysis3",
"OrderAnalysis4",
"OrderAnalysis5",
"OrderAnalysis6"
],
"sourceID": "15DDCB92-FEA1-5F43-86D0-121353271E07",
"sqlQuery": "SELECT o.POPOrderReturnID AS OrderKey, o.DocumentNo AS OrderNo, o.DocumentDate AS OrderDate, a.SupplierAccountNumber AS SupplierRef, a.SupplierAccountName AS SupplierName, o.SupplierDocumentNo AS SupplierOrderRef, 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 RequestedDate, o.DocumentCreatedBy AS CreatedBy, o.AuthorisationStatusID AS Authorisation, o.SourceDocumentNo AS SourceDocumentNo, o.AnalysisCode1 AS OrderAnalysis1, o.AnalysisCode2 AS OrderAnalysis2, o.AnalysisCode3 AS OrderAnalysis3, o.AnalysisCode4 AS OrderAnalysis4, o.AnalysisCode5 AS OrderAnalysis5, o.AnalysisCode6 AS OrderAnalysis6 FROM dbo.POPOrderReturn o LEFT JOIN dbo.PLSupplierAccount a ON a.PLSupplierAccountID=o.SupplierID WHERE o.DocumentTypeID=0 AND o.POPOrderReturnID 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": "EA1752BE-ADD3-5418-8F88-D5E5F2AA91D6",
"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 purchase 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": "Recorded 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": "SupplierPartRef",
"label": "Recorded supplier part reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierPartRef",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountRef",
"label": "Nominal account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountRef",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"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": "LineAnalysis1",
"label": "Line analysis code 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineAnalysis1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineAnalysis2",
"label": "Line analysis code 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineAnalysis2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineAnalysis3",
"label": "Line analysis code 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineAnalysis3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineAnalysis4",
"label": "Line analysis code 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineAnalysis4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineAnalysis5",
"label": "Line analysis code 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineAnalysis5",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineAnalysis6",
"label": "Line analysis code 6",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineAnalysis6",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ShowOnDocuments",
"label": "Show line on supplier documents",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ShowOnDocuments",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Purchase order lines",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderKey",
"id": "A323C9D6-39C1-56E3-A830-BECF2E25AC99",
"name": "order",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"OrderNo",
"LineType",
"ItemCode",
"ItemDescription",
"SupplierPartRef",
"AccountRef",
"CostCentre",
"Department",
"LineAnalysis1",
"LineAnalysis2",
"LineAnalysis3",
"LineAnalysis4",
"LineAnalysis5",
"LineAnalysis6",
"ShowOnDocuments"
],
"sourceID": "15DDCB92-FEA1-5F43-86D0-121353271E07",
"sqlQuery": "SELECT o.POPOrderReturnID AS OrderKey, l.POPOrderReturnLineID 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.SupplierPartRef AS SupplierPartRef, l.NominalAccountRef AS AccountRef, l.NominalCostCentre AS CostCentre, l.NominalDepartment AS Department, l.AnalysisCode1 AS LineAnalysis1, l.AnalysisCode2 AS LineAnalysis2, l.AnalysisCode3 AS LineAnalysis3, l.AnalysisCode4 AS LineAnalysis4, l.AnalysisCode5 AS LineAnalysis5, l.AnalysisCode6 AS LineAnalysis6, CASE l.ShowOnSupplierDocs WHEN 1 THEN N'Yes' WHEN 0 THEN N'No' ELSE N'Not recorded / unknown' END AS ShowOnDocuments FROM dbo.POPOrderReturnLine l INNER JOIN dbo.POPOrderReturn o ON o.POPOrderReturnID=l.POPOrderReturnID WHERE o.DocumentTypeID=0 AND o.POPOrderReturnID=:order AND l.POPOrderReturnLineID IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "1A54A729-C7AB-56B6-ABFA-1299749499C4",
"key": "ReceiptDate",
"type": "date"
},
{
"direction": "ascending",
"id": "49A1AC23-D85A-5ABB-9E2C-537F9E3242FE",
"key": "ReceiptLineKey",
"type": "text"
}
],
"id": "E78221B6-F195-5B75-AEAA-0ECCE641AA00",
"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 purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Recorded 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": true
},
{
"commonFieldKey": "",
"key": "ReceiptLineKey",
"label": "Internal receipt line key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReceiptLineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ReceiptNo",
"label": "Recorded receipt/return reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReceiptNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ReceiptDate",
"label": "Recorded receipt line date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReceiptDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ReceiptBy",
"label": "Receipt line operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReceiptBy",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "RecordedOrderNo",
"label": "Recorded receipt order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RecordedOrderNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BinName",
"label": "Recorded receipt bin name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BinName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ReceiptSource",
"label": "Recorded receipt line source",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReceiptSource",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HeaderNo",
"label": "Linked receipt header reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderKind",
"label": "Linked receipt header kind",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderKind",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderDate",
"label": "Linked receipt header date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierReceiptRef",
"label": "Linked supplier document reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierReceiptRef",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierReceiptDate",
"label": "Linked supplier document date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierReceiptDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ReceiptNarrative",
"label": "Linked receipt header narrative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ReceiptNarrative",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderBy",
"label": "Linked receipt header operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderBy",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Line receipt references",
"primaryKey": "ReceiptLineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderKey",
"id": "A323C9D6-39C1-56E3-A830-BECF2E25AC99",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "LineKey",
"id": "CD581712-12BD-5AE5-8247-CF392F1DEA70",
"name": "line",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"OrderNo",
"ItemCode",
"ItemDescription",
"ReceiptNo",
"ReceiptBy",
"RecordedOrderNo",
"BinName",
"ReceiptSource",
"HeaderNo",
"HeaderKind",
"SupplierReceiptRef",
"ReceiptNarrative",
"HeaderBy"
],
"sourceID": "15DDCB92-FEA1-5F43-86D0-121353271E07",
"sqlQuery": "SELECT o.POPOrderReturnID AS OrderKey, l.POPOrderReturnLineID AS LineKey, o.DocumentNo AS OrderNo, l.ItemCode AS ItemCode, l.ItemDescription AS ItemDescription, v.POPReceiptReturnLineID AS ReceiptLineKey, v.ReceiptReturnNo AS ReceiptNo, v.ReceiptReturnDate AS ReceiptDate, v.UserName AS ReceiptBy, v.OrderReturnNo AS RecordedOrderNo, v.BinName AS BinName, CASE v.POPRcptRtnLineSourceID WHEN 0 THEN N'GRN' WHEN 1 THEN N'Invoice or Credit' ELSE CASE WHEN v.POPRcptRtnLineSourceID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',v.POPRcptRtnLineSourceID) END END AS ReceiptSource, h.DocumentNo AS HeaderNo, CASE h.POPReceiptReturnTypeID WHEN 0 THEN N'Receipt' WHEN 1 THEN N'Despatch' ELSE CASE WHEN h.POPReceiptReturnTypeID IS NULL THEN N'Not recorded' ELSE CONCAT(N'Unknown native value: ',h.POPReceiptReturnTypeID) END END AS HeaderKind, h.DocumentDate AS HeaderDate, h.SupplierDocumentNo AS SupplierReceiptRef, h.SupplierDocumentDate AS SupplierReceiptDate, h.Narrative AS ReceiptNarrative, h.UserName AS HeaderBy FROM dbo.POPReceiptReturnLine v INNER JOIN dbo.POPOrderReturnLine l ON l.POPOrderReturnLineID=v.POPOrderReturnLineID INNER JOIN dbo.POPOrderReturn o ON o.POPOrderReturnID=l.POPOrderReturnID LEFT JOIN dbo.POPReceiptReturn h ON h.POPReceiptReturnID=v.POPReceiptReturnID WHERE o.DocumentTypeID=0 AND o.POPOrderReturnID=:order AND l.POPOrderReturnLineID=:line AND v.POPReceiptReturnLineID IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "Sage 200 Professional UK",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "4F735011-E033-5589-BF51-40D6F11DA441",
"key": "InvoiceDate",
"type": "date"
},
{
"direction": "ascending",
"id": "C8AB84F1-689E-5251-8B91-59021D56BC07",
"key": "InvoiceLineKey",
"type": "text"
}
],
"id": "B95AA130-70F2-5EC2-8577-79612615A120",
"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 purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Recorded 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": true
},
{
"commonFieldKey": "",
"key": "InvoiceLineKey",
"label": "Internal invoice line key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceLineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceNo",
"label": "Recorded invoice/credit reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvoiceDate",
"label": "Recorded invoice/credit line date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvoiceBy",
"label": "Invoice line operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvoiceBy",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Disputed",
"label": "Recorded invoice line disputed flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Disputed",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DisputeNo",
"label": "Same-supplier dispute reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DisputeNo",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DisputeDate",
"label": "Same-supplier dispute document date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DisputeDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DisputeDueDate",
"label": "Same-supplier dispute due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DisputeDueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DisputeComment",
"label": "Same-supplier dispute comment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DisputeComment",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DisputeCode",
"label": "Dispute code — native value",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DisputeCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Line invoice and dispute references",
"primaryKey": "InvoiceLineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "OrderKey",
"id": "A323C9D6-39C1-56E3-A830-BECF2E25AC99",
"name": "order",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "LineKey",
"id": "CD581712-12BD-5AE5-8247-CF392F1DEA70",
"name": "line",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"OrderNo",
"ItemCode",
"ItemDescription",
"InvoiceNo",
"InvoiceBy",
"Disputed",
"DisputeNo",
"DisputeComment",
"DisputeCode"
],
"sourceID": "15DDCB92-FEA1-5F43-86D0-121353271E07",
"sqlQuery": "SELECT o.POPOrderReturnID AS OrderKey, l.POPOrderReturnLineID AS LineKey, o.DocumentNo AS OrderNo, l.ItemCode AS ItemCode, l.ItemDescription AS ItemDescription, v.POPInvoiceCreditLineID AS InvoiceLineKey, v.POPInvoiceCreditNo AS InvoiceNo, v.InvoiceCreditDate AS InvoiceDate, v.UserName AS InvoiceBy, CASE v.IsDisputed WHEN 1 THEN N'Yes' WHEN 0 THEN N'No' ELSE N'Not recorded / unknown' END AS Disputed, h.DocumentNo AS DisputeNo, h.DocumentDate AS DisputeDate, h.DocumentDueDate AS DisputeDueDate, h.DisputeComment AS DisputeComment, h.POPDisputeCodeID AS DisputeCode FROM dbo.POPInvoiceCreditLine v INNER JOIN dbo.POPOrderReturnLine l ON l.POPOrderReturnLineID=v.POPOrderReturnLineID INNER JOIN dbo.POPOrderReturn o ON o.POPOrderReturnID=l.POPOrderReturnID LEFT JOIN dbo.POPInvCredDispute h ON h.POPInvCredDisputeID=v.POPInvCredDisputeID AND h.SupplierID=o.SupplierID WHERE o.DocumentTypeID=0 AND o.POPOrderReturnID=:order AND l.POPOrderReturnLineID=:line AND v.POPInvoiceCreditLineID IS NOT NULL",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "D53DF3AC-92D5-5699-B5AD-4AB13245D288",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "9978CF53-7518-50C4-A12E-DE002BB88E20",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "EA1752BE-ADD3-5418-8F88-D5E5F2AA91D6",
"title": "Purchase order lines",
"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": "SupplierOrderRef",
"label": "Supplier document 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": "RequestedDate",
"label": "Order requested delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CreatedBy",
"label": "Order originator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "879D0937-A604-5D36-B11B-CD7845612195",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Order and current supplier",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and current supplier",
"detailRole": "information",
"isVisible": true,
"key": "OrderDate",
"label": "Order date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and current supplier",
"detailRole": "information",
"isVisible": true,
"key": "SupplierRef",
"label": "Current supplier account reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and current supplier",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Current supplier name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and current supplier",
"detailRole": "information",
"isVisible": true,
"key": "SupplierOrderRef",
"label": "Supplier document reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and current supplier",
"detailRole": "information",
"isVisible": true,
"key": "OrderStatus",
"label": "Order status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and current supplier",
"detailRole": "information",
"isVisible": true,
"key": "PrintStatus",
"label": "Order print status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and current supplier",
"detailRole": "information",
"isVisible": true,
"key": "RequestedDate",
"label": "Order requested delivery",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and current supplier",
"detailRole": "information",
"isVisible": true,
"key": "CreatedBy",
"label": "Order originator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and current supplier",
"detailRole": "information",
"isVisible": true,
"key": "Authorisation",
"label": "Authorisation status — native value",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Order and current supplier",
"detailRole": "information",
"isVisible": true,
"key": "SourceDocumentNo",
"label": "Recorded source document reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "OrderAnalysis1",
"label": "Order analysis code 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "OrderAnalysis2",
"label": "Order analysis code 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "OrderAnalysis3",
"label": "Order analysis code 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "OrderAnalysis4",
"label": "Order analysis code 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "OrderAnalysis5",
"label": "Order analysis code 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "OrderAnalysis6",
"label": "Order analysis code 6",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "2002FCC3-7831-5CAC-A629-8D4E632B75EF",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "07C666DD-6CD9-5F04-B15C-F113ABCE8089",
"includeAllOption": false,
"key": "OrderDate",
"title": "Choose a purchase-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": "SupplierName",
"systemImage": "doc.text",
"title": "Purchase order operations",
"titleKey": "OrderNo"
},
{
"actions": [
{
"id": "A9149AB5-9BBF-50B4-8F21-FE016DF7E706",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "2B81470B-A0BA-5BD6-93AD-582B45A6F9F1",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "E78221B6-F195-5B75-AEAA-0ECCE641AA00",
"title": "Receipt references",
"urlKey": ""
},
{
"id": "FE7D9EAB-5A65-5F8C-89FE-918800AD8E3F",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "B8E58E6A-7654-5A1D-B6B4-04C31E52D5BF",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "B95AA130-70F2-5EC2-8577-79612615A120",
"title": "Invoice and dispute references",
"urlKey": ""
}
],
"badgeKey": "LineType",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected purchase 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": "SupplierPartRef",
"label": "Recorded supplier part reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountRef",
"label": "Nominal account reference",
"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": "EA1752BE-ADD3-5418-8F88-D5E5F2AA91D6",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded order line",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded order line",
"detailRole": "information",
"isVisible": true,
"key": "Sequence",
"label": "Printed line sequence",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded order line",
"detailRole": "information",
"isVisible": true,
"key": "LineType",
"label": "Document line type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded order line",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Recorded item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded order line",
"detailRole": "information",
"isVisible": true,
"key": "ItemDescription",
"label": "Recorded line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded order line",
"detailRole": "information",
"isVisible": true,
"key": "SupplierPartRef",
"label": "Recorded supplier part reference",
"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": "LineAnalysis1",
"label": "Line analysis code 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "LineAnalysis2",
"label": "Line analysis code 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "LineAnalysis3",
"label": "Line analysis code 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "LineAnalysis4",
"label": "Line analysis code 4",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "LineAnalysis5",
"label": "Line analysis code 5",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Nominal and analysis references",
"detailRole": "information",
"isVisible": true,
"key": "LineAnalysis6",
"label": "Line analysis code 6",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded order line",
"detailRole": "information",
"isVisible": true,
"key": "ShowOnDocuments",
"label": "Show line on supplier documents",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "0F3F7B1B-7EE8-5CAC-B349-5605E331F934",
"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": "Purchase order lines",
"titleKey": "ItemDescription"
},
{
"actions": [],
"badgeKey": "HeaderKind",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptDate",
"label": "Recorded receipt line date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptBy",
"label": "Receipt line operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BinName",
"label": "Recorded receipt bin name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptSource",
"label": "Recorded receipt line source",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E78221B6-F195-5B75-AEAA-0ECCE641AA00",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded receipt line",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded receipt line",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Recorded item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded receipt line",
"detailRole": "information",
"isVisible": true,
"key": "ItemDescription",
"label": "Recorded line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded receipt line",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptNo",
"label": "Recorded receipt/return reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded receipt line",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptDate",
"label": "Recorded receipt line date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded receipt line",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptBy",
"label": "Receipt line operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded receipt line",
"detailRole": "information",
"isVisible": true,
"key": "RecordedOrderNo",
"label": "Recorded receipt order reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded receipt line",
"detailRole": "information",
"isVisible": true,
"key": "BinName",
"label": "Recorded receipt bin name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded receipt line",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptSource",
"label": "Recorded receipt line source",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Linked receipt header — may cover more than one order",
"detailRole": "information",
"isVisible": true,
"key": "HeaderNo",
"label": "Linked receipt header reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Linked receipt header — may cover more than one order",
"detailRole": "information",
"isVisible": true,
"key": "HeaderKind",
"label": "Linked receipt header kind",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Linked receipt header — may cover more than one order",
"detailRole": "information",
"isVisible": true,
"key": "HeaderDate",
"label": "Linked receipt header date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Linked receipt header — may cover more than one order",
"detailRole": "information",
"isVisible": true,
"key": "SupplierReceiptRef",
"label": "Linked supplier document reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Linked receipt header — may cover more than one order",
"detailRole": "information",
"isVisible": true,
"key": "SupplierReceiptDate",
"label": "Linked supplier document date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Linked receipt header — may cover more than one order",
"detailRole": "information",
"isVisible": true,
"key": "ReceiptNarrative",
"label": "Linked receipt header narrative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Linked receipt header — may cover more than one order",
"detailRole": "information",
"isVisible": true,
"key": "HeaderBy",
"label": "Linked receipt header operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "E4E00687-EAAE-5271-89E5-131BE1330F3D",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "1A54A729-C7AB-56B6-ABFA-1299749499C4",
"key": "ReceiptDate",
"type": "date"
},
{
"direction": "ascending",
"id": "49A1AC23-D85A-5ABB-9E2C-537F9E3242FE",
"key": "ReceiptLineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemDescription",
"systemImage": "doc.text",
"title": "Line receipt references",
"titleKey": "ReceiptNo"
},
{
"actions": [],
"badgeKey": "Disputed",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Recorded invoice/credit line date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceBy",
"label": "Invoice line operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DisputeNo",
"label": "Same-supplier dispute reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B95AA130-70F2-5EC2-8577-79612615A120",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Recorded invoice/credit line",
"detailRole": "information",
"isVisible": true,
"key": "OrderNo",
"label": "Selected purchase order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded invoice/credit line",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Recorded item reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded invoice/credit line",
"detailRole": "information",
"isVisible": true,
"key": "ItemDescription",
"label": "Recorded line description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded invoice/credit line",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceNo",
"label": "Recorded invoice/credit reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded invoice/credit line",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceDate",
"label": "Recorded invoice/credit line date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded invoice/credit line",
"detailRole": "information",
"isVisible": true,
"key": "InvoiceBy",
"label": "Invoice line operator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recorded invoice/credit line",
"detailRole": "information",
"isVisible": true,
"key": "Disputed",
"label": "Recorded invoice line disputed flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Optional same-supplier dispute context",
"detailRole": "information",
"isVisible": true,
"key": "DisputeNo",
"label": "Same-supplier dispute reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Optional same-supplier dispute context",
"detailRole": "information",
"isVisible": true,
"key": "DisputeDate",
"label": "Same-supplier dispute document date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Optional same-supplier dispute context",
"detailRole": "information",
"isVisible": true,
"key": "DisputeDueDate",
"label": "Same-supplier dispute due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Optional same-supplier dispute context",
"detailRole": "information",
"isVisible": true,
"key": "DisputeComment",
"label": "Same-supplier dispute comment",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Optional same-supplier dispute context",
"detailRole": "information",
"isVisible": true,
"key": "DisputeCode",
"label": "Dispute code — native value",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "BD049AAA-EDC2-535B-9CFE-7CF756CFFA93",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "4F735011-E033-5589-BF51-40D6F11DA441",
"key": "InvoiceDate",
"type": "date"
},
{
"direction": "ascending",
"id": "C8AB84F1-689E-5251-8B91-59021D56BC07",
"key": "InvoiceLineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemDescription",
"systemImage": "doc.text",
"title": "Line invoice and dispute references",
"titleKey": "InvoiceNo"
}
],
"relations": [
{
"childDatasetID": "EA1752BE-ADD3-5418-8F88-D5E5F2AA91D6",
"childKey": "OrderKey",
"id": "9978CF53-7518-50C4-A12E-DE002BB88E20",
"name": "Purchase order lines",
"parentDatasetID": "879D0937-A604-5D36-B11B-CD7845612195",
"parentKey": "OrderKey"
},
{
"childDatasetID": "E78221B6-F195-5B75-AEAA-0ECCE641AA00",
"childKey": "LineKey",
"id": "2B81470B-A0BA-5BD6-93AD-582B45A6F9F1",
"name": "Receipt references",
"parentDatasetID": "EA1752BE-ADD3-5418-8F88-D5E5F2AA91D6",
"parentKey": "LineKey"
},
{
"childDatasetID": "B95AA130-70F2-5EC2-8577-79612615A120",
"childKey": "LineKey",
"id": "B8E58E6A-7654-5A1D-B6B4-04C31E52D5BF",
"name": "Invoice and dispute references",
"parentDatasetID": "EA1752BE-ADD3-5418-8F88-D5E5F2AA91D6",
"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 purchasing, receiving, supplier-invoice coordination and managers: choose an order-date period, find purchase orders and inspect the requested delivery date, supplier reference, current supplier name, native order/print statuses, originator and analysis references. Open all recorded lines, including free text, charges and comments. Follow each line to its receipt and invoice/credit references, dates, operators and optional dispute context. An operational enquiry, not a complete financial, quantity, outstanding or payment 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 separately authorised company SQL Server reader, four bounded live lists/Details and three lazy related buttons. Read-only SELECT, at most 2,000 results per read, no periodic refresh. Native opening period selects order dates, not historical balances or all receipt/invoice dates. Child reads revalidate both internal order and line keys, never a human document number. Row caps/filters are not an ACL, completeness or cheap-query guarantee. Check installed indexes, execution plans and timeouts. SQL does not inherit Sage UI permissions. Operator names, references and free text may be sensitive; authorise only the required scope.\n\nUNOFFICIAL, not affiliated with Sage. Selected physical identifiers and status legends are from the partial Sage 200 2015 database guide, November 2014. Not full DDL or current-version compatibility certification. Requires compatible dbo objects; verify installed edition, ownership, keys/uniqueness, types, status meanings and permissions before import. Not Sage 200 Standard, Evolution, Sage 300 or an API template.\n\nNo quantities, prices, monetary totals, currency, conversions, outstanding subtraction or cross-unit aggregates. Authorisation/dispute codes remain raw native values, not decoded guesses. Missing, blank and unknown values are preserved. Current supplier names are not historical snapshots; recorded line descriptions and supplier part references are not replaced from a current stock master. Only type-0 purchase orders in the legacy guide; returns/archives/cancelled-line history are not included. A recorded invoice/credit line is not an A/P invoice, paid/posted proof or a complete matching report. The receipt header may cover lines from several orders and is not incorrectly restricted to a nonexistent header order key. Its dates/reference/narrative are distinct from those of the receipt line. Invoice dispute headers are optional: absent or foreign-supplier dispute context does not remove the invoice line or certify no dispute/payment. No receipt-to-invoice cross join or totals across unrelated records. Traceable batch/serial records and bridge matching are not included. No source credentials, server addresses or business rows in the package. Gallery images are native Cifru with wholly fictional DEMO data.\n\nPrimary physical reference: https://desktophelp.sage.co.uk/sage200/PDF/2015/Understanding%20the%20Sage%20200%202015%20Database.pdf\nPurchase enquiry: https://desktophelp.sage.co.uk/sage200/professional/Content/POP/POP%20enquiries.htm\n\nGallery coverage: Eight representative images show the complete selected order, order-line and invoice-reference cards, all four selected Details routes and all three actions. The order and order-line continuations use their own matching complete cards for header values. Receipt Details includes its continuation with the complete narrative; the receipt-list card is retained privately, not shown in this gallery. All 61 useful Details positions are paired with exact fictional input. All 14 private PNG/XML viewports and raw pending footage remain retained. This is not every record/viewport, whole-video approval or real ERP/SQL Server/current-edition certification.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "65B1DADB-1DA8-5451-AD59-EC48123E4495",
"rootButtonCount": 1,
"summary": "Order delivery dates, supplier parts, recorded line receipts and invoice/dispute references on demand.",
"tags": [
"Sage 200 Professional UK",
"SQL Server",
"Purchase orders",
"Receipts",
"Supplier invoices",
"Pro"
],
"title": "Purchase orders: lines, receipts and invoice references — Pro"
}
}