You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 lines
1.6 KiB
19 lines
1.6 KiB
|
|
|
|
|
|
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)
|
|
|