First, we need to create a Playlist Header table (table number 50102), which will contain one record for each scheduled Radio Show:
Then, we will create the associated Playlist Line table (table number 50103). This table will contain child records for the Playlist Header table. Each Playlist Line record represents one scheduled piece of music, advertisement, public service announcement, or embedded show within scheduled Radio Show that's defined in the Playlist Header table. Description for each of the option fields shows the information that needs to be entered into the OptionMembers property for those fields:
Now, we'll create our Playlist Item Rate table. These rates include both what we charge for advertising time and what we must pay in royalties for material we broadcast:
An entry table contains the detailed history of processed activity records. In this case, the data is a detailed history of all of the Playlist Line records for...