--Insert into tbBankingDeposit
INSERT INTO [dbo].[tbBankingDeposit]
           ([BankingID]
           ,[TransactionDate]
           ,[BagNo]
           ,[AmountDeposit]
           ,[Collected]
           ,[AmountCollected]
           ,[Variance]
           ,[HOConfirmedByUserID]
           ,[DateAuthorised]
           ,[Lost]
           ,[ReceiptNo]
           ,[ExcludeFromBanking]
           ,[WitnessUserID]
           ,[HOWitnessedByUserID]
           ,[DepositManagerID]
           ,[DepositWitnessID]
           ,[DepositNo]
           ,[DepositWitnessName]
           ,[Dispatched]
           ,[DispatchLost]
           ,[AlternateBagNo]
           ,[AutoBillAmount]
           ,[ManualCashAmount]
           ,[ManualCheckAmount]
           ,[Comment]
           ,[AccountsLinkID]
           ,[AchAmount])
     VALUES
           (7961
           ,'2012-05-15 15:03:07.610'
           ,''
           ,<210,00
           ,0
           ,NULL
           ,NULL
           ,NULL
           ,NULL
           ,0
           ,NULL
           ,0
           ,NULL
           ,NULL
           ,57861
           ,NULL
           ,NULL
           ,''
           ,1
           ,0
           ,NULL
           ,0
           ,0
           ,0
           ,NULL
           ,NULL
           ,NULL)
GO

--UPDATE the tbBankingDeposit
--SEELECT * FROM tbBankingDeposit WHERE [TransactionDate] = 
UPDATE tbBankingDeposit
SET AchAmount = 10,
	ManualCheckAmount = 11,
	ManualCashAmount = 12,
	AutoBillAmount = 13,
	Completed = 1
WHERE [BankingDepositID] = ???


DELETE from tbBankingDeposit
WHERE [BankingDepositID] = ???

