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

$DOC(PIF_QUERIES_ALLOCATE)
 name=Заявка на размещение паев
 class=1
 product=ALD_PIF
 name_formula='Заявка на размещение N ' + isnull(@agent_regs_no, '') + ' от ' + .DATE_TO_STR(@agent_regs_date)
 remark_formula='Фонд: '+.ITEM_NAME(@owner_id)+' Пайщик: '+.ITEM_NAME(@pay_owner_id)+' Дата размещения: '+.DATE_TO_STR(@in_date)

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

 $STATE(CANCEL)
  name=Отказ реестра
  class=0
 $ENDSTATE

 $STATE(CRT)
  name=Оплачен
  class=0
 $ENDSTATE

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

 $STATE(ED)
  name=Редактируется
  class=0
 $ENDSTATE

 $STATE(NOT_CRT)
  name=Требует ручной квитовки
  class=0
 $ENDSTATE

 $STATE(PROV)
  name=Обработан
  class=0
 $ENDSTATE

 $PROP(BANK_ACCOUNT_NAME)
  name=Комментарий
  field_name=bank_account_name
  table_name=t_bank_accounts
  field_type=varchar
  field_length=50
  field_scale=null
  field_prec=null
  page=3
  order=37
  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(BANK_ACCOUNT_NO)
  name=Номер счета
  field_name=bank_account_no
  table_name=t_bank_accounts
  field_type=varchar
  field_length=50
  field_scale=null
  field_prec=null
  page=3
  order=38
  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(BANK_ID)
  name=Банк
  field_name=bank_id
  table_name=t_bank_accounts
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=3
  order=39
  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(BANK_NAME)
  name=Наименование банка
  field_name=bank_name
  table_name=t_bank_accounts
  field_type=varchar
  field_length=150
  field_scale=null
  field_prec=null
  page=3
  order=40
  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(CORR_ACCOUNT)
  name=Кор. счет
  field_name=corr_account
  table_name=t_bank_accounts
  field_type=varchar
  field_length=150
  field_scale=null
  field_prec=null
  page=3
  order=41
  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(BIK)
  name=БИК
  field_name=bik
  table_name=t_bank_accounts
  field_type=varchar
  field_length=30
  field_scale=null
  field_prec=null
  page=3
  order=44
  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(BANK_CITY_NAME)
  name=Город банка
  field_name=bank_city_name
  table_name=t_bank_accounts
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=null
  page=3
  order=45
  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(BRANCH_ACC_NO)
  name=Кор. счет филиала
  field_name=branch_acc_no
  table_name=t_bank_accounts
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=null
  page=3
  order=43
  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(BRANCH_NAME)
  name=Наименование филиала
  field_name=branch_name
  table_name=t_bank_accounts
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=null
  page=3
  order=42
  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=null
  field_prec=null
  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=null
  field_prec=null
  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=null
  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=null
  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=null
  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=null
  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=null
  field_prec=null
  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=1
  init_formula=1
  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=null
  field_prec=null
  page=1
  order=12
  init_class=1
  init_formula=1
  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=null
  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
  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_ID)
  name=Агент
  field_name=agent_id
  table_name=tp_pif_queries
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  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(AGENT_REGS_DATE)
  name=Дата регистрации заявки
  field_name=agent_regs_date
  table_name=tp_pif_queries
  field_type=datetime
  field_length=8
  field_scale=null
  field_prec=null
  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(AGENT_REGS_NO)
  name=Номер заявки у агента
  field_name=agent_regs_no
  table_name=tp_pif_queries
  field_type=varchar
  field_length=50
  field_scale=null
  field_prec=null
  page=2
  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(PAY_OWNER_ID)
  name=Пайщик
  field_name=pay_owner_id
  table_name=tp_pif_queries
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=2
  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(PAY_TYPE_ID)
  name=Тип расчета суммы
  field_name=pay_type_id
  table_name=tp_pif_queries
  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(PAYDOC_DATE)
  name=Дата платежного документа
  field_name=paydoc_date
  table_name=tp_pif_queries
  field_type=datetime
  field_length=8
  field_scale=null
  field_prec=null
  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(PAYDOC_NO)
  name=Номер платежного документа
  field_name=paydoc_no
  table_name=tp_pif_queries
  field_type=varchar
  field_length=60
  field_scale=null
  field_prec=null
  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(CALC_DATE)
  name=Дата расчета
  field_name=calc_date
  table_name=tp_pif_queries
  field_type=datetime
  field_length=8
  field_scale=null
  field_prec=null
  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(STOCK_PRICE)
  name=Цена пая
  field_name=stock_price
  table_name=tp_pif_queries
  field_type=money
  field_length=8
  field_scale=null
  field_prec=null
  page=2
  order=26
  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(STOCK_PRICE_CUR_ID)
  name=Валюта цены пая
  field_name=stock_price_cur_id
  table_name=tp_pif_queries
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=2
  order=27
  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(STOCK_QTY)
  name=Количество паев
  field_name=stock_qty
  table_name=tp_pif_queries
  field_type=decimal
  field_length=9
  field_scale=8
  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(PAYMENT_SUM)
  name=Сумма оплаты
  field_name=payment_sum
  table_name=tp_pif_queries
  field_type=money
  field_length=8
  field_scale=null
  field_prec=null
  page=2
  order=29
  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_COMIS_SUM)
  name=Комиссия агента
  field_name=agent_comis_sum
  table_name=tp_pif_queries
  field_type=money
  field_length=8
  field_scale=null
  field_prec=null
  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(TAX)
  name=Налог
  field_name=tax
  table_name=tp_pif_queries
  field_type=money
  field_length=8
  field_scale=null
  field_prec=null
  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(REESTR_ACC_NO)
  name=Номер счета в реестре
  field_name=reestr_acc_no
  table_name=tp_pif_queries
  field_type=varchar
  field_length=100
  field_scale=null
  field_prec=null
  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(TYPE_QUERIES)
  name=Тип заявки
  field_name=type_queries
  table_name=tp_pif_queries
  field_type=int
  field_length=4
  field_scale=null
  field_prec=null
  page=2
  order=33
  init_class=2
  init_formula=1
  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(TOTAL_SUM)
  name=Сумма  без комиссии
  field_name=total_sum
  table_name=tp_pif_queries
  field_type=money
  field_length=8
  field_scale=null
  field_prec=null
  page=2
  order=34
  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_DOG_ID)
  name=Агентский договор
  field_name=agent_dog_id
  table_name=tp_pif_queries
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=2
  order=35
  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(REESTR_REPORT_ID)
  name=Отчет о сверке из реестра
  field_name=reestr_report_id
  table_name=tp_pif_queries
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=2
  order=36
  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=items
  form=null
  prop=FOUNDATION_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL2)
  class=0
  type=partners
  form=null
  prop=AGENT_ID
  idname=null
  order=null
 $ENDRELATION

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

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

 $RELATION(REL5)
  class=0
  type=partners
  form=null
  prop=PAY_OWNER_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL8)
  class=0
  type=partners
  form=null
  prop=CORRESPONDENT_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL9)
  class=0
  type=partners
  form=null
  prop=INITIATOR_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL10)
  class=1
  type=actions_history
  form=uo_actions_history_list
  prop=null
  idname=null
  order=998
 $ENDRELATION

 $RELATION(REL11)
  class=1
  type=activdocs
  form=ACTION1
  prop=null
  idname=null
  order=1000
 $ENDRELATION

 $RELATION(REL12)
  class=0
  type=partners
  form=null
  prop=PAYER_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL13)
  class=0
  type=items
  form=null
  prop=FOLDER_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL14)
  class=0
  type=pif_fund
  form=null
  prop=OWNER_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL15)
  class=1
  type=t_operations
  form=item_opers_list
  prop=null
  idname=item_id_s
  order=999
 $ENDRELATION

 $RELATION(REL6)
  class=0
  type=REESTR_REPORT
  form=null
  prop=REESTR_REPORT_ID
  idname=null
  order=null
 $ENDRELATION

 $RELATION(REL7)
  class=0
  type=FUND_CONTRACT_GROUP
  form=null
  prop=AGENT_DOG_ID
  idname=null
  order=null
 $ENDRELATION

 $FORM(D_PIF_QUERIES_ACCOUNT)
  name=Банковские реквизиты
  class=5
  filter=null
  target_state=
  uo=uo_edit
  dw=d_pif_queries_account
  procedure=ap_60150000000006300
  patterns=GENERIC_VIEW_ITEM_P3
  user_define=0
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(17061767)
create procedure dbo.%PROC%
  @sid varchar(30) = null
