# Date: 21/11/05
# Version: 105

$DOC(REAL_PAYMENT_GR)
 name=Платежи
 class=5
 product=ALD_SECUR
 name_formula=null
 remark_formula=null

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

 $PROP(FROM_PARTNER_ID)
  name=Отправитель
  field_name=from_partner_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=1
  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(TO_PARTNER_ID)
  name=Получатель
  field_name=to_partner_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=2
  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(FROM_PARTNER_ACC_ID)
  name=Cчет отправителя
  field_name=from_partner_acc_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=3
  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(TO_PARTNER_ACC_ID)
  name=Cчет получателя
  field_name=to_partner_acc_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  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(DOC_SUM)
  name=Сумма в валюте
  field_name=doc_sum
  table_name=t_paydocs
  field_type=money
  field_length=8
  field_scale=4
  field_prec=19
  page=1
  order=5
  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(CUR_ID)
  name=Валюта суммы
  field_name=cur_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=6
  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(PERPOSE_STR)
  name=Комментарий
  field_name=perpose_str
  table_name=t_paydocs
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=255
  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(COMPLETE_DATE)
  name=Дата исполнения
  field_name=complete_date
  table_name=t_paydocs
  field_type=datetime
  field_length=8
  field_scale=3
  field_prec=23
  page=1
  order=8
  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=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=13
  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(PORTFOLIO_ID)
  name=Портфель
  field_name=portfolio_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=9
  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(PORTFOLIO_SUB_ID)
  name=Раздел учета
  field_name=portfolio_sub_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=10
  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(PURPOSE_ID)
  name=Целевое назначение
  field_name=purpose_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=11
  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(TYPE_PAYER_ID)
  name=Тип платежа
  field_name=type_payer_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=14
  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(TYPE_EXEC_ID)
  name=Тип исполнения
  field_name=type_exec_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  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(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=16
  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(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=17
  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_GET)
  name=Не задан
  field_name=who_get
  table_name=td_depo_docs
  field_type=varchar
  field_length=100
  field_scale=null
  field_prec=100
  page=2
  order=18
  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=2
  order=19
  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=20
  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(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=21
  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(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=2
  order=22
  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=2
  order=23
  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=2
  order=24
  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=2
  order=25
  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=2
  order=26
  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(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=2
  order=27
  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(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=2
  order=28
  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(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=2
  order=29
  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(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=2
  order=30
  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(FOUNDATION_REMARK)
  name=Не задан
  field_name=foundation_remark
  table_name=td_depo_docs
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=255
  page=2
  order=31
  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(OWNER_ID)
  name=ID организации
  field_name=owner_id
  table_name=td_depo_docs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=12
  init_class=1
  init_formula=.ORGANIZATION
  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_STATE_ID)
  name=Не задан
  field_name=foundation_state_id
  table_name=td_depo_docs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=2
  order=32
  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(PERPOSE_ID)
  name=Не задан
  field_name=perpose_id
  table_name=td_depo_docs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=2
  order=33
  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

 $RELATION(REL7)
  class=1
  type=T_OPERATIONS
  form=ITEM_OPERS_LIST
  prop=null
  idname=item_id_s
  order=999
 $ENDRELATION

 $RELATION(REL2)
  class=0
  type=CUR
  form=null
  prop=CUR_ID
  idname=null
  order=null
 $ENDRELATION

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

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

 $RELATION(REL5)
  class=0
  type=BANK_ACCOUNTS
  form=null
  prop=FROM_PARTNER_ACC_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL6)
  class=0
  type=BANK_ACCOUNTS
  form=null
  prop=TO_PARTNER_ACC_ID
  idname=null
  order=null
 $ENDRELATION

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

 $RELATION(REL11)
  class=0
  type=PORTFOLIO_SECTION
  form=null
  prop=PORTFOLIO_SUB_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL9)
  class=0
  type=TARGET_PURPOSES
  form=null
  prop=PURPOSE_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL10)
  class=0
  type=PORTFOLIO
  form=null
  prop=PORTFOLIO_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL15)
  class=5
  type=SETOFF_FOR_DEALINGS
  form=FORM4
  prop=null
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL14)
  class=5
  type=REAL_PAYMENT_OUT
  form=FORM_VIEW1
  prop=null
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL13)
  class=5
  type=REAL_PAYMENT_IN
  form=FORM_VIEW
  prop=null
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL1)
  class=5
  type=MONEY_MOVE_COMMISSION_2
  form=D_BROKOPER_P1
  prop=null
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL12)
  class=5
  type=MONEY_MOVE2INVESTORS
  form=FORM_VIEW
  prop=null
  idname=null
  order=null
 $ENDRELATION

 $FORM(D_REAL_PAYMENT_FILTER)
  name=Фильтр
  class=6
  filter=null
  target_state=
  uo=uo_filter
  dw=d_real_payment_filter
  procedure=ap_d_real_payment_filter
  patterns=GENERIC_VIEW_LIST
  user_define=1
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=2103
  height=1808
  proc_text=$TEXT(15010941)
