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

.CHECK_USER
.CHECK_UPDATE

begin tran
.UPDATE_STATE
.ACTION_HISTORY
.GET_PROPS

/* продажа ЦБ - входящий платёж */

if @ticket_type_id = 2
begin

if exists (select 1 from t_paydocs,t_items,t_states where foundation_id = @id and t_items.id=t_paydocs.id and
t_states.id=t_items.state_id and t_states.class_id=0)
  .EXIT_MESSAGE('Такой платёж уже существует')

.TYPE_INIT('REAL_PAYMENT_IN',1)

select @type_id1_1=id from t_types where upper(type_code)='REAL_PAYMENT_IN'

--.TYPE_ASSIGN(id, @id1_1, 1)

if @character_id = 1
  begin
  .TYPE_ASSIGN(to_partner_id, @owner_id, 1)
  end
else
  begin
  .TYPE_ASSIGN(to_partner_id, @client_id, 1)
  end

  .TYPE_ASSIGN(from_partner_id, @contragent_id, 1)
  .TYPE_ASSIGN(from_partner_acc_id, null, 1)
  .TYPE_ASSIGN(to_partner_acc_id, @bank_account_id, 1)


.TYPE_ASSIGN(doc_sum, @sum_in_paycur,  1)

/*.TYPE_ASSIGN(cur_id, @payment_cur_id, 1)*/
.TYPE_ASSIGN(cur_id, @pay_cur_id, 1)

-- letsko_av
.TYPE_ASSIGN(character_cur_price, @character_cur_price, 1) -- Нестандартный курс
.TYPE_ASSIGN(cur_price, @cur_price2pay_rate, 1) -- Курс
.TYPE_ASSIGN(cur_price_date, @rate_date, 1) -- Дата курса
.TYPE_ASSIGN(procent_plus, @procent_plus, 1) -- Дополнительный процент

.TYPE_ASSIGN(portfolio_id, @portfolio_id, 1)
.TYPE_ASSIGN(portfolio_sub_id, @portfolio_sub_id, 1)

declare @purp1 numeric(18,0)
select @purp1 = (.GET_PURPOSE_ID(@owner_id,10,@type_id1_1))
.TYPE_ASSIGN(purpose_id, @purp1, 1)

.TYPE_ASSIGN(foundation_id, @id, 1)

declare @added_date1 datetime
select @added_date1 = (DATEADD(dd, -1, @rate_date))
-- letsko_av
--.TYPE_ASSIGN(cur_price_date, @added_date1, 1)

.TYPE_ASSIGN(character_cur_price, @character_cur_price, 1)

if @character_cur_price = 1
  .TYPE_ASSIGN(cur_price, @cur_price2pay_rate, 1)
else
  begin
  declare @curs1 money
  select @curs1 = (.RATE_DATE_TEST(@rate_date, @cur_id))
  .TYPE_ASSIGN(cur_price, @curs1, 1)
  end

.TYPE_ASSIGN(procent_plus, @procent_plus, 1)
.TYPE_ASSIGN(cur_dealing_id, @cur_id, 1)

.TYPE_ASSIGN(sum_cur_dealing, @summ_doc_total2unkd, 1)

.TYPE_ASSIGN(type_exec_id, 1, 1)

--declare @to_direction_id numeric(18, 0)
.TYPE_ASSIGN(to_object_id, @asset_place_id, 1)

.TYPE_ASSIGN(in_date, @plan_pay_date, 1)
/*.TYPE_ASSIGN(in_date, @contract_date, 1)*/



.TYPE_ASSIGN(depo_doc_type, 1, 1)

.BACK_GEN_NO(@in_no1_1, @depo_doc_type, @in_date)

.TYPE_ASSIGN(folder_id, @folder_id, 1)

.TYPE_ASSIGN(owner_id, @owner_id, 1)

.TYPE_ASSIGN(client_contract_id,@client_contract_id)

.TYPE_INSERT('REAL_PAYMENT_IN', 'ED', 1)
end

--.EXEC_ACTION(@id1_1, 'REAL_PAYMENT_IN', 'ACTION_UPDATE_X')
/*-------Проводки ----------*/
commit tran
.END