Practical tools, queries, and documentation built from 10 years working inside the TOTVS Protheus ERP ecosystem.
This repository is a collection of utilities, SQL queries, and technical references developed during real-world work with the Protheus platform (ADVPL/TLPP, REST APIs, data dictionary, manufacturing and agribusiness modules).
Everything here was born from production problems, not theory.
Queries designed to run against the Protheus dictionary tables (SX2, SX3, SXB and others), useful for developers and analysts who need to inspect the ERP structure programmatically.
| Query | Description |
|---|---|
find-function-in-dictionary.sql |
Searches for ADVPL function references across dictionary tables and columns |
Note: All queries are generic and work against the standard Protheus dictionary structure. No client data, no proprietary source code.
Documentation and checklists for forensic analysis of ADVPL routines, focused on data integrity, write mechanisms, and dictionary relationship mapping.
Practical reference for building and consuming REST services in the Protheus environment (ADVPL/TLPP), including common pitfalls and performance considerations.
- Protheus developers and analysts looking for ready-to-use diagnostic tools
- Technical leads doing pre-triage or impact analysis on maintenance demands
- Anyone mapping the Protheus dictionary structure without access to full documentation
- SQL Server connected to a Protheus environment
- Access to the dictionary tables (SX2, SX3, SX5, SX6, SX7, SXB and related)
- Compatibility level 110 or higher (queries include workarounds for environments below level 130)
Thiago Henrique Rover Senior Development Analyst at TOTVS with 10+ years in the Protheus ecosystem, covering Agribusiness, Quality Management and Manufacturing (Production Planning and Control).
Focused on ADVPL development, REST API integration, data governance and technical pre-triage of complex ERP demands.
MIT License. Feel free to use, adapt, and contribute.