In Chapter 1, Introduction to Business Central, we created the Radio Show table for the WDTU application. At that time, we used the minimum fields that allowed us to usefully define a master record. Now, let's set properties on existing data fields, add more data fields, and create an additional data table to which the Radio Show table can refer.
Our new data fields are shown in the following layout table:
Field no. |
Field name |
Description |
1000 |
Frequency |
An Option data type (Hourly, Daily, Weekly, or Monthly) is used for the frequency of a show; Hourly should be used for a show segment such as news, sports, or weather that is scheduled every hour. A space/blank is used for the first option to allow a valid blank field value. |
1010 |
PSA Planned Quantity |
This is the number (stored as Integer) of Public Service Announcements (PSAs) to be played per show; this will be used by playlist generation and posting logic. |
... |