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

$DOC(SD_PAYBANK_OUT)
 name=Исходящий платеж по банку для фонда
 class=1
 product=ALD_UKPIF
 name_formula="Исходящий платеж по банку № "+@doc_number+" от " + convert(varchar,@doc_date,3)
 remark_formula=null

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

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

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

 $STATE(NOT_ACPT)
  name=Не принят банком
  class=0
 $ENDSTATE

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

 $STATE(PERF)
  name=Проведен
  class=0
 $ENDSTATE

 $STATE(TOSEND)
  name=На отправку
  class=0
 $ENDSTATE

 $PROP(DOC_DATE)
  name=Дата документа
  field_name=doc_date
  table_name=t_paydocs
  field_type=datetime
  field_length=8
  field_scale=3
  field_prec=23
  page=0
  order=1
  init_class=1
  init_formula=.OPERDAY
  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_NUMBER)
  name=Номер документа
  field_name=doc_number
  table_name=t_paydocs
  field_type=varchar
  field_length=30
  field_scale=null
  field_prec=30
  page=0
  order=2
  init_class=1
  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_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=3
  init_class=1
  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=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(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=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(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=6
  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=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(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=8
  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=14
  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=17
  init_class=1
  init_formula=.OPERDAY
  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=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(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=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(COVERED_SUM)
  name=Покрытая сумма
  field_name=covered_sum
  table_name=t_paydocs
  field_type=money
  field_length=8
  field_scale=4
  field_prec=19
  page=1
  order=15
  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(IS_COMPLETED)
  name=Исполнен
  field_name=is_completed
  table_name=t_paydocs
  field_type=int
  field_length=4
  field_scale=0
  field_prec=10
  page=0
  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(PAY_PERPOSE)
  name=Назн.платежа
  field_name=pay_perpose
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=0
  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(BANK_ACC_REP_ID)
  name=ID выписки из банка
  field_name=bank_acc_rep_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=20
  init_class=1
  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_TRAN_NO)
  name=Номер транзакции банка
  field_name=bank_tran_no
  table_name=t_paydocs
  field_type=varchar
  field_length=100
  field_scale=null
  field_prec=100
  page=1
  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(PIF_PAY_ID)
  name=Заявка на выкуп паев
  field_name=pif_pay_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=46
  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_NDS_RATE)
  name=Ставка НДС
  field_name=tax_nds_rate
  table_name=t_paydocs
  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(TAX_NDS_SUM)
  name=Сумма НДС
  field_name=tax_nds_sum
  table_name=t_paydocs
  field_type=money
  field_length=8
  field_scale=4
  field_prec=19
  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(PAYS_QUEVE)
  name=Очередность платежа
  field_name=pays_queve
  table_name=t_paydocs
  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=null
  import_where=null
  ref_table=null
  ref_key=null
  ref_display=null
  ref_alias=null
  ref_where=null
 $ENDPROP

 $PROP(DATE_OTGR)
  name=Дата отгр продукции
  field_name=date_otgr
  table_name=t_paydocs
  field_type=datetime
  field_length=8
  field_scale=3
  field_prec=23
  page=1
  order=12
  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(TELEGR_ACC_STR)
  name=телеграфн счет
  field_name=telegr_acc_str
  table_name=t_paydocs
  field_type=varchar
  field_length=50
  field_scale=null
  field_prec=50
  page=1
  order=13
  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_TYPE_ID)
  name=Вид оплаты
  field_name=pay_type_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=0
  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(TO_PARTNER_NAME)
  name=Имя получателя
  field_name=to_partner_name
  table_name=t_paydocs
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=255
  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(TO_PARTNER_INN)
  name=ИНН получптеля
  field_name=to_partner_inn
  table_name=t_paydocs
  field_type=varchar
  field_length=30
  field_scale=null
  field_prec=30
  page=1
  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(TO_PARTNER_BANK_NAME)
  name=Банк полуяателя
  field_name=to_partner_bank_name
  table_name=t_paydocs
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=255
  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(TO_PARTNER_BANK_BIC)
  name=BIC банка получателя
  field_name=to_partner_bank_bic
  table_name=t_paydocs
  field_type=varchar
  field_length=30
  field_scale=null
  field_prec=30
  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

 $PROP(FROM_PARTNER_NAME)
  name=Имя отправителя
  field_name=from_partner_name
  table_name=t_paydocs
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=255
  page=1
  order=25
  init_class=1
  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_INN)
  name=ИНН отправителя
  field_name=from_partner_inn
  table_name=t_paydocs
  field_type=varchar
  field_length=30
  field_scale=null
  field_prec=30
  page=1
  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(FROM_PARTNER_BANK_NAME)
  name=Банк отправителя
  field_name=from_partner_bank_name
  table_name=t_paydocs
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=255
  page=1
  order=27
  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_BANK_BIC)
  name=BIC  банка отправителя
  field_name=from_partner_bank_bic
  table_name=t_paydocs
  field_type=varchar
  field_length=30
  field_scale=null
  field_prec=30
  page=1
  order=28
  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(COMPOSE_LINE_COMMENT)
  name=Состав строки комментария
  field_name=compose_line_comment
  table_name=t_paydocs
  field_type=int
  field_length=4
  field_scale=0
  field_prec=10
  page=1
  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(PAYMENT_TYPE)
  name=Вид перевода платежа
  field_name=payment_type
  table_name=t_paydocs
  field_type=int
  field_length=4
  field_scale=0
  field_prec=10
  page=1
  order=30
  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_NO)
  name=Номер счета отправителя
  field_name=from_partner_acc_no
  table_name=t_paydocs
  field_type=varchar
  field_length=150
  field_scale=null
  field_prec=150
  page=1
  order=31
  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_CORR_ACC_NO)
  name=Корреспондентский счет отправителя
  field_name=from_partner_corr_acc_no
  table_name=t_paydocs
  field_type=varchar
  field_length=150
  field_scale=null
  field_prec=150
  page=1
  order=32
  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_CORR_ACC_NO)
  name=Корреспондентский счет получателя
  field_name=to_partner_corr_acc_no
  table_name=t_paydocs
  field_type=varchar
  field_length=150
  field_scale=null
  field_prec=150
  page=1
  order=33
  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_NO)
  name=Номер счета получателя
  field_name=to_partner_acc_no
  table_name=t_paydocs
  field_type=varchar
  field_length=150
  field_scale=null
  field_prec=150
  page=1
  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(SUM_STR)
  name=Сумма прописью
  field_name=sum_str
  table_name=t_paydocs
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=255
  page=1
  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(URGENCY_PAYMENT_ID)
  name=Срочность платежа
  field_name=urgency_payment_id
  table_name=t_paydocs
  field_type=int
  field_length=4
  field_scale=0
  field_prec=10
  page=1
  order=38
  init_class=1
  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(INTERNAL_NAMBER)
  name=Внутренний номер
  field_name=internal_namber
  table_name=t_paydocs
  field_type=varchar
  field_length=30
  field_scale=null
  field_prec=30
  page=1
  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(FOUNDATION_NO)
  name=Номер документа-основания
  field_name=foundation_no
  table_name=t_paydocs
  field_type=varchar
  field_length=100
  field_scale=null
  field_prec=100
  page=1
  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(FOUNDATION_DATE)
  name=Дата документа - основания
  field_name=foundation_date
  table_name=t_paydocs
  field_type=datetime
  field_length=8
  field_scale=3
  field_prec=23
  page=1
  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(TO_PARTNER_BRANCH_NO)
  name=Расчетный счет филиала
  field_name=to_partner_branch_no
  table_name=t_paydocs
  field_type=varchar
  field_length=100
  field_scale=null
  field_prec=100
  page=1
  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(TO_PARTNER_BRANCH_NAME)
  name=Наименование филиала
  field_name=to_partner_branch_name
  table_name=t_paydocs
  field_type=varchar
  field_length=255
  field_scale=null
  field_prec=255
  page=1
  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

 $PROP(CANCEL_PAYMT_ID)
  name=Возвращаемый платеж
  field_name=cancel_paymt_id
  table_name=t_paydocs
  field_type=numeric
  field_length=9
  field_scale=0
  field_prec=18
  page=1
  order=47
  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=0
  order=45
  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(REL5)
  class=1
  type=T_OPERATIONS
  form=ITEM_OPERS_LIST
  prop=null
  idname=item_id_s
  order=999
 $ENDRELATION

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

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

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

 $RELATION(REL15)
  class=0
  type=ITEMS
  form=null
  prop=PIF_PAY_ID
  idname=null
  order=8
 $ENDRELATION

 $RELATION(REL1)
  class=0
  type=ITEMS
  form=null
  prop=CANCEL_PAYMT_ID
  idname=null
  order=9
 $ENDRELATION

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

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

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

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

 $RELATION(REL2)
  class=1
  type=CANCELLING_PIF_PAYMENT
  form=CANCELLING_PAYMENT_LIST
  prop=null
  idname=depo_doc_id_s
  order=1000
 $ENDRELATION

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

