The System Dictionary
The Metric Dictionary says what a number means. This says which system holds it, what the records inside are called, how the data actually comes out, and which join will silently return nothing. Written for whoever has to go and get the number.
01 ERP and finance
ERP and finance
The systems of record for money: what was ordered, posted, consolidated and planned. Every value tree reconciles here in the end.
SAP ECC and S/4HANA
The financial and logistical system of record for most large enterprises: what was ordered, made, moved, invoiced and posted.
SAP ECC 6.0, S/4HANA (on-premise, RISE, private and public cloud)OracleOracle ERP
The same role as SAP in a different estate: ledger, procurement, order management and the sub-ledgers that feed them.
Oracle E-Business Suite, Oracle Fusion Cloud ERP, PeopleSoft, JD EdwardsD365Microsoft Dynamics 365
The mid-market and divisional ERP of choice, and increasingly the second ERP inside a group that also runs SAP or Oracle.
Dynamics 365 Finance & Operations, Business Central, Dynamics AX / NAV legacyEPMConsolidation and planning (EPM)
Where the group result is assembled and where the plan lives: consolidation, eliminations, currency translation, budget and forecast.
OneStream, Oracle EPM / Hyperion, Anaplan, SAP BPC and Group Reporting, Board02 Commercial
Commercial
Everything before and around the order — pipeline, storefront and till. This is where the customer is described, usually more than once.
Salesforce and CRM
The commercial system of record before an order exists: accounts, contacts, pipeline, activity and service cases.
Salesforce Sales and Service Cloud, Microsoft Dynamics 365 Sales, HubSpot, ZohoECOME-commerce platform
The digital storefront: sessions, baskets, orders and the fulfilment promise made at checkout.
Shopify, Salesforce Commerce Cloud, Adobe Commerce / Magento, SAP Commerce, customPOSPoint of sale
The record of what was actually sold, in store, at the moment it happened.
Oracle Micros, NCR, Toshiba, Lightspeed, Square, SAP Customer Checkout03 Operations
Operations
What actually happened on the line and to the asset. High volume, low value per row, and the only place physical loss exists.
Manufacturing execution (MES)
The record of what actually happened on the line, minute by minute.
Siemens Opcenter, Rockwell FactoryTalk, AVEVA, SAP ME / DMC, in-housePIProcess historian and SCADA
The continuous record of process values: temperatures, pressures, flows, speeds and states, sampled constantly.
AVEVA PI System, Honeywell PHD, Yokogawa Exaquantum, InfluxDB, IgnitionPLMProduct lifecycle management
What the product is meant to be: specification, structure, revisions and the changes made to them over time.
Siemens Teamcenter, PTC Windchill, Dassault ENOVIA, Autodesk, SAP PLMQMSQuality management (QMS)
The record of what went wrong, what was done about it, and what it cost.
Veeva QualityDocs, MasterControl, ETQ, Sparta TrackWise, SAP QMCMMS / EAMMaintenance and asset management
The asset register and its work history: what you own, what has broken, and what was done about it.
IBM Maximo, SAP PM / EAM, Infor EAM, Fiix, UpKeep04 Supply chain
Supply chain
Stock, movement and supply. The systems that decide service level and hold most of the working capital.
Warehouse management
What is physically where, and every movement that put it there.
Manhattan, Blue Yonder, SAP EWM, Korber, Oracle WMSTMSTransport management
How goods move: planning, tendering, execution, tracking and what each movement cost.
Oracle OTM, Blue Yonder TMS, MercuryGate, Transporeon, project44 for visibilityS2PProcurement and source-to-pay
What the business buys, from whom, at what price, under which contract.
SAP Ariba, Coupa, Jaggaer, Ivalua, Oracle Procurement Cloud05 Workforce
Workforce
Who works here, what they were paid and what they were available to do. The largest cost line in most service businesses.
HR information system
The people record: who works here, in which role, reporting to whom, at what cost.
Workday, SAP SuccessFactors, Oracle HCM, Personio, BambooHRT&APayroll and time attendance
What people were actually paid, and what hours produced that payment.
ADP, SD Worx, Ceridian, Kronos / UKG, SAP Payroll06 Financial services
Financial services
The regulated cores: accounts, payments, policies and claims. Account-centric by design, which is why customer resolution is so hard here.
Core banking
The ledger of the bank: accounts, balances and every posting against them.
Temenos, Finacle, Flexcube, Mambu, FIS, FiservSwitchPayments and cards switch
The movement of money in real time, and the fee events attached to each movement.
ACI, FIS, Fiserv, Visa and Mastercard scheme interfaces, domestic schemesPASPolicy administration
The contract of record in insurance: what is covered, for whom, on what terms, at what premium.
Guidewire PolicyCenter, Duck Creek, Sapiens, Majesco, in-houseClaimsClaims management
What the risk actually cost: notification, reserving, handling and settlement.
Guidewire ClaimCenter, Duck Creek Claims, Sapiens, in-house07 Healthcare
Healthcare
The clinical record and the billing record of the same episode, which never match by design.
08 Travel
Travel
Perishable inventory sold against a countdown, where the booking mutates until departure.
09 Facilities
Facilities
Estate, assets and the work orders against them — contracted service delivered somewhere you do not own.
— Why this exists
The join is the work
Almost every question worth asking crosses two systems. The calculation is arithmetic; finding the same customer, item or asset on both sides of the join is the part that takes the quarter. Each page here names the keys that work, the keys that look like they work, and the ones that quietly return nothing.
Connect the systems on this page
SCIKIQ ships with 187+ connectors and governs what the data means once it lands.