aurelienclere-365/d365fo-cowork-plugin/d365fo-table-search

D365FO Table Search

Explore table definitions, field lists, data types, relations, and indexes from the D365FO metadata index.

When to use

• User asks about fields, EDTs, or mandatory flags on a specific table
• User asks how two tables are related (FK relations, join conditions, cardinality)
• User asks about indexes, primary keys, or unique constraints
• User asks which tables belong to a business area or process
• User is building a report, integration spec, or entity diagram and needs join keys

Workflow

1. Identify the target table(s). Extract table names from the question. If ambiguous, call

search_tables(keywords) to find candidates and confirm the best match.

1. Retrieve field metadata. Call get_table_info(tableName) to get the full field list:

name, EDT, base type, mandatory flag, and label.

1. Retrieve relations (if asked). Call get_table_relations(tableName) for FK links to

other tables. Do this for each table when the user asks about joins.

1. Retrieve indexes (if asked). Call get_table_indexes(tableName) for index definitions,

uniqueness, and whether they are the cluster index.

1. Retrieve methods (if asked). Call get_table_methods(tableName) for method signatures.

1. Format and present using the Output Format tables. Filter columns to what the user

actually needs — do not dump all 200+ fields unless explicitly requested.

Output Format

Field list

Relations

Indexes

Notes

• EDTs shown as TypeName (base: ActualType length) — e.g., SalesIdBase (str 20).
• For large tables (100+ fields), group by category: identifiers, FK references,

amounts, dates, flags. Only expand a category if the user asks about it.

• If a table is not found by exact name, try search_tables with keywords from the

business concept (e.g., "sales line" instead of "SalesLine").

• See references/field-types.md for common EDT families.