 
 select * from @paymentsByMonth
 
+-- transfer source table
+
+declare @transfersByMonth DataGen.PaymentGenerationSourceTable
+
+insert @transfersByMonth
+select * from DataGen.GenerateSourceTable(@toDate, @numberOfMonthsToCreate, @defaultMonthlyTransfer, @defaultNumberOfTransferPaymentsPerMonth)
+
+select * from @transfersByMonth
+
 -- 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

COMMIT TRANSACTION ScenarioExample

﻿
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

