Dictionary
The tables, explained
Every table and field shows its business label, right inside the editor.
SQL Editor · IntellX
Built-in table dictionary, autocompletion on your folder and your custom fields, guarded read-only execution. Queries written in minutes instead of an afternoon.
From your browser · No direct database access for your users
| Item | Description | Stock | Min |
|---|---|---|---|
| BMS0100 | Engine block S100 | 12 | 50 |
| BMS0240 | Engine block S240 | 3 | 25 |
| CPL1120 | Coupling 1120 | 0 | 40 |
The problem
The Sage X3 data model is not something you improvise: thousands of tables, abbreviated field names, dimension suffixes, and your own additions on top.
Finding the right table
ITMMASTER, ITMFACILIT, ITMMVT, STOCK: which one holds the data you are after?
Decoding the fields
_0 suffixes, activity codes, miscellaneous tables: a field name does not say what it holds.
Working without a safety net
Running a query straight on the production database is a risk nobody enjoys taking.
Features
Dictionary
Every table and field shows its business label, right inside the editor.
Assistance
Describe what you are looking for, the editor proposes the query, the joins and the filters that go with it.
Autocompletion
Standard tables, custom fields, company and site codes: completion knows your environment, not a theoretical X3.
Security
Read only by default. Queries run with guardrails, and every run is logged.
Results
Results you can sort, filter and export to Excel or CSV for your analysis.
Team
Useful queries become a common library, instead of circulating by e-mail.
In practice
1 · Your question
"Revenue invoiced per customer in 2026, with the number of invoices"
2 · The proposed query
SELECT BPR_0, COUNT(*) AS NB, SUM(AMTNOT_0) AS CA_HT FROM SINVOICE WHERE YEAR(ACCDAT_0) = 2026 GROUP BY BPR_0
3 · The result
| CL0042 | 318 400 € |
| CL0117 | 247 950 € |
| CL0008 | 96 300 € |
You review, you adjust, you export.
Illustrative example, on demonstration data.
Security
The editor is for reading, understanding and extracting. Writes into Sage X3 go through the standard screens and mechanisms, never through a query.
Who uses it
Developers
Check a value during development, without leaving the browser.
Consultants
Diagnose a setup discrepancy by querying the folder directly.
Finance and controlling
Pull a reliable extract without queuing behind IT.
Bring the query that has been resisting you for weeks. We write it together during the demo.


30 min with Adrien or Laurent.
We solve your current X3 headache together.