The Playlist Line table's default primary key was Document No.. For the primary key to be unique for each record, another field is needed. For a Line table, the additional field is the Line No. field, which is incremented via AL code for each record. So, we'll change the key for table 50003 accordingly:
We know that a lot of reporting will be done based on the data in Radio Show Ledger. We also know that we want to do reporting on data by Radio Show and by the type of entry (individual song, specific advertisement, and so on). So, we will add secondary keys for each of those, including a Date field so that we can rapidly filter the data by Date. The reporting that is financial in nature will need totals of the Fee Amount field, so we'll put that in the SumIndexFields column for our new keys:
We know that to do the necessary listenership analysis, the listenership ledger needs an additional key, combined with SumIndexFields for...