add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
BusinessRefId Period GoalType Amount StartDateUtc EndDateUtc Currency
Business A 2019-2020 CommittedTransactionFee 45000.0000 2019-07-06 00:00:00.000 2020-07-06 00:00:00.000 USD
Business A 2020-2021 CommittedTransactionFee 45000.0000 2020-07-06 00:00:00.000 2021-07-06 00:00:00.000 USD
Business A 2021-2022 CommittedTransactionFee 45000.0000 2021-07-06 00:00:00.000 2022-07-06 00:00:00.000 USD
Business B 2017-2018 CommittedTransactionFee 18000.0000 2017-07-06 00:00:00.000 2018-07-06 00:00:00.000 USD
Business B 2018-2019 CommittedTransactionFee 18000.0000 2018-07-06 00:00:00.000 2019-07-06 00:00:00.000 USD
Business B 2019-2020 CommittedTransactionFee 18000.0000 2019-07-06 00:00:00.000 2020-07-06 00:00:00.000 USD
Business C 2016-2017 CommittedTransactionFee 3000.0000 2016-02-14 00:00:00.000 2017-02-14 00:00:00.000 USD
Business C 2017-2018 CommittedTransactionFee 3000.0000 2017-02-14 00:00:00.000 2018-01-05 00:00:00.000 USD