Removal of Vendor Custom Fields in Native Tables

(0) Share

Report

Posted on by Community Member

I'm very new to BC development, liking it though. However, I have an issue that I need some input from the community on. We are in the process of moving from object based BC to extension based BC. There is a vender component that has modified several of the native tables by adding their on fields on to the end of the table. There's ~1340 tables that need to be modified. What is considered best practice in resolving issues like this (if there are any), and how should we go about removing all of these custom fields from these tables?

-FireCoder79

All responses (3)

Answers (0)

Sort by

Chris Bulson Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

If this is for Business Central SaaS environment, you cannot do any schema change. It sounds like this may be for On-Prem though. If that is the case then maybe someone from the community will have some advice on that.
Community Member on at

Like (0)

Report
Copy link

Link copied!

This is for an On-Prem version. What I'm needing to do is filter based on "native" tables. I'm under the impression that 0..49999 are considered "native" ranges. Is that correct?
Daniel Rimmelzwaan 3,485 on at

Like (0)

Report
Copy link

Link copied!

Here's a good explanation of the object number ranges in NAV/BC: docs.microsoft.com/.../devenv-object-ranges

Moving from modified base tables, the modifications would be moved into 'tableextension' objects. You can keep all the fields, they just move into a different type of object. There are limitations as to what you can and cannot convert, but there are tools out there that can help you do the conversion