# Date: 07/03/06
# Version: 105

$DOC(SR_REPORT_TIME_BUY)
 name=Отчет о времени владения по заявкам на погашение
 class=6
 product=ALD_SREG
 name_formula='Справка о времени владения паями фонда владельцами паев, подавшими заявки на погашение №'+@in_no+' от ' + convert(varchar,@in_date,104)
 remark_formula=.ITEM_REMARK(@foundation_id)

 $STATE(CREATE)
  name=Создан
  class=0
 $ENDSTATE

 $STATE(DELETE)
  name=Удален
  class=2
 $ENDSTATE

 $STATE(NEW)
  name=Начальный
  class=1
 $ENDSTATE

 $STATE(READY)
  name=В архиве
  class=0
 $ENDSTATE

 $PROP(OUT_DATE)
  name=Внешняя дата корреспондента
  field_name=out_date
  table_name=td_depo_docs
  field_type=datetime
  field_length=8
  field_scale=3
  field_prec=23
  page=1
  order=1
  init_class=null
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(IN_DATE)
  name=Дата документа
  field_name=in_date
  table_name=td_depo_docs
  field_type=datetime
  field_length=8
  field_scale=3
  field_prec=23
  page=1
  order=2
  init_class=1
  init_formula=.OPERDAY
  unique_index=1
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(WHO_GET)
  name=Кто принял
  field_name=who_get
  table_name=td_depo_docs
  field_type=varchar
  field_length=100
  field_scale=null
  field_prec=100
  page=1
  order=3
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(WHO_PUT)
  name=Кто отправил
  field_name=who_put
  table_name=td_depo_docs
  field_type=varchar
  field_length=100
  field_scale=null
  field_prec=100
  page=1
  order=4
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(OUT_NO)
  name=Внешний номер
  field_name=out_no
  table_name=td_depo_docs
  field_type=varchar
  field_length=50
  field_scale=null
  field_prec=50
  page=1
  order=5
  init_class=null
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(IN_NO)
  name=Номер документа
  field_name=in_no
  table_name=td_depo_docs
  field_type=varchar
  field_length=50
  field_scale=null
  field_prec=50
  page=1
  order=6
  init_class=0
  init_formula=null
  unique_index=1
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(CORRESPONDENT_ID)
  name=Корреспондент
  field_name=correspondent_id
  table_name=td_depo_docs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=7
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(PAYER_ID)
  name=Плательщик
  field_name=payer_id
  table_name=td_depo_docs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=8
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(PAY_SUM)
  name=Сумма
  field_name=pay_sum
  table_name=td_depo_docs
  field_type=money
  field_length=8
  field_scale=4
  field_prec=19
  page=1
  order=9
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(INITIATOR_ID)
  name=Инициатор
  field_name=initiator_id
  table_name=td_depo_docs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=10
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(DOCUMENT_FORM_ID)
  name=Форма документа
  field_name=document_form_id
  table_name=td_depo_docs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=11
  init_class=0
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(DEPO_DOC_TYPE)
  name=Входящий исходящий или внутр
  field_name=depo_doc_type
  table_name=td_depo_docs
  field_type=int
  field_length=4
  field_scale=0
  field_prec=10
  page=1
  order=12
  init_class=1
  init_formula=2
  unique_index=1
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(FOLDER_ID)
  name=Депозитарная папка
  field_name=folder_id
  table_name=td_depo_docs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=13
  init_class=2
  init_formula=.DEPO_FOLDER_DEFAULT
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(SUM_CUR_ID)
  name=Валюта суммы
  field_name=sum_cur_id
  table_name=td_depo_docs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=14
  init_class=1
  init_formula=.CUR("RUR")
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(DOC_COMMENT)
  name=Комментарий
  field_name=doc_comment
  table_name=td_depo_docs
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=255
  page=1
  order=15
  init_class=null
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(FOUNDATION_ID)
  name=Документ основание
  field_name=foundation_id
  table_name=td_depo_docs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=16
  init_class=null
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(OWNER_ID)
  name=Фонд
  field_name=owner_id
  table_name=td_depo_docs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=17
  init_class=1
  init_formula=.ORGANIZATION_PIF
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(CLAIM_ID)
  name=Заявка
  field_name=claim_id
  table_name=tr_report_time_buy
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=-1
  order=18
  init_class=null
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(ALLOC_DATE)
  name=Дата приобретения паев
  field_name=alloc_date
  table_name=tr_report_time_buy
  field_type=datetime
  field_length=8
  field_scale=3
  field_prec=23
  page=-1
  order=19
  init_class=null
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(DAYS_QTY)
  name=Срок владения
  field_name=days_qty
  table_name=tr_report_time_buy
  field_type=int
  field_length=4
  field_scale=0
  field_prec=10
  page=-1
  order=20
  init_class=null
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(AGENT_PROC)
  name=Размер скидки
  field_name=agent_proc
  table_name=tr_report_time_buy
  field_type=money
  field_length=8
  field_scale=4
  field_prec=19
  page=-1
  order=21
  init_class=null
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(PART_ID)
  name=Партия
  field_name=part_id
  table_name=tr_report_time_buy
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=-1
  order=22
  init_class=null
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(REP_ID)
  name=Отчет регистратора
  field_name=rep_id
  table_name=tr_report_time_buy
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=-1
  order=23
  init_class=null
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(PAY_PART_QTY)
  name=Кол-во паев
  field_name=pay_part_qty
  table_name=tr_report_time_buy
  field_type=decimal
  field_length=9
  field_scale=8
  field_prec=18
  page=-1
  order=24
  init_class=null
  init_formula=null
  unique_index=null
  numerator=null
  import_type=null
  import_table=null
  import_field=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $RELATION(REL1)
  class=0
  type=CUR
  form=null
  prop=SUM_CUR_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL7)
  class=0
  type=D_DEPO_FOLDERS
  form=null
  prop=FOLDER_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL3)
  class=0
  type=PARTNERS
  form=null
  prop=CORRESPONDENT_ID
  idname=null
  order=1
 $ENDRELATION

 $RELATION(REL5)
  class=0
  type=PARTNERS
  form=null
  prop=PAYER_ID
  idname=null
  order=2
 $ENDRELATION

 $RELATION(REL4)
  class=0
  type=PARTNERS
  form=null
  prop=INITIATOR_ID
  idname=null
  order=3
 $ENDRELATION

 $RELATION(REL6)
  class=0
  type=PARTNERS
  form=null
  prop=OWNER_ID
  idname=null
  order=5
 $ENDRELATION

 $RELATION(REL9)
  class=0
  type=ITEMS
  form=null
  prop=FOUNDATION_ID
  idname=null
  order=4
 $ENDRELATION

 $RELATION(REL2)
  class=1
  type=ACTIONS_HISTORY
  form=UO_ACTIONS_HISTORY_LIST
  prop=null
  idname=null
  order=999
 $ENDRELATION

 $RELATION(REL8)
  class=1
  type=ACTIVDOCS
  form=ACTION2
  prop=null
  idname=null
  order=1000
 $ENDRELATION

 $FORM(D_REPORT_TIME_BUY)
  name=Просмотр отчета
  class=5
  filter=null
  target_state=
  uo=uo_print
  dw=d_sr_report_time_buy
  procedure=ap_10000000000090602
  patterns=GENERIC_VIEW_ITEM
  user_define=1
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(15470862)
create procedure dbo.%PROC%
  @sid varchar(30) = null