create procedure dbo.%PROC%
as

declare @owner_id numeric

select @owner_id=.ORGANIZATION

select
null,
null,
null,
null,
null,
null,
convert(datetime,null) as in_date_db,
convert(datetime,null) as in_date_de,
convert(datetime,null) as out_date_db,
convert(datetime,null) as out_date_de,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
convert(varchar,@owner_id) as owner_id_s,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
(select partner_code from t_partners where id=@owner_id),
(select partner_short_name from t_partners where id=@owner_id),
null
  $ENDTEXT(15010941)

  $FILTER(TO_PARTNER_ACC_ID)
   type=1
   label=  Cчет получателя
   prop=TO_PARTNER_ACC_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(CUR_ID)
   type=1
   label= Валюта суммы
   prop=CUR_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(PORTFOLIO_SUB_ID)
   type=1
   label=  Раздел учета
   prop=PORTFOLIO_SUB_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(FOUNDATION_ID)
   type=1
   label=FOUNDATION_ID
   prop=FOUNDATION_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(IN_DATE)
   type=2
   label=  Дата документа
   prop=IN_DATE
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(PURPOSE_ID)
   type=1
   label= Целевое назначение
   prop=PURPOSE_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(TYPE_EXEC_ID)
   type=1
   label=Тип исполнения
   prop=TYPE_EXEC_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(OWNER_ID)
   type=1
   label=OWNER_ID
   prop=OWNER_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(IN_NO)
   type=3
   label=Номер
   prop=IN_NO
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(TO_PARTNER_ID)
   type=1
   label= Получатель
   prop=TO_PARTNER_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(DOC_SUM)
   type=1
   label= Сумма в валюте
   prop=DOC_SUM
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(PORTFOLIO_ID)
   type=1
   label= Портфель
   prop=PORTFOLIO_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(FROM_PARTNER_ID)
   type=1
   label=Отправитель
   prop=FROM_PARTNER_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(FROM_PARTNER_ACC_ID)
   type=1
   label=Cчет отправителя
   prop=FROM_PARTNER_ACC_ID
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(PERPOSE_STR)
   type=3
   label= Комментарий
   prop=PERPOSE_STR
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(OUT_NO)
   type=1
   label=OUT_NO
   prop=OUT_NO
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER

  $FILTER(OUT_DATE)
   type=2
   label=OUT_DATE
   prop=OUT_DATE
   arg_code=null
   arg_type=null
   arg_length=null
   arg_prec=null
   arg_scale=null
  $ENDFILTER
 $ENDFORM

 $FORM(D_REAL_PAYMENT_LIST)
  name=Список
  class=4
  filter=D_REAL_PAYMENT_FILTER
  target_state=
  uo=uo_list
  dw=d_real_payment_list
  procedure=ap_10000000000036893
  patterns=GENERIC_VIEW_LIST_P1
  user_define=1
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=5376
  height=3184
  proc_text=$TEXT(15010941)
create procedure dbo.%PROC%
  @sid varchar(30) = null .ARGLIST_FILTER
as
.BEGIN('N')

.CHECK_USER
.CHECK_VIEW_LIST

.ARGCONVERT_FILTER