begin

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

.CHECK_USER
.CHECK_VIEW_ITEM

if @id = -1
begin
begin tran
.GET_PROPS
.CHECK_INSERT
.INIT_VARS(B)
.INSERT_ITEMS
.INSERT
commit tran
end

.INSERT_INFO4OPER(@id)
.VIEW_ITEM

end
  $ENDTEXT(16090856)

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

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

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

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

  $ACTION2RELATION(REL13.PARTNER_NAME)
   relation=REL13
   where=null
   prop=PARTNER_NAME
   order=2
   alias=fund_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL14.CODE)
   relation=REL14
   where=null
   prop=CODE
   order=1
   alias=pay_purpose_code
  $ENDACTION2RELATION

  $ACTION2RELATION(REL14.NAME)
   relation=REL14
   where=null
   prop=NAME
   order=2
   alias=pay_purpose_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL15.ITEM_NAME)
   relation=REL15
   where=null
   prop=ITEM_NAME
   order=3
   alias=pif_pay_name
  $ENDACTION2RELATION

  $ACTION2RELATION(REL1.ITEM_NAME)
   relation=REL1
   where=null
   prop=ITEM_NAME
   order=3
   alias=cancel_paymt_name
  $ENDACTION2RELATION

  $BIND(BIND1)
   type=UK_INFO4OPER
   action=FORM_ED
   class=1
   order=10
   idname=sid
  $ENDBIND
 $ENDFORM

 $ACTION(ACTION1)
  name=Не принят банком
  class=9
  form=null
  target_state=NOT_ACPT
  procedure=ap_11535000000048560
  patterns=GENERIC_MOVE
  user_define=0
  isvisible=1
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(16090856)
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

if not exists(select 1 from td_foundation_docs,t_items,t_states
                   where td_foundation_docs.depo_doc_id=@id and
                         t_items.id=@id and t_items.state_id=t_states.id and
                         t_states.class_id=0)
begin
.EXIT_MESSAGE('Введите причину отказа банком')
end

.UPDATE_STATE
.ACTION_HISTORY

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