as
declare
        @id numeric,
        @action_id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @type_id_s varchar(30),
        @new_state_id numeric,
        @state_name_id_s varchar(30)

begin
declare  @sd_name varchar(255)  -- ФИО уполномоченного лица СД
  select @id = convert(numeric, @sid)
  select @action_id = %ACTION_ID%
 select @type_id_s = NULL
select  @state_name_id_s = NULL

.NAME_VAR(@zagolovok1_1)
.NAME_VAR(@zagolovok1_2)
.NAME_VAR(@zagolovok2_1)
.NAME_VAR(@zagolovok2_2)
.NAME_VAR(@user_name)
.ID_VAR(@uk_id)
.ID_VAR(@fund_id)
.ID_VAR(@reg_id)

.GET_PROPS

select @reg_id=.SREG_ID
select @fund_id=owner_id from td_depo_docs where id=@foundation_id
select @uk_id=.GET_CTRL_COMP_ID(@fund_id)
select @zagolovok1_1='о времени владения паями фонда владельцами инвестиционных паев, подавшими заявки на погашение от '+convert(varchar,@in_date,104)+' г.'
select @zagolovok1_2=partner_name from t_partners where id=@reg_id
select @zagolovok2_1=partner_name from t_partners where id=@fund_id
select @zagolovok2_2=partner_name from t_partners where id=@uk_id

