Business partners — Free
Search type, business unit, legacy reference and business classification. Documented; not tested on a real ERP.
UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. Selected physical names and business meanings are documented in Oracle EnterpriseOne 9.2/9.2.x manuals. No real EnterpriseOne, SQL Server or iOS installation has been tested. Confirm your edition, owner, permissions and data at import. This is EnterpriseOne, not JD Edwards World.
For sales, purchasing, service teams and managers: find an authorized business partner by name or long/legacy reference, select a search type and business unit on opening, and review the recorded business classification and credit-message code on your phone.
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.
The complete card shows the partner name, long/legacy reference, search type, business-unit code, industry classification, credit-message code and person/corporation code. Details groups seven useful fields of the same record into Partner identity, Business scope and classification, and Recorded credit message. The technical address number remains hidden. This is a master register, not an invoice, address, contact or balance dossier. It does not invent telephone numbers, mailing addresses, account balances, credit limits, activity dates or active-contract status.
Codes remain exactly as recorded. Search type is configurable UDC 01/ST; commonly documented examples include C for customer and V for supplier, but the template does not hardcode a customer-only rule. Search type is not the separate receivables/payables flag, transaction history or proof of an active relationship. Business unit is not a company or automatic tenant boundary. Industry classification may use different classification systems. Credit message is the recorded 00/CM code, not a numeric amount or the separately maintained temporary credit message. Person/corporation codes depend on country; no universal label or tax identification number is inferred. Unknown values and blanks are retained.
Free: one source, one native list with same-row Details; no custom SQL, relations, sub-buttons, widgets or periodic refresh. Live reads are limited to 2,000 records. Local search and sorting apply only to loaded rows; reaching the limit is not proof that all partners have been read. Narrow the opening choices when appropriate. Your existing workspace also counts towards plan limits.
This adapter explicitly requires the existing object TESTDTA.F0101 and eight selected columns. TESTDTA is the owner used in an Oracle example, not a universal production owner or an instruction to connect to a test environment. The package creates no objects, views, accounts or permissions, and does not automatically discover another owner. Ask the administrator to select the correct authorized database and owner, then remap and test when needed. Confirm installed column types and a non-null, unique ABAN8 address number; the manuals do not certify your installed SQL primary key. F0101Z2 batch-field descriptions support dictionary meanings, not the installed F0101 SQL Server DDL. No batch table is read or written. Microsoft SQL Server is a documented EnterpriseOne platform; confirm the supported version and licensing for your installation. This is not the EnterpriseOne JDBC/Open Data Access driver, an Oracle Database package, automatic cloud access or a certified vendor integration.
Use a separate SELECT-only account restricted by the administrator to authorized records and columns. Direct SQL does not inherit EnterpriseOne row security, OCM routing or user permissions. Opening filters are not access control, even when all is available. Address Book may contain employees and personal names: restrict the source before connecting. Tax IDs, Social Security numbers, banking data, passwords, connection details, birth dates and audit-user fields are excluded from this projection. The images are real Cifru Android screenshots using wholly invented DEMO data and a synthetic-only transport; they are not a real EnterpriseOne connection. Cifru does not change records or replace native workflows or Oracle mobile solutions.
Physical evidence: https://docs.oracle.com/en/applications/jd-edwards/customer-relationship/9.2/eoacf/inserting-tokens-in-the-email-body.html ; https://docs.oracle.com/en/applications/jd-edwards/administration/9.2.x/eotsc/exclusive-row-security.html . Business meanings: https://docs.oracle.com/en/applications/jd-edwards/cross-product/9.2/eoaab/required-fields-6.html ; https://docs.oracle.com/en/applications/jd-edwards/cross-product/9.2/eoaab/optional-fields-2.html . SQL source/owner: https://docs.oracle.com/en/applications/jd-edwards/administration/9.2.x/eotsa/data-sources.html
Gallery coverage: Two complementary native images show the actual C / DEMO-OPS opening choices, the complete seven-value partner card and all seven same-row Details values. Recorded codes are not interpreted as current credit limits or active contracts. This Free has no related lists or sub-buttons. Home, other rows, earlier takes and RAW remain private. Android DEMO with synthetic-only transport, not a real ERP/SQL Server/iOS or Free purchase test.
Screenshots
What this package creates
- Home: Business partners
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "JD Edwards EnterpriseOne — SQL Server",
"id": "6B88B30B-B28B-5AA3-A005-6D16267FE8D7",
"kind": "sqlServer",
"requiredObjects": [
"TESTDTA.F0101"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "4B6663D2-E02F-5930-A81E-148FB4645C2D",
"key": "ABALPH",
"type": "text"
},
{
"direction": "ascending",
"id": "CD7356B8-4B81-53F7-BDFB-E447F2F04E05",
"key": "ABAN8",
"type": "number"
}
],
"id": "76926368-9769-5A84-AE65-3ED89680E99C",
"mappings": [
{
"commonFieldKey": "",
"key": "ABAN8",
"label": "Internal address number",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ABAN8",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ABALPH",
"label": "Partner name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ABALPH",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ABALKY",
"label": "Long / legacy reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ABALKY",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ABAT1",
"label": "Search type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ABAT1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ABMCU",
"label": "Business unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ABMCU",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ABSIC",
"label": "Industry classification",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ABSIC",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ABCM",
"label": "Credit message code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ABCM",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ABTAXC",
"label": "Person / corporation code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "ABTAXC",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 2000,
"name": "Business partners",
"primaryKey": "ABAN8",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"ABALPH",
"ABALKY",
"ABAT1",
"ABMCU",
"ABSIC",
"ABCM",
"ABTAXC"
],
"sourceID": "6B88B30B-B28B-5AA3-A005-6D16267FE8D7",
"sqlQuery": "",
"tableName": "TESTDTA.F0101"
}
],
"pages": [
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ABAT1",
"label": "Search type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ABMCU",
"label": "Business unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ABSIC",
"label": "Industry classification",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ABCM",
"label": "Credit message code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ABTAXC",
"label": "Person / corporation code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "76926368-9769-5A84-AE65-3ED89680E99C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Partner identity",
"detailRole": "information",
"isVisible": true,
"key": "ABALPH",
"label": "Partner name",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Partner identity",
"detailRole": "information",
"isVisible": true,
"key": "ABALKY",
"label": "Long / legacy reference",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Business scope and classification",
"detailRole": "information",
"isVisible": true,
"key": "ABAT1",
"label": "Search type code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Business scope and classification",
"detailRole": "information",
"isVisible": true,
"key": "ABMCU",
"label": "Business unit code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Business scope and classification",
"detailRole": "information",
"isVisible": true,
"key": "ABSIC",
"label": "Industry classification",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Recorded credit message",
"detailRole": "information",
"isVisible": true,
"key": "ABCM",
"label": "Credit message code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Partner identity",
"detailRole": "information",
"isVisible": true,
"key": "ABTAXC",
"label": "Person / corporation code",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "6B836712-39BC-59FA-8ACF-A22025227FC6",
"openFilters": [
{
"id": "674F8F35-4A34-5436-974E-69B20516792C",
"includeAllOption": true,
"key": "ABAT1",
"title": "Search type (01/ST code)",
"type": "text"
},
{
"id": "F9EEE7B4-FB40-5AED-BB80-6309AF737D5C",
"includeAllOption": true,
"key": "ABMCU",
"title": "Business unit (recorded code)",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "4B6663D2-E02F-5930-A81E-148FB4645C2D",
"key": "ABALPH",
"type": "text"
},
{
"direction": "ascending",
"id": "CD7356B8-4B81-53F7-BDFB-E447F2F04E05",
"key": "ABAN8",
"type": "number"
}
],
"subtitle": "",
"subtitleKey": "ABALKY",
"systemImage": "person.2",
"title": "Business partners",
"titleKey": "ABALPH"
}
],
"relations": [],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "JD Edwards EnterpriseOne",
"configurationLanguages": [
"en"
],
"countries": [
"US"
],
"createdAt": "2026-10-10T00:00:00Z",
"description": "UNOFFICIAL — NOT VALIDATED ON A REAL ERP INSTALLATION. Selected physical names and business meanings are documented in Oracle EnterpriseOne 9.2/9.2.x manuals. No real EnterpriseOne, SQL Server or iOS installation has been tested. Confirm your edition, owner, permissions and data at import. This is EnterpriseOne, not JD Edwards World.\n\nFor sales, purchasing, service teams and managers: find an authorized business partner by name or long/legacy reference, select a search type and business unit on opening, and review the recorded business classification and credit-message code on your phone.\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\nThe complete card shows the partner name, long/legacy reference, search type, business-unit code, industry classification, credit-message code and person/corporation code. Details groups seven useful fields of the same record into Partner identity, Business scope and classification, and Recorded credit message. The technical address number remains hidden. This is a master register, not an invoice, address, contact or balance dossier. It does not invent telephone numbers, mailing addresses, account balances, credit limits, activity dates or active-contract status.\n\nCodes remain exactly as recorded. Search type is configurable UDC 01/ST; commonly documented examples include C for customer and V for supplier, but the template does not hardcode a customer-only rule. Search type is not the separate receivables/payables flag, transaction history or proof of an active relationship. Business unit is not a company or automatic tenant boundary. Industry classification may use different classification systems. Credit message is the recorded 00/CM code, not a numeric amount or the separately maintained temporary credit message. Person/corporation codes depend on country; no universal label or tax identification number is inferred. Unknown values and blanks are retained.\n\nFree: one source, one native list with same-row Details; no custom SQL, relations, sub-buttons, widgets or periodic refresh. Live reads are limited to 2,000 records. Local search and sorting apply only to loaded rows; reaching the limit is not proof that all partners have been read. Narrow the opening choices when appropriate. Your existing workspace also counts towards plan limits.\n\nThis adapter explicitly requires the existing object TESTDTA.F0101 and eight selected columns. TESTDTA is the owner used in an Oracle example, not a universal production owner or an instruction to connect to a test environment. The package creates no objects, views, accounts or permissions, and does not automatically discover another owner. Ask the administrator to select the correct authorized database and owner, then remap and test when needed. Confirm installed column types and a non-null, unique ABAN8 address number; the manuals do not certify your installed SQL primary key. F0101Z2 batch-field descriptions support dictionary meanings, not the installed F0101 SQL Server DDL. No batch table is read or written. Microsoft SQL Server is a documented EnterpriseOne platform; confirm the supported version and licensing for your installation. This is not the EnterpriseOne JDBC/Open Data Access driver, an Oracle Database package, automatic cloud access or a certified vendor integration.\n\nUse a separate SELECT-only account restricted by the administrator to authorized records and columns. Direct SQL does not inherit EnterpriseOne row security, OCM routing or user permissions. Opening filters are not access control, even when all is available. Address Book may contain employees and personal names: restrict the source before connecting. Tax IDs, Social Security numbers, banking data, passwords, connection details, birth dates and audit-user fields are excluded from this projection. The images are real Cifru Android screenshots using wholly invented DEMO data and a synthetic-only transport; they are not a real EnterpriseOne connection. Cifru does not change records or replace native workflows or Oracle mobile solutions.\n\nPhysical evidence: https://docs.oracle.com/en/applications/jd-edwards/customer-relationship/9.2/eoacf/inserting-tokens-in-the-email-body.html ; https://docs.oracle.com/en/applications/jd-edwards/administration/9.2.x/eotsc/exclusive-row-security.html . Business meanings: https://docs.oracle.com/en/applications/jd-edwards/cross-product/9.2/eoaab/required-fields-6.html ; https://docs.oracle.com/en/applications/jd-edwards/cross-product/9.2/eoaab/optional-fields-2.html . SQL source/owner: https://docs.oracle.com/en/applications/jd-edwards/administration/9.2.x/eotsa/data-sources.html\n\nGallery coverage: Two complementary native images show the actual C / DEMO-OPS opening choices, the complete seven-value partner card and all seven same-row Details values. Recorded codes are not interpreted as current credit limits or active contracts. This Free has no related lists or sub-buttons. Home, other rows, earlier takes and RAW remain private. Android DEMO with synthetic-only transport, not a real ERP/SQL Server/iOS or Free purchase test.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "free",
"packageID": "E26DFC72-F147-5D1A-8DDE-02F5E2876E82",
"rootButtonCount": 1,
"summary": "Search type, business unit, legacy reference and business classification. Documented; not tested on a real ERP.",
"tags": [
"JD Edwards EnterpriseOne",
"SQL Server",
"Business partners",
"Customers",
"Suppliers",
"Free"
],
"title": "Business partners — Free"
}
}