commit tran
  $ENDTEXT(16090856)
 $ENDACTION

 $ACTION(ACTION3)
  name=Добавить
  class=1
  form=D_PAYDOCS_OUT_VIEW
  target_state=ED
  procedure=ap_11535000000048561
  patterns=GENERIC_INSERT
  user_define=0
  isvisible=0
  istab=1
  posx=0
  posy=0
  width=3342
  height=1996
  proc_text=$TEXT(16090858)
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(30),
       @new_state_id numeric
begin tran

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

.CHECK_USER
.CHECK_UPDATE

.ARGCONVERT
.INIT_VARS

if @from_partner_acc_id=@to_partner_acc_id
.EXIT_MESSAGE('Расчетные счета отправителя и получателя не должны совпадать')

.TEST_UNIQUE

.UPDATE_ITEMS

.UPDATE

.UPDATE_STATE

.RELGEN
.ACTION_HISTORY

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

  $BIND(BIND1)
   type=UK_INFO4OPER
   action=ACTION_UPDATE
   class=1
   order=10
   idname=sid
  $ENDBIND
 $ENDACTION

 $ACTION(ACTION4)
  name=Изменить
  class=2
  form=D_PAYDOCS_OUT_VIEW
  target_state=null
  procedure=ap_11535000000048562
  patterns=GENERIC_UPDATE
  user_define=0
  isvisible=0
  istab=1
  posx=0
  posy=0
  width=3401
  height=1992
  proc_text=$TEXT(16090858)
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
if @from_partner_acc_id=@to_partner_acc_id
.EXIT_MESSAGE('Расчетные счета отправителя и получателя не должны совпадать')

.TEST_UNIQUE

.UPDATE_ITEMS

.UPDATE

.RELGEN
.UPDATE_STATE
.ACTION_HISTORY

commit tran
  $ENDTEXT(16090858)

  $BIND(BIND1)
   type=UK_INFO4OPER
   action=ACTION_UPDATE
   class=1
   order=10
   idname=sid
  $ENDBIND
 $ENDACTION

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

/*** Богаковский 31/05/2005 добавил и 06/10/2005 изменил проверку *********/
-- 06/10/2005 начало -----------------------------------------------
-- Если по документу существуют проводки по удаляемому документу
-- или документ является аналитикой в проводках другого документа
--------------------------------------------------------------------
declare @msg varchar(255)
declare @doc_type_name varchar(255)
declare @doc_no varchar(100)
declare @doc_date varchar(10)
declare @item_id numeric
declare @no varchar(10)
declare @ot varchar(10)
declare @roll_doc_item_name varchar(255)
declare @main_doc_id_out varchar(30)
declare @main_action_id_out varchar(30)
declare @tab_action_id_out varchar(30)
declare @main_doc_type varchar(255)
declare @main_doc_in_no varchar(255)
declare @main_doc_in_date varchar(255)
declare @main_action_name varchar(255)
declare @tab_action_name varchar(255)
declare @warn_name varchar(255)
declare @main_doc_name varchar(255)

CREATE TABLE #temp_sid_bind (select_string varchar(255))
TRUNCATE TABLE #temp_sid_bind

if exists(select 1 from t_operations where item_id=@id)
  .EXIT_MESSAGE('Удаление невозможно, поскольку существуют проводки по данному документу')

if exists(select 1 from t_oper_subconto where t_oper_subconto.item_id=@id)
begin
-- ID документа, в проводках которого данный документ является аналитикой
select @item_id =
(select t_operations.item_id from t_operations where t_operations.id=
(select TOP 1 head_id
  from t_oper_list
 where t_oper_list.id = (select TOP 1 id from t_oper_subconto where t_oper_subconto.item_id=@id)))

--Тип документа, в проводках которого данный документ является аналитикой
select @doc_type_name =
(select t_types.type_name
   from t_types, t_items
  where t_types.id = t_items.type_id
    and t_items.id = @item_id)

-- Номер и дата документа, в проводках которого данный документ является аналитикой
SELECT @doc_no = (select in_no from td_depo_docs where id=@item_id)
SELECT @doc_date = convert(varchar(10), (select in_date from td_depo_docs where id=@item_id), 104)

if isnull(@doc_no,'') =''
 select @no=''
else
 select @no=' №'

if isnull(@doc_date,'') =''
 select @ot=''
else
 select @ot=' от '

SELECT @roll_doc_item_name = isnull(@doc_type_name,'') + @no + isnull(@doc_no, '') + @ot + isnull(@doc_date, '')


   SELECT @warn_name = @warn_name + ' Отмените документ: "' + @roll_doc_item_name + '"'

-- Вычисление ID документа, являющегося главным (В TAB) по отношению к документу, который следует откатить
     .MAIN_DOC_FROM_TAB(@item_id, @main_doc_id_out, @main_action_id_out, @tab_action_id_out)

-- Если документ, который следует откатить, связан в TAB,
-- то добавить к сообщению данные о главном документе и связанных методах

      if @main_doc_id_out is not null
      begin

       SELECT @main_doc_type    = (.ITEM_TYPE_NAME(@main_doc_id_out))
       SELECT @main_doc_in_no   = (select in_no from td_depo_docs where id=@main_doc_id_out)
       SELECT @main_doc_in_date = convert(varchar(10), (select in_date from td_depo_docs where id=@main_doc_id_out), 104)
       SELECT @main_action_name = (select action_name from t_actions where id = @main_action_id_out)
       SELECT @tab_action_name  = (select action_name from t_actions where id = @tab_action_id_out)

          if isnull(@main_doc_in_no,'') =''
            select @no=''
          else
            select @no=' №'

          if isnull(@main_doc_in_date,'') =''
            select @ot=''
          else
            select @ot=' от '

        SELECT @main_doc_name = '"' + isnull(@main_doc_type,'') + '"' + @no + isnull(@main_doc_in_no, '') + @ot + isnull(@main_doc_in_date,'')
        SELECT @warn_name = @warn_name + ',влож. в док.:' + @main_doc_name + '"' + '(методы: главн.' + '"' + @main_action_name + '",влож.:"' + @tab_action_name +  '")'
      end


   select @msg= 'Удаление невозможно. ' + @warn_name
   .EXIT_MESSAGE(@msg)