select @user_name=user_name from t_users where login_name=.SUSER_NAME

select @sd_name=t_item2class.code
  from t_item2class, t_classes, t_classvalues, tb_contracts, td_depo_docs
 where upper(t_classes.code) = 'AUTHORIZED_PERSON'
   and t_classes.id = t_classvalues.class_id
   and upper(t_classvalues.code) = 'SD_AUTHORIZED_PERSON'
   and t_item2class.value_id = t_classvalues.id
   and t_item2class.item_id = tb_contracts.id
   and td_depo_docs.owner_id = @fund_id
   and td_depo_docs.id = tb_contracts.id
   and tb_contracts.dog_type_id = 4 -- договор со спецдепом (5010)
   and .ITEMS_EXISTS_BY_TYPE(td_depo_docs.id,'FUND_CONTRACTS')
   and @in_date between tb_contracts.dogexec_begin_date and isnull(tb_contracts.dogexec_end_date,dateadd(dd,1,@in_date))


if isnull(@sd_name,'') = ''
  select @sd_name=max(t_partners_jur.j_head_last_name)
    from t_partners_jur, tb_contracts, td_depo_docs
   where td_depo_docs.owner_id = @fund_id
     and td_depo_docs.id = tb_contracts.id
     and tb_contracts.dog_type_id = 4 -- договор со спецдепом (5010)
     and tb_contracts.client_id = t_partners_jur.id
     and .ITEMS_EXISTS_BY_TYPE(td_depo_docs.id,'FUND_CONTRACTS')
     and @in_date between tb_contracts.dogexec_begin_date and isnull(tb_contracts.dogexec_end_date,dateadd(dd,1,@in_date))


select
  @sid as sid,
  @zagolovok1_1 as zagolovok1_1,
  @zagolovok1_2 as zagolovok1_2,
  @zagolovok2_1 as zagolovok2_1,
  @zagolovok2_2 as zagolovok2_2,
  @user_name as user_name,
  @sd_name as sd_name


end
  $ENDTEXT(15470862)
 $ENDFORM

 $FORM(D_REPORT_TIME_BUY_DET)
  name=Перечень отчета
  class=5
  filter=null
  target_state=
  uo=null
  dw=d_sr_report_time_buy_det
  procedure=ap_report_time_buy_det
  patterns=GENERIC_VIEW_ITEM
  user_define=1
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(15470863)
create procedure dbo.%PROC%
  @sid varchar(30) = null
as
declare
        @id numeric,
        @action_id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @type_id_s varchar(30),
        @new_state_id numeric,
        @state_name_id_s varchar(30)

begin

  select @id = convert(numeric, @sid)
  select @action_id = %ACTION_ID%
 select @type_id_s = NULL
select  @state_name_id_s = NULL

.CHECK_USER
.CHECK_VIEW_ITEM

.ID_VAR(@foundation_id)
.MONEY_VAR(@tax_nds)
declare @rep_date datetime

select @tax_nds=20
select @foundation_id=foundation_id from td_depo_docs where id=@id
select @rep_date=convert(datetime,convert(varchar,in_date,3),3) from td_depo_docs where id=@id


/*
select
 @sid as sid,
 p.partner_name as payer_name,

 (select a.depo_acc_number from td_depo_accounts a, td_depo_subacc sa
                          where sa.id=pq.subacc_id and sa.depo_acc_id=a.id) as acc_no,
 pq.agent_regs_no as claim_no,
 @rep_date as claim_date,
 ec.share_qty as pays_qty,
    -- convert(decimal(18,4),ec.agent_proc) as agent_proc,
    -- datediff(dd,isnull(ec.alloc_date,@rep_date),@rep_date) as days_qty,
    -- ec.alloc_date as alloc_date
 tr_report_time_buy.alloc_date as alloc_date,
 tr_report_time_buy.days_qty as days_qty,
 tr_report_time_buy.agent_proc as procent,
 tr_report_time_buy.pay_part_qty as pays_part_qty

from tp_extract2claim ec,
     tp_pif_queries pq,
     t_partners p,
     t_partners_fis pf,
     tr_report_time_buy
where
  ec.extract_id=@foundation_id
  and tr_report_time_buy.claim_id=ec.claim_id
  and ec.claim_id=pq.id
  and .ITEMS_EXISTS_BY_TYPE(pq.id,'PIF_PAY_BUY')
  and ec.pay_partner_id*=p.id
  and ec.pay_partner_id*=pf.id
order by claim_no
*/


