Customers and suppliers — Free
Partner directory, contact information, currency and current balances.
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.
Business partners with a type selector (customer, supplier or lead). Balances are current SAP partner balances, not totals for a selected invoice period. The native partner currency setting is not a label for the local-currency balance. Telephone and email are optional private source fields and must never be real in public screenshots.
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: Business partners
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": "A3210A21-4F96-5FEB-8497-D4AB832AC17D",
"kind": "sqlServer",
"requiredObjects": [
"dbo.OCRD"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "F6C0D916-4391-5820-AF49-C16FC991F9FF",
"key": "CardName",
"type": "text"
},
{
"direction": "ascending",
"id": "337CB9A8-A225-502D-AAF1-82A8A1229730",
"key": "CardCode",
"type": "text"
}
],
"id": "C6301520-EB71-5B77-B47A-D52607AA4333",
"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": true,
"visibleInList": true
},
{
"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": true
},
{
"commonFieldKey": "",
"key": "E_Mail",
"label": "Email",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "E_Mail",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Business partners",
"primaryKey": "CardCode",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"CardCode",
"CardName",
"CardType",
"Currency",
"Phone1",
"E_Mail"
],
"sourceID": "A3210A21-4F96-5FEB-8497-D4AB832AC17D",
"sqlQuery": "",
"tableName": "dbo.OCRD"
}
],
"pages": [
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CardType",
"label": "Type (C / S / L)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"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": "Phone1",
"label": "Telephone",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "C6301520-EB71-5B77-B47A-D52607AA4333",
"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": "CardType",
"label": "Partner type (C: customer; S: supplier; L: lead)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Identity",
"detailRole": "information",
"isVisible": true,
"key": "Currency",
"label": "Partner currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Balances and credit",
"detailRole": "information",
"isVisible": true,
"key": "Balance",
"label": "Balance — local currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Balances and credit",
"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"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "7F65E295-4749-56CD-B981-1EC488148C86",
"openFilters": [
{
"id": "39B43E0E-63DF-517F-B931-C8C99415125E",
"includeAllOption": true,
"key": "CardType",
"title": "Partner type (C / S / L)",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "F6C0D916-4391-5820-AF49-C16FC991F9FF",
"key": "CardName",
"type": "text"
},
{
"direction": "ascending",
"id": "337CB9A8-A225-502D-AAF1-82A8A1229730",
"key": "CardCode",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "CardCode",
"systemImage": "tablecells",
"title": "Business partners",
"titleKey": "CardName"
}
],
"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\nBusiness partners with a type selector (customer, supplier or lead). Balances are current SAP partner balances, not totals for a selected invoice period. The native partner currency setting is not a label for the local-currency balance. Telephone and email are optional private source fields and must never be real in public screenshots.\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": "8605676B-E9E8-5B7D-8602-668031B0A623",
"rootButtonCount": 1,
"summary": "Partner directory, contact information, currency and current balances.",
"tags": [
"SAP Business One",
"SQL Server",
"free"
],
"title": "Customers and suppliers — Free"
}
}