end

drop table #temp_sid_bind
-----------------------------------------------------------------------------------------------------------------
--- 06/10/2005 конец --------------------------------------------------------------------------------------------

.CHECK_USER
.CHECK_UPDATE

.UPDATE_STATE
.ACTION_HISTORY

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


commit tran
  $ENDTEXT(16090858)
 $ENDACTION

 $ACTION(ACTION_TO_EDIT)
  name=На изменение
  class=9
  form=null
  target_state=ED
  procedure=ap_21535000001323882
  patterns=GENERIC_MOVE
  user_define=0
  isvisible=0
  istab=0
  posx=null
  posy=null
  width=null
  height=null
  proc_text=$TEXT(16090858)
create procedure dbo.%PROC% @sid varchar(30) = null
as
.BEGIN('N')

.CHECK_USER
.CHECK_UPDATE

begin tran
.UPDATE_STATE
.ACTION_HISTORY

/*-------Проводки ----------*/
commit tran
.END
  $ENDTEXT(16090858)
 $ENDACTION

 $ACTION(ACTION_TO_SEND)
  name=На отправку
  class=9
  form=null
  target_state=TOSEND
  procedure=ap_21535000001323881
  patterns=GENERIC_MOVE
  user_define=0
  isvisible=0
  istab=0
  posx=null
  posy=null
  width=null
  height=null
  proc_text=$TEXT(16090858)
create procedure dbo.%PROC% @sid varchar(30) = null
as
.BEGIN('N')

.CHECK_USER
.CHECK_UPDATE

begin tran
.UPDATE_STATE
.ACTION_HISTORY

/*-------Проводки ----------*/
commit tran
.END
  $ENDTEXT(16090858)
 $ENDACTION

 $ACTION(COPY2)
  name=Скопировать
  class=9
  form=null
  target_state=ED
  procedure=ap_21535000002253683
  patterns=GENERIC_MOVE
  user_define=1
  isvisible=0
  istab=0
  posx=null
  posy=null
  width=null
  height=null
  proc_text=$TEXT(16090858)
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)

declare @set_id numeric

select @set_id=@id

.CHECK_USER
.CHECK_UPDATE

.ACTION_HISTORY

.GET_PROPS

select
@doc_number=null,
@doc_sum=null,
@complete_date=null


--.BACK_GEN_NO(@in_no,@depo_doc_type,@in_date)

.INSERT_ITEMS
.INSERT
update t_items set
item_name='COPY'
where id=@id
/*.ITEM_MOVE_STATE(@id,'EDIT')*/
.UPDATE_STATE

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


commit tran
  $ENDTEXT(16090858)
 $ENDACTION

 $ACTION(OPS)
  name=Провести
  class=9
  form=null
  target_state=PERF
  procedure=ap_11535000000048564
  patterns=GENERIC_MOVE
  user_define=1
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(16090858)
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)
 .NAME_VAR(@mess)

.CHECK_USER
.CHECK_UPDATE

.GET_PROPS
if @from_partner_acc_id=@to_partner_acc_id
 .EXIT_MESSAGE('Расчетные счета отправителя и получателя не должны совпадать')

select @complete_date=isnull(@complete_date,@doc_date)

.UPDATE
.UPDATE_ITEMS
.PAYS_COMPLETE_STATE(@id, 1)
.GET_PROPS

declare @doc_name varchar(255)
declare @deb_acc_id numeric
declare @cred_acc_id numeric
declare @fund_plan_id numeric

select @doc_name = .ITEM_NAME(@id)

.NAME_VAR(@fund_type_code)
select @fund_type_code  = .ITEM_TYPE_CODE(@owner_id)

.NAME_VAR(@perp_str)
select @perp_str = .PURPOSE_NAME(@pay_perpose) + ' : '+ @perpose_str
select @doc_name = @perp_str + ' : '+ @doc_name


/* Проводки для ПИФ */

if .STR_FOR_IF(@fund_type_code) = .STR_FOR_IF('pif_fund') begin

select @fund_plan_id = .ARG_PLAN('PIF_ACCOUNT')
select @cred_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'51')

if @pay_perpose = 4003 /* Перечисление надбавки агенту или УК */
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.11')
else if @pay_perpose = 4005 /* Уплата подоходного налога*/
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'68.7')
else if @pay_perpose = 4006 /* Уплата налога на доходы*/
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'68.8')
else if @pay_perpose = 4008 /* Перечисление вознаграждения УК */
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.1')
else if @pay_perpose = 4009 /* Перечисление вознаграждения СД */
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.2')
else if @pay_perpose = 4010 /* Перечисление вознаграждения СР */
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.3')
else if @pay_perpose = 4017
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.17')
else if @pay_perpose = 4018
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.18')
else if @pay_perpose in (4016,2032)
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.8')
else if @pay_perpose = 9002
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.12')
else if @pay_perpose = 9001
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.5.4')
else if @pay_perpose = 4022
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.8')