declare rep_cur cursor for
select
 p.partner_name as payer_name,

 (select a.depo_acc_number from td_depo_accounts a, td_depo_subacc sa
                          where sa.id=pq.subacc_id and sa.depo_acc_id=a.id) as acc_no,
 pq.agent_regs_no as claim_no,
 @rep_date as claim_date,
 ec.share_qty as pays_qty,
 tr_report_time_buy.alloc_date as alloc_date,
 tr_report_time_buy.days_qty as days_qty,
 tr_report_time_buy.agent_proc as procent,
 tr_report_time_buy.pay_part_qty as pays_part_qty

from tp_extract2claim ec,
     tp_pif_queries pq,
     t_partners p,
     t_partners_fis pf,
     tr_report_time_buy
where
  ec.extract_id=@foundation_id
  and tr_report_time_buy.claim_id=ec.claim_id
  and ec.claim_id=pq.id
  and .ITEMS_EXISTS_BY_TYPE(pq.id,'PIF_PAY_BUY')
  and ec.pay_partner_id*=p.id
  and ec.pay_partner_id*=pf.id
order by claim_no

open rep_cur

declare @partner_name  varchar(255),
        @acc_no        varchar(255),
        @claim_no      varchar(150),
        @claim_no_old  varchar(150),
        @claim_date    datetime,
        @pays_qty      decimal(18,8),
        @alloc_date    datetime,
        @days_qty      int,
        @procent       money,
        @pays_part_qty decimal(18,8),
        @row           int

create table #rep (
  row           int           null,
  partner_name  varchar(255)  null,
  acc_no        varchar(255)  null,
  claim_no      varchar(150)  null,
  claim_date    datetime      null,
  pays_qty      decimal(18,8) null,
  alloc_date    datetime      null,
  days_qty      int           null,
  procent       money         null,
  pays_part_qty decimal(18,8) null
)

fetch rep_cur into @partner_name, @acc_no, @claim_no, @claim_date, @pays_qty, @alloc_date, @days_qty, @procent, @pays_part_qty

select @row = 0
select @claim_no_old=''

-- Нумеруем строки отчета
while .CURSOR_STATE = 0
begin

  if @claim_no <> @claim_no_old
    select @row=@row+1

  insert into #rep (row, partner_name, acc_no, claim_no, claim_date, pays_qty, alloc_date, days_qty, procent, pays_part_qty)
  values (@row, @partner_name, @acc_no, @claim_no, @claim_date, @pays_qty, @alloc_date, @days_qty, @procent, @pays_part_qty)

  select @claim_no_old=@claim_no

  fetch rep_cur into @partner_name, @acc_no, @claim_no, @claim_date, @pays_qty, @alloc_date, @days_qty, @procent, @pays_part_qty

end

close rep_cur
.DEALLOCATE rep_cur

select @sid, #rep.*
  from #rep

drop table #rep
end
  $ENDTEXT(15470863)
 $ENDFORM

 $FORM(FORM1)
  name=Просмотр
  class=5
  filter=null
  target_state=
  uo=uo_edit
  dw=d_sr_reports_p1
  procedure=ap_10000000000090533
  patterns=GENERIC_VIEW_ITEM
  user_define=0
  isvisible=0
  istab=1
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(15470863)
create procedure dbo.%PROC%
  @sid varchar(30) = null
as
declare
        @id numeric,
        @action_id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @type_id_s varchar(30),
        @new_state_id numeric,
        @state_name_id_s varchar(30)

begin

  select @id = convert(numeric, @sid)
  select @action_id = %ACTION_ID%
 select @type_id_s = NULL
select  @state_name_id_s = NULL

