Purchase invoices — Pro
Period, partner, totals and due dates; lines, partner, product and warehouse drilldowns.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.
Based on the official SAP Business One 10.0 SDK reference and synthetic tests. Screenshots show native Cifru with fictional DEMO rows, not a live SAP connection. At import, map your authorized company source, run the read/compatibility test and check edition, fields, permissions and results before business use.
Invoices by posting period, excluding canceled invoices and cancellation documents. Credit notes, payments and journal reports are separate concepts, not silently included. Open/closed document status does not by itself certify payment. Foreign-currency values may be zero for local-currency documents. Service lines remain visible even without an item master record. Lines load for the selected DocEntry only. Product and warehouse buttons apply to inventory items, not service descriptions. Outstanding is the signed document local total minus its paid/credited local amount.
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 authorized source and your Cifru plan.
SAP Business One 10.0 on Microsoft SQL Server only; not SAP HANA. Connect to one authorized company database using a restricted read-only account. Local-currency and foreign-currency amounts are distinct; no invented currency conversion or cross-currency total. Up to 2,000 rows per read; narrow the period or filters for large datasets. Live reads, no periodic background refresh. Detail buttons read only the selected context. Technical join keys are hidden.
Field legend on Free: status O = Open, C = Closed; type I = Items, S = Services. Commercial numbers are shown as identifiers; hidden internal keys drive all related reads. Partner currency settings are not labels for local balances. Do not combine foreign amounts across currencies. Native credit limits are not unused credit. Product activity flags alone do not apply validity dates. Stock drilldowns show the current item in all warehouses, not just the document warehouse or historical stock. Service lines have no product or stock dossier; their original line Details remain available. Document totals can include rounding, freight, withholding or header-level adjustments; do not assume they always equal the sum of net lines and line taxes. SQL Server 2012 or newer is needed for custom SQL CONCAT/DATALENGTH where used. The 2,000-row cap does not guarantee a cheap server scan. Public documentation: https://help.sap.com/docs/SAP_BUSINESS_ONE
Screenshots
What this package creates
1 Home5 Details5 lists1 sources to map
- Home: Purchase invoices
- Details: Invoice lines
- Details: Business partner
- Details: Product dossier
- Details: Stock in all warehouses
- Details: Stock in all warehouses
- Sub-button: Invoice lines
- Sub-button: Business partner
- Sub-button: Product dossier
- Sub-button: Stock in all warehouses
Sources are mapped locally and verified before applying.
Custom queriesPRO5 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 h.[DocEntry], h.[DocNum], h.[DocType], h.[DocStatus], h.[DocDate], h.[DocDueDate], h.[CardCode], h.[CardName], h.[NumAtCard], h.[DocCur], h.[DocTotal], h.[DocTotalFC], h.[PaidToDate], h.[PaidFC], h.[VatSum], h.[VatSumFC], h.[Comments], h.[TransId], h.DocTotal - h.PaidToDate AS OpenBalanceLC, CASE WHEN h.DocStatus IS NULL THEN N'Not specified' WHEN h.DocStatus = 'O' THEN N'Open' WHEN h.DocStatus = 'C' THEN N'Closed' ELSE N'Unknown' END AS DocumentState, CASE WHEN h.DocType IS NULL THEN N'Not specified' WHEN h.DocType = 'I' THEN N'Items' WHEN h.DocType = 'S' THEN N'Services' ELSE N'Unknown' END AS DocumentKind FROM dbo.OPCH h WHERE h.CANCELED = 'N' AND h.DocDate >= :date_from AND h.DocDate < :date_until
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(CAST(l.DocEntry AS varchar(20)), N':', CAST(l.LineNum AS varchar(20))) AS row_id, l.[DocEntry], l.[LineNum], l.[ItemCode], l.[Dscription], l.[Quantity], l.[Price], l.[Currency], l.[LineTotal], l.[TotalFrgn], l.[VatSum], l.[VatSumFrgn], l.[WhsCode], l.[DiscPrcnt], l.[VatPrcnt], l.[unitMsr] FROM dbo.PCH1 l WHERE l.DocEntry = :document
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT p.[CardCode], p.[CardName], p.[CardType], p.[Currency], p.[Balance], p.[BalanceFC], p.[CreditLine], p.[Phone1], p.[E_Mail], CASE WHEN p.CardType IS NULL THEN N'Not specified' WHEN p.CardType = 'C' THEN N'Customer' WHEN p.CardType = 'S' THEN N'Supplier' WHEN p.CardType = 'L' THEN N'Lead' ELSE N'Unknown' END AS PartnerKind FROM dbo.OCRD p WHERE p.CardCode = :partner
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT i.[ItemCode], i.[ItemName], i.[CodeBars], i.[InvntryUom], i.[OnHand], i.[IsCommited], i.[OnOrder], i.[BuyUnitMsr], i.[SalUnitMsr], i.[MinLevel], i.[MaxLevel], i.[frozenFor], i.[validFor], g.ItmsGrpNam, CASE WHEN i.frozenFor IS NULL THEN N'Not specified' WHEN i.frozenFor = 'Y' THEN N'Yes' WHEN i.frozenFor = 'N' THEN N'No' ELSE N'Unknown' END AS InactiveFlag, CASE WHEN i.validFor IS NULL THEN N'Not specified' WHEN i.validFor = 'Y' THEN N'Yes' WHEN i.validFor = 'N' THEN N'No' ELSE N'Unknown' END AS ActiveFlag FROM dbo.OITM i LEFT JOIN dbo.OITB g ON g.ItmsGrpCod = i.ItmsGrpCod WHERE i.ItemCode = :item
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.4.sqlQuerySELECT CONCAT(DATALENGTH(w.ItemCode), N':', w.ItemCode, w.WhsCode) AS row_id, w.[ItemCode], w.[WhsCode], w.[OnHand], w.[IsCommited], w.[OnOrder], w.[MinStock], w.[MaxStock], w.[AvgPrice], i.ItemName, i.InvntryUom, h.WhsName FROM dbo.OITW w LEFT JOIN dbo.OITM i ON i.ItemCode = w.ItemCode LEFT JOIN dbo.OWHS h ON h.WhsCode = w.WhsCode WHERE w.ItemCode = :item
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "SAP Business One 10.0 — SQL Server",
"id": "43875908-3A27-5557-A50B-CD81DC7E018E",
"kind": "sqlServer",
"requiredObjects": [
"dbo.OCRD",
"dbo.OITB",
"dbo.OITM",
"dbo.OITW",
"dbo.OPCH",
"dbo.OWHS",
"dbo.PCH1"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SAP Business One",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05BBEE1C-9832-5C04-8237-2BFCDD38859E",
"key": "DocDate",
"type": "date"
},
{
"direction": "ascending",
"id": "30EE327E-4AAC-5408-83F6-C6ADA9B93CD4",
"key": "DocEntry",
"type": "number"
}
],
"id": "0F5CD371-AB8C-5B3C-87BA-750259BBB163",
"mappings": [
{
"commonFieldKey": "",
"key": "DocEntry",
"label": "Internal document key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocEntry",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocNum",
"label": "Document number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocNum",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocType",
"label": "Type (I: items; S: services)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocType",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocStatus",
"label": "Status (O: open; C: closed)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocStatus",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocDueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CardCode",
"label": "Business partner code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CardCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CardName",
"label": "Business partner",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CardName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "NumAtCard",
"label": "Partner reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NumAtCard",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocCur",
"label": "Document currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocCur",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocTotal",
"label": "Total — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocTotal",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocTotalFC",
"label": "Total — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocTotalFC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PaidToDate",
"label": "Paid / credited — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PaidToDate",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaidFC",
"label": "Paid / credited — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PaidFC",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VatSum",
"label": "Tax — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VatSum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VatSumFC",
"label": "Tax — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VatSumFC",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Comments",
"label": "Remarks",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Comments",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TransId",
"label": "Internal journal key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TransId",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OpenBalanceLC",
"label": "Outstanding — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OpenBalanceLC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocumentState",
"label": "Document status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocumentKind",
"label": "Document type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentKind",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Purchase invoices",
"primaryKey": "DocEntry",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocDate",
"id": "7F0D3D45-2764-5815-9B83-AB5F3B024313",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocDate",
"id": "6B6EDBB5-B153-549D-B75A-4386BC4B71BA",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DocNum",
"CardCode",
"CardName",
"NumAtCard",
"DocCur",
"Comments",
"DocumentState",
"DocumentKind"
],
"sourceID": "43875908-3A27-5557-A50B-CD81DC7E018E",
"sqlQuery": "SELECT h.[DocEntry], h.[DocNum], h.[DocType], h.[DocStatus], h.[DocDate], h.[DocDueDate], h.[CardCode], h.[CardName], h.[NumAtCard], h.[DocCur], h.[DocTotal], h.[DocTotalFC], h.[PaidToDate], h.[PaidFC], h.[VatSum], h.[VatSumFC], h.[Comments], h.[TransId], h.DocTotal - h.PaidToDate AS OpenBalanceLC, CASE WHEN h.DocStatus IS NULL THEN N'Not specified' WHEN h.DocStatus = 'O' THEN N'Open' WHEN h.DocStatus = 'C' THEN N'Closed' ELSE N'Unknown' END AS DocumentState, CASE WHEN h.DocType IS NULL THEN N'Not specified' WHEN h.DocType = 'I' THEN N'Items' WHEN h.DocType = 'S' THEN N'Services' ELSE N'Unknown' END AS DocumentKind FROM dbo.OPCH h WHERE h.CANCELED = 'N' AND h.DocDate >= :date_from AND h.DocDate < :date_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SAP Business One",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "AA367C24-B913-596B-AFB8-936AF6AA00E1",
"key": "LineNum",
"type": "number"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "B92A6CCB-FA21-5DA1-B70C-7D4B12CF2B48",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Internal row key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocEntry",
"label": "Internal document key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocEntry",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineNum",
"label": "Internal line key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineNum",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Dscription",
"label": "Item / service",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Dscription",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Quantity",
"label": "Quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Quantity",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Price",
"label": "Unit price (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Price",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Currency",
"label": "Price currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Currency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineTotal",
"label": "Line net — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineTotal",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TotalFrgn",
"label": "Line net — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TotalFrgn",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VatSum",
"label": "Tax — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VatSum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VatSumFrgn",
"label": "Line tax — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VatSumFrgn",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WhsCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WhsCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DiscPrcnt",
"label": "Discount (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscPrcnt",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VatPrcnt",
"label": "Tax (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VatPrcnt",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "unitMsr",
"label": "Unit on document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "unitMsr",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Invoice lines",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocEntry",
"id": "59759AA4-FF7E-5D19-A7A1-67E3E4BF7D97",
"name": "document",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"Dscription",
"Currency",
"WhsCode",
"unitMsr"
],
"sourceID": "43875908-3A27-5557-A50B-CD81DC7E018E",
"sqlQuery": "SELECT CONCAT(CAST(l.DocEntry AS varchar(20)), N':', CAST(l.LineNum AS varchar(20))) AS row_id, l.[DocEntry], l.[LineNum], l.[ItemCode], l.[Dscription], l.[Quantity], l.[Price], l.[Currency], l.[LineTotal], l.[TotalFrgn], l.[VatSum], l.[VatSumFrgn], l.[WhsCode], l.[DiscPrcnt], l.[VatPrcnt], l.[unitMsr] FROM dbo.PCH1 l WHERE l.DocEntry = :document",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SAP Business One",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "337CB9A8-A225-502D-AAF1-82A8A1229730",
"key": "CardCode",
"type": "text"
}
],
"id": "20B9F043-2A91-56E7-81A7-153FC53219EF",
"mappings": [
{
"commonFieldKey": "",
"key": "CardCode",
"label": "Business partner code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CardCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CardName",
"label": "Business partner",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CardName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CardType",
"label": "Partner type (C: customer; S: supplier; L: lead)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CardType",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Currency",
"label": "Partner currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Currency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Balance",
"label": "Balance — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Balance",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BalanceFC",
"label": "Balance — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BalanceFC",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CreditLine",
"label": "Credit limit (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CreditLine",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Phone1",
"label": "Telephone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Phone1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "E_Mail",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "E_Mail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartnerKind",
"label": "Partner type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartnerKind",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Business partner",
"primaryKey": "CardCode",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "CardCode",
"id": "0CFD7930-8FFD-5517-A7B6-34D722256BF5",
"name": "partner",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"CardCode",
"CardName",
"Currency",
"Phone1",
"E_Mail",
"PartnerKind"
],
"sourceID": "43875908-3A27-5557-A50B-CD81DC7E018E",
"sqlQuery": "SELECT p.[CardCode], p.[CardName], p.[CardType], p.[Currency], p.[Balance], p.[BalanceFC], p.[CreditLine], p.[Phone1], p.[E_Mail], CASE WHEN p.CardType IS NULL THEN N'Not specified' WHEN p.CardType = 'C' THEN N'Customer' WHEN p.CardType = 'S' THEN N'Supplier' WHEN p.CardType = 'L' THEN N'Lead' ELSE N'Unknown' END AS PartnerKind FROM dbo.OCRD p WHERE p.CardCode = :partner",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SAP Business One",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "E3487B36-735E-5C77-859B-D4C1CBC9C6E9",
"key": "ItemCode",
"type": "text"
}
],
"id": "D73214FA-319D-5AB8-863D-202A688EDD7B",
"mappings": [
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CodeBars",
"label": "Barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CodeBars",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvntryUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OnHand",
"label": "In stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OnHand",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IsCommited",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OnOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BuyUnitMsr",
"label": "Purchase unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BuyUnitMsr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SalUnitMsr",
"label": "Sales unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SalUnitMsr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "MinLevel",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MinLevel",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MaxLevel",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MaxLevel",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "frozenFor",
"label": "Inactive flag (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "frozenFor",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "validFor",
"label": "Active flag (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "validFor",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItmsGrpNam",
"label": "Item group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItmsGrpNam",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "InactiveFlag",
"label": "Inactive flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InactiveFlag",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ActiveFlag",
"label": "Active flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ActiveFlag",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Product dossier",
"primaryKey": "ItemCode",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ItemCode",
"id": "BF6806B4-E054-5774-AA4A-CCDB64797F5A",
"name": "item",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"ItemName",
"CodeBars",
"InvntryUom",
"BuyUnitMsr",
"SalUnitMsr",
"ItmsGrpNam",
"InactiveFlag",
"ActiveFlag"
],
"sourceID": "43875908-3A27-5557-A50B-CD81DC7E018E",
"sqlQuery": "SELECT i.[ItemCode], i.[ItemName], i.[CodeBars], i.[InvntryUom], i.[OnHand], i.[IsCommited], i.[OnOrder], i.[BuyUnitMsr], i.[SalUnitMsr], i.[MinLevel], i.[MaxLevel], i.[frozenFor], i.[validFor], g.ItmsGrpNam, CASE WHEN i.frozenFor IS NULL THEN N'Not specified' WHEN i.frozenFor = 'Y' THEN N'Yes' WHEN i.frozenFor = 'N' THEN N'No' ELSE N'Unknown' END AS InactiveFlag, CASE WHEN i.validFor IS NULL THEN N'Not specified' WHEN i.validFor = 'Y' THEN N'Yes' WHEN i.validFor = 'N' THEN N'No' ELSE N'Unknown' END AS ActiveFlag FROM dbo.OITM i LEFT JOIN dbo.OITB g ON g.ItmsGrpCod = i.ItmsGrpCod WHERE i.ItemCode = :item",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "SAP Business One",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "0F18A517-810D-5F6D-8275-4BFB570BDF23",
"key": "WhsName",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "774960B5-11BE-5B13-8C65-261785C2053A",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Internal row key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WhsCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WhsCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OnHand",
"label": "In stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OnHand",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "IsCommited",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OnOrder",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MinStock",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MinStock",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "MaxStock",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "MaxStock",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AvgPrice",
"label": "Average price — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AvgPrice",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvntryUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "WhsName",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WhsName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Stock in all warehouses",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ItemCode",
"id": "E3A31661-A27D-56C9-996F-D519395657F5",
"name": "item",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"WhsCode",
"ItemName",
"InvntryUom",
"WhsName"
],
"sourceID": "43875908-3A27-5557-A50B-CD81DC7E018E",
"sqlQuery": "SELECT CONCAT(DATALENGTH(w.ItemCode), N':', w.ItemCode, w.WhsCode) AS row_id, w.[ItemCode], w.[WhsCode], w.[OnHand], w.[IsCommited], w.[OnOrder], w.[MinStock], w.[MaxStock], w.[AvgPrice], i.ItemName, i.InvntryUom, h.WhsName FROM dbo.OITW w LEFT JOIN dbo.OITM i ON i.ItemCode = w.ItemCode LEFT JOIN dbo.OWHS h ON h.WhsCode = w.WhsCode WHERE w.ItemCode = :item",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "6EFA1545-02CA-5109-BA21-BDA0CC535F0E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "43E9EDD4-AD28-5080-A4D2-12CAC86EB120",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "B92A6CCB-FA21-5DA1-B70C-7D4B12CF2B48",
"title": "Invoice lines",
"urlKey": ""
},
{
"id": "57187DDE-1BFF-5C31-B442-E9B4E0FEC5B5",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "EA82307A-4EB4-5629-B2D0-64B920107B79",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "20B9F043-2A91-56E7-81A7-153FC53219EF",
"title": "Business partner",
"urlKey": ""
}
],
"badgeKey": "DocumentState",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NumAtCard",
"label": "Partner reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocCur",
"label": "Document currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocTotal",
"label": "Total — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocTotalFC",
"label": "Total — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OpenBalanceLC",
"label": "Outstanding — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "0F5CD371-AB8C-5B3C-87BA-750259BBB163",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "DocNum",
"label": "Document number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "DocDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "DocDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "CardCode",
"label": "Business partner code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "CardName",
"label": "Business partner",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "NumAtCard",
"label": "Partner reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "DocCur",
"label": "Document currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "DocTotal",
"label": "Total — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "DocTotalFC",
"label": "Total — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "PaidToDate",
"label": "Paid / credited — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "PaidFC",
"label": "Paid / credited — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "VatSum",
"label": "Tax — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "VatSumFC",
"label": "Tax — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Remarks",
"detailRole": "information",
"isVisible": true,
"key": "Comments",
"label": "Remarks",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "OpenBalanceLC",
"label": "Outstanding — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "DocumentState",
"label": "Document status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "DocumentKind",
"label": "Document type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "B359E099-9889-56B5-947B-BF83D0D55564",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "07C96302-DA17-5840-8258-63AA4CC2C030",
"includeAllOption": false,
"key": "DocDate",
"title": "Period",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05BBEE1C-9832-5C04-8237-2BFCDD38859E",
"key": "DocDate",
"type": "date"
},
{
"direction": "ascending",
"id": "30EE327E-4AAC-5408-83F6-C6ADA9B93CD4",
"key": "DocEntry",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "DocNum",
"systemImage": "doc.text",
"title": "Purchase invoices",
"titleKey": "CardName"
},
{
"actions": [
{
"id": "194F5658-D6CD-51ED-B5BD-7C30D3DDCC34",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "F4B8F8C2-11DF-5A30-B400-843A166BA1F1",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "D73214FA-319D-5AB8-863D-202A688EDD7B",
"title": "Product dossier",
"urlKey": ""
},
{
"id": "2D71B734-C6CF-56F7-9D3C-9D94EB937147",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "D6B94489-62FA-5D76-B3B4-3F64954F8925",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "774960B5-11BE-5B13-8C65-261785C2053A",
"title": "Stock in all warehouses",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Quantity",
"label": "Quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Price",
"label": "Unit price (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Price currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineTotal",
"label": "Line net — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TotalFrgn",
"label": "Line net — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WhsCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DiscPrcnt",
"label": "Discount (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VatPrcnt",
"label": "Tax (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "unitMsr",
"label": "Unit on document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B92A6CCB-FA21-5DA1-B70C-7D4B12CF2B48",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "Dscription",
"label": "Item / service",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Line quantities and pricing",
"detailRole": "information",
"isVisible": true,
"key": "Quantity",
"label": "Quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Line quantities and pricing",
"detailRole": "information",
"isVisible": true,
"key": "Price",
"label": "Unit price (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Line quantities and pricing",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Price currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "LineTotal",
"label": "Line net — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "TotalFrgn",
"label": "Line net — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "VatSum",
"label": "Tax — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "VatSumFrgn",
"label": "Line tax — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Line quantities and pricing",
"detailRole": "information",
"isVisible": true,
"key": "WhsCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Line quantities and pricing",
"detailRole": "information",
"isVisible": true,
"key": "DiscPrcnt",
"label": "Discount (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Line quantities and pricing",
"detailRole": "information",
"isVisible": true,
"key": "VatPrcnt",
"label": "Tax (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Line quantities and pricing",
"detailRole": "information",
"isVisible": true,
"key": "unitMsr",
"label": "Unit on document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "8B46E736-7BE5-5B95-B5F4-C6B4CFF0AA4B",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "AA367C24-B913-596B-AFB8-936AF6AA00E1",
"key": "LineNum",
"type": "number"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemCode",
"systemImage": "doc.text",
"title": "Invoice lines",
"titleKey": "Dscription"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Partner currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Balance",
"label": "Balance — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BalanceFC",
"label": "Balance — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CreditLine",
"label": "Credit limit (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PartnerKind",
"label": "Partner type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "20B9F043-2A91-56E7-81A7-153FC53219EF",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "CardCode",
"label": "Business partner code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "CardName",
"label": "Business partner",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Partner currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — local currency",
"detailRole": "information",
"isVisible": true,
"key": "Balance",
"label": "Balance — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Amounts — foreign currency",
"detailRole": "information",
"isVisible": true,
"key": "BalanceFC",
"label": "Balance — foreign currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Balances and credit",
"detailRole": "information",
"isVisible": true,
"key": "CreditLine",
"label": "Credit limit (native)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contacts",
"detailRole": "information",
"isVisible": true,
"key": "Phone1",
"label": "Telephone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contacts",
"detailRole": "information",
"isVisible": true,
"key": "E_Mail",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "PartnerKind",
"label": "Partner type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "B182721A-CB73-5458-8C40-38FD90A76352",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "337CB9A8-A225-502D-AAF1-82A8A1229730",
"key": "CardCode",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "CardCode",
"systemImage": "tablecells",
"title": "Business partner",
"titleKey": "CardName"
},
{
"actions": [
{
"id": "34722721-EF68-5FE6-9E5F-B6F7574AC74A",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "F24FCFB3-28B9-5B62-AB85-AA63EA663374",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "774960B5-11BE-5B13-8C65-261785C2053A",
"title": "Stock in all warehouses",
"urlKey": ""
}
],
"badgeKey": "OnHand",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CodeBars",
"label": "Barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MinLevel",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MaxLevel",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ItmsGrpNam",
"label": "Item group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "D73214FA-319D-5AB8-863D-202A688EDD7B",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "CodeBars",
"label": "Barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "OnHand",
"label": "In stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "BuyUnitMsr",
"label": "Purchase unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "SalUnitMsr",
"label": "Sales unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "MinLevel",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "MaxLevel",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItmsGrpNam",
"label": "Item group",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "InactiveFlag",
"label": "Inactive flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "ActiveFlag",
"label": "Active flag",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "C508D438-B285-5755-B04A-4C0CB7F5F0C3",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "E3487B36-735E-5C77-859B-D4C1CBC9C6E9",
"key": "ItemCode",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemCode",
"systemImage": "tablecells",
"title": "Product dossier",
"titleKey": "ItemName"
},
{
"actions": [],
"badgeKey": "OnHand",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MinStock",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "MaxStock",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AvgPrice",
"label": "Average price — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "774960B5-11BE-5B13-8C65-261785C2053A",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "WhsCode",
"label": "Warehouse code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "OnHand",
"label": "In stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "IsCommited",
"label": "Committed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "OnOrder",
"label": "On order",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "MinStock",
"label": "Minimum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "MaxStock",
"label": "Maximum stock",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Stock quantities and thresholds",
"detailRole": "information",
"isVisible": true,
"key": "AvgPrice",
"label": "Average price — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ItemName",
"label": "Item",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "WhsName",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "AA760316-6C68-524E-B70E-6A7B1B47B56D",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "0F18A517-810D-5F6D-8275-4BFB570BDF23",
"key": "WhsName",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "WhsCode",
"systemImage": "tablecells",
"title": "Stock in all warehouses",
"titleKey": "WhsName"
}
],
"relations": [
{
"childDatasetID": "B92A6CCB-FA21-5DA1-B70C-7D4B12CF2B48",
"childKey": "DocEntry",
"id": "43E9EDD4-AD28-5080-A4D2-12CAC86EB120",
"name": "Invoice lines",
"parentDatasetID": "0F5CD371-AB8C-5B3C-87BA-750259BBB163",
"parentKey": "DocEntry"
},
{
"childDatasetID": "20B9F043-2A91-56E7-81A7-153FC53219EF",
"childKey": "CardCode",
"id": "EA82307A-4EB4-5629-B2D0-64B920107B79",
"name": "Business partner",
"parentDatasetID": "0F5CD371-AB8C-5B3C-87BA-750259BBB163",
"parentKey": "CardCode"
},
{
"childDatasetID": "D73214FA-319D-5AB8-863D-202A688EDD7B",
"childKey": "ItemCode",
"id": "F4B8F8C2-11DF-5A30-B400-843A166BA1F1",
"name": "Product dossier",
"parentDatasetID": "B92A6CCB-FA21-5DA1-B70C-7D4B12CF2B48",
"parentKey": "ItemCode"
},
{
"childDatasetID": "774960B5-11BE-5B13-8C65-261785C2053A",
"childKey": "ItemCode",
"id": "D6B94489-62FA-5D76-B3B4-3F64954F8925",
"name": "Stock in all warehouses",
"parentDatasetID": "B92A6CCB-FA21-5DA1-B70C-7D4B12CF2B48",
"parentKey": "ItemCode"
},
{
"childDatasetID": "774960B5-11BE-5B13-8C65-261785C2053A",
"childKey": "ItemCode",
"id": "F24FCFB3-28B9-5B62-AB85-AA63EA663374",
"name": "Stock in all warehouses",
"parentDatasetID": "D73214FA-319D-5AB8-863D-202A688EDD7B",
"parentKey": "ItemCode"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "SAP Business One",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-03T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.\n\nBased on the official SAP Business One 10.0 SDK reference and synthetic tests. Screenshots show native Cifru with fictional DEMO rows, not a live SAP connection. At import, map your authorized company source, run the read/compatibility test and check edition, fields, permissions and results before business use.\n\nInvoices by posting period, excluding canceled invoices and cancellation documents. Credit notes, payments and journal reports are separate concepts, not silently included. Open/closed document status does not by itself certify payment. Foreign-currency values may be zero for local-currency documents. Service lines remain visible even without an item master record. Lines load for the selected DocEntry only. Product and warehouse buttons apply to inventory items, not service descriptions. Outstanding is the signed document local total minus its paid/credited local amount.\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 authorized source and your Cifru plan.\n\nSAP Business One 10.0 on Microsoft SQL Server only; not SAP HANA. Connect to one authorized company database using a restricted read-only account. Local-currency and foreign-currency amounts are distinct; no invented currency conversion or cross-currency total. Up to 2,000 rows per read; narrow the period or filters for large datasets. Live reads, no periodic background refresh. Detail buttons read only the selected context. Technical join keys are hidden.\n\nField legend on Free: status O = Open, C = Closed; type I = Items, S = Services. Commercial numbers are shown as identifiers; hidden internal keys drive all related reads. Partner currency settings are not labels for local balances. Do not combine foreign amounts across currencies. Native credit limits are not unused credit. Product activity flags alone do not apply validity dates. Stock drilldowns show the current item in all warehouses, not just the document warehouse or historical stock. Service lines have no product or stock dossier; their original line Details remain available. Document totals can include rounding, freight, withholding or header-level adjustments; do not assume they always equal the sum of net lines and line taxes. SQL Server 2012 or newer is needed for custom SQL CONCAT/DATALENGTH where used. The 2,000-row cap does not guarantee a cheap server scan. Public documentation: https://help.sap.com/docs/SAP_BUSINESS_ONE",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "15ABBACA-57D2-5FBA-B721-2B43DAE173CE",
"rootButtonCount": 1,
"summary": "Period, partner, totals and due dates; lines, partner, product and warehouse drilldowns.",
"tags": [
"SAP Business One",
"SQL Server",
"pro"
],
"title": "Purchase invoices — Pro"
}
}