/*
else if @pay_perpose = 2018 -- Перечисление денежных средств на депозит (57)
begin
 if (@to_partner_acc_id is null)
    or (.GET_CTRL_COMP_ID(@owner_id) != @to_partner_id)
  .EXIT_MESSAGE('Не задан целевой депозитный счет для фонда')
 select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'57')
end
else if @pay_perpose = 2028 -- Перечисление денежных средств на депозит (напрямую)
begin
 if (@to_partner_acc_id is null) or (.GET_CTRL_COMP_ID(@owner_id) != @to_partner_id)
  .EXIT_MESSAGE('Не задан целевой депозитный счет для фонда')
 select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'58.2')
end
else if @pay_perpose = 2019 -- Перечисление денежных средств с депозита (57)
begin
 if (@to_partner_acc_id is null) or (.GET_CTRL_COMP_ID(@owner_id) != @to_partner_id)
  .EXIT_MESSAGE('Не задан целевой расчетный счет для фонда')
 select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'57')
 select @cred_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'58.2')
end
*/

/*
else if @pay_perpose in(
  2011, -- 2011 Перечисление денежных средств за недвижимость
  2012  -- 2012 Перечисление денежных средств за прочие активы
)
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.13')
else if @pay_perpose = 2022 -- Перечисление денежных средств по взаимозачету
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.5.5')
else if @pay_perpose = 2004 -- Основной платеж по Договору покупки ЦБ
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.5.2')
else if @pay_perpose = 2025 -- Платеж на биржу
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.5.4')
else if @pay_perpose=103 -- 103 Расчеты с банком
begin
  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'89.2')
  select @cred_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.8')
end
*/

--else if @pay_perpose = 4007 /* Перечисление денег УК в счет возмещения за выкуп паев */
--  select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.1')
else if @pay_perpose in (4014,4020) /* 4014 Выплата цены выкупа пая */
begin
 if @pif_pay_id is null
  .EXIT_MESSAGE('Не указана заявка')
 if upper(.ITEM_STATE_CODE(@pif_pay_id)) not in ('WAIT_CRT','CRT_RET')
  .EXIT_MESSAGE('Заявка должна быть подтверждена в отчете регистратора, но не оплачена')
 if (@pif_pay_id is not null) and
    ((select owner_id from td_depo_docs where id=@pif_pay_id) != @owner_id)
  .EXIT_MESSAGE('Выберите заявку для указанного фонда')
 if (@pif_pay_id is not null) and
    ((select pay_owner_id from tp_pif_queries where id=@pif_pay_id) != @to_partner_id)
  .EXIT_MESSAGE('Получатель платежа не является пайщиком в заявке')
 if (select pay_type_id from tp_pif_queries where id=@pif_pay_id)=2 -- нач.задолженность
  if (select isnull(payment_sum,0) from tp_pif_queries where id=@pif_pay_id) != @doc_sum
   .EXIT_MESSAGE('Сумма платежа не равна задолженности по заявке')
 if (select isnull(pay_type_id,1) from tp_pif_queries where id=@pif_pay_id)=1
  if (select isnull(sum_for_transfer,0) from tp_extract2claim where claim_id=@pif_pay_id) != @doc_sum
   .EXIT_MESSAGE('Сумма платежа не равна сумме заявки в отчете регистратора')

 if (select count(*) from t_paydocs, td_depo_docs, t_items, t_types, t_states
                    where t_paydocs.pif_pay_id = @pif_pay_id
                      and t_paydocs.id = td_depo_docs.id
                      and td_depo_docs.owner_id = @owner_id
                      and t_paydocs.id = t_items.id
                      and t_paydocs.complete_date > @complete_date
                      and t_items.type_id = t_types.id
                      and upper(t_types.type_code) in ('SD_PAYBANK_IN', 'SD_PAYBANK_OUT')
                      and t_items.state_id = t_states.id
                      and upper(t_states.state_code) in ('PERF')) >0
  .EXIT_MESSAGE('По заявке есть платежи с датой больше текущей')

 select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.4.2')
 if upper(.ITEM_STATE_CODE(@pif_pay_id))='CRT_RET'
 begin
  .ITEM_MOVE_STATE(@pif_pay_id,'CRT_NEXT')
 end
 else
 begin
  .ITEM_MOVE_STATE(@pif_pay_id,'CRT')
 end
 update t_paydocs set covered_sum=@doc_sum where id=@id
end
else if @pay_perpose=4015 /* 4015 возврат по заявкам на размещение */
begin
 if @cancel_paymt_id is null
  .EXIT_MESSAGE('Не задан вх.платеж, по которому производится возврат')
 if (@pif_pay_id is not null) and (upper(.ITEM_STATE_CODE(@pif_pay_id)) not in ('PROV','CANCEL'))
  .EXIT_MESSAGE('Заявка должна быть на исполнении или отказана в исполнении')
 if (@pif_pay_id is not null) and
    ((select owner_id from td_depo_docs where id=@pif_pay_id) != @owner_id)
  .EXIT_MESSAGE('Выберите заявку для указанного фонда')
 if (@pif_pay_id is not null) and
    ((select pay_owner_id from tp_pif_queries where id=@pif_pay_id) != @to_partner_id)
  .EXIT_MESSAGE('Получатель платежа не является пайщиком в заявке')
 select @deb_acc_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.4.1')
 update t_paydocs set covered_sum=@doc_sum where id=@id
end
else /* Неизвестное назначение */
begin
  .EXIT_MESSAGE('Неизвестное целевое назначение')
end


/* OPERATION */
.UPDATE_STATE
.ACTION_HISTORY