.CHECK_USER
.CHECK_VIEW_ITEM


if @id = -1
begin
begin tran
.GET_PROPS
.CHECK_INSERT
.INIT_VARS(B)
.INSERT_ITEMS
.INSERT
commit tran
end
.VIEW_ITEM
/*
.ACTION_HISTORY
*/
end
  $ENDTEXT(15470863)

  $ACTION2RELATION(REL4.PARTNER_CODE)
   relation=REL4
   where=null
   prop=PARTNER_CODE
   order=null
   alias=initiator_code
  $ENDACTION2RELATION

  $ACTION2RELATION(REL4.PARTNER_SHORT_NAME)
   relation=REL4
   where=null
   prop=PARTNER_SHORT_NAME
   order=null
   alias=initiator_short_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL3.PARTNER_CODE)
   relation=REL3
   where=null
   prop=PARTNER_CODE
   order=null
   alias=corr_code
  $ENDACTION2RELATION

  $ACTION2RELATION(REL3.PARTNER_SHORT_NAME)
   relation=REL3
   where=null
   prop=PARTNER_SHORT_NAME
   order=null
   alias=corr_short_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL5.PARTNER_CODE)
   relation=REL5
   where=null
   prop=PARTNER_CODE
   order=null
   alias=payer_code
  $ENDACTION2RELATION

  $ACTION2RELATION(REL5.PARTNER_SHORT_NAME)
   relation=REL5
   where=null
   prop=PARTNER_SHORT_NAME
   order=null
   alias=payer_short_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL9.ITEM_NAME)
   relation=REL9
   where=null
   prop=ITEM_NAME
   order=null
   alias=foundation_doc_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL6.PARTNER_SHORT_NAME)
   relation=REL6
   where=null
   prop=PARTNER_SHORT_NAME
   order=10
   alias=owner_short_name
  $ENDACTION2RELATION

  $BIND(BIND1)
   type=SR_REPORT_TIME_BUY
   action=D_REPORT_TIME_BUY
   class=1
   order=null
   idname=null
  $ENDBIND
 $ENDFORM

 $ACTION(ACTION1)
  name=Добавить
  class=1
  form=FORM1
  target_state=CREATE
  procedure=ap_10000000000090606
  patterns=GENERIC_INSERT
  user_define=0
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(15470863)
create procedure dbo.%PROC% @sid varchar(30) = null,
.ARGLIST
as
declare @action_id numeric,
        @id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @item_name varchar(100),
        @new_state_id numeric
begin
begin tran

  select @action_id = %ACTION_ID%
   select @id = convert(numeric, @sid)

.CHECK_USER
.CHECK_UPDATE

.ARGCONVERT

.INIT_VARS

.DEPO_GEN_NO(@in_no,@depo_doc_type)

.UPDATE_ITEMS

.UPDATE

.RELGEN
.UPDATE_STATE
.ACTION_HISTORY

commit tran
select sid = convert(varchar, @id)
end
  $ENDTEXT(15470863)
 $ENDACTION

 $ACTION(ACTION2)
  name=Изменить
  class=2
  form=FORM1
  target_state=null
  procedure=ap_10000000000090607
  patterns=GENERIC_UPDATE
  user_define=0
  isvisible=0
  istab=1
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(15470863)
create procedure dbo.%PROC% @sid varchar(30) = null,
.ARGLIST
as
declare @action_id numeric,
        @id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @item_name varchar(100),
        @new_state_id numeric
begin tran

  select @action_id = %ACTION_ID%
   select @id = convert(numeric, @sid)

.CHECK_USER
.CHECK_UPDATE

.ARGCONVERT

.DEPO_CHK_NO(@id,@in_no,@depo_doc_type)

.UPDATE_ITEMS

.UPDATE

.RELGEN
.UPDATE_STATE
.ACTION_HISTORY

commit tran
  $ENDTEXT(15470863)
 $ENDACTION

 $ACTION(ACTION3)
  name=Удалить
  class=9
  form=null
  target_state=DELETE
  procedure=ap_10000000000090608
  patterns=GENERIC_MOVE
  user_define=0
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(15470863)
create procedure dbo.%PROC% @sid varchar(30) = null
as
declare @action_id numeric,
        @id numeric,
        @user_id numeric,
        @state_id numeric,
        @new_state_id numeric,
        @type_id numeric
