Vault- sp_changefunddeposited Negative Field $Value and Field name needs to be updated

Environment: Testing 

Store: 02693 - George Washington FSU

Date: January 31, 2023

While testing Ticket CFAMX-24156 2023.R2 Sprint 3 Testing CLONE - Stored Procedure for Remaining Change Fund Data.

for sp_changefunddeposited.

1- it was noticed that the Deposit amount is negative value '-' so for example while the deposit value in the UI is 50 , it is -50 in RDS Test DB .

2- the field name used in RDS Test is "Amount Received" where it needs to be "Amount Deposited"

Notes:

Inform DB

SELECT StoreTimestamp, Amount, ManagerID, * FROm tbFloatMovementSELECT StoreTimestamp, Amount, ManagerID, * FROm tbFloatMovementWHERe EntityID=1810 AND floatmovementdate='2023-01-31' AND FloatMovementTypeID=4 --4 = Deposited and 5=received.

RDS Test DB
begin;

call sp_changefunddeposited(1810, '2023-01-31 00:00:00.000', 'testtable');

select * from testtable;

commit;