.OPERATION(@owner_id,@fund_plan_id,@complete_date,@deb_acc_id,@cred_acc_id,@doc_sum,'RUR',@complete_date,0,0,@doc_name,N)
/* END OPERATION */


/* SUBC DEB */
if @pay_perpose in (
  4003 /* Перечисление надбавки агенту или УК */,
--  4007 /* Перечисление денег УК в счет возмещения за выкуп паев */,
  4008 /* Перечисление вознаграждения УК */,
  4009 /* Перечисление вознаграждения СД */,
  4010 /* Перечисление вознаграждения СР */,
  4017,4018,4016,2032,
--  2004 /* Основной платеж по Договору покупки ЦБ */,
  9001,9002,4022
--  2011 /* 2011 Перечисление денежных средств за недвижимость */,
--  2012 /* 2012 Перечисление денежных средств за прочие активы */,
--  2022 /* Перечисление денежных средств по взаимозачету */,
--  2025 /* Платеж на биржу */
)
begin
  .UPDATE_SUBC(D,'partners',@to_partner_id)
end
else if @pay_perpose in (4014,4020) /* 4014 - Выплата цены выкупа пая */
begin
 .UPDATE_SUBC(D,'partners',@to_partner_id)
 .UPDATE_SUBC(D,'pifdocs',@pif_pay_id)
end
else if @pay_perpose=4015 /* 4015 - возврат по заявкам на размещение */
begin
 .UPDATE_SUBC(D,'partners',@to_partner_id)
 .UPDATE_SUBC(D,'paydocs',@cancel_paymt_id)
end

/*
else if @pay_perpose in (
  2018, -- Перечисление денежных средств на счет банковского депозита (57)
  2019,  -- Перечисление денежных средств со счета банковского депозита (57)
  2028 -- Перечисление денежных средств на счет банковского депозита (напрямую)
)
begin
  .UPDATE_SUBC(D,'bank_account',@to_partner_acc_id)
end
*/

/* SUBC CRED */
.UPDATE_SUBC(K,'bank_account',@from_partner_acc_id)

/*
if @pay_perpose = 103 -- 103 Расчеты с банком
begin
  .UPDATE_SUBC(K,'partners',@to_partner_id)
end
else
begin
  .UPDATE_SUBC(K,'bank_account',@from_partner_acc_id)
end
*/

/* ADD */

/*
if @pay_perpose = 103 -- 103 Расчеты с банком
begin
  declare @d103_id numeric
  declare @c103_id numeric
  select @d103_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.8')
  select @c103_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'51')

  .OPERATION(@owner_id,@fund_plan_id,@complete_date,@d103_id,@c103_id,@doc_sum,'RUR',@complete_date,0,0,@doc_name,N)
  .UPDATE_SUBC(K,'bank_account',@from_partner_acc_id)
  .UPDATE_SUBC(D,'partners',@to_partner_id)
  .SUBC_CHECK
end
*/

-- доп.проводка Д 96.2 - К 76.8 на уменьшение проч.резерва
if @pay_perpose = 4016 -- "Перечисление прочих вознаграждений"
begin
  declare @d4019_id numeric
  declare @c4019_id numeric
  select @c4019_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.8')
  select @d4019_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'89.2')

  .OPERATION(@owner_id,@fund_plan_id,@complete_date,@d4019_id,@c4019_id,@doc_sum,'RUR',@complete_date,0,0,@doc_name,N)
  .UPDATE_SUBC(K,'partners',@to_partner_id)
  .SUBC_CHECK
end

-- доп.проводка Д 91.7 - К 76.8 а 91.7 потом закроют как-то
if @pay_perpose = 4022 -- 4022, тоже тогда, но мельникову на 91.7 как в росбанке
begin
  declare @d4022_id numeric
  declare @c4022_id numeric
-- letsko_av
--  select @c4022_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'76.8')
  SELECT @c4022_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id, '96.2')
  select @d4022_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'91.7')

  .OPERATION(@owner_id, @fund_plan_id, @complete_date, @d4022_id, @c4022_id, @doc_sum, 'RUR',
    @complete_date, 0, 0, @doc_name, N)
-- letsko_av
--  .UPDATE_SUBC(K,'partners',@to_partner_id)
  .SUBC_CHECK
end

end /* Конец проводок ПИФ*/

--------------------
-- Проводки для BACK
--------------------
if @pay_perpose in (4008,4009,4010,4017,4018,4016,4014,4015,4003,4005,4006,4020,2032,4022)
begin

.ID_VAR(@back_owner_id)
.ID_VAR(@plan_money_id)
.ID_VAR(@plan_securs_id)
.INT_VAR(@out_method_id)
.ID_VAR(@organisation_id)
.ID_VAR(@home_place_class_id)
.ID_VAR(@home_object_id)
.ID_VAR(@home_bank_acc_id)
.ID_VAR(@client_contract_id)
.ID_VAR(@portfolio_id)
.ID_VAR(@portfolio_sub_id)
.ID_VAR(@is_org_realiz)
.ID_VAR(@is_org_comis)
.INT_VAR(@is_com_in)
.INT_VAR(@is_allow_short4stocks)
.INT_VAR(@is_allow_short4money)
.ID_VAR(@asset4pereoc_type_id)
.NAME_VAR(@investor_subc_str)
.NAME_VAR(@ext_subc_str)
.NAME_VAR(@home_subc_str)
.MONEY_VAR(@cred_acc_sum)
.MONEY_VAR(@deb_acc_sum)

