Purchase orders and fulfilment details — Pro
Posting period, partner, dates and totals; order lines, open quantities, products and warehouse stock.
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.
For purchasing and replenishment teams and managers: review purchase orders by posting period and open the selected order’s lines. The order status and line status are distinct; canceled orders are excluded, closed orders remain visible. Remaining quantity is SAP’s native OpenQty, not ordered quantity minus a guessed delivered amount. Delivery dates are planned document dates, not proof of fulfilment. Keep each line quantity with its document unit and price currency; do not total unlike units or currencies. Product and warehouse drilldowns are meaningful for item lines; service lines remain visible without an item. Current warehouse stock is not a reservation guarantee or stock at the order date. Order totals are not invoice balances, amounts overdue or evidence of payment. Cards label local-currency amounts separately from foreign-currency values; the document currency does not label the local total. Document numbers are identifiers, not formatted amounts. The stock button on an item line shows that item across all warehouses, not just the line warehouse.
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 orders
- Details: Order lines
- Details: Business partner
- Details: Product dossier
- Details: Stock in all warehouses
- Details: Stock in all warehouses
- Sub-button: Order 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.[VatSum], h.[VatSumFC], h.[Comments], h.[Confirmed], h.[PartSupply], CASE h.DocStatus WHEN 'O' THEN N'Open' WHEN 'C' THEN N'Closed' ELSE CASE WHEN h.DocStatus IS NULL THEN N'Not specified' ELSE N'Unknown' END END AS OrderState, CASE h.DocType WHEN 'I' THEN N'Items' WHEN 'S' THEN N'Services' ELSE CASE WHEN h.DocType IS NULL THEN N'Not specified' ELSE N'Unknown' END END AS DocumentKind, CASE h.Confirmed WHEN 'Y' THEN N'Yes' WHEN 'N' THEN N'No' ELSE CASE WHEN h.Confirmed IS NULL THEN N'Not specified' ELSE N'Unknown' END END AS ConfirmationState, CASE h.PartSupply WHEN 'Y' THEN N'Yes' WHEN 'N' THEN N'No' ELSE CASE WHEN h.PartSupply IS NULL THEN N'Not specified' ELSE N'Unknown' END END AS PartialDeliveryState FROM dbo.OPOR 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.[LineStatus], l.[ItemCode], l.[Dscription], l.[Quantity], l.[ShipDate], l.[OpenQty], l.[Price], l.[Currency], l.[LineTotal], l.[TotalFrgn], l.[WhsCode], l.[DiscPrcnt], l.[VatPrcnt], l.[unitMsr], CASE l.LineStatus WHEN 'O' THEN N'Open' WHEN 'C' THEN N'Closed' ELSE CASE WHEN l.LineStatus IS NULL THEN N'Not specified' ELSE N'Unknown' END END AS LineState FROM dbo.POR1 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": "55FADC3B-B4B4-5454-A552-4499C2843F25",
"kind": "sqlServer",
"requiredObjects": [
"dbo.OCRD",
"dbo.OITB",
"dbo.OITM",
"dbo.OITW",
"dbo.OPOR",
"dbo.OWHS",
"dbo.POR1"
],
"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": "F9A3F8D1-9708-5132-9B50-0C2C7BE5B9BA",
"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": "Planned order 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": "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": "Confirmed",
"label": "Confirmed (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Confirmed",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartSupply",
"label": "Partial delivery allowed (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartSupply",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderState",
"label": "Order status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocumentKind",
"label": "Document type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentKind",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ConfirmationState",
"label": "Confirmed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ConfirmationState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PartialDeliveryState",
"label": "Partial delivery allowed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PartialDeliveryState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Purchase orders",
"primaryKey": "DocEntry",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocDate",
"id": "5421E851-D455-5315-AF3F-327035AA5194",
"name": "date_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocDate",
"id": "EA161856-B751-548B-A72C-4B1A6009CF83",
"name": "date_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DocNum",
"CardCode",
"CardName",
"NumAtCard",
"DocCur",
"Comments",
"OrderState",
"DocumentKind",
"ConfirmationState",
"PartialDeliveryState"
],
"sourceID": "55FADC3B-B4B4-5454-A552-4499C2843F25",
"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.[VatSum], h.[VatSumFC], h.[Comments], h.[Confirmed], h.[PartSupply], CASE h.DocStatus WHEN 'O' THEN N'Open' WHEN 'C' THEN N'Closed' ELSE CASE WHEN h.DocStatus IS NULL THEN N'Not specified' ELSE N'Unknown' END END AS OrderState, CASE h.DocType WHEN 'I' THEN N'Items' WHEN 'S' THEN N'Services' ELSE CASE WHEN h.DocType IS NULL THEN N'Not specified' ELSE N'Unknown' END END AS DocumentKind, CASE h.Confirmed WHEN 'Y' THEN N'Yes' WHEN 'N' THEN N'No' ELSE CASE WHEN h.Confirmed IS NULL THEN N'Not specified' ELSE N'Unknown' END END AS ConfirmationState, CASE h.PartSupply WHEN 'Y' THEN N'Yes' WHEN 'N' THEN N'No' ELSE CASE WHEN h.PartSupply IS NULL THEN N'Not specified' ELSE N'Unknown' END END AS PartialDeliveryState FROM dbo.OPOR 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": "7D9E39D7-71D9-56DC-BA4E-C31350295079",
"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": "LineStatus",
"label": "Line status code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineStatus",
"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": "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": "ShipDate",
"label": "Line delivery date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ShipDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OpenQty",
"label": "Remaining open quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OpenQty",
"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": "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": false
},
{
"commonFieldKey": "",
"key": "VatPrcnt",
"label": "Tax (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VatPrcnt",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "unitMsr",
"label": "Unit on document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "unitMsr",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineState",
"label": "Line status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Order lines",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "DocEntry",
"id": "AA5340EA-F5CB-54CD-BEEF-E220EB59F383",
"name": "document",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"Dscription",
"Currency",
"WhsCode",
"unitMsr",
"LineState"
],
"sourceID": "55FADC3B-B4B4-5454-A552-4499C2843F25",
"sqlQuery": "SELECT CONCAT(CAST(l.DocEntry AS varchar(20)), N':', CAST(l.LineNum AS varchar(20))) AS row_id, l.[DocEntry], l.[LineNum], l.[LineStatus], l.[ItemCode], l.[Dscription], l.[Quantity], l.[ShipDate], l.[OpenQty], l.[Price], l.[Currency], l.[LineTotal], l.[TotalFrgn], l.[WhsCode], l.[DiscPrcnt], l.[VatPrcnt], l.[unitMsr], CASE l.LineStatus WHEN 'O' THEN N'Open' WHEN 'C' THEN N'Closed' ELSE CASE WHEN l.LineStatus IS NULL THEN N'Not specified' ELSE N'Unknown' END END AS LineState FROM dbo.POR1 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": "8B673952-7E59-59DA-B53A-4D45693ABA87",
"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": "CD0E1D16-457B-5942-AF8E-20B3ECE4B535",
"name": "partner",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"CardCode",
"CardName",
"Currency",
"Phone1",
"E_Mail",
"PartnerKind"
],
"sourceID": "55FADC3B-B4B4-5454-A552-4499C2843F25",
"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": "8233223D-4FBE-53FF-8786-6F68D4D781B3",
"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": "B191C3AB-6297-57CF-8D9C-37399A7A83BF",
"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": "55FADC3B-B4B4-5454-A552-4499C2843F25",
"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": "E27A3628-1972-57C3-B374-A96920E7C373",
"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": "E20C9849-197B-5CFD-8EBC-A6D0D538D4ED",
"name": "item",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"WhsCode",
"ItemName",
"InvntryUom",
"WhsName"
],
"sourceID": "55FADC3B-B4B4-5454-A552-4499C2843F25",
"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": "A87BA948-CA02-5EFD-8CDE-F261397B63C7",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "58A948D4-C7C5-5905-8C6B-B42B1BE5A6D9",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "7D9E39D7-71D9-56DC-BA4E-C31350295079",
"title": "Order lines",
"urlKey": ""
},
{
"id": "7D7F1713-7FB0-5127-A88A-6A794E646FA0",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "FC0DAB77-B933-5D25-89CD-5B9F6AEB3596",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8B673952-7E59-59DA-B53A-4D45693ABA87",
"title": "Business partner",
"urlKey": ""
}
],
"badgeKey": "OrderState",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocDueDate",
"label": "Planned order 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"
}
],
"datasetID": "F9A3F8D1-9708-5132-9B50-0C2C7BE5B9BA",
"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": "Planned order 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": "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": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "OrderState",
"label": "Order status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "DocumentKind",
"label": "Document type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "ConfirmationState",
"label": "Confirmed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "PartialDeliveryState",
"label": "Partial delivery allowed",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "F014F93A-55B8-5DEE-988B-F2A27035043D",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "E3A6C267-9132-5C54-957F-F70818A2E7BD",
"includeAllOption": false,
"key": "DocDate",
"title": "Posting 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": "tablecells",
"title": "Purchase orders",
"titleKey": "CardName"
},
{
"actions": [
{
"id": "A2715B7F-6AAC-5603-A67A-68216265FAD1",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "E0EF970A-B2D2-5BFE-A253-8474C89A31CC",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8233223D-4FBE-53FF-8786-6F68D4D781B3",
"title": "Product dossier",
"urlKey": ""
},
{
"id": "1D4EE343-82CB-52A4-9548-0D295D6F5C30",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "F85058C8-84C7-5B34-8629-C457C0CB8D6A",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "E27A3628-1972-57C3-B374-A96920E7C373",
"title": "Stock in all warehouses",
"urlKey": ""
}
],
"badgeKey": "LineState",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Quantity",
"label": "Quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ShipDate",
"label": "Line delivery date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OpenQty",
"label": "Remaining open 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": "unitMsr",
"label": "Unit on document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "7D9E39D7-71D9-56DC-BA4E-C31350295079",
"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": "Dates and references",
"detailRole": "information",
"isVisible": true,
"key": "ShipDate",
"label": "Line delivery date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Line quantities and pricing",
"detailRole": "information",
"isVisible": true,
"key": "OpenQty",
"label": "Remaining open 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": "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"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "LineState",
"label": "Line status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "35B4AD7F-4E06-54D4-8977-1F7B08CF5967",
"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": "tablecells",
"title": "Order 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": "8B673952-7E59-59DA-B53A-4D45693ABA87",
"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": "545C8CEC-2DB9-5BCE-B874-51189486ABFC",
"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": "07236DFC-9CAC-53FF-BFA6-8C30995D37F2",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "7A0B3477-8FC7-5FD3-B7A7-93C5C295FEA5",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "E27A3628-1972-57C3-B374-A96920E7C373",
"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": "8233223D-4FBE-53FF-8786-6F68D4D781B3",
"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": "33CE52CB-F190-5E42-B626-122C85CB1C8B",
"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": "E27A3628-1972-57C3-B374-A96920E7C373",
"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": "3F955D00-8161-53EE-8FCC-88FBCB33AE7A",
"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": "7D9E39D7-71D9-56DC-BA4E-C31350295079",
"childKey": "DocEntry",
"id": "58A948D4-C7C5-5905-8C6B-B42B1BE5A6D9",
"name": "Order lines",
"parentDatasetID": "F9A3F8D1-9708-5132-9B50-0C2C7BE5B9BA",
"parentKey": "DocEntry"
},
{
"childDatasetID": "8B673952-7E59-59DA-B53A-4D45693ABA87",
"childKey": "CardCode",
"id": "FC0DAB77-B933-5D25-89CD-5B9F6AEB3596",
"name": "Business partner",
"parentDatasetID": "F9A3F8D1-9708-5132-9B50-0C2C7BE5B9BA",
"parentKey": "CardCode"
},
{
"childDatasetID": "8233223D-4FBE-53FF-8786-6F68D4D781B3",
"childKey": "ItemCode",
"id": "E0EF970A-B2D2-5BFE-A253-8474C89A31CC",
"name": "Product dossier",
"parentDatasetID": "7D9E39D7-71D9-56DC-BA4E-C31350295079",
"parentKey": "ItemCode"
},
{
"childDatasetID": "E27A3628-1972-57C3-B374-A96920E7C373",
"childKey": "ItemCode",
"id": "F85058C8-84C7-5B34-8629-C457C0CB8D6A",
"name": "Stock in all warehouses",
"parentDatasetID": "7D9E39D7-71D9-56DC-BA4E-C31350295079",
"parentKey": "ItemCode"
},
{
"childDatasetID": "E27A3628-1972-57C3-B374-A96920E7C373",
"childKey": "ItemCode",
"id": "7A0B3477-8FC7-5FD3-B7A7-93C5C295FEA5",
"name": "Stock in all warehouses",
"parentDatasetID": "8233223D-4FBE-53FF-8786-6F68D4D781B3",
"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\nFor purchasing and replenishment teams and managers: review purchase orders by posting period and open the selected order’s lines. The order status and line status are distinct; canceled orders are excluded, closed orders remain visible. Remaining quantity is SAP’s native OpenQty, not ordered quantity minus a guessed delivered amount. Delivery dates are planned document dates, not proof of fulfilment. Keep each line quantity with its document unit and price currency; do not total unlike units or currencies. Product and warehouse drilldowns are meaningful for item lines; service lines remain visible without an item. Current warehouse stock is not a reservation guarantee or stock at the order date. Order totals are not invoice balances, amounts overdue or evidence of payment. Cards label local-currency amounts separately from foreign-currency values; the document currency does not label the local total. Document numbers are identifiers, not formatted amounts. The stock button on an item line shows that item across all warehouses, not just the line warehouse.\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": "AF0FC489-593C-50DF-A708-FC81D717D90B",
"rootButtonCount": 1,
"summary": "Posting period, partner, dates and totals; order lines, open quantities, products and warehouse stock.",
"tags": [
"SAP Business One",
"SQL Server",
"pro"
],
"title": "Purchase orders and fulfilment details — Pro"
}
}