Support for FinancialCalendar BOD having multiple years

In the previous release, ISR only supports parsing FinancialCalendar BODs having a single year setup. You must set the parameters m3beFromYear and m3beToYear for Sync/Show FinancialCalendar in Agreement Control Properties of Enterprise Collaborator Administration with the same year value, so when it is published, the created XML file only has data on the specified year.

As an enhancement, the published FinancialCalendar BODs which contains several calendar years setup in one XML file is now supported. The received BOD is parsed and all the years and their periods are saved to corresponding Supplier Rebate tables.

The database schema is modified to match the exact structure of the FinancialCalendar BOD. A new table is created to serve as the parent table. The existing header table for the Year data becomes a sub collection. Each Year record has a sub collection of Periods data. This nested sub-collection is implemented in the replication document elements in Supplier Rebate.

You can now set the parameters m3beFromYear and m3beToYear for Sync/Show FinancialCalendar in Agreement Control Properties of Enterprise Collaborator Administration to blank or a range of values. When it is published, the created XML file having multiple calendar years data can now be parsed and saved correctly into corresponding Supplier Rebate tables.

2197234