as
declare
        @id numeric,
        @action_id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @new_state_id numeric

begin

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

.CHECK_USER
.CHECK_VIEW_ITEM

.VIEW_ITEM(ALL,3)

end
  $ENDTEXT(17061767)
 $ENDFORM

 $FORM(FORM1)
  name=Просмотр
  class=5
  filter=null
  target_state=
  uo=uo_edit
  dw=d_pif_depooper_p1
  procedure=ap_50630000000028027
  patterns=GENERIC_VIEW_ITEM_P1
  user_define=0
  isvisible=0
  istab=1
  posx=0
  posy=0
  width=2770
  height=1916
  proc_text=$TEXT(17061767)
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
.INSERT_DOC_RECORD(@id)
commit tran
end

.VIEW_ITEM(ALL,1)

end
  $ENDTEXT(17061767)

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

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

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

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

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

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

  $ACTION2RELATION(REL14.PARTNER_CODE)
   relation=REL14
   where=null
   prop=PARTNER_CODE
   order=1
   alias=fond_code
  $ENDACTION2RELATION

  $ACTION2RELATION(REL14.PARTNER_NAME)
   relation=REL14
   where=null
   prop=PARTNER_NAME
   order=2
   alias=fond_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL1.ITEM_NAME)
   relation=REL1
   where=null
   prop=ITEM_NAME
   order=2
   alias=foundation_name
  $ENDACTION2RELATION

  $BIND(BIND1)
   type=PIF_QUERIES_ALLOCATE
   action=D_PIF_QUERIES_ACCOUNT
   class=1
   order=2
   idname=null
  $ENDBIND

  $BIND(BIND2)
   type=PIF_QUERIES_ALLOCATE
   action=PIF_QUERIES_ALLOCATE_EDIT
   class=1
   order=1
   idname=null
  $ENDBIND
 $ENDFORM

 $FORM(FORM2)
  name=Привязанные платежи
  class=5
  filter=null
  target_state=
  uo=null
  dw=null
  procedure=ap_50630000000028038
  patterns=GENERIC_VIEW_LIST
  user_define=0
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(17061767)
create procedure dbo.%PROC% @sid varchar(30) = null
   .ARGLIST_FILTER
