# Date: 17/02/06
# Version: 105

$DOC(URM2INVESTOR)
 name=Уровень маржи инвестора
 class=1
 product=ALD_SECUR
 name_formula=null
 remark_formula=null

 $STATE(CRT)
  name=Создан
  class=1
 $ENDSTATE

 $PROP(INVESTOR_ID)
  name=Инвестор
  field_name=investor_id
  table_name=tb_urm2investor
  field_type=numeric
  field_length=null
  field_scale=0
  field_prec=18
  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(OWNER_ID)
  name=Организация
  field_name=owner_id
  table_name=tb_urm2investor
  field_type=numeric
  field_length=null
  field_scale=0
  field_prec=18
  page=1
  order=2
  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(URM_SUM)
  name=Уровень маржи
  field_name=urm_sum
  table_name=tb_urm2investor
  field_type=money
  field_length=8
  field_scale=4
  field_prec=19
  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(URM_DATE)
  name=Дата расчета
  field_name=urm_date
  table_name=tb_urm2investor
  field_type=datetime
  field_length=null
  field_scale=null
  field_prec=null
  page=1
  order=4
  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(REL0)
  class=0
  type=ITEMS
  form=null
  prop=INVESTOR_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL2)
  class=0
  type=PARTNERS_JUR
  form=null
  prop=OWNER_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL1)
  class=0
  type=CLIENT_CONTRACTS
  form=null
  prop=INVESTOR_ID
  idname=null
  order=null
 $ENDRELATION

 $FORM(URM2INVESTOR_LIST)
  name=Список
  class=4
  filter=null
  target_state=
  uo=null
  dw=null
  procedure=ap_21535000002421851
  patterns=GENERIC_VIEW_LIST
  user_define=0
  isvisible=0
  istab=0
  posx=null
  posy=null
  width=null
  height=null
  proc_text=$TEXT(14104184)
create procedure dbo.%PROC% @sid varchar(30) = null
   .ARGLIST_FILTER
as
.BEGIN('N')

.CHECK_USER
.CHECK_VIEW_LIST

.ARGCONVERT_FILTER

.VIEW_LIST

.END
  $ENDTEXT(14104184)

  $ACTION2RELATION(REL0.ITEM_NAME)
   relation=REL0
   where=null
   prop=ITEM_NAME
   order=3
   alias=item_name
  $ENDACTION2RELATION
 $ENDFORM

 $STATE2ACTION(CRT.URM2INVESTOR_LIST)
  state=CRT
  action=URM2INVESTOR_LIST
 $ENDSTATE2ACTION
$ENDDOC