begin tran

  select @action_id = %ACTION_ID%
   select @id = convert(numeric, @sid)

.CHECK_USER
.CHECK_UPDATE

.UPDATE_STATE
.ACTION_HISTORY

/*-------Проводки ----------*/


commit tran
  $ENDTEXT(15470863)
 $ENDACTION

 $STATE2ACTION(CREATE.ACTION2)
  state=CREATE
  action=ACTION2
 $ENDSTATE2ACTION

 $STATE2ACTION(CREATE.ACTION3)
  state=CREATE
  action=ACTION3
 $ENDSTATE2ACTION

 $STATE2ACTION(CREATE.D_REPORT_TIME_BUY)
  state=CREATE
  action=D_REPORT_TIME_BUY
 $ENDSTATE2ACTION

 $STATE2ACTION(CREATE.D_REPORT_TIME_BUY_DET)
  state=CREATE
  action=D_REPORT_TIME_BUY_DET
 $ENDSTATE2ACTION

 $STATE2ACTION(CREATE.FORM1)
  state=CREATE
  action=FORM1
 $ENDSTATE2ACTION

 $STATE2ACTION(READY.ACTION3)
  state=READY
  action=ACTION3
 $ENDSTATE2ACTION

 $STATE2ACTION(READY.D_REPORT_TIME_BUY)
  state=READY
  action=D_REPORT_TIME_BUY
 $ENDSTATE2ACTION

 $STATE2ACTION(READY.D_REPORT_TIME_BUY_DET)
  state=READY
  action=D_REPORT_TIME_BUY_DET
 $ENDSTATE2ACTION

 $STATE2ACTION(READY.FORM1)
  state=READY
  action=FORM1
 $ENDSTATE2ACTION

 $STATE2PROP(CREATE.CORRESPONDENT_ID)
  state=CREATE
  prop=CORRESPONDENT_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.DOCUMENT_FORM_ID)
  state=CREATE
  prop=DOCUMENT_FORM_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.DOC_COMMENT)
  state=CREATE
  prop=DOC_COMMENT
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.FOLDER_ID)
  state=CREATE
  prop=FOLDER_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.INITIATOR_ID)
  state=CREATE
  prop=INITIATOR_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.IN_DATE)
  state=CREATE
  prop=IN_DATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.IN_NO)
  state=CREATE
  prop=IN_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.OUT_DATE)
  state=CREATE
  prop=OUT_DATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.OUT_NO)
  state=CREATE
  prop=OUT_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.PAYER_ID)
  state=CREATE
  prop=PAYER_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.PAY_SUM)
  state=CREATE
  prop=PAY_SUM
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.SUM_CUR_ID)
  state=CREATE
  prop=SUM_CUR_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.WHO_GET)
  state=CREATE
  prop=WHO_GET
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(CREATE.WHO_PUT)
  state=CREATE
  prop=WHO_PUT
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.CORRESPONDENT_ID)
  state=NEW
  prop=CORRESPONDENT_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.DOCUMENT_FORM_ID)
  state=NEW
  prop=DOCUMENT_FORM_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.DOC_COMMENT)
  state=NEW
  prop=DOC_COMMENT
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.FOLDER_ID)
  state=NEW
  prop=FOLDER_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.FOUNDATION_ID)
  state=NEW
  prop=FOUNDATION_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.INITIATOR_ID)
  state=NEW
  prop=INITIATOR_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.IN_DATE)
  state=NEW
  prop=IN_DATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.IN_NO)
  state=NEW
  prop=IN_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.OUT_DATE)
  state=NEW
  prop=OUT_DATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.OUT_NO)
  state=NEW
  prop=OUT_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.PAYER_ID)
  state=NEW
  prop=PAYER_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.PAY_SUM)
  state=NEW
  prop=PAY_SUM
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.SUM_CUR_ID)
  state=NEW
  prop=SUM_CUR_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.WHO_GET)
  state=NEW
  prop=WHO_GET
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NEW.WHO_PUT)
  state=NEW
  prop=WHO_PUT
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(READY.DOC_COMMENT)
  state=READY
  prop=DOC_COMMENT
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP
$ENDDOC