as
declare
        @id numeric,
        @action_id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric
begin

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

.CHECK_USER
.GET_PROPS


end
  $ENDTEXT(17061767)
 $ENDFORM

 $FORM(PIF_QUERIES_ALLOCATE_EDIT)
  name=Данные
  class=5
  filter=null
  target_state=
  uo=uo_edit
  dw=d_pif_queries_alloc_edit
  procedure=ap_50630000000028036
  patterns=GENERIC_VIEW_ITEM_P2
  user_define=0
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(17061767)
create procedure dbo.%PROC%
  @sid varchar(30) = null
as
declare
        @id numeric,
        @action_id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @new_state_id numeric

begin

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

.CHECK_USER
.CHECK_VIEW_ITEM

.VIEW_ITEM(ALL,2)

end
  $ENDTEXT(17061767)

  $ACTION2RELATION(REL6.IN_DATE)
   relation=REL6
   where=null
   prop=IN_DATE
   order=5
   alias=reestr_report_date
  $ENDACTION2RELATION

  $ACTION2RELATION(REL6.IN_NO)
   relation=REL6
   where=null
   prop=IN_NO
   order=12
   alias=reestr_report_no
  $ENDACTION2RELATION

  $ACTION2RELATION(REL7.CLIENT_REG_NO)
   relation=REL7
   where=null
   prop=CLIENT_REG_NO
   order=8
   alias=agent_dog_no
  $ENDACTION2RELATION

  $ACTION2RELATION(REL2.PARTNER_CODE)
   relation=REL2
   where=null
   prop=PARTNER_CODE
   order=20
   alias=agent_code
  $ENDACTION2RELATION

  $ACTION2RELATION(REL2.PARTNER_SHORT_NAME)
   relation=REL2
   where=null
   prop=PARTNER_SHORT_NAME
   order=21
   alias=agent_short_name
  $ENDACTION2RELATION

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

  $ACTION2RELATION(REL5.PARTNER_SHORT_NAME)
   relation=REL5
   where=null
   prop=PARTNER_SHORT_NAME
   order=21
   alias=partner_short_name
  $ENDACTION2RELATION
 $ENDFORM

 $ACTION(ACTION2)
  name=Данные (изменение)
  class=2
  form=PIF_QUERIES_ALLOCATE_EDIT
  target_state=null
  procedure=ap_50630000000028040
  patterns=GENERIC_UPDATE_P2
  user_define=0
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(17061768)
create procedure dbo.%PROC% @sid varchar(30) = null,
.ARGLIST(ALL, 2)
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(ALL, 2)

.TEST_UNIQUE(ALL, 2)

.GET_PROPS(ALL,1)

.PIF_ROUND_PAYS(@owner_id,@stock_qty,@stock_qty)

.UPDATE_ITEMS

.UPDATE(ALL,2)

.RELGEN
.UPDATE_STATE
.ACTION_HISTORY

commit tran
  $ENDTEXT(17061768)
 $ENDACTION

 $ACTION(ACTION3)
  name=Добавить
  class=1
  form=FORM1
  target_state=ED
  procedure=ap_50630000000028041
  patterns=GENERIC_INSERT_P1
  user_define=0
  isvisible=0
  istab=1
  posx=0
  posy=0
  width=2418
  height=2000
  proc_text=$TEXT(17061768)
create procedure dbo.%PROC% @sid varchar(30) = null,
.ARGLIST(ALL,1)
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

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

.CHECK_USER
.CHECK_UPDATE

.ARGCONVERT(ALL,1)

.INIT_VARS(AFTER,ALL,1)
.DEPO_GEN_NO(@in_no,@depo_doc_type)

.TEST_UNIQUE(ALL,1)

begin tran

.UPDATE(ALL,1)

.RELGEN
.UPDATE_STATE
.ACTION_HISTORY
commit tran

