web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / AL name for "Sale...
Business Central forum

AL name for "Sales Orders" table? / Resource to lookup AL table names for standard tables?

(0) ShareShare
ReportReport
Posted on by WolterKaper

Dear BC experts,

What name can I use in AL to refer to the "Sales Orders" table that I see in the Business Central UI?
Using the intellisense feature in Visual Studio code, after typing "Sales Ord" I find two candidates:
- "Sales Order Entity Buffer"
- "Trailing Sales Orders Setup"
To avoid similar questions in the future: is there a list of available AL table-names somewhere?

With best regards

Categories:
Other
Business Central
  • WolterKaper Profile Picture
    WolterKaper on at

    After further intellisense explorations and after comparing the results of the self-made page to what I see in the standard UI, I conclude that the table "Sales Header" is the most likely source of the standard UI the Sales Order page.

    It is a better match than the two tables mentioned earlier. It has more of the fields that I see in the UI.

    I remain interested in a work method or a lookup list that would enable me to find this out more quickly...

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,172 Most Valuable Professional on at

    Sales Order Page has two underlying tables: Sales Header (for the Header) and Sales Line (for the lines).

    When developing, the suggestion is to also create a local Docker-based development sandbox, from here you can inspect all objects and see standard code too.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans