data-dictionary-lookup

What problem does it solve?

It solves the problem of not knowing how Protheus ADVPL/TLPP table metadata is structured, how fields relate, and what dictionary impact your changes may have.

Core Features & Use Cases

• Dictionary discovery across SX catalogs*: look up table metadata, fields, indexes, triggers, parameters (MV_*), generic tables, parameterization questions, relationships, and standard lookups.
• Impact validation for refactoring/migrations: confirm whether your planned code improvements affect fields, triggers, indexes, parameters, or relationships of the involved tables.
• Query correctness rules: enforces soft-delete filtering and safe SQL patterns (lowercase columns, TRIM for character comparisons, base table names).
• Use cases: “What fields does SA1 have?”, “Which index does SE1 use?”, “What is MV_ESTADO?”, “Triggers for field A1_COD?”, “Standard lookup for SA1 (SXB/F3)”, “Relationship between tables”.

Quick Start

Ask for the dictionary details by saying: Query the Protheus data dictionary for SA1 fields, including indexes and any triggers for A1_COD, and present the results in a clear markdown summary.