select @sid = convert(varchar,@id)
select @sid
end
  $ENDTEXT(17061768)

  $BIND(BIND1)
   type=PIF_QUERIES_ALLOCATE
   action=ACTION9
   class=1
   order=2
   idname=null
  $ENDBIND

  $BIND(BIND2)
   type=PIF_QUERIES_ALLOCATE
   action=ACTION2
   class=1
   order=1
   idname=null
  $ENDBIND
 $ENDACTION

 $ACTION(ACTION4)
  name=Изменить
  class=2
  form=FORM1
  target_state=null
  procedure=ap_50630000000028044
  patterns=GENERIC_UPDATE_P1
  user_define=0
  isvisible=0
  istab=1
  posx=0
  posy=0
  width=2597
  height=2016
  proc_text=$TEXT(17061768)
create procedure dbo.%PROC% @sid varchar(30) = null,
.ARGLIST(ALL,1)
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(ALL,1)
.DEPO_CHK_NO(@id,@in_no,@depo_doc_type)
.TEST_UNIQUE(ALL,1)

.UPDATE(ALL,1)

.RELGEN
.UPDATE_STATE
.ACTION_HISTORY

commit tran
select sid = convert(varchar, @id)
  $ENDTEXT(17061768)

  $BIND(BIND1)
   type=PIF_QUERIES_ALLOCATE
   action=ACTION9
   class=1
   order=2
   idname=null
  $ENDBIND

  $BIND(BIND2)
   type=PIF_QUERIES_ALLOCATE
   action=ACTION2
   class=1
   order=1
   idname=null
  $ENDBIND
 $ENDACTION

 $ACTION(ACTION5)
  name=Удалить
  class=9
  form=null
  target_state=DEL
  procedure=ap_50630000000028047
  patterns=GENERIC_MOVE
  user_define=0
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(17061768)
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(17061768)

  $BIND(BIND1)
   type=PIF_QUERIES_ALLOCATE
   action=PIF_QUERIES_ALLOCATE_EDIT
   class=1
   order=1
   idname=null
  $ENDBIND
 $ENDACTION

 $ACTION(ACTION6)
  name=На уточнение
  class=9
  form=null
  target_state=ED
  procedure=ap_50630000000028049
  patterns=GENERIC_MOVE
  user_define=0
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(17061768)
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

/*-------Проводки ----------*/
.OPERS_ROLL(ALL)

commit tran
  $ENDTEXT(17061768)

  $BIND(BIND1)
   type=PIF_QUERIES_ALLOCATE
   action=PIF_QUERIES_ALLOCATE_EDIT
   class=1
   order=1
   idname=null
  $ENDBIND
 $ENDACTION

 $ACTION(ACTION7)
  name=На ручную квитовку
  class=9
  form=null
  target_state=NOT_CRT
  procedure=ap_50630000000028051
  patterns=GENERIC_MOVE
  user_define=0
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(17061768)
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(17061768)
 $ENDACTION

 $ACTION(ACTION8)
  name=Отказать
  class=9
  form=null
  target_state=CANCEL
  procedure=ap_50630000000028052
  patterns=GENERIC_MOVE
  user_define=0
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(17061768)
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

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

.OPERS_ROLL(ALL)

commit tran
  $ENDTEXT(17061768)
 $ENDACTION

 $ACTION(ACTION9)
  name=Изменение реквизитов
  class=2
  form=D_PIF_QUERIES_ACCOUNT
  target_state=null
  procedure=ap_60150000000006306
  patterns=null
  user_define=0
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(17061768)
create procedure dbo.%PROC% @sid varchar(30) = null,
.ARGLIST(ALL, 3)
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(ALL, 3)

.UPDATE(ALL,3)

commit tran
  $ENDTEXT(17061768)
 $ENDACTION

 $ACTION(ACTION_EXEC)
  name=В обработку
  class=9
  form=null
  target_state=PROV
  procedure=ap_50630000000028039
  patterns=GENERIC_MOVE
  user_define=1
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(17061768)
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
.ACTION_HISTORY

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

declare @stock_qty1 double precision
declare @operday datetime

/* Опердень */
if @reestr_report_id is null begin
   select @operday = .OPERDAY
end
else
   select @operday = (select in_date from td_depo_docs where id=@reestr_report_id)

/*Тип оценки пая*/
declare @val_type numeric

select @val_type = (select val_type
                      from td_pay_fond
                     where id = @owner_id)


if @agent_dog_id is null
.EXIT_MESSAGE('Не задан договор с агентом по размещению')


-- 22/06/2004 убираем обязательность указания выписки из реестра в заявке
--if @reestr_report_id is null
--.EXIT_MESSAGE('Не задана выписка из реестра')

declare @agent_comis_persent money
/* Получение процента комиссии */

/*select @agent_comis_persent = 1 */

declare @comission_null_level money

