create procedure dbo.%PROC% @sid varchar(30) = null
as
.BEGIN('N')

.CHECK_USER
.CHECK_UPDATE

.GET_PROPS

begin tran
/*
if @pay_perpose = 4011 select @purpose_id = id,@perpose_str = name, @pay_perpose = code from t_purposes where code = 4015
                  else select @purpose_id = id,@perpose_str = name, @pay_perpose = code from t_purposes where code = 4030
*/
select @purpose_id = id,@perpose_str = name, @pay_perpose = code from t_purposes where code = 4030

select @doc_number = @doc_number + ' -Возврат'


if exists(select 1 from t_paydocs,td_depo_docs where t_paydocs.cancel_paymt_id = @id
                                               and t_paydocs.id=td_depo_docs.id
                                               and td_depo_docs.owner_id = @owner_id
                                               and .ITEMS_EXISTS_BY_TYPE_STATE(t_paydocs.id,'SD_PAYBANK_OUT','PERF'))
.EXIT_MESSAGE('Исходящий платеж по возврату для данного платежа уже существует в статусе Проведен')


---.OPERS_ROLL

.TYPE_INIT('SD_PAYBANK_OUT',1)

.TYPE_ASSIGN(doc_date,(.OPERDAY),1)
.TYPE_ASSIGN(doc_number,@doc_number,1)
.TYPE_ASSIGN(from_partner_id,@to_partner_id,1)
.TYPE_ASSIGN(to_partner_id,@from_partner_id,1)
.TYPE_ASSIGN(from_partner_acc_id,@to_partner_acc_id,1)
.TYPE_ASSIGN(to_partner_acc_id,@from_partner_acc_id,1)
.TYPE_ASSIGN(doc_sum,@doc_sum,1)
.TYPE_ASSIGN(cur_id,@cur_id,1)
.TYPE_ASSIGN(tax_nds_rate,@tax_nds_rate,1)
.TYPE_ASSIGN(tax_nds_sum,@tax_nds_sum,1)
.TYPE_ASSIGN(pays_queve,@pays_queve,1)
.TYPE_ASSIGN(date_otgr,@date_otgr,1)
.TYPE_ASSIGN(telegr_acc_str,@telegr_acc_str,1)
.TYPE_ASSIGN(perpose_str,@perpose_str,1)
.TYPE_ASSIGN(covered_sum,@covered_sum,1)
.TYPE_ASSIGN(is_completed,@is_completed,1)
.TYPE_ASSIGN(complete_date,(.OPERDAY),1)
.TYPE_ASSIGN(pay_perpose,@pay_perpose,1)
.TYPE_ASSIGN(pay_type_id,@pay_type_id,1)
.TYPE_ASSIGN(bank_acc_rep_id,@bank_acc_rep_id,1)
.TYPE_ASSIGN(to_partner_name,@from_partner_name,1)
.TYPE_ASSIGN(to_partner_inn,@from_partner_inn,1)
.TYPE_ASSIGN(to_partner_bank_name,@from_partner_bank_name,1)
.TYPE_ASSIGN(to_partner_bank_bic,@from_partner_bank_bic,1)
.TYPE_ASSIGN(from_partner_name,@to_partner_name,1)
.TYPE_ASSIGN(from_partner_inn,@to_partner_inn,1)
.TYPE_ASSIGN(from_partner_bank_name,@to_partner_bank_name,1)
.TYPE_ASSIGN(from_partner_bank_bic,@to_partner_bank_bic,1)
.TYPE_ASSIGN(compose_line_comment,@compose_line_comment,1)
.TYPE_ASSIGN(payment_type,@payment_type,1)
.TYPE_ASSIGN(from_partner_acc_no,@to_partner_acc_no,1)
.TYPE_ASSIGN(from_partner_corr_acc_no,@to_partner_corr_acc_no,1)
.TYPE_ASSIGN(to_partner_corr_acc_no,@from_partner_corr_acc_no,1)
.TYPE_ASSIGN(to_partner_acc_no,@from_partner_acc_no,1)
.TYPE_ASSIGN(sum_str,@sum_str,1)
.TYPE_ASSIGN(foundation_id,@foundation_id,1)
.TYPE_ASSIGN(bank_tran_no,@bank_tran_no,1)
.TYPE_ASSIGN(foundation_no,@foundation_no,1)
.TYPE_ASSIGN(foundation_date,@foundation_date,1)
.TYPE_ASSIGN(purpose_id,@purpose_id,1)
.TYPE_ASSIGN(owner_id,@owner_id,1)
.TYPE_ASSIGN(pif_pay_id,@pif_pay_id,1)
.TYPE_ASSIGN(cancel_paymt_id,@id,1)


.TYPE_INSERT('SD_PAYBANK_OUT','ED',1)


---.EXEC_ACTION(@id1_1,'SD_PAYBANK_OUT','SIG')
---.EXEC_ACTION(@id1_1,'SD_PAYBANK_OUT','OPS')




commit tran

.END