---.EXIT_MESSAGE('!!')
.VIEW_LIST(ALL,1)
order by in_date,in_no
.END
  $ENDTEXT(15010941)

  $ACTION2RELATION(REL2.CUR_CODE)
   relation=REL2
   where=null
   prop=CUR_CODE
   order=null
   alias=cur_code
  $ENDACTION2RELATION

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

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

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

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

  $ACTION2RELATION(REL10.PORTFOLIO_NAME)
   relation=REL10
   where=null
   prop=PORTFOLIO_NAME
   order=null
   alias=portfolio_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL11.SECTION_NAME)
   relation=REL11
   where=null
   prop=SECTION_NAME
   order=null
   alias=section_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL5.BANK_ACCOUNT_NO)
   relation=REL5
   where=null
   prop=BANK_ACCOUNT_NO
   order=null
   alias=from_account_no
  $ENDACTION2RELATION

  $ACTION2RELATION(REL6.BANK_ACCOUNT_NO)
   relation=REL6
   where=null
   prop=BANK_ACCOUNT_NO
   order=null
   alias=to_account_no
  $ENDACTION2RELATION

  $ACTION2RELATION(REL9.NAME)
   relation=REL9
   where=null
   prop=NAME
   order=null
   alias=purpose_name
  $ENDACTION2RELATION
 $ENDFORM

 $FORM(FORM_OPER_DS)
  name=Операции с ДС
  class=4
  filter=null
  target_state=
  uo=uo_list
  dw=d_oper_ds_vbr
  procedure=ap_10000000000292201
  patterns=GENERIC_VIEW_LIST_P2
  user_define=0
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(15010941)
create procedure dbo.%PROC%
  @sid varchar(30) = null,
  @foundation_id_s varchar(30) = null .ARGLIST_FILTER
as
.BEGIN('N')

select @type_id_s=null
select @state_name_id_s=null
select @item_remark=null

.CHECK_USER
.CHECK_VIEW_LIST

select @type_id=null
select @state_name_id=null

.ARGCONVERT_FILTER

declare @foundation_id numeric

select @foundation_id=convert(numeric,@foundation_id_s)

.VIEW_LIST(ALL,2)
and ( exists(select 1 from t_paydocs where t_paydocs.id=td_depo_docs.id and t_paydocs.foundation_id=@foundation_id) or
( exists(select 1 from t_dealings2pay where t_dealings2pay.act_id=td_depo_docs.id and t_dealings2pay.dog_id=@foundation_id)))
.END
  $ENDTEXT(15010941)
 $ENDFORM

 $FORM(FORM_VIEW)
  name=Платежи
  class=5
  filter=null
  target_state=
  uo=uo_list
  dw=d_real_payment_list
  procedure=ap_10000000000031588
  patterns=GENERIC_VIEW_LIST_P1
  user_define=0
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(15010942)
create procedure dbo.%PROC%
  @sid varchar(30) = null .ARGLIST_FILTER
as
.BEGIN('N')

.CHECK_USER
.CHECK_VIEW_LIST

.ARGCONVERT_FILTER

.VIEW_LIST(ALL,1)

.END
  $ENDTEXT(15010942)

  $ACTION2RELATION(REL2.CUR_CODE)
   relation=REL2
   where=null
   prop=CUR_CODE
   order=12
   alias=cur_code
  $ENDACTION2RELATION

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

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

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

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

  $ACTION2RELATION(REL10.PORTFOLIO_NAME)
   relation=REL10
   where=null
   prop=PORTFOLIO_NAME
   order=3
   alias=portfolio_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL11.SECTION_NAME)
   relation=REL11
   where=null
   prop=SECTION_NAME
   order=3
   alias=section_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL5.BANK_ACCOUNT_NO)
   relation=REL5
   where=null
   prop=BANK_ACCOUNT_NO
   order=11
   alias=from_account_no
  $ENDACTION2RELATION

  $ACTION2RELATION(REL6.BANK_ACCOUNT_NO)
   relation=REL6
   where=null
   prop=BANK_ACCOUNT_NO
   order=11
   alias=to_account_no
  $ENDACTION2RELATION

  $ACTION2RELATION(REL9.NAME)
   relation=REL9
   where=null
   prop=NAME
   order=2
   alias=purpose_name
  $ENDACTION2RELATION
 $ENDFORM

 $STATE2ACTION(NEW.D_REAL_PAYMENT_FILTER)
  state=NEW
  action=D_REAL_PAYMENT_FILTER
 $ENDSTATE2ACTION

 $STATE2ACTION(NEW.D_REAL_PAYMENT_LIST)
  state=NEW
  action=D_REAL_PAYMENT_LIST
 $ENDSTATE2ACTION

 $STATE2ACTION(NEW.FORM_OPER_DS)
  state=NEW
  action=FORM_OPER_DS
 $ENDSTATE2ACTION

 $STATE2ACTION(NEW.FORM_VIEW)
  state=NEW
  action=FORM_VIEW
 $ENDSTATE2ACTION

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

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

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

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

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

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

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

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

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

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

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

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