select @comission_null_level = max(tb_settings_comis.comission_null_level)
from tb_settings_comis,tb_contracts
where tb_contracts.id= @agent_dog_id
  and tb_settings_comis.settings_id=tb_contracts.id
  and tb_settings_comis.comission_null_level <= @payment_sum
  and tb_settings_comis.profit_type_id = 1
  and .ITEMS_EXISTS_BY_TYPE(tb_settings_comis.id,'revard')


select @agent_comis_persent = tb_settings_comis.comission_percent
from tb_settings_comis,tb_contracts
where tb_contracts.id= @agent_dog_id
  and tb_settings_comis.settings_id=tb_contracts.id
  and tb_settings_comis.comission_null_level = @comission_null_level
  and tb_settings_comis.profit_type_id = 1
  and .ITEMS_EXISTS_BY_TYPE(tb_settings_comis.id,'revard')


if @agent_comis_persent is null
  select @agent_comis_persent = 0
/*
1 - Размещение
2 - Выкуп
*/

/* Расчет сумм */

.TRANSACTION_SAVE

/* Вычисление остатков */

declare @fund_plan_id numeric
select @fund_plan_id = .ARG_PLAN('PIF_ACCOUNT')
declare @acc96_id numeric
declare @acc76_id numeric
declare @acc_agent_id numeric

select @acc96_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'96.1')
select @acc76_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.4.1')
select @acc_agent_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.11')

.TOTALS_QUERY_SUB(@owner_id,@fund_plan_id,@operday,@operday,@acc76_id,'partners',@pay_owner_id,'paydocs',N,N,N,L,N,N,N,Y)

declare @stock_price_allocate money

/* Цена пая */
select @stock_price = .PIF_PAY_PRICE(@owner_id, @operday)
if @stock_price is null
.EXIT_MESSAGE('Для данного фонда не задана цена пая')

if @agent_comis_persent = 0
begin
select @agent_comis_sum = 0
select @stock_price_allocate = @stock_price
select @total_sum = @payment_sum
/* Количество !!!!!!!! */
select @stock_qty1 = convert(double precision,@payment_sum) / convert(double precision,@stock_price_allocate)
/* Округление паев */
.PIF_ROUND_PAYS(@owner_id, @stock_qty1, @stock_qty1)
select @stock_qty = convert(.PIF_PAY_TYPE,@stock_qty1)


end
else
begin
select @stock_price_allocate = @stock_price + @stock_price * @agent_comis_persent / 100.0
.PIF_ROUND_MONEY(@owner_id, @stock_price_allocate, @stock_price_allocate)

if @stock_price_allocate = 0
.EXIT_MESSAGE('При расчете получилась нулевая сумма стоимости пая для размещения')

if @pay_type_id not in (1,2)
  .exit_message('Не задан тип расчета суммы')

if @pay_type_id = 1
begin
  /* На указанную сумму */
  if (@payment_sum is null) OR (@payment_sum = 0)
  .EXIT_MESSAGE('В документе не указана сумма на размещение паев')
