SAP Business One
A/R invoices with line details
Standard OINV invoice cards with an inline INV1 line-item table.
A/R invoices from the standard SAP Business One SQL Server tables OINV and INV1, with line items shown inside the invoice record. This package is for the SQL Server edition only; it does not claim SAP HANA compatibility.
Prepare SAP Business One / SQL Server:
1. Ask the SAP/SQL administrator for a dedicated SQL login with SELECT only on OINV and INV1 in the company database.
2. Do not use a SAP application user or a database owner. Restrict network access and use TLS/VPN.
3. Confirm fields against the installed SAP Business One version.
Official reference: SAP Business One SDK Help, database tables OINV (A/R Invoice)
and INV1 (A/R Invoice - Rows). Search those exact table names in the SDK Help
matching the installed major version.
Configure Cifru on iPhone/iPad:
1. Sources → Add source → SQL Server; enter server, company database and the SELECT-only login.
2. Keep TLS enabled, test the connection and browse OINV/INV1.
3. Import this package, map its single SQL slot and run compatibility/read testing.
4. Plan Pro is required because the line dataset creates a collision-free row ID from DocEntry + LineNum. Cifru validates that query as SELECT-only before execution.
5. The package contains no company database name, server or credential.
Ce creează pachetul
1 Home1 Detalii2 liste1 surse de legat
- Home: A/R invoices
- Detalii: Invoice lines
- Sub-buton: Invoice lines
Sursele se mapează local și se verifică înainte de aplicare.
Interogări personalizatePRO1 SQL
Interogările personalizate sunt funcții PRO. Cifru repetă validarea read-only pe sursa locală înainte de execuție.
Read-only verificat static
$.components.workspaceSelection.datasets.1.sqlQuerySELECT
CONCAT(CONVERT(varchar(30), DocEntry), '|', CONVERT(varchar(30), LineNum)) AS row_id,
DocEntry, LineNum, ItemCode, Dscription, Quantity, Price, LineTotal, VatSum, WhsCode
FROM INV1static read-only checks passed
Vezi JSON-ul care se importărestrâns implicit
{
"components": {
"sourceSlots": [
{
"displayName": "SAP Business One SQL Server company database",
"id": "BA72F309-4AA5-5870-B22A-7E0389FF8EA9",
"kind": "sqlServer",
"requiredObjects": [
"OINV",
"INV1"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05BBEE1C-9832-5C04-8237-2BFCDD38859E",
"key": "DocDate",
"type": "date"
}
],
"id": "AA2DDE22-B9F3-540F-AFF7-F99AAE157092",
"mappings": [
{
"commonFieldKey": "",
"key": "DocEntry",
"label": "Document entry",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocEntry",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "document_number",
"key": "DocNum",
"label": "Invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocNum",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "DocDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocDueDate",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CardCode",
"label": "Customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CardCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "customer_name",
"key": "CardName",
"label": "Customer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CardName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocTotal",
"label": "Total",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocTotal",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocCur",
"label": "Currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocCur",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocStatus",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocStatus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CANCELED",
"label": "Canceled",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CANCELED",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PaidToDate",
"label": "Paid to date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PaidToDate",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "Comments",
"label": "Comments",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Comments",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "A/R invoices",
"primaryKey": "DocEntry",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"DocEntry",
"DocNum",
"DocDate",
"DocDueDate",
"CardCode"
],
"sourceID": "BA72F309-4AA5-5870-B22A-7E0389FF8EA9",
"sqlQuery": "",
"tableName": "OINV"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "SAP Business One",
"endpointPath": "",
"fetchSortRules": [],
"id": "FDA2C723-687F-56E7-B85A-9D49A84E4C73",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Row ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocEntry",
"label": "Document entry",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocEntry",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineNum",
"label": "Line number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineNum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "product_code",
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ItemCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "product_name",
"key": "Dscription",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Dscription",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "quantity",
"key": "Quantity",
"label": "Quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Quantity",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "Price",
"label": "Unit price",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "Price",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineTotal",
"label": "Line total",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineTotal",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "VatSum",
"label": "VAT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VatSum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WhsCode",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WhsCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 5000,
"name": "A/R invoice lines",
"primaryKey": "row_id",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"row_id",
"DocEntry",
"LineNum",
"ItemCode",
"Dscription"
],
"sourceID": "BA72F309-4AA5-5870-B22A-7E0389FF8EA9",
"sqlQuery": "SELECT\n CONCAT(CONVERT(varchar(30), DocEntry), '|', CONVERT(varchar(30), LineNum)) AS row_id,\n DocEntry, LineNum, ItemCode, Dscription, Quantity, Price, LineTotal, VatSum, WhsCode\nFROM INV1",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "14CFCF47-1A7A-5AA0-9D35-E689AFA2750D",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "25788797-0C39-5F1B-847A-F40431EBA1F4",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "FDA2C723-687F-56E7-B85A-9D49A84E4C73",
"title": "Invoice lines",
"urlKey": ""
}
],
"badgeKey": "DocTotal",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocNum",
"label": "Invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CardName",
"label": "Customer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocStatus",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocTotal",
"label": "Total",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocCur",
"label": "Currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "AA2DDE22-B9F3-540F-AFF7-F99AAE157092",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocEntry",
"label": "Document entry",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocNum",
"label": "Invoice number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocDate",
"label": "Posting date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocDueDate",
"label": "Due date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CardCode",
"label": "Customer code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CardName",
"label": "Customer",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "DocTotal",
"label": "Total",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocCur",
"label": "Currency",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocStatus",
"label": "Status",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CANCELED",
"label": "Canceled",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PaidToDate",
"label": "Paid to date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Comments",
"label": "Comments",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"fixedFilters": [],
"id": "63F106E1-5933-5E20-AEFC-190562D940C1",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05BBEE1C-9832-5C04-8237-2BFCDD38859E",
"key": "DocDate",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "CardName",
"systemImage": "doc.text",
"title": "A/R invoices",
"titleKey": "DocNum"
},
{
"actions": [],
"badgeKey": "Quantity",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Dscription",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Quantity",
"label": "Quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Price",
"label": "Unit price",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineTotal",
"label": "Line total",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WhsCode",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "FDA2C723-687F-56E7-B85A-9D49A84E4C73",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "row_id",
"label": "Row ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocEntry",
"label": "Document entry",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineNum",
"label": "Line number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ItemCode",
"label": "Item code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Dscription",
"label": "Description",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "Quantity",
"label": "Quantity",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "Price",
"label": "Unit price",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "LineTotal",
"label": "Line total",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "VatSum",
"label": "VAT",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "WhsCode",
"label": "Warehouse",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"fixedFilters": [],
"id": "A38FD331-46DF-5583-ABC4-CA494AA5FF7B",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "ItemCode",
"systemImage": "tablecells",
"title": "Invoice lines",
"titleKey": "Dscription"
}
],
"relations": [
{
"childDatasetID": "FDA2C723-687F-56E7-B85A-9D49A84E4C73",
"childKey": "DocEntry",
"id": "25788797-0C39-5F1B-847A-F40431EBA1F4",
"name": "Invoice lines",
"parentDatasetID": "AA2DDE22-B9F3-540F-AFF7-F99AAE157092",
"parentKey": "DocEntry"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "SAP Business One",
"configurationLanguages": [
"en"
],
"countries": [
"ALL"
],
"createdAt": "2026-07-24T16:26:43Z",
"description": "A/R invoices from the standard SAP Business One SQL Server tables OINV and INV1, with line items shown inside the invoice record. This package is for the SQL Server edition only; it does not claim SAP HANA compatibility.\n\nPrepare SAP Business One / SQL Server:\n1. Ask the SAP/SQL administrator for a dedicated SQL login with SELECT only on OINV and INV1 in the company database.\n2. Do not use a SAP application user or a database owner. Restrict network access and use TLS/VPN.\n3. Confirm fields against the installed SAP Business One version.\nOfficial reference: SAP Business One SDK Help, database tables OINV (A/R Invoice)\nand INV1 (A/R Invoice - Rows). Search those exact table names in the SDK Help\nmatching the installed major version.\n\nConfigure Cifru on iPhone/iPad:\n1. Sources → Add source → SQL Server; enter server, company database and the SELECT-only login.\n2. Keep TLS enabled, test the connection and browse OINV/INV1.\n3. Import this package, map its single SQL slot and run compatibility/read testing.\n4. Plan Pro is required because the line dataset creates a collision-free row ID from DocEntry + LineNum. Cifru validates that query as SELECT-only before execution.\n5. The package contains no company database name, server or credential.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0",
"minimumPlan": "pro",
"packageID": "1B7ED790-32D0-5151-8ADA-79049C595A37",
"rootButtonCount": 1,
"summary": "Standard OINV invoice cards with an inline INV1 line-item table.",
"tags": [
"SAP Business One",
"invoices",
"SQL Server",
"ERP"
],
"title": "A/R invoices with line details"
}
}