select @back_owner_id=.ORGANIZATION
.BACK_GET_ORG_PARMS(@back_owner_id,@organisation_id,@plan_money_id,@plan_securs_id,@out_method_id,@is_org_realiz,@is_org_comis,@is_com_in,@is_allow_short4stocks,@is_allow_short4money,@asset4pereoc_type_id)
.BACK_GET_PIF_CONTRACT(@owner_id,@back_owner_id,@client_contract_id)

/**/
select @home_object_id=min(b.id)
from tb_broker2exchange b,tb_contracts c, td_depo_docs d , t_move_directions m
 where  upper(m.code)=.GET_CONST('WHOAREME')
   and b.object_class_id = m.id
   and b.ext_broker_deal = c.id
   and c.client_id = @back_owner_id
   and c.id = d.id
   and d.owner_id = @back_owner_id
   and .ITEMS_EXISTS_BY_TYPE(b.id,'BROKER2EXCHANGE')
   and .ITEMS_EXISTS_BY_TYPE(c.id,'ORGANIZATION_CONTRACTS')

select @mess = 'Не задано место нахождения ДС с кодом ->' + .GET_CONST('WHOAREME') + '<- из константы WHOAREME'
--select @mess = 'Не задано место нахождения ДС с кодом OWN'
if @home_object_id is null .EXIT_MESSAGE(@mess)
/**/

--select @home_object_id=@organisation_id

.BACK_PLASE_CLASS_FROM_OBJ(@home_object_id,@organisation_id,@home_place_class_id)
--select @home_place_class_id = @home_object_id
select @mess = 'Не задан класс места нахождения ДС с кодом ->' + .GET_CONST('WHOAREME') + '<- из константы WHOAREME'
--select @mess = 'Не задан класс места нахождения ДС с кодом OWN'
if @home_place_class_id is null
.EXIT_MESSAGE(@mess)

.BACK_GET_PIF_SECTION(@client_contract_id,@portfolio_sub_id)
.BACK_GET_PIF_PORTFOLIO(@client_contract_id,@portfolio_id)

select @home_bank_acc_id=@from_partner_acc_id
if @home_bank_acc_id is null .EXIT_MESSAGE('Не задан расчетный счет')

select @cred_acc_sum=@doc_sum
select @deb_acc_sum=@doc_sum

.SUBC_STR_ADD(@investor_subc_str,'investors',@client_contract_id)
.SUBC_STR_ADD(@investor_subc_str,'investor2portfolio',@portfolio_sub_id)
.SUBC_STR_ADD(@investor_subc_str,'portfolio',@portfolio_id)

if @pay_perpose in (4008,4009,4010,4017,4018,4016,2032,4022)
begin
 select @ext_subc_str=@investor_subc_str
 .SUBC_STR_ADD(@ext_subc_str,'contragents',@to_partner_id)
end

if @pay_perpose in (4014,4015,4003,4005,4006,4020)
begin
 .SUBC_STR_ADD(@ext_subc_str,'investors',@client_contract_id)
end

select @home_subc_str=@investor_subc_str
.SUBC_STR_ADD(@home_subc_str,'ASSET_PLACES',@home_object_id)
.SUBC_STR_ADD(@home_subc_str,'BANK_ACCOUNT',@home_bank_acc_id)

.BACK_OPERS_BEGIN(@back_owner_id,(-1),@purpose_id,@home_place_class_id,@home_object_id,@client_contract_id,@investor_subc_str,@portfolio_sub_id)
.BACK_MONEY_INOUT(@doc_sum,@complete_date,@complete_date,@cur_id,@home_subc_str,@ext_subc_str,@deb_acc_sum,@cred_acc_sum,@cur_id,@cur_id)

-- 2.11 - 3.6.0

if @pay_perpose in (4014,4020) /* 4014 Выплата цены выкупа пая */
begin
 .ID_VAR(@acc211_id)
 .ID_VAR(@acc360_id)
 .NAME_VAR(@subc211_str)
 .NAME_VAR(@subc360_str)

 .ACCID_FROM_CONST2PLAN(@acc211_id,'BACK_ACC_FUND_MONEY_OUT',@plan_money_id,3,1,'ожид.расход ДС',@mess)
 .ACCID_FROM_CONST2PLAN(@acc360_id,'BACK_ACC_FUND_MONEY_CHNG',@plan_money_id,3,1,'ожид.списание из фонда',@mess)

 .SUBC_STR_ADD(@subc360_str,'investors',@client_contract_id)
 .SUBC_STR_ADD(@subc211_str,'investors',@client_contract_id)
 .SUBC_STR_ADD(@subc211_str,'investor2portfolio',@portfolio_sub_id)
 .SUBC_STR_ADD(@subc211_str,'portfolio',@portfolio_id)
 .SUBC_STR_ADD(@subc211_str,'docs4out_fund',@pif_pay_id)

 select @mess='Снятие резервирования ДС по заявке'

 .OPERATION_SBC(@back_owner_id,@plan_money_id,@complete_date,@acc211_id,@acc360_id,@doc_sum,@cur_id,@complete_date,null,null,@mess,Y,
                @operation_id,null,null,@action_history_id,@doc_sum,@doc_sum,@subc211_str,@subc360_str)
end
end -- BACK

/*
.ID_VAR(@j_asset_id)
select @j_asset_id=@from_partner_acc_id
.SD_ASSET_OPER_ADD(@id,@j_asset_id,@doc_sum,null,@owner_id,@purpose_id,2)
*/

commit tran
  $ENDTEXT(16090858)
 $ENDACTION

 $ACTION(SIG_RET)
  name=На редактирование
  class=9
  form=null
  target_state=ED
  procedure=ap_sd_paybank_ret
  patterns=GENERIC_MOVE
  user_define=0
  isvisible=0
  istab=0
  posx=0
  posy=0
  width=0
  height=0
  proc_text=$TEXT(16090858)