end
else if @pay_type_id = 2
begin
/* COMIS <> 0 */
  /* По всем платежам */
  select @payment_sum = (select sum(#tmp_oss.saldo_ce) from #tmp_oss)

  if (@payment_sum is null) OR (@payment_sum = 0)
  .EXIT_MESSAGE('У клиента не найдено ни одного платежа на размещение паев')
end

/* Количество !!!!!!!! */
select @stock_qty1 = convert(double precision,@payment_sum) / convert(double precision,@stock_price_allocate)
/* Округление паев */
.PIF_ROUND_PAYS(@owner_id, @stock_qty1, @stock_qty1)
select @stock_qty = convert(.PIF_PAY_TYPE,@stock_qty1)


if (@stock_qty is null) OR (@stock_qty = 0)
.EXIT_MESSAGE('При расчете получилась нулевое количество паев')

/* Сумма за паи */
select @total_sum = @stock_qty * @stock_price
select @total_sum = .ROUND_MONEY(@total_sum, 2)

/* Сумма комиссии */
select @agent_comis_sum = @payment_sum - @total_sum
select @agent_comis_sum = .ROUND_MONEY(@agent_comis_sum,2)

/* END COMIS <> 0 */
end

/* Сумма налога */
select @tax = 0

/* Поиск платежа */
declare @pay_doc_id numeric

if @pay_type_id = 1
begin
/* По номеру платежа */
if @paydoc_no is not null
select @pay_doc_id = t_paydocs.id
  from t_paydocs, #tmp_oss
 where t_paydocs.id =  #tmp_oss.subc2_id
   and #tmp_oss.saldo_ce >= @payment_sum
   and ltrim(upper(t_paydocs.doc_number)) = ltrim(upper(@paydoc_no))
else
select @pay_doc_id = t_paydocs.id
  from t_paydocs, #tmp_oss
 where t_paydocs.id =  #tmp_oss.subc2_id
   and #tmp_oss.saldo_ce >= @payment_sum


if @pay_doc_id is null
begin
  .UPDATE(ALL,2)
  .ACTION_HISTORY
  .TRANSACTION_RESTORE
/*  .MOVE_STATE('NOT_CRT')*/
  .EXIT_MESSAGE('Платежный документ не найден')
  return
end

declare @bal_qty1 money
select @bal_qty1=.PAYS_QTY_BAL(@stock_qty,@owner_id)

declare @comment1 varchar(200)
declare @comment2 varchar(255)
select @comment1='Заявка на размещение паев №'+isnull(@in_no,'')+' от '+isnull(convert(varchar,@in_date,104),'')
select @comment2 = @comment1 + ':зачисление паев'

.OPERATION(@owner_id,@fund_plan_id,@operday,@acc76_id,@acc96_id,@total_sum,'RUR',@operday,0,@bal_qty1,@comment2,0)
.UPDATE_SUBC(D,'partners',@pay_owner_id)
.UPDATE_SUBC(D,'paydocs',@pay_doc_id)
.UPDATE_SUBC(K,'partners',@pay_owner_id)
.SUBC_CHECK

if (@agent_comis_sum is not null) and (@agent_comis_sum <> 0)
begin
select @comment2 = @comment1 + ':начисление вознаграждения агенту'
.OPERATION(@owner_id,@fund_plan_id,@operday,@acc76_id,@acc_agent_id,@agent_comis_sum,'RUR',@operday,0,0,@comment2,0)
.UPDATE_SUBC(D,'partners',@pay_owner_id)
.UPDATE_SUBC(D,'paydocs',@pay_doc_id)
.UPDATE_SUBC(K,'partners',@agent_id)
.SUBC_CHECK
end

end
else if @pay_type_id = 2
begin
  /* По всем платежам */

/* Loop */

declare @op_pay_id numeric
declare @op_pay_sum money
declare @op_pay_qty .PIF_PAY_TYPE
declare @op_comis_sum money

declare @ost_pay_qty .PIF_PAY_TYPE
declare @ost_pay_sum money
declare @ost_comis_sum money

select @ost_pay_sum = @total_sum
select @ost_comis_sum = @agent_comis_sum
select @ost_pay_qty = @stock_qty

declare pay_cursor cursor for
select #tmp_oss.subc2_id,
       #tmp_oss.saldo_ce
  from #tmp_oss
for read only


open pay_cursor
fetch pay_cursor into @op_pay_id, @op_pay_sum

while ( @@sqlstatus =0 ) and (@ost_pay_sum > 0)
begin

if @op_pay_sum >= (@ost_pay_sum + @ost_comis_sum)
begin
  select @op_pay_sum = @ost_pay_sum
  select @op_pay_qty = @ost_pay_qty
  select @op_comis_sum = @ost_comis_sum
end
else
begin
  select @op_pay_qty = convert(.PIF_PAY_TYPE, (@stock_qty * @op_pay_sum / @total_sum))
  .PIF_ROUND_PAYS(@owner_id, @op_pay_qty, @op_pay_qty)

  select @op_comis_sum = convert(money, (@agent_comis_sum * @op_pay_sum / (@total_sum + @agent_comis_sum)))
  .PIF_ROUND_MONEY(@owner_id, @op_comis_sum, @op_comis_sum)
end

declare @bal_qty2 money
select @bal_qty2 = .PAYS_QTY_BAL(@op_pay_qty,@owner_id)

select @comment2 = @comment1 + ':зачисление паев'
.OPERATION(@owner_id,@fund_plan_id,@operday,@acc76_id,@acc96_id,@op_pay_sum,'RUR',@operday,0,@bal_qty2,@comment2,0)
.UPDATE_SUBC(D,'partners',@pay_owner_id)
.UPDATE_SUBC(D,'paydocs',@op_pay_id)
.UPDATE_SUBC(K,'partners',@pay_owner_id)
.SUBC_CHECK

if (@agent_comis_sum is not null) and (@agent_comis_sum <> 0)
begin
select @comment2 = @comment1 + ':начисление вознаграждения агенту'
.OPERATION(@owner_id,@fund_plan_id,@operday,@acc76_id,@acc_agent_id,@op_comis_sum,'RUR',@operday,0,0,@comment2,0)
.UPDATE_SUBC(D,'partners',@pay_owner_id)
.UPDATE_SUBC(D,'paydocs',@op_pay_id)
.UPDATE_SUBC(K,'partners',@agent_id)
.SUBC_CHECK
end

select @ost_pay_sum = @ost_pay_sum - @op_pay_sum
select @ost_pay_qty = @ost_pay_qty - @op_pay_qty
select @ost_comis_sum = @ost_comis_sum - @op_comis_sum

fetch pay_cursor into @op_pay_id, @op_pay_sum
end

close pay_cursor
deallocate cursor pay_cursor

/* End Loop */
end

.DROP_QUERY_TABLES(#tmp_oss)
.TRANSACTION_RESTORE
.UPDATE(ALL,2)
.UPDATE_STATE

commit tran
  $ENDTEXT(17061768)
 $ENDACTION

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

 $STATE2ACTION(BEG.ACTION9)
  state=BEG
  action=ACTION9
 $ENDSTATE2ACTION

 $STATE2ACTION(CANCEL.ACTION6)
  state=CANCEL
  action=ACTION6
 $ENDSTATE2ACTION

 $STATE2ACTION(CANCEL.D_PIF_QUERIES_ACCOUNT)
  state=CANCEL
  action=D_PIF_QUERIES_ACCOUNT
 $ENDSTATE2ACTION

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

 $STATE2ACTION(CANCEL.PIF_QUERIES_ALLOCATE_EDIT)
  state=CANCEL
  action=PIF_QUERIES_ALLOCATE_EDIT
 $ENDSTATE2ACTION

 $STATE2ACTION(CRT.ACTION6)
  state=CRT
  action=ACTION6
 $ENDSTATE2ACTION

 $STATE2ACTION(CRT.D_PIF_QUERIES_ACCOUNT)
  state=CRT
  action=D_PIF_QUERIES_ACCOUNT
 $ENDSTATE2ACTION

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

 $STATE2ACTION(CRT.PIF_QUERIES_ALLOCATE_EDIT)
  state=CRT
  action=PIF_QUERIES_ALLOCATE_EDIT
 $ENDSTATE2ACTION

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

 $STATE2ACTION(ED.ACTION4)
  state=ED
  action=ACTION4
 $ENDSTATE2ACTION

 $STATE2ACTION(ED.ACTION5)
  state=ED
  action=ACTION5
 $ENDSTATE2ACTION

 $STATE2ACTION(ED.ACTION8)
  state=ED
  action=ACTION8
 $ENDSTATE2ACTION

 $STATE2ACTION(ED.ACTION9)
  state=ED
  action=ACTION9
 $ENDSTATE2ACTION

 $STATE2ACTION(ED.ACTION_EXEC)
  state=ED
  action=ACTION_EXEC
 $ENDSTATE2ACTION

 $STATE2ACTION(ED.D_PIF_QUERIES_ACCOUNT)
  state=ED
  action=D_PIF_QUERIES_ACCOUNT
 $ENDSTATE2ACTION

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

 $STATE2ACTION(ED.PIF_QUERIES_ALLOCATE_EDIT)
  state=ED
  action=PIF_QUERIES_ALLOCATE_EDIT
 $ENDSTATE2ACTION

 $STATE2ACTION(NOT_CRT.ACTION6)
  state=NOT_CRT
  action=ACTION6
 $ENDSTATE2ACTION

 $STATE2ACTION(NOT_CRT.ACTION8)
  state=NOT_CRT
  action=ACTION8
 $ENDSTATE2ACTION

 $STATE2ACTION(NOT_CRT.ACTION_EXEC)
  state=NOT_CRT
  action=ACTION_EXEC
 $ENDSTATE2ACTION

 $STATE2ACTION(NOT_CRT.D_PIF_QUERIES_ACCOUNT)
  state=NOT_CRT
  action=D_PIF_QUERIES_ACCOUNT
 $ENDSTATE2ACTION

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

 $STATE2ACTION(NOT_CRT.PIF_QUERIES_ALLOCATE_EDIT)
  state=NOT_CRT
  action=PIF_QUERIES_ALLOCATE_EDIT
 $ENDSTATE2ACTION

 $STATE2ACTION(PROV.ACTION6)
  state=PROV
  action=ACTION6
 $ENDSTATE2ACTION

 $STATE2ACTION(PROV.D_PIF_QUERIES_ACCOUNT)
  state=PROV
  action=D_PIF_QUERIES_ACCOUNT
 $ENDSTATE2ACTION

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

 $STATE2ACTION(PROV.PIF_QUERIES_ALLOCATE_EDIT)
  state=PROV
  action=PIF_QUERIES_ALLOCATE_EDIT
 $ENDSTATE2ACTION

 $STATE2PROP(BEG.AGENT_COMIS_SUM)
  state=BEG
  prop=AGENT_COMIS_SUM
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.AGENT_DOG_ID)
  state=BEG
  prop=AGENT_DOG_ID
  enable=1
  mandatory=1
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.AGENT_ID)
  state=BEG
  prop=AGENT_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.AGENT_REGS_DATE)
  state=BEG
  prop=AGENT_REGS_DATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.AGENT_REGS_NO)
  state=BEG
  prop=AGENT_REGS_NO
  enable=1
  mandatory=1
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.BANK_ACCOUNT_NAME)
  state=BEG
  prop=BANK_ACCOUNT_NAME
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.BANK_ACCOUNT_NO)
  state=BEG
  prop=BANK_ACCOUNT_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.BANK_CITY_NAME)
  state=BEG
  prop=BANK_CITY_NAME
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.BANK_ID)
  state=BEG
  prop=BANK_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.BANK_NAME)
  state=BEG
  prop=BANK_NAME
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.BIK)
  state=BEG
  prop=BIK
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.BRANCH_ACC_NO)
  state=BEG
  prop=BRANCH_ACC_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.BRANCH_NAME)
  state=BEG
  prop=BRANCH_NAME
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.CALC_DATE)
  state=BEG
  prop=CALC_DATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

 $STATE2PROP(BEG.CORR_ACCOUNT)
  state=BEG
  prop=CORR_ACCOUNT
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.DEPO_DOC_TYPE)
  state=BEG
  prop=DEPO_DOC_TYPE
  enable=1
  mandatory=1
  visible=1
 $ENDSTATE2PROP

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

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

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

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

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

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

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

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

 $STATE2PROP(BEG.OWNER_ID)
  state=BEG
  prop=OWNER_ID
  enable=1
  mandatory=1
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.PAYDOC_DATE)
  state=BEG
  prop=PAYDOC_DATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.PAYDOC_NO)
  state=BEG
  prop=PAYDOC_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

 $STATE2PROP(BEG.PAYMENT_SUM)
  state=BEG
  prop=PAYMENT_SUM
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.PAY_OWNER_ID)
  state=BEG
  prop=PAY_OWNER_ID
  enable=1
  mandatory=1
  visible=1
 $ENDSTATE2PROP

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

 $STATE2PROP(BEG.PAY_TYPE_ID)
  state=BEG
  prop=PAY_TYPE_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.REESTR_ACC_NO)
  state=BEG
  prop=REESTR_ACC_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.REESTR_REPORT_ID)
  state=BEG
  prop=REESTR_REPORT_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.STOCK_QTY)
  state=BEG
  prop=STOCK_QTY
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

 $STATE2PROP(BEG.TAX)
  state=BEG
  prop=TAX
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.TOTAL_SUM)
  state=BEG
  prop=TOTAL_SUM
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(BEG.TYPE_QUERIES)
  state=BEG
  prop=TYPE_QUERIES
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

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

 $STATE2PROP(ED.AGENT_COMIS_SUM)
  state=ED
  prop=AGENT_COMIS_SUM
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.AGENT_DOG_ID)
  state=ED
  prop=AGENT_DOG_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.AGENT_ID)
  state=ED
  prop=AGENT_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.AGENT_REGS_DATE)
  state=ED
  prop=AGENT_REGS_DATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.AGENT_REGS_NO)
  state=ED
  prop=AGENT_REGS_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.BANK_ACCOUNT_NAME)
  state=ED
  prop=BANK_ACCOUNT_NAME
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.BANK_ACCOUNT_NO)
  state=ED
  prop=BANK_ACCOUNT_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.BANK_CITY_NAME)
  state=ED
  prop=BANK_CITY_NAME
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.BANK_ID)
  state=ED
  prop=BANK_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.BANK_NAME)
  state=ED
  prop=BANK_NAME
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.BIK)
  state=ED
  prop=BIK
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.BRANCH_ACC_NO)
  state=ED
  prop=BRANCH_ACC_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.BRANCH_NAME)
  state=ED
  prop=BRANCH_NAME
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.CALC_DATE)
  state=ED
  prop=CALC_DATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

 $STATE2PROP(ED.CORR_ACCOUNT)
  state=ED
  prop=CORR_ACCOUNT
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.DEPO_DOC_TYPE)
  state=ED
  prop=DEPO_DOC_TYPE
  enable=1
  mandatory=1
  visible=1
 $ENDSTATE2PROP

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

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

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

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

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

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

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

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

 $STATE2PROP(ED.OWNER_ID)
  state=ED
  prop=OWNER_ID
  enable=1
  mandatory=1
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.PAYDOC_DATE)
  state=ED
  prop=PAYDOC_DATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.PAYDOC_NO)
  state=ED
  prop=PAYDOC_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

 $STATE2PROP(ED.PAYMENT_SUM)
  state=ED
  prop=PAYMENT_SUM
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.PAY_OWNER_ID)
  state=ED
  prop=PAY_OWNER_ID
  enable=1
  mandatory=1
  visible=1
 $ENDSTATE2PROP

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

 $STATE2PROP(ED.PAY_TYPE_ID)
  state=ED
  prop=PAY_TYPE_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.REESTR_ACC_NO)
  state=ED
  prop=REESTR_ACC_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.REESTR_REPORT_ID)
  state=ED
  prop=REESTR_REPORT_ID
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.STOCK_QTY)
  state=ED
  prop=STOCK_QTY
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

 $STATE2PROP(ED.TAX)
  state=ED
  prop=TAX
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.TOTAL_SUM)
  state=ED
  prop=TOTAL_SUM
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(ED.TYPE_QUERIES)
  state=ED
  prop=TYPE_QUERIES
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

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