2025-10-30 16:27:36.1293||DEBUG|AccountManagement.Program|init main function 2025-10-30 16:27:41.2997|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'WaysMeans'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 2025-10-30 16:27:41.3132|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CurrentBalance' on entity type 'SourceAccountManagements'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 2025-10-30 16:27:41.3132|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'OverdraftLimit' on entity type 'SourceAccountManagements'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 2025-10-30 16:27:41.3418|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-10-30 16:27:42.1411|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (15ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-10-30 16:27:42.1637|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-10-30 16:27:42.1637|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT 1 2025-10-30 16:27:42.1637|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 2025-10-30 16:27:42.1891|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [MigrationId], [ProductVersion] FROM [__EFMigrationsHistory] ORDER BY [MigrationId]; 2025-10-30 16:27:42.2043|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 2025-10-30 16:27:43.2148||INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|User profile not available. Using 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\4.0.30319.0\AutoGenKeys\S-1-5-82-636400548-2315632189-4083574877-3698939047-2307078153\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 2025-10-30 16:27:43.5571|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-10-30 16:27:43.5571|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-10-30 16:27:43.5571|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=503 2025-10-30 16:27:43.5571|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-10-30 16:27:44.3859|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:27:44.3859|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:27:44.3859|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:27:44.3859|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:27:44.3995|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 842.9658ms 204 2025-10-30 16:27:44.3995|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 842.9606ms 204 2025-10-30 16:27:44.3995|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 842.9606ms 204 2025-10-30 16:27:44.3995|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 842.9721ms 204 2025-10-30 16:27:44.4180|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-10-30 16:27:44.4180|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAllInitiatePaymentSourceAccountsByUserId?userId=503 2025-10-30 16:27:44.4180|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-10-30 16:27:44.4180|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-10-30 16:27:44.7629|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:27:44.7629|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:27:44.7629|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:27:44.7629|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:27:44.7629|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:27:44.7728|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:27:44.7728|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:27:44.7728|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:27:44.7728|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:27:44.7728|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:27:44.7728|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:27:44.7728|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:27:44.7728|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-10-30 16:27:44.7728|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 2025-10-30 16:27:44.7728|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-10-30 16:27:44.7728|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-10-30 16:27:44.8167|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchCurrentWaysMeans", controller = "WaysMeans"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult FetchCurrentWaysMeans() on controller AccountManagement.Controllers.WaysMeansController (AccountManagement). 2025-10-30 16:27:44.8239|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-10-30 16:27:44.8239|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAccountByCorporateId", controller = "AccountManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAccountByCorporateIdAsync(Int64) on controller AccountManagement.Controllers.AccountManagementController (AccountManagement). 2025-10-30 16:27:44.8239|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllInitiatePaymentSourceAccountsByUserId", controller = "AccountManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllInitiatePaymentSourceAccountsByUserIdAsync(Int64) on controller AccountManagement.Controllers.AccountManagementController (AccountManagement). 2025-10-30 16:27:44.8239|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchBalance", controller = "TreasuryAccount"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] FetchBalance(System.Nullable`1[CorporatePay.Common.GovernmentAccountType]) on controller AccountManagement.Controllers.TreasuryAccountController (AccountManagement). 2025-10-30 16:27:44.8559|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-10-30 16:27:44.8559|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-10-30 16:27:44.8559||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 2025-10-30 16:27:45.2313|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [w].[Id], [w].[Amount], [w].[Comment], [w].[CreatedBy], [w].[DateCreated], [w].[DateModified], [w].[IsActive], [w].[IsDeleted], [w].[ModifiedBy], [w].[Year] FROM [WaysMeans] AS [w] WHERE ([w].[IsDeleted] = CAST(0 AS bit)) AND ([w].[IsActive] = CAST(1 AS bit)) ORDER BY [w].[Id] DESC 2025-10-30 16:27:45.3070|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[AccountManagement.Data.Models.WaysMeansModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2025-10-30 16:27:45.3411|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 519.5121ms 2025-10-30 16:27:45.3411|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-10-30 16:27:45.3411||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-10-30 16:27:45.3411|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 929.1779ms 200 application/json; charset=utf-8 2025-10-30 16:27:45.3504||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-10-30 16:27:45.3827|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (125ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId] FROM [SourceAccountManagements] AS [s] WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:27:45.3827|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (137ms) [Parameters=[@__userId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName], [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId], [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [AccountPermissions] AS [a] LEFT JOIN [SourceAccountManagements] AS [s] ON [a].[AccountsId] = [s].[Id] INNER JOIN [Permissions] AS [p] ON [a].[PermissionId] = [p].[Id] WHERE ((((([a].[UserId] = @__userId_0) AND ([a].[PermissionName] = N'Can Initiate Payment On Source Account')) AND ([a].[IsActive] = CAST(1 AS bit))) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit))) AND ([s].[IsDeleted] = CAST(0 AS bit)) 2025-10-30 16:27:45.4103|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[AccountManagement.Data.Entity.AccountPermission, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2025-10-30 16:27:45.4194|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement) in 585.8894ms 2025-10-30 16:27:45.4194|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAllInitiatePaymentSourceAccountsByUserIdAsync (AccountManagement)' 2025-10-30 16:27:45.4194||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-10-30 16:27:45.4194|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 1005.7526ms 200 application/json; charset=utf-8 2025-10-30 16:27:45.4194||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-10-30 16:27:54.2704||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 2025-10-30 16:27:54.2704||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:27:54.2704||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 2025-10-30 16:27:54.2704||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 2025-10-30 16:27:55.1076||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-7861933432.4","bookBalance":0.0,"accountType":null,"accountName":"AGD EXPENDITURE ACCOUNTS-GENERAL","currency":null,"accountno":"0111001279","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:27:55.1238||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:27:55.1238||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:27:55.1474||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:27:55.1474||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:27:55.1474||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 2025-10-30 16:27:55.9637||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-7861933432.4","bookBalance":0.0,"accountType":null,"accountName":"AGD EXPENDITURE ACCOUNTS-GENERAL","currency":null,"accountno":"0111001279","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:27:55.9693||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:27:55.9693||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:27:55.9852||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:27:55.9852||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:27:55.9852||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 2025-10-30 16:27:56.8704||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-4597240913.73","bookBalance":0.0,"accountType":null,"accountName":"AGD SALARIES AND WAGES ACCOUNT19","currency":null,"accountno":"0111001293","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:27:56.8776||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:27:56.8776||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:27:56.8933||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:27:56.8933||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:27:56.8933||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 2025-10-30 16:27:57.6755||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response [{"data":[{"availableBalance":383447729.02,"formattedAmount":"383,447,729.02","bookBalance":383447729.02,"accountType":"","accountName":"TREASURY MAIN","currency":null,"accountno":"0111001255"},{"availableBalance":-7861933432.4,"formattedAmount":"-7,861,933,432.40","bookBalance":-7861933432.4,"accountType":"","accountName":"AGD EXPENDITURE ACCOUNTS-GENERAL","currency":null,"accountno":"0111001279"},{"availableBalance":-4597240913.73,"formattedAmount":"-4,597,240,913.73","bookBalance":-4597240913.73,"accountType":"","accountName":"AGD SALARIES AND WAGES ACCOUNT19","currency":null,"accountno":"0111001293"},{"availableBalance":-88592650.72,"formattedAmount":"-88,592,650.72","bookBalance":-88592650.72,"accountType":"","accountName":"AGD PENSIONS ACCOUNTS 1998","currency":null,"accountno":"0111001310"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"DIFD (UK) BUDGSUPPORT GRANT","currency":null,"accountno":"0111001358"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SALARY ADVANCES ACCOUNT","currency":null,"accountno":"0111001372"},{"availableBalance":5287941060.49,"formattedAmount":"5,287,941,060.49","bookBalance":5287941060.49,"accountType":"","accountName":"INCOME TAX TREAS AC","currency":null,"accountno":"0111001396"},{"availableBalance":1499247227.91,"formattedAmount":"1,499,247,227.91","bookBalance":1499247227.91,"accountType":"","accountName":"CUSTOMS AND EXCISE TREAS AC","currency":null,"accountno":"0111001413"},{"availableBalance":102718828.2,"formattedAmount":"102,718,828.20","bookBalance":102718828.2,"accountType":"","accountName":"MARINE RESOURCES TREAS AC","currency":null,"accountno":"0111001437"},{"availableBalance":1144285686.71,"formattedAmount":"1,144,285,686.71","bookBalance":1144285686.71,"accountType":"","accountName":"MINERAL RESOURCES TREAS AC","currency":null,"accountno":"0111001451"},{"availableBalance":11531865.2,"formattedAmount":"11,531,865.20","bookBalance":11531865.2,"accountType":"","accountName":"IMMIGRATION TREAS AC","currency":null,"accountno":"0111001475"},{"availableBalance":444627855.91,"formattedAmount":"444,627,855.91","bookBalance":444627855.91,"accountType":"","accountName":"GENERAL REVENUE TREAS AC","currency":null,"accountno":"0111001499"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"IMMIGRATION ESCROW ACCOUNT","currency":null,"accountno":"0111001516"},{"availableBalance":12105897.0,"formattedAmount":"12,105,897.00","bookBalance":12105897.0,"accountType":"","accountName":"ADMINISTRATOR AND REGISTRAR GENE","currency":null,"accountno":"0111001530"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"POLICE-UNCLAIMED SALARIES WAGES","currency":null,"accountno":"0111001578"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"EDU SCIENCE AND TECH-UNCLAIMED S","currency":null,"accountno":"0111001592"},{"availableBalance":1984275.2,"formattedAmount":"1,984,275.20","bookBalance":1984275.2,"accountType":"","accountName":"OTHER DEPTMINISTRIES-UNCLAIMED S","currency":null,"accountno":"0111001657"},{"availableBalance":607877456.1,"formattedAmount":"607,877,456.10","bookBalance":607877456.1,"accountType":"","accountName":"TREASURY WAYS AND MEANS ADVANCES","currency":null,"accountno":"0111001671"},{"availableBalance":990172300.0,"formattedAmount":"990,172,300.00","bookBalance":990172300.0,"accountType":"","accountName":"TREASURY BEARER BOND ACCOUNTS","currency":null,"accountno":"0111001695"},{"availableBalance":-1285494020.06,"formattedAmount":"-1,285,494,020.06","bookBalance":-1285494020.06,"accountType":"","accountName":"INTEREST ON TREASURY BEARER BOND","currency":null,"accountno":"0111001712"},{"availableBalance":-2083060235.36,"formattedAmount":"-2,083,060,235.36","bookBalance":-2083060235.36,"accountType":"","accountName":"EXTERNAL DEBT SERVICE PAYMENTS","currency":null,"accountno":"0111001736"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"KENEMA GOVT TREASURY DEPOSITS AC","currency":null,"accountno":"0111001750"},{"availableBalance":20494300.88,"formattedAmount":"20,494,300.88","bookBalance":20494300.88,"accountType":"","accountName":"HIPC TRUST FUND ACCOUNT","currency":null,"accountno":"0111001774"},{"availableBalance":-729960.98,"formattedAmount":"-729,960.98","bookBalance":-729960.98,"accountType":"","accountName":"TREASURY BILLS AC","currency":null,"accountno":"0111001839"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"OFIDSL GOV DEBT RELIEF AC","currency":null,"accountno":"0111001891"},{"availableBalance":113758090.93,"formattedAmount":"113,758,090.93","bookBalance":113758090.93,"accountType":"","accountName":"NOMINALCOST AC FOR 182-DAYS TREA","currency":null,"accountno":"0111001918"},{"availableBalance":3387842863.96,"formattedAmount":"3,387,842,863.96","bookBalance":3387842863.96,"accountType":"","accountName":"NOMINALCOST AC FOR 364-DAYS TREA","currency":null,"accountno":"0111001932"},{"availableBalance":-8247204.18,"formattedAmount":"-8,247,204.18","bookBalance":-8247204.18,"accountType":"","accountName":"COMMISSION AC FOR TREASURY BILLS","currency":null,"accountno":"0111001970"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"MIN OF FISHERIES AND MARINE RESO","currency":null,"accountno":"0111002032"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"NAT TELECOMS REVENUE ESCROW AC","currency":null,"accountno":"0111002056"},{"availableBalance":4146519.05,"formattedAmount":"4,146,519.05","bookBalance":4146519.05,"accountType":"","accountName":"SIERRA LEONE PHARMACY BOARD REVE","currency":null,"accountno":"0111002070"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SIERRA LEONE MARITIME ADMIN REVE","currency":null,"accountno":"0111002094"},{"availableBalance":10968822.4,"formattedAmount":"10,968,822.40","bookBalance":10968822.4,"accountType":"","accountName":"SLCAA FOREIGN TRAVEL TAX A/C","currency":null,"accountno":"0111002111"},{"availableBalance":2152456934.58,"formattedAmount":"2,152,456,934.58","bookBalance":2152456934.58,"accountType":"","accountName":"GOODS AND SERVICES TAX ACCOUNT","currency":null,"accountno":"0111002135"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"MARINES FINES AC","currency":null,"accountno":"0111002159"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"AFFORESTATION AC","currency":null,"accountno":"0111002197"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"NATIONAL IDENTITY CARD PROJECT E","currency":null,"accountno":"0111002252"},{"availableBalance":412398.2,"formattedAmount":"412,398.20","bookBalance":412398.2,"accountType":"","accountName":"MINISTRY OF PRESIDENTIAL AND PUB","currency":null,"accountno":"0111002276"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"JAPANESE GRANT FOR COPING WITH C","currency":null,"accountno":"0111002317"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"DIAMOND ROYALTIES AC","currency":null,"accountno":"0111002355"},{"availableBalance":11278546.22,"formattedAmount":"11,278,546.22","bookBalance":11278546.22,"accountType":"","accountName":"NON-TAX REVENUE AC","currency":null,"accountno":"0111002379"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"INT. ON 91 182 364 - DAYS TREASU","currency":null,"accountno":"0111002393"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SIERRATELEBID MODERNISATION AND","currency":null,"accountno":"0111002410"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"IMF BUDGET FINANCING TREASURY A/","currency":null,"accountno":"0111002843"},{"availableBalance":926113844.14,"formattedAmount":"926,113,844.14","bookBalance":926113844.14,"accountType":"","accountName":"PETROLEUM EXCISE DUTY ACCOUNT","currency":null,"accountno":"0111002984"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"CATASTROPHE CONTAINMENT RELIEF T","currency":null,"accountno":"0111002991"},{"availableBalance":-47389.02,"formattedAmount":"-47,389.02","bookBalance":-47389.02,"accountType":"","accountName":"INTEREST ON 91 DAYS TREASURY BIL","currency":null,"accountno":"0111003314"},{"availableBalance":-14271660.43,"formattedAmount":"-14,271,660.43","bookBalance":-14271660.43,"accountType":"","accountName":"INTEREST ON 182 DAYS TREASURY BI","currency":null,"accountno":"0111003321"},{"availableBalance":-4508834654.11,"formattedAmount":"-4,508,834,654.11","bookBalance":-4508834654.11,"accountType":"","accountName":"INTEREST ON 364 DAYS TREASURY BI","currency":null,"accountno":"0111003338"},{"availableBalance":11491920.7,"formattedAmount":"11,491,920.70","bookBalance":11491920.7,"accountType":"","accountName":"PETROLEUM REGULATORY AGENCY","currency":null,"accountno":"0111003448"},{"availableBalance":14624361.1,"formattedAmount":"14,624,361.10","bookBalance":14624361.1,"accountType":"","accountName":"PETROLEUM DIRECTORATE","currency":null,"accountno":"0111003455"},{"availableBalance":716682.0,"formattedAmount":"716,682.00","bookBalance":716682.0,"accountType":"","accountName":"ROAD MAINTENANCE FUND","currency":null,"accountno":"0111003462"},{"availableBalance":11748486.6,"formattedAmount":"11,748,486.60","bookBalance":11748486.6,"accountType":"","accountName":"ENVIRONMENTAL PROTECTION AGENCY","currency":null,"accountno":"0111003479"},{"availableBalance":3109342.86,"formattedAmount":"3,109,342.86","bookBalance":3109342.86,"accountType":"","accountName":"NATIONAL TELECOMMUNICATION COMMI","currency":null,"accountno":"0111003486"},{"availableBalance":33456809.91,"formattedAmount":"33,456,809.91","bookBalance":33456809.91,"accountType":"","accountName":"SIERRA LEONE MARITIME ADMINISTRA","currency":null,"accountno":"0111003493"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SPECIAL TAX & DUTIES","currency":null,"accountno":"0111003503"},{"availableBalance":431020263.0,"formattedAmount":"431,020,263.00","bookBalance":431020263.0,"accountType":"","accountName":"TIMBER EXPORT LEVY","currency":null,"accountno":"0111003527"},{"availableBalance":6709406.02,"formattedAmount":"6,709,406.02","bookBalance":6709406.02,"accountType":"","accountName":"AFFORESTATION AND CITIES LEVY","currency":null,"accountno":"0111003534"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"MULTI DONOR BASKET FUND FREE EDU","currency":null,"accountno":"0111003572"},{"availableBalance":622112.00,"formattedAmount":"622,112.00","bookBalance":622112.00,"accountType":"","accountName":"MULTI DONOR BASKET FUND 4 FREE E","currency":null,"accountno":"0111003596"},{"availableBalance":-10000000.00,"formattedAmount":"-10,000,000.00","bookBalance":-10000000.00,"accountType":"","accountName":"CORRUPTION REC FUNDS ACCOUNT (SL","currency":null,"accountno":"0111003637"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"CORRUPTION REC FUNDS ACCOUNT (US","currency":null,"accountno":"0111003644"},{"availableBalance":4257195.02,"formattedAmount":"4,257,195.02","bookBalance":4257195.02,"accountType":"","accountName":"SIERRA LEONE STANDARD BUREAU DIS","currency":null,"accountno":"0111003651"},{"availableBalance":2021303.84,"formattedAmount":"2,021,303.84","bookBalance":2021303.84,"accountType":"","accountName":"SIERRA LEONE ROADS SAFETY AUTHOR","currency":null,"accountno":"0111003668"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SLPA/GOSL CARGO TRACKING","currency":null,"accountno":"0111003699"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"RECO FUNDS BASED ON TECHNICAL AU","currency":null,"accountno":"0111003730"},{"availableBalance":16515705.94,"formattedAmount":"16,515,705.94","bookBalance":16515705.94,"accountType":"","accountName":"FISHERIES PROTECTION STATISTICS&","currency":null,"accountno":"0111003754"},{"availableBalance":666084.4,"formattedAmount":"666,084.40","bookBalance":666084.4,"accountType":"","accountName":"FREE HEALTH CARE INITIATIVE","currency":null,"accountno":"0111003778"},{"availableBalance":63339688.83,"formattedAmount":"63,339,688.83","bookBalance":63339688.83,"accountType":"","accountName":"PRODUCE MONITORING BOARD","currency":null,"accountno":"0111003785"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"USL TEACHING HOSPITAL COMPLEX","currency":null,"accountno":"0111003840"},{"availableBalance":10433625.0,"formattedAmount":"10,433,625.00","bookBalance":10433625.0,"accountType":"","accountName":"DUTY WAIVER JOINT MNT FUND TREAS","currency":null,"accountno":"0111003857"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"PUBLIC AUCTION COMMITTE TREASURY","currency":null,"accountno":"0111003864"},{"availableBalance":3623824.03,"formattedAmount":"3,623,824.03","bookBalance":3623824.03,"accountType":"","accountName":"COMM OF INQUIRY SPECIAL RECOVERY","currency":null,"accountno":"0111003888"},{"availableBalance":-1509739.69,"formattedAmount":"-1,509,739.69","bookBalance":-1509739.69,"accountType":"","accountName":"DAILY SUBSISTENCE ALW/MED EXP AC","currency":null,"accountno":"0111003929"},{"availableBalance":3780.96,"formattedAmount":"3,780.96","bookBalance":3780.96,"accountType":"","accountName":"S/L LOCAL CONTENT DEVELOPMENT FU","currency":null,"accountno":"0111003936"},{"availableBalance":10000.0,"formattedAmount":"10,000.00","bookBalance":10000.0,"accountType":"","accountName":"LSS/SLPA/GOSL CARGO TRACKING","currency":null,"accountno":"0111003943"},{"availableBalance":5000000.0,"formattedAmount":"5,000,000.00","bookBalance":5000000.0,"accountType":"","accountName":"LOCAL COUNCIL DEVELOPMENT PROJEC","currency":null,"accountno":"0111003950"},{"availableBalance":205694040.46,"formattedAmount":"205,694,040.46","bookBalance":205694040.46,"accountType":"","accountName":"DEBT MANAGEMENT TREASURY","currency":null,"accountno":"0111003967"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"AUDIT SERVICE S/L - AUDIT FEES","currency":null,"accountno":"0111003974"},{"availableBalance":816415.54,"formattedAmount":"816,415.54","bookBalance":816415.54,"accountType":"","accountName":"NPPA-REV FROM SALE OF BIDDING DO","currency":null,"accountno":"0111003981"},{"availableBalance":19551766.44,"formattedAmount":"19,551,766.44","bookBalance":19551766.44,"accountType":"","accountName":"VEHICLE LOAN SCHEME","currency":null,"accountno":"0111004005"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SLCAA AVIATION FEES","currency":null,"accountno":"0111004012"},{"availableBalance":3326998.54,"formattedAmount":"3,326,998.54","bookBalance":3326998.54,"accountType":"","accountName":"NACOVERC LAB FEES & ENFORCE FINE","currency":null,"accountno":"0111004029"},{"availableBalance":139164.95,"formattedAmount":"139,164.95","bookBalance":139164.95,"accountType":"","accountName":"CTN FEES - FOREIGN CURRENCY","currency":null,"accountno":"0111004036"},{"availableBalance":0.01,"formattedAmount":"0.01","bookBalance":0.01,"accountType":"","accountName":"NATCOM AND BRADCORP GATEWAY REVE","currency":null,"accountno":"0111004043"},{"availableBalance":1104613.33,"formattedAmount":"1,104,613.33","bookBalance":1104613.33,"accountType":"","accountName":"NAT. WATER RESOURCES MGMT AGENCY","currency":null,"accountno":"0111004067"},{"availableBalance":2252147.11,"formattedAmount":"2,252,147.11","bookBalance":2252147.11,"accountType":"","accountName":"NaCOVERC LABORATORY FEES (USD)","currency":null,"accountno":"0111004074"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"WAGE BILL REVOLVING FUND ACCOUNT","currency":null,"accountno":"0111004098"},{"availableBalance":83069442.86,"formattedAmount":"83,069,442.86","bookBalance":83069442.86,"accountType":"","accountName":"STATE LAND SALES A/C","currency":null,"accountno":"0111004160"},{"availableBalance":48487.0,"formattedAmount":"48,487.00","bookBalance":48487.0,"accountType":"","accountName":"34 MILITARY HOSPITAL","currency":null,"accountno":"0111004201"},{"availableBalance":2206155.0,"formattedAmount":"2,206,155.00","bookBalance":2206155.0,"accountType":"","accountName":"BETTING & GAMBLING LICENCES ACCO","currency":null,"accountno":"0111004232"},{"availableBalance":34865.21,"formattedAmount":"34,865.21","bookBalance":34865.21,"accountType":"","accountName":"PAY NO BRIBE CAMPAIGN PROJECT AC","currency":null,"accountno":"0111004421"},{"availableBalance":2293395.84,"formattedAmount":"2,293,395.84","bookBalance":2293395.84,"accountType":"","accountName":"LUNGI BRIDGE FEASIBILITY STUDY(S","currency":null,"accountno":"0111004438"},{"availableBalance":17.05,"formattedAmount":"17.05","bookBalance":17.05,"accountType":"","accountName":"MOPED UNICEF PROGRAM SUPPORT A/C","currency":null,"accountno":"0111004658"},{"availableBalance":164418.88,"formattedAmount":"164,418.88","bookBalance":164418.88,"accountType":"","accountName":"NAT ELECTIONS SUSTAIN TRUST FUND","currency":null,"accountno":"0111004809"},{"availableBalance":0.79,"formattedAmount":"0.79","bookBalance":0.79,"accountType":"","accountName":"IMF SPECIAL DRAWING RIGHTS RETRO","currency":null,"accountno":"0111004847"},{"availableBalance":64949307.74,"formattedAmount":"64,949,307.74","bookBalance":64949307.74,"accountType":"","accountName":"GoSL TSA REVENUE SHARE ACCOUNT","currency":null,"accountno":"0111004878"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"DUTY WAIVER","currency":null,"accountno":"0111004885"},{"availableBalance":-931456.0,"formattedAmount":"-931,456.00","bookBalance":-931456.0,"accountType":"","accountName":"IMPREST AC FOR ACC GEN DEPT","currency":null,"accountno":"0111004926"},{"availableBalance":10685160.00,"formattedAmount":"10,685,160.00","bookBalance":10685160.00,"accountType":"","accountName":"SL NATIONAL SHIPPING COMPANY ESC","currency":null,"accountno":"0111004995"},{"availableBalance":-1009872.99,"formattedAmount":"-1,009,872.99","bookBalance":-1009872.99,"accountType":"","accountName":"MINISTRY OF DEFENCE QUARTERLY","currency":null,"accountno":"0111005057"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SIERRA LEONE POLICE GENERAL ACCO","currency":null,"accountno":"0111005129"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SIERRA LEONE CORRECTIONAL SERVIC","currency":null,"accountno":"0111005136"},{"availableBalance":3446.86,"formattedAmount":"3,446.86","bookBalance":3446.86,"accountType":"","accountName":"IMMIGRATION ACCOUNT","currency":null,"accountno":"0111005150"},{"availableBalance":14952799.83,"formattedAmount":"14,952,799.83","bookBalance":14952799.83,"accountType":"","accountName":"DIAGNOSTIC MEDICAL CENTRE","currency":null,"accountno":"0111005260"},{"availableBalance":6331936.99,"formattedAmount":"6,331,936.99","bookBalance":6331936.99,"accountType":"","accountName":"SALES OF AIRSTRIP LANDS","currency":null,"accountno":"0111005332"},{"availableBalance":245148.43,"formattedAmount":"245,148.43","bookBalance":245148.43,"accountType":"","accountName":"GOSL NATIONAL TREE PLANTING","currency":null,"accountno":"0111005387"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"OFFICE OF THE OMBUDSMAN DISBURSE","currency":null,"accountno":"0111005844"},{"availableBalance":379264.0,"formattedAmount":"379,264.00","bookBalance":379264.0,"accountType":"","accountName":"FERTILIZER SUPPORT FUND","currency":null,"accountno":"0111006054"},{"availableBalance":117899.95,"formattedAmount":"117,899.95","bookBalance":117899.95,"accountType":"","accountName":"TERTIARY EDUCATION COMMISSION DI","currency":null,"accountno":"0111006308"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SIERRA LEONE PHARMACY BOARD DISB","currency":null,"accountno":"0111006377"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SLMET AGRIC VAL CHA DEV PROJ (AV","currency":null,"accountno":"0111006456"},{"availableBalance":1774771.57,"formattedAmount":"1,774,771.57","bookBalance":1774771.57,"accountType":"","accountName":"DIGITAL DEVELOPMENT FUND (DDF) A","currency":null,"accountno":"0111006535"}],"code":"01","success":true,"description":"Success"}] 2025-10-30 16:27:57.6884||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 2025-10-30 16:27:57.6884|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[System.Object, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2025-10-30 16:27:57.7028|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 12868.308ms 2025-10-30 16:27:57.7028|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-10-30 16:27:57.7028|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 13287.09ms 200 application/json; charset=utf-8 2025-10-30 16:27:57.7899||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"4256873.7","bookBalance":0.0,"accountType":null,"accountName":"ELECTRONIC FUNDS TRANS SUSPENSE","currency":null,"accountno":"SLE116030002","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:27:57.7949||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:27:57.7949||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:27:57.7949||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:27:57.8096||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:27:57.8096||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 2025-10-30 16:27:58.5881||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-4597240913.73","bookBalance":0.0,"accountType":null,"accountName":"AGD SALARIES AND WAGES ACCOUNT19","currency":null,"accountno":"0111001293","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:27:58.5951||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:27:58.5951||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:27:58.6123||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:27:58.6123||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:27:58.6123||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 2025-10-30 16:27:59.4005||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-88592650.72","bookBalance":0.0,"accountType":null,"accountName":"AGD PENSIONS ACCOUNTS 1998","currency":null,"accountno":"0111001310","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:27:59.4060||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:27:59.4060||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:27:59.4204||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:27:59.5076|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (17ms) [Parameters=[@p4='?' (DbType = Int64), @p0='?' (DbType = Decimal), @p1='?' (DbType = DateTime2), @p2='?' (DbType = DateTime2), @p3='?' (DbType = Int64), @p9='?' (DbType = Int64), @p5='?' (DbType = Decimal), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p8='?' (DbType = Int64), @p14='?' (DbType = Int64), @p10='?' (DbType = Decimal), @p11='?' (DbType = DateTime2), @p12='?' (DbType = DateTime2), @p13='?' (DbType = Int64), @p19='?' (DbType = Int64), @p15='?' (DbType = Decimal), @p16='?' (DbType = DateTime2), @p17='?' (DbType = DateTime2), @p18='?' (DbType = Int64), @p24='?' (DbType = Int64), @p20='?' (DbType = Decimal), @p21='?' (DbType = DateTime2), @p22='?' (DbType = DateTime2), @p23='?' (DbType = Int64), @p29='?' (DbType = Int64), @p25='?' (DbType = Decimal), @p26='?' (DbType = DateTime2), @p27='?' (DbType = DateTime2), @p28='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p0, [CurrentBalanceLastUpdatedTime] = @p1, [DateModified] = @p2, [ModifiedBy] = @p3 WHERE [Id] = @p4; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p5, [CurrentBalanceLastUpdatedTime] = @p6, [DateModified] = @p7, [ModifiedBy] = @p8 WHERE [Id] = @p9; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p10, [CurrentBalanceLastUpdatedTime] = @p11, [DateModified] = @p12, [ModifiedBy] = @p13 WHERE [Id] = @p14; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p15, [CurrentBalanceLastUpdatedTime] = @p16, [DateModified] = @p17, [ModifiedBy] = @p18 WHERE [Id] = @p19; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p20, [CurrentBalanceLastUpdatedTime] = @p21, [DateModified] = @p22, [ModifiedBy] = @p23 WHERE [Id] = @p24; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalance] = @p25, [CurrentBalanceLastUpdatedTime] = @p26, [DateModified] = @p27, [ModifiedBy] = @p28 WHERE [Id] = @p29; SELECT @@ROWCOUNT; 2025-10-30 16:27:59.5401|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId] FROM [SourceAccountManagements] AS [s] WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit)) ORDER BY [s].[DateCreated] DESC 2025-10-30 16:27:59.5618|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:27:59.5844|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:27:59.5844|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:27:59.5937|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:27:59.5937|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:27:59.5937|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:27:59.5937|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:27:59.5937|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:27:59.5937|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:27:59.5937|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:27:59.6089|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:27:59.6089|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:27:59.7828|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[SourceAccountManagement.Data.Models.SourceAccountManagementViewModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2025-10-30 16:27:59.7828|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 14961.6297ms 2025-10-30 16:27:59.7951|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-10-30 16:27:59.7951|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 15377.8074ms 200 application/json; charset=utf-8 2025-10-30 16:29:53.3777|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys 2025-10-30 16:29:53.3777|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks 2025-10-30 16:29:53.3777|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:29:53.3777|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:29:53.3859|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.3049ms 204 2025-10-30 16:29:53.3859|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 9.3743ms 204 2025-10-30 16:29:53.3859|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/BankManagement/GetAllBanks 2025-10-30 16:29:53.3859|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/CurrencyManagement/GetAllCurrencys 2025-10-30 16:29:53.3859|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:29:53.4001|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:29:53.4001|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:29:53.4001|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:29:53.4001|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:29:53.4001|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 2025-10-30 16:29:53.4001|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:29:53.4001|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 2025-10-30 16:29:53.4193|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllBanks", controller = "BankManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllBanksAsync(AccountManagement.Data.Utility.PaginationHelpers.BankParameters) on controller AccountManagement.Controllers.BankManagementController (AccountManagement). 2025-10-30 16:29:53.4193|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-10-30 16:29:53.4193|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAllCurrencys", controller = "CurrencyManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAllCurrencysAsync(AccountManagement.Data.Utility.PaginationHelpers.CurrencyParameters) on controller AccountManagement.Controllers.CurrencyManagementController (AccountManagement). 2025-10-30 16:29:53.4193|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-10-30 16:29:53.4509|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name] FROM [Currencies] AS [c] ORDER BY [c].[Name] 2025-10-30 16:29:53.4670|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'AccountManagement.Data.Utility.PaginationHelpers.PagedList`1[[CorporatePay.Common.Models.CurrencyViewModel, CorporatePay.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2025-10-30 16:29:53.4798|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement) in 54.1906ms 2025-10-30 16:29:53.4798|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.CurrencyManagementController.GetAllCurrencysAsync (AccountManagement)' 2025-10-30 16:29:53.4798|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 91.6361ms 200 application/json; charset=utf-8 2025-10-30 16:29:53.4999|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (57ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT [b].[Id], [b].[Account], [b].[BBAN], [b].[BICCode], [b].[BankType], [b].[Code], [b].[CountryId], [b].[CreatedBy], [b].[DateCreated], [b].[DateModified], [b].[IsActive], [b].[IsDeleted], [b].[ModifiedBy], [b].[Name], [b].[SettlementBankId], [b].[SettlementBankName], [b].[SettlementBankOfficerEmail], [b].[ShortName], [c].[Id], [c].[Code1], [c].[Code2], [c].[Name] FROM [Banks] AS [b] INNER JOIN [Countries] AS [c] ON [b].[CountryId] = [c].[Id] ORDER BY [b].[Name] 2025-10-30 16:29:53.5552|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.ResponsePageList`1[[System.Collections.Generic.List`1[[CorporatePay.Common.Models.BankViewModel, CorporatePay.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2025-10-30 16:29:53.5641|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement) in 143.5564ms 2025-10-30 16:29:53.5641|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.BankManagementController.GetAllBanksAsync (AccountManagement)' 2025-10-30 16:29:53.5641|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 173.3222ms 200 application/json; charset=utf-8 2025-10-30 16:31:47.3585|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-10-30 16:31:47.3585|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-10-30 16:31:47.3585|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-10-30 16:31:47.3585|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:31:47.3585|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:31:47.3585|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:31:47.3730|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 14.6645ms 204 2025-10-30 16:31:47.3730|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 17.9109ms 204 2025-10-30 16:31:47.3730|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 21.0914ms 204 2025-10-30 16:31:47.3730|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-10-30 16:31:47.3887|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-10-30 16:31:47.3887|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-10-30 16:31:47.3887|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:31:47.3887|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:31:47.3887|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:31:47.4040|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:31:47.4040|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:31:47.4040|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:31:47.4040|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:31:47.4040|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:31:47.4040|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:31:47.4040|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-10-30 16:31:47.4040|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-10-30 16:31:47.4196|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-10-30 16:31:47.4196|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchBalance", controller = "TreasuryAccount"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] FetchBalance(System.Nullable`1[CorporatePay.Common.GovernmentAccountType]) on controller AccountManagement.Controllers.TreasuryAccountController (AccountManagement). 2025-10-30 16:31:47.4196|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchCurrentWaysMeans", controller = "WaysMeans"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult FetchCurrentWaysMeans() on controller AccountManagement.Controllers.WaysMeansController (AccountManagement). 2025-10-30 16:31:47.4196||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 2025-10-30 16:31:47.4196|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAccountByCorporateId", controller = "AccountManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAccountByCorporateIdAsync(Int64) on controller AccountManagement.Controllers.AccountManagementController (AccountManagement). 2025-10-30 16:31:47.4196|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-10-30 16:31:47.4196||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-10-30 16:31:47.4196|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-10-30 16:31:47.4361|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [w].[Id], [w].[Amount], [w].[Comment], [w].[CreatedBy], [w].[DateCreated], [w].[DateModified], [w].[IsActive], [w].[IsDeleted], [w].[ModifiedBy], [w].[Year] FROM [WaysMeans] AS [w] WHERE ([w].[IsDeleted] = CAST(0 AS bit)) AND ([w].[IsActive] = CAST(1 AS bit)) ORDER BY [w].[Id] DESC 2025-10-30 16:31:47.4361||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-10-30 16:31:47.4361|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[AccountManagement.Data.Models.WaysMeansModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2025-10-30 16:31:47.4361|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 15.4016ms 2025-10-30 16:31:47.4361|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId] FROM [SourceAccountManagements] AS [s] WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:31:47.4361|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-10-30 16:31:47.4361|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 53.9281ms 200 application/json; charset=utf-8 2025-10-30 16:31:47.4361||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-10-30 16:31:47.4361||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-10-30 16:31:47.5145||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 2025-10-30 16:31:47.5145||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:31:47.5145||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 2025-10-30 16:31:47.5145||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 2025-10-30 16:31:48.3343||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-7861933432.4","bookBalance":0.0,"accountType":null,"accountName":"AGD EXPENDITURE ACCOUNTS-GENERAL","currency":null,"accountno":"0111001279","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:31:48.3343||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:31:48.3443||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:31:48.3578||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:31:48.3578||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:31:48.3578||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 2025-10-30 16:31:49.1285||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-7861933432.4","bookBalance":0.0,"accountType":null,"accountName":"AGD EXPENDITURE ACCOUNTS-GENERAL","currency":null,"accountno":"0111001279","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:31:49.1285||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:31:49.1285||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:31:49.1448||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:31:49.1448||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:31:49.1448||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 2025-10-30 16:31:49.8787||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-4597240913.73","bookBalance":0.0,"accountType":null,"accountName":"AGD SALARIES AND WAGES ACCOUNT19","currency":null,"accountno":"0111001293","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:31:49.8787||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:31:49.8886||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:31:49.8886||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:31:49.9026||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:31:49.9026||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 2025-10-30 16:31:50.5626||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response [{"data":[{"availableBalance":383447729.02,"formattedAmount":"383,447,729.02","bookBalance":383447729.02,"accountType":"","accountName":"TREASURY MAIN","currency":null,"accountno":"0111001255"},{"availableBalance":-7861933432.4,"formattedAmount":"-7,861,933,432.40","bookBalance":-7861933432.4,"accountType":"","accountName":"AGD EXPENDITURE ACCOUNTS-GENERAL","currency":null,"accountno":"0111001279"},{"availableBalance":-4597240913.73,"formattedAmount":"-4,597,240,913.73","bookBalance":-4597240913.73,"accountType":"","accountName":"AGD SALARIES AND WAGES ACCOUNT19","currency":null,"accountno":"0111001293"},{"availableBalance":-88592650.72,"formattedAmount":"-88,592,650.72","bookBalance":-88592650.72,"accountType":"","accountName":"AGD PENSIONS ACCOUNTS 1998","currency":null,"accountno":"0111001310"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"DIFD (UK) BUDGSUPPORT GRANT","currency":null,"accountno":"0111001358"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SALARY ADVANCES ACCOUNT","currency":null,"accountno":"0111001372"},{"availableBalance":5289390967.12,"formattedAmount":"5,289,390,967.12","bookBalance":5289390967.12,"accountType":"","accountName":"INCOME TAX TREAS AC","currency":null,"accountno":"0111001396"},{"availableBalance":1499355693.37,"formattedAmount":"1,499,355,693.37","bookBalance":1499355693.37,"accountType":"","accountName":"CUSTOMS AND EXCISE TREAS AC","currency":null,"accountno":"0111001413"},{"availableBalance":102718828.2,"formattedAmount":"102,718,828.20","bookBalance":102718828.2,"accountType":"","accountName":"MARINE RESOURCES TREAS AC","currency":null,"accountno":"0111001437"},{"availableBalance":1144285686.71,"formattedAmount":"1,144,285,686.71","bookBalance":1144285686.71,"accountType":"","accountName":"MINERAL RESOURCES TREAS AC","currency":null,"accountno":"0111001451"},{"availableBalance":11531865.2,"formattedAmount":"11,531,865.20","bookBalance":11531865.2,"accountType":"","accountName":"IMMIGRATION TREAS AC","currency":null,"accountno":"0111001475"},{"availableBalance":444627855.91,"formattedAmount":"444,627,855.91","bookBalance":444627855.91,"accountType":"","accountName":"GENERAL REVENUE TREAS AC","currency":null,"accountno":"0111001499"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"IMMIGRATION ESCROW ACCOUNT","currency":null,"accountno":"0111001516"},{"availableBalance":12105897.0,"formattedAmount":"12,105,897.00","bookBalance":12105897.0,"accountType":"","accountName":"ADMINISTRATOR AND REGISTRAR GENE","currency":null,"accountno":"0111001530"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"POLICE-UNCLAIMED SALARIES WAGES","currency":null,"accountno":"0111001578"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"EDU SCIENCE AND TECH-UNCLAIMED S","currency":null,"accountno":"0111001592"},{"availableBalance":1984275.2,"formattedAmount":"1,984,275.20","bookBalance":1984275.2,"accountType":"","accountName":"OTHER DEPTMINISTRIES-UNCLAIMED S","currency":null,"accountno":"0111001657"},{"availableBalance":607877456.1,"formattedAmount":"607,877,456.10","bookBalance":607877456.1,"accountType":"","accountName":"TREASURY WAYS AND MEANS ADVANCES","currency":null,"accountno":"0111001671"},{"availableBalance":990172300.0,"formattedAmount":"990,172,300.00","bookBalance":990172300.0,"accountType":"","accountName":"TREASURY BEARER BOND ACCOUNTS","currency":null,"accountno":"0111001695"},{"availableBalance":-1285494020.06,"formattedAmount":"-1,285,494,020.06","bookBalance":-1285494020.06,"accountType":"","accountName":"INTEREST ON TREASURY BEARER BOND","currency":null,"accountno":"0111001712"},{"availableBalance":-2083060235.36,"formattedAmount":"-2,083,060,235.36","bookBalance":-2083060235.36,"accountType":"","accountName":"EXTERNAL DEBT SERVICE PAYMENTS","currency":null,"accountno":"0111001736"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"KENEMA GOVT TREASURY DEPOSITS AC","currency":null,"accountno":"0111001750"},{"availableBalance":20494300.88,"formattedAmount":"20,494,300.88","bookBalance":20494300.88,"accountType":"","accountName":"HIPC TRUST FUND ACCOUNT","currency":null,"accountno":"0111001774"},{"availableBalance":-729960.98,"formattedAmount":"-729,960.98","bookBalance":-729960.98,"accountType":"","accountName":"TREASURY BILLS AC","currency":null,"accountno":"0111001839"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"OFIDSL GOV DEBT RELIEF AC","currency":null,"accountno":"0111001891"},{"availableBalance":113758090.93,"formattedAmount":"113,758,090.93","bookBalance":113758090.93,"accountType":"","accountName":"NOMINALCOST AC FOR 182-DAYS TREA","currency":null,"accountno":"0111001918"},{"availableBalance":3387842863.96,"formattedAmount":"3,387,842,863.96","bookBalance":3387842863.96,"accountType":"","accountName":"NOMINALCOST AC FOR 364-DAYS TREA","currency":null,"accountno":"0111001932"},{"availableBalance":-8247204.18,"formattedAmount":"-8,247,204.18","bookBalance":-8247204.18,"accountType":"","accountName":"COMMISSION AC FOR TREASURY BILLS","currency":null,"accountno":"0111001970"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"MIN OF FISHERIES AND MARINE RESO","currency":null,"accountno":"0111002032"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"NAT TELECOMS REVENUE ESCROW AC","currency":null,"accountno":"0111002056"},{"availableBalance":4146519.05,"formattedAmount":"4,146,519.05","bookBalance":4146519.05,"accountType":"","accountName":"SIERRA LEONE PHARMACY BOARD REVE","currency":null,"accountno":"0111002070"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SIERRA LEONE MARITIME ADMIN REVE","currency":null,"accountno":"0111002094"},{"availableBalance":10968822.4,"formattedAmount":"10,968,822.40","bookBalance":10968822.4,"accountType":"","accountName":"SLCAA FOREIGN TRAVEL TAX A/C","currency":null,"accountno":"0111002111"},{"availableBalance":2152475800.7,"formattedAmount":"2,152,475,800.70","bookBalance":2152475800.7,"accountType":"","accountName":"GOODS AND SERVICES TAX ACCOUNT","currency":null,"accountno":"0111002135"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"MARINES FINES AC","currency":null,"accountno":"0111002159"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"AFFORESTATION AC","currency":null,"accountno":"0111002197"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"NATIONAL IDENTITY CARD PROJECT E","currency":null,"accountno":"0111002252"},{"availableBalance":412398.2,"formattedAmount":"412,398.20","bookBalance":412398.2,"accountType":"","accountName":"MINISTRY OF PRESIDENTIAL AND PUB","currency":null,"accountno":"0111002276"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"JAPANESE GRANT FOR COPING WITH C","currency":null,"accountno":"0111002317"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"DIAMOND ROYALTIES AC","currency":null,"accountno":"0111002355"},{"availableBalance":11283546.22,"formattedAmount":"11,283,546.22","bookBalance":11283546.22,"accountType":"","accountName":"NON-TAX REVENUE AC","currency":null,"accountno":"0111002379"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"INT. ON 91 182 364 - DAYS TREASU","currency":null,"accountno":"0111002393"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SIERRATELEBID MODERNISATION AND","currency":null,"accountno":"0111002410"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"IMF BUDGET FINANCING TREASURY A/","currency":null,"accountno":"0111002843"},{"availableBalance":926113844.14,"formattedAmount":"926,113,844.14","bookBalance":926113844.14,"accountType":"","accountName":"PETROLEUM EXCISE DUTY ACCOUNT","currency":null,"accountno":"0111002984"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"CATASTROPHE CONTAINMENT RELIEF T","currency":null,"accountno":"0111002991"},{"availableBalance":-47389.02,"formattedAmount":"-47,389.02","bookBalance":-47389.02,"accountType":"","accountName":"INTEREST ON 91 DAYS TREASURY BIL","currency":null,"accountno":"0111003314"},{"availableBalance":-14271660.43,"formattedAmount":"-14,271,660.43","bookBalance":-14271660.43,"accountType":"","accountName":"INTEREST ON 182 DAYS TREASURY BI","currency":null,"accountno":"0111003321"},{"availableBalance":-4508834654.11,"formattedAmount":"-4,508,834,654.11","bookBalance":-4508834654.11,"accountType":"","accountName":"INTEREST ON 364 DAYS TREASURY BI","currency":null,"accountno":"0111003338"},{"availableBalance":11491920.7,"formattedAmount":"11,491,920.70","bookBalance":11491920.7,"accountType":"","accountName":"PETROLEUM REGULATORY AGENCY","currency":null,"accountno":"0111003448"},{"availableBalance":14624361.1,"formattedAmount":"14,624,361.10","bookBalance":14624361.1,"accountType":"","accountName":"PETROLEUM DIRECTORATE","currency":null,"accountno":"0111003455"},{"availableBalance":716682.0,"formattedAmount":"716,682.00","bookBalance":716682.0,"accountType":"","accountName":"ROAD MAINTENANCE FUND","currency":null,"accountno":"0111003462"},{"availableBalance":11748486.6,"formattedAmount":"11,748,486.60","bookBalance":11748486.6,"accountType":"","accountName":"ENVIRONMENTAL PROTECTION AGENCY","currency":null,"accountno":"0111003479"},{"availableBalance":3109342.86,"formattedAmount":"3,109,342.86","bookBalance":3109342.86,"accountType":"","accountName":"NATIONAL TELECOMMUNICATION COMMI","currency":null,"accountno":"0111003486"},{"availableBalance":33456809.91,"formattedAmount":"33,456,809.91","bookBalance":33456809.91,"accountType":"","accountName":"SIERRA LEONE MARITIME ADMINISTRA","currency":null,"accountno":"0111003493"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SPECIAL TAX & DUTIES","currency":null,"accountno":"0111003503"},{"availableBalance":431020263.0,"formattedAmount":"431,020,263.00","bookBalance":431020263.0,"accountType":"","accountName":"TIMBER EXPORT LEVY","currency":null,"accountno":"0111003527"},{"availableBalance":6709406.02,"formattedAmount":"6,709,406.02","bookBalance":6709406.02,"accountType":"","accountName":"AFFORESTATION AND CITIES LEVY","currency":null,"accountno":"0111003534"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"MULTI DONOR BASKET FUND FREE EDU","currency":null,"accountno":"0111003572"},{"availableBalance":622112.00,"formattedAmount":"622,112.00","bookBalance":622112.00,"accountType":"","accountName":"MULTI DONOR BASKET FUND 4 FREE E","currency":null,"accountno":"0111003596"},{"availableBalance":-10000000.00,"formattedAmount":"-10,000,000.00","bookBalance":-10000000.00,"accountType":"","accountName":"CORRUPTION REC FUNDS ACCOUNT (SL","currency":null,"accountno":"0111003637"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"CORRUPTION REC FUNDS ACCOUNT (US","currency":null,"accountno":"0111003644"},{"availableBalance":4257195.02,"formattedAmount":"4,257,195.02","bookBalance":4257195.02,"accountType":"","accountName":"SIERRA LEONE STANDARD BUREAU DIS","currency":null,"accountno":"0111003651"},{"availableBalance":2056108.84,"formattedAmount":"2,056,108.84","bookBalance":2056108.84,"accountType":"","accountName":"SIERRA LEONE ROADS SAFETY AUTHOR","currency":null,"accountno":"0111003668"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SLPA/GOSL CARGO TRACKING","currency":null,"accountno":"0111003699"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"RECO FUNDS BASED ON TECHNICAL AU","currency":null,"accountno":"0111003730"},{"availableBalance":16515705.94,"formattedAmount":"16,515,705.94","bookBalance":16515705.94,"accountType":"","accountName":"FISHERIES PROTECTION STATISTICS&","currency":null,"accountno":"0111003754"},{"availableBalance":666084.4,"formattedAmount":"666,084.40","bookBalance":666084.4,"accountType":"","accountName":"FREE HEALTH CARE INITIATIVE","currency":null,"accountno":"0111003778"},{"availableBalance":63339688.83,"formattedAmount":"63,339,688.83","bookBalance":63339688.83,"accountType":"","accountName":"PRODUCE MONITORING BOARD","currency":null,"accountno":"0111003785"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"USL TEACHING HOSPITAL COMPLEX","currency":null,"accountno":"0111003840"},{"availableBalance":10433625.0,"formattedAmount":"10,433,625.00","bookBalance":10433625.0,"accountType":"","accountName":"DUTY WAIVER JOINT MNT FUND TREAS","currency":null,"accountno":"0111003857"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"PUBLIC AUCTION COMMITTE TREASURY","currency":null,"accountno":"0111003864"},{"availableBalance":3623824.03,"formattedAmount":"3,623,824.03","bookBalance":3623824.03,"accountType":"","accountName":"COMM OF INQUIRY SPECIAL RECOVERY","currency":null,"accountno":"0111003888"},{"availableBalance":-1509739.69,"formattedAmount":"-1,509,739.69","bookBalance":-1509739.69,"accountType":"","accountName":"DAILY SUBSISTENCE ALW/MED EXP AC","currency":null,"accountno":"0111003929"},{"availableBalance":3780.96,"formattedAmount":"3,780.96","bookBalance":3780.96,"accountType":"","accountName":"S/L LOCAL CONTENT DEVELOPMENT FU","currency":null,"accountno":"0111003936"},{"availableBalance":10000.0,"formattedAmount":"10,000.00","bookBalance":10000.0,"accountType":"","accountName":"LSS/SLPA/GOSL CARGO TRACKING","currency":null,"accountno":"0111003943"},{"availableBalance":5000000.0,"formattedAmount":"5,000,000.00","bookBalance":5000000.0,"accountType":"","accountName":"LOCAL COUNCIL DEVELOPMENT PROJEC","currency":null,"accountno":"0111003950"},{"availableBalance":205694040.46,"formattedAmount":"205,694,040.46","bookBalance":205694040.46,"accountType":"","accountName":"DEBT MANAGEMENT TREASURY","currency":null,"accountno":"0111003967"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"AUDIT SERVICE S/L - AUDIT FEES","currency":null,"accountno":"0111003974"},{"availableBalance":816415.54,"formattedAmount":"816,415.54","bookBalance":816415.54,"accountType":"","accountName":"NPPA-REV FROM SALE OF BIDDING DO","currency":null,"accountno":"0111003981"},{"availableBalance":19551766.44,"formattedAmount":"19,551,766.44","bookBalance":19551766.44,"accountType":"","accountName":"VEHICLE LOAN SCHEME","currency":null,"accountno":"0111004005"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SLCAA AVIATION FEES","currency":null,"accountno":"0111004012"},{"availableBalance":3326998.54,"formattedAmount":"3,326,998.54","bookBalance":3326998.54,"accountType":"","accountName":"NACOVERC LAB FEES & ENFORCE FINE","currency":null,"accountno":"0111004029"},{"availableBalance":139164.95,"formattedAmount":"139,164.95","bookBalance":139164.95,"accountType":"","accountName":"CTN FEES - FOREIGN CURRENCY","currency":null,"accountno":"0111004036"},{"availableBalance":0.01,"formattedAmount":"0.01","bookBalance":0.01,"accountType":"","accountName":"NATCOM AND BRADCORP GATEWAY REVE","currency":null,"accountno":"0111004043"},{"availableBalance":1104613.33,"formattedAmount":"1,104,613.33","bookBalance":1104613.33,"accountType":"","accountName":"NAT. WATER RESOURCES MGMT AGENCY","currency":null,"accountno":"0111004067"},{"availableBalance":2252147.11,"formattedAmount":"2,252,147.11","bookBalance":2252147.11,"accountType":"","accountName":"NaCOVERC LABORATORY FEES (USD)","currency":null,"accountno":"0111004074"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"WAGE BILL REVOLVING FUND ACCOUNT","currency":null,"accountno":"0111004098"},{"availableBalance":83069442.86,"formattedAmount":"83,069,442.86","bookBalance":83069442.86,"accountType":"","accountName":"STATE LAND SALES A/C","currency":null,"accountno":"0111004160"},{"availableBalance":48487.0,"formattedAmount":"48,487.00","bookBalance":48487.0,"accountType":"","accountName":"34 MILITARY HOSPITAL","currency":null,"accountno":"0111004201"},{"availableBalance":2206155.0,"formattedAmount":"2,206,155.00","bookBalance":2206155.0,"accountType":"","accountName":"BETTING & GAMBLING LICENCES ACCO","currency":null,"accountno":"0111004232"},{"availableBalance":34865.21,"formattedAmount":"34,865.21","bookBalance":34865.21,"accountType":"","accountName":"PAY NO BRIBE CAMPAIGN PROJECT AC","currency":null,"accountno":"0111004421"},{"availableBalance":2293395.84,"formattedAmount":"2,293,395.84","bookBalance":2293395.84,"accountType":"","accountName":"LUNGI BRIDGE FEASIBILITY STUDY(S","currency":null,"accountno":"0111004438"},{"availableBalance":17.05,"formattedAmount":"17.05","bookBalance":17.05,"accountType":"","accountName":"MOPED UNICEF PROGRAM SUPPORT A/C","currency":null,"accountno":"0111004658"},{"availableBalance":164418.88,"formattedAmount":"164,418.88","bookBalance":164418.88,"accountType":"","accountName":"NAT ELECTIONS SUSTAIN TRUST FUND","currency":null,"accountno":"0111004809"},{"availableBalance":0.79,"formattedAmount":"0.79","bookBalance":0.79,"accountType":"","accountName":"IMF SPECIAL DRAWING RIGHTS RETRO","currency":null,"accountno":"0111004847"},{"availableBalance":64949307.74,"formattedAmount":"64,949,307.74","bookBalance":64949307.74,"accountType":"","accountName":"GoSL TSA REVENUE SHARE ACCOUNT","currency":null,"accountno":"0111004878"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"DUTY WAIVER","currency":null,"accountno":"0111004885"},{"availableBalance":-931456.0,"formattedAmount":"-931,456.00","bookBalance":-931456.0,"accountType":"","accountName":"IMPREST AC FOR ACC GEN DEPT","currency":null,"accountno":"0111004926"},{"availableBalance":10685160.00,"formattedAmount":"10,685,160.00","bookBalance":10685160.00,"accountType":"","accountName":"SL NATIONAL SHIPPING COMPANY ESC","currency":null,"accountno":"0111004995"},{"availableBalance":-1009872.99,"formattedAmount":"-1,009,872.99","bookBalance":-1009872.99,"accountType":"","accountName":"MINISTRY OF DEFENCE QUARTERLY","currency":null,"accountno":"0111005057"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SIERRA LEONE POLICE GENERAL ACCO","currency":null,"accountno":"0111005129"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SIERRA LEONE CORRECTIONAL SERVIC","currency":null,"accountno":"0111005136"},{"availableBalance":3446.86,"formattedAmount":"3,446.86","bookBalance":3446.86,"accountType":"","accountName":"IMMIGRATION ACCOUNT","currency":null,"accountno":"0111005150"},{"availableBalance":14952799.83,"formattedAmount":"14,952,799.83","bookBalance":14952799.83,"accountType":"","accountName":"DIAGNOSTIC MEDICAL CENTRE","currency":null,"accountno":"0111005260"},{"availableBalance":6331936.99,"formattedAmount":"6,331,936.99","bookBalance":6331936.99,"accountType":"","accountName":"SALES OF AIRSTRIP LANDS","currency":null,"accountno":"0111005332"},{"availableBalance":245148.43,"formattedAmount":"245,148.43","bookBalance":245148.43,"accountType":"","accountName":"GOSL NATIONAL TREE PLANTING","currency":null,"accountno":"0111005387"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"OFFICE OF THE OMBUDSMAN DISBURSE","currency":null,"accountno":"0111005844"},{"availableBalance":379264.0,"formattedAmount":"379,264.00","bookBalance":379264.0,"accountType":"","accountName":"FERTILIZER SUPPORT FUND","currency":null,"accountno":"0111006054"},{"availableBalance":117899.95,"formattedAmount":"117,899.95","bookBalance":117899.95,"accountType":"","accountName":"TERTIARY EDUCATION COMMISSION DI","currency":null,"accountno":"0111006308"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SIERRA LEONE PHARMACY BOARD DISB","currency":null,"accountno":"0111006377"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SLMET AGRIC VAL CHA DEV PROJ (AV","currency":null,"accountno":"0111006456"},{"availableBalance":1774771.57,"formattedAmount":"1,774,771.57","bookBalance":1774771.57,"accountType":"","accountName":"DIGITAL DEVELOPMENT FUND (DDF) A","currency":null,"accountno":"0111006535"}],"code":"01","success":true,"description":"Success"}] 2025-10-30 16:31:50.5626||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 2025-10-30 16:31:50.5626|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[System.Object, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2025-10-30 16:31:50.5748|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 3148.7852ms 2025-10-30 16:31:50.5748|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-10-30 16:31:50.5748|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3193.7873ms 200 application/json; charset=utf-8 2025-10-30 16:31:50.6445||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"4256873.7","bookBalance":0.0,"accountType":null,"accountName":"ELECTRONIC FUNDS TRANS SUSPENSE","currency":null,"accountno":"SLE116030002","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:31:50.6445||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:31:50.6537||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:31:50.6537||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:31:50.6537||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:31:50.6687||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 2025-10-30 16:31:51.4721||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-4597240913.73","bookBalance":0.0,"accountType":null,"accountName":"AGD SALARIES AND WAGES ACCOUNT19","currency":null,"accountno":"0111001293","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:31:51.4721||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:31:51.4826||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:31:51.4826||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:31:51.4979||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:31:51.4979||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 2025-10-30 16:31:52.2583||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-88592650.72","bookBalance":0.0,"accountType":null,"accountName":"AGD PENSIONS ACCOUNTS 1998","currency":null,"accountno":"0111001310","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:31:52.2639||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:31:52.2639||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:31:52.2781||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:31:52.2964|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (9ms) [Parameters=[@p2='?' (DbType = Int64), @p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p5='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p8='?' (DbType = Int64), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p11='?' (DbType = Int64), @p9='?' (DbType = DateTime2), @p10='?' (DbType = DateTime2), @p14='?' (DbType = Int64), @p12='?' (DbType = DateTime2), @p13='?' (DbType = DateTime2), @p17='?' (DbType = Int64), @p15='?' (DbType = DateTime2), @p16='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p0, [DateModified] = @p1 WHERE [Id] = @p2; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p3, [DateModified] = @p4 WHERE [Id] = @p5; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p6, [DateModified] = @p7 WHERE [Id] = @p8; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p9, [DateModified] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p12, [DateModified] = @p13 WHERE [Id] = @p14; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p15, [DateModified] = @p16 WHERE [Id] = @p17; SELECT @@ROWCOUNT; 2025-10-30 16:31:52.2964|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId] FROM [SourceAccountManagements] AS [s] WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit)) ORDER BY [s].[DateCreated] DESC 2025-10-30 16:31:52.3127|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:31:52.3127|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:31:52.3127|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:31:52.3270|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:31:52.3270|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:31:52.3270|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:31:52.3414|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:31:52.3414|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:31:52.3414|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:31:52.3554|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:31:52.3554|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:31:52.3554|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:31:52.4161|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[SourceAccountManagement.Data.Models.SourceAccountManagementViewModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2025-10-30 16:31:52.4217|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 4990.8821ms 2025-10-30 16:31:52.4217|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-10-30 16:31:52.4217|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5037.0848ms 200 application/json; charset=utf-8 2025-10-30 16:46:55.3574|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-10-30 16:46:55.3574|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-10-30 16:46:55.3574|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-10-30 16:46:55.3618|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:46:55.3618|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:46:55.3618|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:46:55.3618|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.8551ms 204 2025-10-30 16:46:55.3618|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 11.8274ms 204 2025-10-30 16:46:55.3618|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 12.7715ms 204 2025-10-30 16:46:55.3787|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/AccountManagement/GetAccountByCorporateId?corporateId=207 2025-10-30 16:46:55.3787|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/WaysMeans/Current 2025-10-30 16:46:55.3787|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/AccountServices/api/TreasuryAccount/Balance 2025-10-30 16:46:55.3787|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:46:55.3787|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:46:55.3787|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 2025-10-30 16:46:55.3787|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:46:55.3787|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:46:55.3787|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 2025-10-30 16:46:55.3787|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:46:55.3923|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:46:55.3923|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 2025-10-30 16:46:55.3923|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-10-30 16:46:55.3923|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-10-30 16:46:55.3923|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-10-30 16:46:55.3923|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetAccountByCorporateId", controller = "AccountManagement"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetAccountByCorporateIdAsync(Int64) on controller AccountManagement.Controllers.AccountManagementController (AccountManagement). 2025-10-30 16:46:55.3923|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchCurrentWaysMeans", controller = "WaysMeans"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult FetchCurrentWaysMeans() on controller AccountManagement.Controllers.WaysMeansController (AccountManagement). 2025-10-30 16:46:55.3923|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "FetchBalance", controller = "TreasuryAccount"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] FetchBalance(System.Nullable`1[CorporatePay.Common.GovernmentAccountType]) on controller AccountManagement.Controllers.TreasuryAccountController (AccountManagement). 2025-10-30 16:46:55.3923|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-10-30 16:46:55.3923|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 2025-10-30 16:46:55.3923||WARN|AccountManagement.Core.Services.TreasuryAccountService|CorporateId : 207 2025-10-30 16:46:55.4275||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-10-30 16:46:55.4275|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [w].[Id], [w].[Amount], [w].[Comment], [w].[CreatedBy], [w].[DateCreated], [w].[DateModified], [w].[IsActive], [w].[IsDeleted], [w].[ModifiedBy], [w].[Year] FROM [WaysMeans] AS [w] WHERE ([w].[IsDeleted] = CAST(0 AS bit)) AND ([w].[IsActive] = CAST(1 AS bit)) ORDER BY [w].[Id] DESC 2025-10-30 16:46:55.4275||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-10-30 16:46:55.4275|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[AccountManagement.Data.Models.WaysMeansModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2025-10-30 16:46:55.4275|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement) in 35.9298ms 2025-10-30 16:46:55.4275|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (4ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId] FROM [SourceAccountManagements] AS [s] WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:46:55.4393|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.WaysMeansController.FetchCurrentWaysMeans (AccountManagement)' 2025-10-30 16:46:55.4393|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 64.9974ms 200 application/json; charset=utf-8 2025-10-30 16:46:55.4393||WARN|AccountManagement.Core.Services.IntegrationService|Route Url:https://rcpayapi.mof.gov.sl/RouteManagement/ 2025-10-30 16:46:55.4583||WARN|AccountManagement.Core.Services.IntegrationService|Route Endpoint:/api/RouteManagement/FetchRoutes/79 2025-10-30 16:46:55.4829||WARN|AccountManagement.Core.Services.TreasuryAccountService|About to Fetch Treasury Accounts 2025-10-30 16:46:55.4860||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: api/SL/CorporatePayAPI/V2/Treasury/Accounts/Balance 2025-10-30 16:46:55.4860||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:46:55.4860||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=1100512 2025-10-30 16:46:57.4282||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-7861933432.4","bookBalance":0.0,"accountType":null,"accountName":"AGD EXPENDITURE ACCOUNTS-GENERAL","currency":null,"accountno":"0111001279","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:46:57.4282||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:46:57.4282||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:46:57.4512||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:46:57.4550||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:46:57.4550||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100127923 2025-10-30 16:46:57.5232||WARN|AccountManagement.Core.Services.IntegrationService|Treasury Balance Enquiry Response [{"data":[{"availableBalance":388447729.02,"formattedAmount":"388,447,729.02","bookBalance":388447729.02,"accountType":"","accountName":"TREASURY MAIN","currency":null,"accountno":"0111001255"},{"availableBalance":-7861933432.4,"formattedAmount":"-7,861,933,432.40","bookBalance":-7861933432.4,"accountType":"","accountName":"AGD EXPENDITURE ACCOUNTS-GENERAL","currency":null,"accountno":"0111001279"},{"availableBalance":-4597240913.73,"formattedAmount":"-4,597,240,913.73","bookBalance":-4597240913.73,"accountType":"","accountName":"AGD SALARIES AND WAGES ACCOUNT19","currency":null,"accountno":"0111001293"},{"availableBalance":-88592650.72,"formattedAmount":"-88,592,650.72","bookBalance":-88592650.72,"accountType":"","accountName":"AGD PENSIONS ACCOUNTS 1998","currency":null,"accountno":"0111001310"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"DIFD (UK) BUDGSUPPORT GRANT","currency":null,"accountno":"0111001358"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SALARY ADVANCES ACCOUNT","currency":null,"accountno":"0111001372"},{"availableBalance":5289546828.0,"formattedAmount":"5,289,546,828.00","bookBalance":5289546828.0,"accountType":"","accountName":"INCOME TAX TREAS AC","currency":null,"accountno":"0111001396"},{"availableBalance":1510677697.47,"formattedAmount":"1,510,677,697.47","bookBalance":1510677697.47,"accountType":"","accountName":"CUSTOMS AND EXCISE TREAS AC","currency":null,"accountno":"0111001413"},{"availableBalance":102718828.2,"formattedAmount":"102,718,828.20","bookBalance":102718828.2,"accountType":"","accountName":"MARINE RESOURCES TREAS AC","currency":null,"accountno":"0111001437"},{"availableBalance":1144285686.71,"formattedAmount":"1,144,285,686.71","bookBalance":1144285686.71,"accountType":"","accountName":"MINERAL RESOURCES TREAS AC","currency":null,"accountno":"0111001451"},{"availableBalance":11531865.2,"formattedAmount":"11,531,865.20","bookBalance":11531865.2,"accountType":"","accountName":"IMMIGRATION TREAS AC","currency":null,"accountno":"0111001475"},{"availableBalance":444627855.91,"formattedAmount":"444,627,855.91","bookBalance":444627855.91,"accountType":"","accountName":"GENERAL REVENUE TREAS AC","currency":null,"accountno":"0111001499"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"IMMIGRATION ESCROW ACCOUNT","currency":null,"accountno":"0111001516"},{"availableBalance":12105897.0,"formattedAmount":"12,105,897.00","bookBalance":12105897.0,"accountType":"","accountName":"ADMINISTRATOR AND REGISTRAR GENE","currency":null,"accountno":"0111001530"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"POLICE-UNCLAIMED SALARIES WAGES","currency":null,"accountno":"0111001578"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"EDU SCIENCE AND TECH-UNCLAIMED S","currency":null,"accountno":"0111001592"},{"availableBalance":1984275.2,"formattedAmount":"1,984,275.20","bookBalance":1984275.2,"accountType":"","accountName":"OTHER DEPTMINISTRIES-UNCLAIMED S","currency":null,"accountno":"0111001657"},{"availableBalance":607877456.1,"formattedAmount":"607,877,456.10","bookBalance":607877456.1,"accountType":"","accountName":"TREASURY WAYS AND MEANS ADVANCES","currency":null,"accountno":"0111001671"},{"availableBalance":990172300.0,"formattedAmount":"990,172,300.00","bookBalance":990172300.0,"accountType":"","accountName":"TREASURY BEARER BOND ACCOUNTS","currency":null,"accountno":"0111001695"},{"availableBalance":-1285494020.06,"formattedAmount":"-1,285,494,020.06","bookBalance":-1285494020.06,"accountType":"","accountName":"INTEREST ON TREASURY BEARER BOND","currency":null,"accountno":"0111001712"},{"availableBalance":-2083060235.36,"formattedAmount":"-2,083,060,235.36","bookBalance":-2083060235.36,"accountType":"","accountName":"EXTERNAL DEBT SERVICE PAYMENTS","currency":null,"accountno":"0111001736"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"KENEMA GOVT TREASURY DEPOSITS AC","currency":null,"accountno":"0111001750"},{"availableBalance":20494300.88,"formattedAmount":"20,494,300.88","bookBalance":20494300.88,"accountType":"","accountName":"HIPC TRUST FUND ACCOUNT","currency":null,"accountno":"0111001774"},{"availableBalance":-729960.98,"formattedAmount":"-729,960.98","bookBalance":-729960.98,"accountType":"","accountName":"TREASURY BILLS AC","currency":null,"accountno":"0111001839"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"OFIDSL GOV DEBT RELIEF AC","currency":null,"accountno":"0111001891"},{"availableBalance":113758090.93,"formattedAmount":"113,758,090.93","bookBalance":113758090.93,"accountType":"","accountName":"NOMINALCOST AC FOR 182-DAYS TREA","currency":null,"accountno":"0111001918"},{"availableBalance":3387842863.96,"formattedAmount":"3,387,842,863.96","bookBalance":3387842863.96,"accountType":"","accountName":"NOMINALCOST AC FOR 364-DAYS TREA","currency":null,"accountno":"0111001932"},{"availableBalance":-8247204.18,"formattedAmount":"-8,247,204.18","bookBalance":-8247204.18,"accountType":"","accountName":"COMMISSION AC FOR TREASURY BILLS","currency":null,"accountno":"0111001970"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"MIN OF FISHERIES AND MARINE RESO","currency":null,"accountno":"0111002032"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"NAT TELECOMS REVENUE ESCROW AC","currency":null,"accountno":"0111002056"},{"availableBalance":4146519.05,"formattedAmount":"4,146,519.05","bookBalance":4146519.05,"accountType":"","accountName":"SIERRA LEONE PHARMACY BOARD REVE","currency":null,"accountno":"0111002070"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SIERRA LEONE MARITIME ADMIN REVE","currency":null,"accountno":"0111002094"},{"availableBalance":10968822.4,"formattedAmount":"10,968,822.40","bookBalance":10968822.4,"accountType":"","accountName":"SLCAA FOREIGN TRAVEL TAX A/C","currency":null,"accountno":"0111002111"},{"availableBalance":2154504253.26,"formattedAmount":"2,154,504,253.26","bookBalance":2154504253.26,"accountType":"","accountName":"GOODS AND SERVICES TAX ACCOUNT","currency":null,"accountno":"0111002135"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"MARINES FINES AC","currency":null,"accountno":"0111002159"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"AFFORESTATION AC","currency":null,"accountno":"0111002197"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"NATIONAL IDENTITY CARD PROJECT E","currency":null,"accountno":"0111002252"},{"availableBalance":412398.2,"formattedAmount":"412,398.20","bookBalance":412398.2,"accountType":"","accountName":"MINISTRY OF PRESIDENTIAL AND PUB","currency":null,"accountno":"0111002276"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"JAPANESE GRANT FOR COPING WITH C","currency":null,"accountno":"0111002317"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"DIAMOND ROYALTIES AC","currency":null,"accountno":"0111002355"},{"availableBalance":11283546.22,"formattedAmount":"11,283,546.22","bookBalance":11283546.22,"accountType":"","accountName":"NON-TAX REVENUE AC","currency":null,"accountno":"0111002379"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"INT. ON 91 182 364 - DAYS TREASU","currency":null,"accountno":"0111002393"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SIERRATELEBID MODERNISATION AND","currency":null,"accountno":"0111002410"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"IMF BUDGET FINANCING TREASURY A/","currency":null,"accountno":"0111002843"},{"availableBalance":926113844.14,"formattedAmount":"926,113,844.14","bookBalance":926113844.14,"accountType":"","accountName":"PETROLEUM EXCISE DUTY ACCOUNT","currency":null,"accountno":"0111002984"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"CATASTROPHE CONTAINMENT RELIEF T","currency":null,"accountno":"0111002991"},{"availableBalance":-47389.02,"formattedAmount":"-47,389.02","bookBalance":-47389.02,"accountType":"","accountName":"INTEREST ON 91 DAYS TREASURY BIL","currency":null,"accountno":"0111003314"},{"availableBalance":-14271660.43,"formattedAmount":"-14,271,660.43","bookBalance":-14271660.43,"accountType":"","accountName":"INTEREST ON 182 DAYS TREASURY BI","currency":null,"accountno":"0111003321"},{"availableBalance":-4508834654.11,"formattedAmount":"-4,508,834,654.11","bookBalance":-4508834654.11,"accountType":"","accountName":"INTEREST ON 364 DAYS TREASURY BI","currency":null,"accountno":"0111003338"},{"availableBalance":11491920.7,"formattedAmount":"11,491,920.70","bookBalance":11491920.7,"accountType":"","accountName":"PETROLEUM REGULATORY AGENCY","currency":null,"accountno":"0111003448"},{"availableBalance":14624361.1,"formattedAmount":"14,624,361.10","bookBalance":14624361.1,"accountType":"","accountName":"PETROLEUM DIRECTORATE","currency":null,"accountno":"0111003455"},{"availableBalance":2084087.0,"formattedAmount":"2,084,087.00","bookBalance":2084087.0,"accountType":"","accountName":"ROAD MAINTENANCE FUND","currency":null,"accountno":"0111003462"},{"availableBalance":11748486.6,"formattedAmount":"11,748,486.60","bookBalance":11748486.6,"accountType":"","accountName":"ENVIRONMENTAL PROTECTION AGENCY","currency":null,"accountno":"0111003479"},{"availableBalance":3109342.86,"formattedAmount":"3,109,342.86","bookBalance":3109342.86,"accountType":"","accountName":"NATIONAL TELECOMMUNICATION COMMI","currency":null,"accountno":"0111003486"},{"availableBalance":33456809.91,"formattedAmount":"33,456,809.91","bookBalance":33456809.91,"accountType":"","accountName":"SIERRA LEONE MARITIME ADMINISTRA","currency":null,"accountno":"0111003493"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SPECIAL TAX & DUTIES","currency":null,"accountno":"0111003503"},{"availableBalance":431020263.0,"formattedAmount":"431,020,263.00","bookBalance":431020263.0,"accountType":"","accountName":"TIMBER EXPORT LEVY","currency":null,"accountno":"0111003527"},{"availableBalance":6709406.02,"formattedAmount":"6,709,406.02","bookBalance":6709406.02,"accountType":"","accountName":"AFFORESTATION AND CITIES LEVY","currency":null,"accountno":"0111003534"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"MULTI DONOR BASKET FUND FREE EDU","currency":null,"accountno":"0111003572"},{"availableBalance":622112.00,"formattedAmount":"622,112.00","bookBalance":622112.00,"accountType":"","accountName":"MULTI DONOR BASKET FUND 4 FREE E","currency":null,"accountno":"0111003596"},{"availableBalance":-10000000.00,"formattedAmount":"-10,000,000.00","bookBalance":-10000000.00,"accountType":"","accountName":"CORRUPTION REC FUNDS ACCOUNT (SL","currency":null,"accountno":"0111003637"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"CORRUPTION REC FUNDS ACCOUNT (US","currency":null,"accountno":"0111003644"},{"availableBalance":4257195.02,"formattedAmount":"4,257,195.02","bookBalance":4257195.02,"accountType":"","accountName":"SIERRA LEONE STANDARD BUREAU DIS","currency":null,"accountno":"0111003651"},{"availableBalance":2109578.84,"formattedAmount":"2,109,578.84","bookBalance":2109578.84,"accountType":"","accountName":"SIERRA LEONE ROADS SAFETY AUTHOR","currency":null,"accountno":"0111003668"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SLPA/GOSL CARGO TRACKING","currency":null,"accountno":"0111003699"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"RECO FUNDS BASED ON TECHNICAL AU","currency":null,"accountno":"0111003730"},{"availableBalance":16515705.94,"formattedAmount":"16,515,705.94","bookBalance":16515705.94,"accountType":"","accountName":"FISHERIES PROTECTION STATISTICS&","currency":null,"accountno":"0111003754"},{"availableBalance":666084.4,"formattedAmount":"666,084.40","bookBalance":666084.4,"accountType":"","accountName":"FREE HEALTH CARE INITIATIVE","currency":null,"accountno":"0111003778"},{"availableBalance":63346063.83,"formattedAmount":"63,346,063.83","bookBalance":63346063.83,"accountType":"","accountName":"PRODUCE MONITORING BOARD","currency":null,"accountno":"0111003785"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"USL TEACHING HOSPITAL COMPLEX","currency":null,"accountno":"0111003840"},{"availableBalance":10433625.0,"formattedAmount":"10,433,625.00","bookBalance":10433625.0,"accountType":"","accountName":"DUTY WAIVER JOINT MNT FUND TREAS","currency":null,"accountno":"0111003857"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"PUBLIC AUCTION COMMITTE TREASURY","currency":null,"accountno":"0111003864"},{"availableBalance":3623824.03,"formattedAmount":"3,623,824.03","bookBalance":3623824.03,"accountType":"","accountName":"COMM OF INQUIRY SPECIAL RECOVERY","currency":null,"accountno":"0111003888"},{"availableBalance":-1509739.69,"formattedAmount":"-1,509,739.69","bookBalance":-1509739.69,"accountType":"","accountName":"DAILY SUBSISTENCE ALW/MED EXP AC","currency":null,"accountno":"0111003929"},{"availableBalance":3780.96,"formattedAmount":"3,780.96","bookBalance":3780.96,"accountType":"","accountName":"S/L LOCAL CONTENT DEVELOPMENT FU","currency":null,"accountno":"0111003936"},{"availableBalance":10000.0,"formattedAmount":"10,000.00","bookBalance":10000.0,"accountType":"","accountName":"LSS/SLPA/GOSL CARGO TRACKING","currency":null,"accountno":"0111003943"},{"availableBalance":5000000.0,"formattedAmount":"5,000,000.00","bookBalance":5000000.0,"accountType":"","accountName":"LOCAL COUNCIL DEVELOPMENT PROJEC","currency":null,"accountno":"0111003950"},{"availableBalance":205694040.46,"formattedAmount":"205,694,040.46","bookBalance":205694040.46,"accountType":"","accountName":"DEBT MANAGEMENT TREASURY","currency":null,"accountno":"0111003967"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"AUDIT SERVICE S/L - AUDIT FEES","currency":null,"accountno":"0111003974"},{"availableBalance":817415.54,"formattedAmount":"817,415.54","bookBalance":817415.54,"accountType":"","accountName":"NPPA-REV FROM SALE OF BIDDING DO","currency":null,"accountno":"0111003981"},{"availableBalance":19551766.44,"formattedAmount":"19,551,766.44","bookBalance":19551766.44,"accountType":"","accountName":"VEHICLE LOAN SCHEME","currency":null,"accountno":"0111004005"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"SLCAA AVIATION FEES","currency":null,"accountno":"0111004012"},{"availableBalance":3326998.54,"formattedAmount":"3,326,998.54","bookBalance":3326998.54,"accountType":"","accountName":"NACOVERC LAB FEES & ENFORCE FINE","currency":null,"accountno":"0111004029"},{"availableBalance":139164.95,"formattedAmount":"139,164.95","bookBalance":139164.95,"accountType":"","accountName":"CTN FEES - FOREIGN CURRENCY","currency":null,"accountno":"0111004036"},{"availableBalance":0.01,"formattedAmount":"0.01","bookBalance":0.01,"accountType":"","accountName":"NATCOM AND BRADCORP GATEWAY REVE","currency":null,"accountno":"0111004043"},{"availableBalance":1104613.33,"formattedAmount":"1,104,613.33","bookBalance":1104613.33,"accountType":"","accountName":"NAT. WATER RESOURCES MGMT AGENCY","currency":null,"accountno":"0111004067"},{"availableBalance":2252147.11,"formattedAmount":"2,252,147.11","bookBalance":2252147.11,"accountType":"","accountName":"NaCOVERC LABORATORY FEES (USD)","currency":null,"accountno":"0111004074"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"WAGE BILL REVOLVING FUND ACCOUNT","currency":null,"accountno":"0111004098"},{"availableBalance":83069442.86,"formattedAmount":"83,069,442.86","bookBalance":83069442.86,"accountType":"","accountName":"STATE LAND SALES A/C","currency":null,"accountno":"0111004160"},{"availableBalance":48487.0,"formattedAmount":"48,487.00","bookBalance":48487.0,"accountType":"","accountName":"34 MILITARY HOSPITAL","currency":null,"accountno":"0111004201"},{"availableBalance":2206155.0,"formattedAmount":"2,206,155.00","bookBalance":2206155.0,"accountType":"","accountName":"BETTING & GAMBLING LICENCES ACCO","currency":null,"accountno":"0111004232"},{"availableBalance":34865.21,"formattedAmount":"34,865.21","bookBalance":34865.21,"accountType":"","accountName":"PAY NO BRIBE CAMPAIGN PROJECT AC","currency":null,"accountno":"0111004421"},{"availableBalance":2293395.84,"formattedAmount":"2,293,395.84","bookBalance":2293395.84,"accountType":"","accountName":"LUNGI BRIDGE FEASIBILITY STUDY(S","currency":null,"accountno":"0111004438"},{"availableBalance":17.05,"formattedAmount":"17.05","bookBalance":17.05,"accountType":"","accountName":"MOPED UNICEF PROGRAM SUPPORT A/C","currency":null,"accountno":"0111004658"},{"availableBalance":164418.88,"formattedAmount":"164,418.88","bookBalance":164418.88,"accountType":"","accountName":"NAT ELECTIONS SUSTAIN TRUST FUND","currency":null,"accountno":"0111004809"},{"availableBalance":0.79,"formattedAmount":"0.79","bookBalance":0.79,"accountType":"","accountName":"IMF SPECIAL DRAWING RIGHTS RETRO","currency":null,"accountno":"0111004847"},{"availableBalance":64949307.74,"formattedAmount":"64,949,307.74","bookBalance":64949307.74,"accountType":"","accountName":"GoSL TSA REVENUE SHARE ACCOUNT","currency":null,"accountno":"0111004878"},{"availableBalance":0.00,"formattedAmount":"0.00","bookBalance":0.00,"accountType":"","accountName":"DUTY WAIVER","currency":null,"accountno":"0111004885"},{"availableBalance":-931456.0,"formattedAmount":"-931,456.00","bookBalance":-931456.0,"accountType":"","accountName":"IMPREST AC FOR ACC GEN DEPT","currency":null,"accountno":"0111004926"},{"availableBalance":10685160.00,"formattedAmount":"10,685,160.00","bookBalance":10685160.00,"accountType":"","accountName":"SL NATIONAL SHIPPING COMPANY ESC","currency":null,"accountno":"0111004995"},{"availableBalance":-1009872.99,"formattedAmount":"-1,009,872.99","bookBalance":-1009872.99,"accountType":"","accountName":"MINISTRY OF DEFENCE QUARTERLY","currency":null,"accountno":"0111005057"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SIERRA LEONE POLICE GENERAL ACCO","currency":null,"accountno":"0111005129"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SIERRA LEONE CORRECTIONAL SERVIC","currency":null,"accountno":"0111005136"},{"availableBalance":3446.86,"formattedAmount":"3,446.86","bookBalance":3446.86,"accountType":"","accountName":"IMMIGRATION ACCOUNT","currency":null,"accountno":"0111005150"},{"availableBalance":14952799.83,"formattedAmount":"14,952,799.83","bookBalance":14952799.83,"accountType":"","accountName":"DIAGNOSTIC MEDICAL CENTRE","currency":null,"accountno":"0111005260"},{"availableBalance":6331936.99,"formattedAmount":"6,331,936.99","bookBalance":6331936.99,"accountType":"","accountName":"SALES OF AIRSTRIP LANDS","currency":null,"accountno":"0111005332"},{"availableBalance":245148.43,"formattedAmount":"245,148.43","bookBalance":245148.43,"accountType":"","accountName":"GOSL NATIONAL TREE PLANTING","currency":null,"accountno":"0111005387"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"OFFICE OF THE OMBUDSMAN DISBURSE","currency":null,"accountno":"0111005844"},{"availableBalance":379264.0,"formattedAmount":"379,264.00","bookBalance":379264.0,"accountType":"","accountName":"FERTILIZER SUPPORT FUND","currency":null,"accountno":"0111006054"},{"availableBalance":117899.95,"formattedAmount":"117,899.95","bookBalance":117899.95,"accountType":"","accountName":"TERTIARY EDUCATION COMMISSION DI","currency":null,"accountno":"0111006308"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SIERRA LEONE PHARMACY BOARD DISB","currency":null,"accountno":"0111006377"},{"availableBalance":0.0,"formattedAmount":"0.00","bookBalance":0.0,"accountType":"","accountName":"SLMET AGRIC VAL CHA DEV PROJ (AV","currency":null,"accountno":"0111006456"},{"availableBalance":1774771.57,"formattedAmount":"1,774,771.57","bookBalance":1774771.57,"accountType":"","accountName":"DIGITAL DEVELOPMENT FUND (DDF) A","currency":null,"accountno":"0111006535"}],"code":"01","success":true,"description":"Success"}] 2025-10-30 16:46:57.5232||WARN|AccountManagement.Core.Services.TreasuryAccountService|Done Fetching Treasury Accounts 2025-10-30 16:46:57.5352|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[System.Object, System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 2025-10-30 16:46:57.5352|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement) in 2136.5869ms 2025-10-30 16:46:57.5352|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.TreasuryAccountController.FetchBalance (AccountManagement)' 2025-10-30 16:46:57.5352|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2162.9785ms 200 application/json; charset=utf-8 2025-10-30 16:46:58.2746||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-7861933432.4","bookBalance":0.0,"accountType":null,"accountName":"AGD EXPENDITURE ACCOUNTS-GENERAL","currency":null,"accountno":"0111001279","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:46:58.2746||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:46:58.2746||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:46:58.2915||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:46:58.2915||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:46:58.2915||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=0111001293 2025-10-30 16:46:59.1333||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-4597240913.73","bookBalance":0.0,"accountType":null,"accountName":"AGD SALARIES AND WAGES ACCOUNT19","currency":null,"accountno":"0111001293","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:46:59.1333||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:46:59.1426||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:46:59.1426||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:46:59.1426||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:46:59.1576||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=SLE116030002 2025-10-30 16:46:59.9285||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"4256873.7","bookBalance":0.0,"accountType":null,"accountName":"ELECTRONIC FUNDS TRANS SUSPENSE","currency":null,"accountno":"SLE116030002","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:46:59.9285||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:46:59.9285||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:46:59.9464||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:46:59.9464||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:46:59.9464||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100129378 2025-10-30 16:47:00.7584||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-4597240913.73","bookBalance":0.0,"accountType":null,"accountName":"AGD SALARIES AND WAGES ACCOUNT19","currency":null,"accountno":"0111001293","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:47:00.7584||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:47:00.7695||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:47:00.7695||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:47:00.7695||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to validate Source Account 2025-10-30 16:47:00.7845||WARN|AccountManagement.Core.Services.IntegrationService|Endpoint: /api/SL/CorporatePayApi/V2/GetAccountBalance?accountNumber=000001011100131027 2025-10-30 16:47:01.5855||WARN|AccountManagement.Core.Services.IntegrationService|Balance Enquiry Response [{"availableBalance":"-88592650.72","bookBalance":0.0,"accountType":null,"accountName":"AGD PENSIONS ACCOUNTS 1998","currency":null,"accountno":"0111001310","responseCode":"00","responseMessage":"Success","transactionDate":"0001-01-01T00:00:00"}] 2025-10-30 16:47:01.5855||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done validating Source Account 2025-10-30 16:47:01.5855||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|About to Get OverDraft Limit 2025-10-30 16:47:01.6018||WARN|SourceAccountManagement.Core.Services.SourceAccountManagementService|Done getting Overdraft Limit 2025-10-30 16:47:01.6149|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (3ms) [Parameters=[@p2='?' (DbType = Int64), @p0='?' (DbType = DateTime2), @p1='?' (DbType = DateTime2), @p5='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p8='?' (DbType = Int64), @p6='?' (DbType = DateTime2), @p7='?' (DbType = DateTime2), @p11='?' (DbType = Int64), @p9='?' (DbType = DateTime2), @p10='?' (DbType = DateTime2), @p14='?' (DbType = Int64), @p12='?' (DbType = DateTime2), @p13='?' (DbType = DateTime2), @p17='?' (DbType = Int64), @p15='?' (DbType = DateTime2), @p16='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p0, [DateModified] = @p1 WHERE [Id] = @p2; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p3, [DateModified] = @p4 WHERE [Id] = @p5; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p6, [DateModified] = @p7 WHERE [Id] = @p8; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p9, [DateModified] = @p10 WHERE [Id] = @p11; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p12, [DateModified] = @p13 WHERE [Id] = @p14; SELECT @@ROWCOUNT; UPDATE [SourceAccountManagements] SET [CurrentBalanceLastUpdatedTime] = @p15, [DateModified] = @p16 WHERE [Id] = @p17; SELECT @@ROWCOUNT; 2025-10-30 16:47:01.6149|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [s].[Id], [s].[AccountName], [s].[AccountNumber], [s].[ApprovalStatus], [s].[ApprovalStatusDate], [s].[ApprovedBy], [s].[BankId], [s].[BankName], [s].[Code], [s].[CreatedBy], [s].[Currency], [s].[CurrentBalance], [s].[CurrentBalanceLastUpdatedTime], [s].[DateCreated], [s].[DateModified], [s].[IsActive], [s].[IsDeleted], [s].[ModifiedBy], [s].[OverdraftLimit], [s].[RejectionComment], [s].[UserType], [s].[UserTypeId] FROM [SourceAccountManagements] AS [s] WHERE (([s].[UserTypeId] = @__Id_0) AND ([s].[IsDeleted] = CAST(0 AS bit))) AND ([s].[IsActive] = CAST(1 AS bit)) ORDER BY [s].[DateCreated] DESC 2025-10-30 16:47:01.6149|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:47:01.6292|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:47:01.6292|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:47:01.6292|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:47:01.6292|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:47:01.6435|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:47:01.6435|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:47:01.6435|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:47:01.6435|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:47:01.6435|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:47:01.6587|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [p].[Id], [p].[Code], [p].[Name], [p].[PermissionCategory], [p].[PermissionGroupings], [p].[UserType] FROM [Permissions] AS [p] WHERE [p].[Code] = N'CVAB' 2025-10-30 16:47:01.6587|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__userId_0='?' (DbType = Int64), @__permissionId_Id_1='?' (DbType = Int64), @__accountId_2='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[AccountId], [a].[Accountnumber], [a].[AccountsId], [a].[CreatedBy], [a].[DateCreated], [a].[DateModified], [a].[IsActive], [a].[IsDeleted], [a].[ModifiedBy], [a].[PermissionId], [a].[PermissionName], [a].[UserId], [a].[UserName] FROM [AccountPermissions] AS [a] WHERE (((([a].[UserId] = @__userId_0) AND ([a].[PermissionId] = @__permissionId_Id_1)) AND ([a].[AccountId] = @__accountId_2)) AND ([a].[IsDeleted] = CAST(0 AS bit))) AND ([a].[IsActive] = CAST(1 AS bit)) 2025-10-30 16:47:01.7115|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[SourceAccountManagement.Data.Models.SourceAccountManagementViewModel, AccountManagement.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 2025-10-30 16:47:01.7115|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement) in 6314.5369ms 2025-10-30 16:47:01.7115|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'AccountManagement.Controllers.AccountManagementController.GetAccountByCorporateIdAsync (AccountManagement)' 2025-10-30 16:47:01.7115|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6338.61ms 200 application/json; charset=utf-8 2025-10-30 17:07:34.5775|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:28210/ACCOUNTSERVICES/iisintegration 0 2025-10-30 17:07:34.5775|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 4.4906ms 202