One of the big advantages of the Business Central system development environment is the fact that we are allowed to enhance the tables that are part of the original standard product. Many package software products do not provide this flexibility. Nevertheless, with privilege comes responsibility. When we modify a standard Business Central table, we must do so carefully.
In our system, we are going to use the standard Item table—table 27—to store data about recordings such as music and advertisements and PSAs that we have available for broadcast. To do this, we will create a table extension, as described in Chapter 1, Introduction to Business Central. One of the new fields will be an Option field. Another will refer to the Publisher table we created earlier. When the modifications for the Item table design are completed, they will look as follows:
