Products and stock totals — Free
Item names, barcodes, units, current stock, commitments and purchase orders.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION.
Based on the official SAP Business One 10.0 SDK reference and synthetic tests. Screenshots use native Cifru with fictional DEMO rows, not a live SAP connection. At import, map your authorized company source, run the read/compatibility test and verify the edition, fields, permissions and results before business use.
Native item catalog and aggregate stock held by SAP in OITM. In stock, committed and on order are separate quantities; not a historical stock valuation. No warehouse drilldown on Free. Activity flags do not replace SAP date-validity rules.
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: Y = Yes, N = No; partner type C = Customer, S = Supplier, L = Lead. A multi-currency partner setting is not an ISO currency code. Native foreign balances must not be combined across currencies; use SAP for currency-specific reconciliation. Active/inactive item flags alone do not apply SAP validity dates or document rules. Stock is a current snapshot in inventory units, not a historical valuation or a promise of availability. SQL Server 2012 or newer is needed for custom SQL CONCAT/DATALENGTH where used. The configured read cap does not guarantee an inexpensive server scan. Public documentation: https://help.sap.com/docs/SAP_BUSINESS_ONE
Screenshots
What this package creates
1 Home0 Details1 lists1 sources to map
- Home: Products
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "SAP Business One 10.0 — SQL Server",
"id": "53C15B19-3C80-55E5-9C6B-C91F4CCB6EE7",
"kind": "sqlServer",
"requiredObjects": [
"dbo.OITM"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "A297A14A-715A-5DFD-BD86-50BBDADE5921",
"key": "ItemName",
"type": "text"
},
{
"direction": "ascending",
"id": "E3487B36-735E-5C77-859B-D4C1CBC9C6E9",
"key": "ItemCode",
"type": "text"
}
],
"id": "C1B58524-1610-580E-ABEA-854209BD4A7D",
"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": "FrgnName",
"label": "Additional item name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FrgnName",
"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": "InvntItem",
"label": "Inventory item (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvntItem",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SellItem",
"label": "Sales item (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SellItem",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PrchseItem",
"label": "Purchase item (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PrchseItem",
"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": "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": "InvntryUom",
"label": "Inventory unit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "InvntryUom",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"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": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "validFor",
"label": "Active flag (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "validFor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Products",
"primaryKey": "ItemCode",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ItemCode",
"ItemName",
"FrgnName",
"CodeBars",
"InvntItem",
"SellItem",
"PrchseItem",
"BuyUnitMsr",
"SalUnitMsr",
"InvntryUom",
"frozenFor",
"validFor"
],
"sourceID": "53C15B19-3C80-55E5-9C6B-C91F4CCB6EE7",
"sqlQuery": "",
"tableName": "dbo.OITM"
}
],
"pages": [
{
"actions": [],
"badgeKey": "OnHand",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CodeBars",
"label": "Barcode",
"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": "InvntryUom",
"label": "Inventory unit",
"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"
}
],
"datasetID": "C1B58524-1610-580E-ABEA-854209BD4A7D",
"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": "FrgnName",
"label": "Additional item name",
"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": "InvntItem",
"label": "Inventory item (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "SellItem",
"label": "Sales item (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "PrchseItem",
"label": "Purchase item (Y/N)",
"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": "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": "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": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "frozenFor",
"label": "Inactive flag (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Units and settings",
"detailRole": "information",
"isVisible": true,
"key": "validFor",
"label": "Active flag (Y/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "5F46E900-67D9-5532-947E-6BCA2F45539D",
"openFilters": [
{
"id": "8400C3C2-0021-50B2-9DBA-F1B90AB5EF99",
"includeAllOption": true,
"key": "InvntItem",
"title": "Inventory item (Y/N)",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "A297A14A-715A-5DFD-BD86-50BBDADE5921",
"key": "ItemName",
"type": "text"
},
{
"direction": "ascending",
"id": "E3487B36-735E-5C77-859B-D4C1CBC9C6E9",
"key": "ItemCode",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ItemCode",
"systemImage": "tablecells",
"title": "Products",
"titleKey": "ItemName"
}
],
"relations": [],
"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 use native Cifru with fictional DEMO rows, not a live SAP connection. At import, map your authorized company source, run the read/compatibility test and verify the edition, fields, permissions and results before business use.\n\nNative item catalog and aggregate stock held by SAP in OITM. In stock, committed and on order are separate quantities; not a historical stock valuation. No warehouse drilldown on Free. Activity flags do not replace SAP date-validity rules.\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: Y = Yes, N = No; partner type C = Customer, S = Supplier, L = Lead. A multi-currency partner setting is not an ISO currency code. Native foreign balances must not be combined across currencies; use SAP for currency-specific reconciliation. Active/inactive item flags alone do not apply SAP validity dates or document rules. Stock is a current snapshot in inventory units, not a historical valuation or a promise of availability. SQL Server 2012 or newer is needed for custom SQL CONCAT/DATALENGTH where used. The configured read cap does not guarantee an inexpensive server scan. Public documentation: https://help.sap.com/docs/SAP_BUSINESS_ONE",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "free",
"packageID": "1EE07C26-C0E5-5FF7-9738-60102C530849",
"rootButtonCount": 1,
"summary": "Item names, barcodes, units, current stock, commitments and purchase orders.",
"tags": [
"SAP Business One",
"SQL Server",
"free"
],
"title": "Products and stock totals — Free"
}
}