Table Extensions in Business Central

 

Ever wondered what really goes on behind the scenes when you're making a table extension in Business Central?


To find the answer, i created a new Extension for table "Sales Header" and added a new field "Rush Shipping".




View in SQL -

>    A new table is created by Business central automatically.

>    New table contains the primary keys from parent table and also the newly added fields.






Comments

Post a Comment

Popular posts from this blog

Image
  Auto Import of Objects from Dev to Test system I got a requirement to develop a solution so that technical changes can be moved automatically from Dev to Test system. Why we want to do this -  1) If developers have direct access on test system then there is a high risk that they will be developing directly on test system and this results in poor documentation, plus more issues when things move to prod. 2) Well there are custom solutions available, but the additional features that are being delivered are not needed. How i did this -  1) Created a powershell script. 2) Created a bat file. 3)  Created a directory to store the imported files. 4) Created a task in application server to run the bat file. Detailed Steps -  1) Powershell script -  2) create a notepad file and save it as .bat file with following code -  3) Look for task scheduler - 4) Create a task -  5) Specify path of your bat file, define the intervals when you want to run the task. P...
Read more

Understanding the OptimizeForTextSearch Property in Business Central

 Are you curious about the OptimizeForTextSearch field property in Business Central ? In my latest YouTube video , I break down: 🔍 How to enable or disable the OptimizeForTextSearch property 🔍 What happens behind the scenes in SQL Server when you modify it 🔍 An interesting open question —what if we change the Boolean value directly in SQL? This is a must-watch for Business Central developers and anyone working with Dynamics 365 and SQL Server . 🎥 Watch the full video here:   Youtube Video 💡 Let’s discuss—what are your thoughts on modifying this property directly in SQL? Drop your insights in the comments of the video! #BusinessCentral #Dynamics365 #SQL #MicrosoftDynamics365BusinessCentral
Read more

Mastering Name Spaces & AL Explorer in Business Central Development

 Looking to streamline your AL development in Dynamics 365 Business Central ? In my latest YouTube video , I break down two essential tools: ✅ Name Spaces in AL – What they are and why they matter ✅ AL Explorer – How to navigate and use it efficiently Whether you're a beginner or an experienced AL developer , this video will help you simplify your workflow and enhance productivity . 🎥 Watch the full tutorial here:   Youtube Link 💡 Don’t forget to like, subscribe, and share to stay updated with more AL development tips! #ALDevelopment #NameSpacesInAL #ALExplorer #Dynamics365 #BusinessCentral #ALTutorial #ProgrammingTips #LearnAL #MicrosoftAL
Read more