 ﻿
-DECLARE @accountId BIGINT                          = 1
-declare @accountName NVARCHAR(100)                 = 'Insert Name Here'
-DECLARE @toDate DATETIME2                          = GETDATE()
-DECLARE @numberOfMonthsToCreate INT                = 25
-DECLARE @payeScheme NVARCHAR(50)                   = '222/ZZ00002'
-DECLARE @monthlyLevy DECIMAL(18, 4)                = 1000
-declare @defaultMonthlyTotalPayments DECIMAL(18,5) = 100
-declare @defaultPaymentsPerMonth int               = 3
+DECLARE @accountId BIGINT                             = 1
+declare @accountName NVARCHAR(100)                    = 'Insert Name Here'
+DECLARE @toDate DATETIME2                             = GETDATE()
+DECLARE @numberOfMonthsToCreate INT                   = 25
+DECLARE @payeScheme NVARCHAR(50)                      = '222/ZZ00002'
+DECLARE @monthlyLevy DECIMAL(18, 4)                   = 1000
+declare @defaultMonthlyTotalPayments DECIMAL(18,5)    = 100
+declare @defaultPaymentsPerMonth int                  = 3
+
+DECLARE @senderAccountId BIGINT                       = @accountId
+DECLARE @senderAccountName NVARCHAR(100)              = @accountName
+DECLARE @receiverAccountId BIGINT                     = 2
+DECLARE @receiverAccountName NVARCHAR(100)            = 'Receiver Name'
+declare @defaultMonthlyTransfer DECIMAL(18,4)         = 100
+declare @defaultNumberOfTransferPaymentsPerMonth INT  = 1
+
 
 BEGIN TRANSACTION ScenarioExample
 


select * from @paymentsByMonth

-- generate scenario from source table and parameters

--- Generate english fraction rows to cover the levy decs we're about to generate


exec DataGen.CreatePaymentsForMonths @accountId, @accountName, @paymentsByMonth

exec DataGen.CreateTransfersForMonths @senderAccountId, @senderAccountName, @receiverAccountId, @receiverAccountName, @transfersByMonth

COMMIT TRANSACTION ScenarioExample
