|
|
EXEC PROC_REMIT_INBOUND_TRANSACTION_VALIDATE @Flag = 'VALIDATE', @UserName= 'ajey', @AgentId = '394390', @SendingCountryCode = 'JP', @PayoutCountryCode = 'NP', @PayoutTypeCode = 'CP' , @PayoutBankCode = null, @PayoutBankBranchCode = null, @PayoutCurrencyCode = 'NPR', @SendingCurrencyCode = 'JPY', @CollectionAmount = '500000', @TransferAmount = '498500.00' , @PayoutAmount = '438580.00', @ServiceCharge = '1500', @ExchangeRate = '00.8798', @RemittancePurpose = '1290', @SourceOfFund = '1120', @Relationship = '1239', @Occupation = '19182' , @PartnerTransactionId = '1231231243423432', @CalcBy = 'C', @SenderFirstName = 'ARJUN', @SenderMiddleName = 'SINGH', @SenderLastName = 'DHAMI', @SenderIdType = '120', @SenderIdNo = '93281432' , @SenderIdIssued = '2022-01-01', @SenderIdValid = '2030-01-01', @SenderMobile = '981281928', @SenderNativeCountryCode = 'NP', @SenderCity = 'TOKYO', @SenderAddress = 'TOKYO-32, JAPAN' , @SenderEmail = 'ARJUNDHAMI554@GMAIL.COM', @SenderGender = 'M', @ReceiverFirstName = 'ARJUN', @ReceiverMiddleName = 'SINGH', @ReceiverLastName = 'DHAMI', @ReceiverIdType = '102' , @ReceiverIdNo = '19281982', @ReceiverIdIssued = '2022-01-01', @ReceiverIdValid = '2030-01-01', @ReceiverMobile = '9819281928', @ReceiverCity = 'KATHMANDU', @ReceiverAddress = 'KOTESHWOR-32, KATHMANDU, NEPAL' , @ReceiverEmail = 'ARJUNDHAMI554@GMAIL.COM', @ReceiverAccountNo = '02138921839'
SELECT SendingAgentCommission = amount, sAgentCommCurrency = commissionCurrency FROM dbo.FNAGetSendComm( 113, 393877, 394390, NULL, 151, 394397, 394398, NULL, 'JPY', 1, 500000.00, 438580.00, 1500.00, NULL, NULL, 1, 0.8798)
|