create procedure dbo.%PROC% @sid varchar(30) = null,
  @report_sid varchar(30) = null,
  @report_state int = 0 out
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
.GET_PROPS

declare @old_state_code varchar(30)
select @old_state_code = upper(state_code) from t_items, t_states
 where t_items.id=@id
   and t_items.state_id = t_states.id

if @pay_perpose = 4014 and @old_state_code='PERF'/* Выплата цены выкупа пая */
begin
 if upper(.ITEM_STATE_CODE(@pif_pay_id)) not in ('CRT','CRT_NEXT')
  .EXIT_MESSAGE('Заявка должна быть исполнена')

 if (select count(*) from t_paydocs, td_depo_docs, t_items, t_types, t_states
      where t_paydocs.pif_pay_id = @pif_pay_id
        and t_paydocs.id = td_depo_docs.id
        and td_depo_docs.owner_id = @owner_id
        and t_paydocs.id = t_items.id
        and t_paydocs.complete_date > @complete_date
        and t_items.type_id = t_types.id
        and upper(t_types.type_code) in ('SD_PAYBANK_IN', 'SD_PAYBANK_OUT')
        and t_items.state_id = t_states.id
        and upper(t_states.state_code) in ('PERF')) >0
   .EXIT_MESSAGE('По заявке есть платежи с датой больше текущей')

 if upper(.ITEM_STATE_CODE(@pif_pay_id)) = 'CRT'
 begin
  .ITEM_MOVE_STATE(@pif_pay_id,'WAIT_CRT')
 end
 else
 begin
  .ITEM_MOVE_STATE(@pif_pay_id,'CRT_RET')
 end
 update t_paydocs set covered_sum=null where id=@id
end


.UPDATE_STATE
.ACTION_HISTORY

.PAYS_COMPLETE_STATE(@id,0)
.OPERS_ROLL(ALL)

commit tran
  $ENDTEXT(16090858)
 $ENDACTION

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

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

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

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

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

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

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

 $STATE2ACTION(NOT_ACPT.D_PAYDOCS_OUT_VIEW)
  state=NOT_ACPT
  action=D_PAYDOCS_OUT_VIEW
 $ENDSTATE2ACTION

 $STATE2ACTION(NOT_ACPT.SIG_RET)
  state=NOT_ACPT
  action=SIG_RET
 $ENDSTATE2ACTION

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

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

 $STATE2ACTION(NOT_CHECK.COPY2)
  state=NOT_CHECK
  action=COPY2
 $ENDSTATE2ACTION

 $STATE2ACTION(NOT_CHECK.D_PAYDOCS_OUT_VIEW)
  state=NOT_CHECK
  action=D_PAYDOCS_OUT_VIEW
 $ENDSTATE2ACTION

 $STATE2ACTION(PERF.COPY2)
  state=PERF
  action=COPY2
 $ENDSTATE2ACTION

 $STATE2ACTION(PERF.D_PAYDOCS_OUT_VIEW)
  state=PERF
  action=D_PAYDOCS_OUT_VIEW
 $ENDSTATE2ACTION

 $STATE2ACTION(PERF.SIG_RET)
  state=PERF
  action=SIG_RET
 $ENDSTATE2ACTION

 $STATE2ACTION(TOSEND.ACTION_TO_EDIT)
  state=TOSEND
  action=ACTION_TO_EDIT
 $ENDSTATE2ACTION

 $STATE2ACTION(TOSEND.D_PAYDOCS_OUT_VIEW)
  state=TOSEND
  action=D_PAYDOCS_OUT_VIEW
 $ENDSTATE2ACTION

 $STATE2ACTION(TOSEND.OPS)
  state=TOSEND
  action=OPS
 $ENDSTATE2ACTION

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

 $STATE2PROP(ED.IS_COMPLETED)
  state=ED
  prop=IS_COMPLETED
  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.PAYMENT_TYPE)
  state=ED
  prop=PAYMENT_TYPE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

 $STATE2PROP(ED.PAY_PERPOSE)
  state=ED
  prop=PAY_PERPOSE
  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.PERPOSE_STR)
  state=ED
  prop=PERPOSE_STR
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

 $STATE2PROP(NEW.FOUNDATION_DATE)
  state=NEW
  prop=FOUNDATION_DATE
  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.FOUNDATION_NO)
  state=NEW
  prop=FOUNDATION_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

 $STATE2PROP(NEW.PIF_PAY_ID)
  state=NEW
  prop=PIF_PAY_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.TAX_NDS_RATE)
  state=NEW
  prop=TAX_NDS_RATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

 $STATE2PROP(NEW.TELEGR_ACC_STR)
  state=NEW
  prop=TELEGR_ACC_STR
  enable=1
  mandatory=0
  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_ACC_NO)
  state=NEW
  prop=TO_PARTNER_ACC_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

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

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

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

 $STATE2PROP(NEW.TO_PARTNER_CORR_ACC_NO)
  state=NEW
  prop=TO_PARTNER_CORR_ACC_NO
  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.TO_PARTNER_INN)
  state=NEW
  prop=TO_PARTNER_INN
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

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

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

 $STATE2PROP(NOT_CHECK.FOUNDATION_DATE)
  state=NOT_CHECK
  prop=FOUNDATION_DATE
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP

 $STATE2PROP(NOT_CHECK.FOUNDATION_NO)
  state=NOT_CHECK
  prop=FOUNDATION_NO
  enable=1
  mandatory=0
  visible=1
 $ENDSTATE2PROP
$ENDDOC