# Date: 18/10/06 # Version: 105 $DOC(PIF_FUND_CHANGE) name=Изменение ПИФ class=3 product=ALD_UKPIF name_formula='Внесение изменений в анкету ПИФ № '+@in_no+' от '+.DATE_TO_STR(@in_date) remark_formula=@partner_short_name + IsNull(' (' + @regist_sertificate_no + ')', '') $STATE(CRT) name=Исполнено class=0 $ENDSTATE $STATE(DEL) name=Удален class=2 $ENDSTATE $STATE(ED) name=В обработке class=0 $ENDSTATE $STATE(NEW) name=Начальный class=1 $ENDSTATE $PROP(PARTNER_CODE) name=Шифр фонда field_name=partner_code table_name=t_partners field_type=varchar field_length=50 field_scale=null field_prec=50 page=2 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(PARTNER_NAME) name=Название фонда field_name=partner_name table_name=t_partners field_type=varchar field_length=255 field_scale=null field_prec=255 page=2 order=2 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PARTNER_SHORT_NAME) name=Краткое имя партнера field_name=partner_short_name table_name=t_partners field_type=varchar field_length=100 field_scale=null field_prec=100 page=2 order=3 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(IS_COMPANY) name=Компания field_name=is_company table_name=t_partners field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=4 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(LIST_FOLDER_ID) name=Папка документов field_name=list_folder_id table_name=t_partners field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 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(PARTNER_COMMENT) name=Комменарии фонда field_name=partner_comment table_name=t_partners field_type=varchar field_length=255 field_scale=null field_prec=255 page=2 order=6 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(REGIST_SERTIFICATE_NO) name=Регистрационный номер field_name=regist_sertificate_no table_name=t_partners field_type=varchar field_length=50 field_scale=null field_prec=50 page=2 order=7 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(REGIST_SERTIFICATE_DATE) name=Дата регистрации field_name=regist_sertificate_date table_name=t_partners field_type=datetime field_length=8 field_scale=3 field_prec=23 page=2 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(REGIST_ORGANISATION) name=Орган осуществивший регистрацию field_name=regist_organisation table_name=t_partners field_type=varchar field_length=150 field_scale=null field_prec=150 page=2 order=9 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PARTNER_SHORT_NAME_RP) name=Название фонда в родительном падеже field_name=partner_short_name_rp table_name=t_partners_jur field_type=varchar field_length=100 field_scale=null field_prec=100 page=2 order=10 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(J_HEAD_STAFF) name=Должность руководителя field_name=j_head_staff table_name=t_partners_jur field_type=varchar field_length=150 field_scale=null field_prec=150 page=2 order=11 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(J_HEAD_LAST_NAME) name=Фамилия руководителя field_name=j_head_last_name table_name=t_partners_jur field_type=varchar field_length=150 field_scale=null field_prec=150 page=2 order=12 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(J_BOOKKEEPER_STAFF) name=Должность бухгалтера field_name=j_bookkeeper_staff table_name=t_partners_jur field_type=varchar field_length=150 field_scale=null field_prec=150 page=2 order=13 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(J_BOOKKEEPER_NAME) name=Фамилия ИО Бухгалтера field_name=j_bookkeeper_name table_name=t_partners_jur field_type=varchar field_length=150 field_scale=null field_prec=150 page=2 order=14 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(OUT_DATE) name=Внешняя дата корреспондента field_name=out_date table_name=td_depo_docs field_type=datetime field_length=8 field_scale=3 field_prec=23 page=1 order=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(IN_DATE) name=Дата документа field_name=in_date table_name=td_depo_docs field_type=datetime field_length=8 field_scale=3 field_prec=23 page=1 order=16 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(WHO_GET) name=Кто принял field_name=who_get table_name=td_depo_docs field_type=varchar field_length=100 field_scale=null field_prec=100 page=1 order=17 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(WHO_PUT) name=Кто отправил field_name=who_put table_name=td_depo_docs field_type=varchar field_length=100 field_scale=null field_prec=100 page=1 order=18 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(OUT_NO) name=Внешний номер field_name=out_no table_name=td_depo_docs field_type=varchar field_length=50 field_scale=null field_prec=50 page=1 order=19 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(IN_NO) name=Номер документа field_name=in_no table_name=td_depo_docs field_type=varchar field_length=50 field_scale=null field_prec=50 page=1 order=20 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=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(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=22 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PAY_SUM) name=Сумма field_name=pay_sum table_name=td_depo_docs field_type=money field_length=8 field_scale=4 field_prec=19 page=1 order=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(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=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(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=25 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(DEPO_DOC_TYPE) name=Входящий исходящий field_name=depo_doc_type table_name=td_depo_docs field_type=int field_length=4 field_scale=0 field_prec=10 page=1 order=27 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(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=29 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=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(DOC_COMMENT) name=Коментарии к компании field_name=doc_comment table_name=td_depo_docs field_type=varchar field_length=255 field_scale=null field_prec=255 page=1 order=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(CHANGED_ITEM_ID) name=Изменяемый справочник field_name=changed_item_id table_name=td_depo_docs field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 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(CLASS_ID) name=Класс действия field_name=class_id table_name=td_depo_docs field_type=int field_length=4 field_scale=0 field_prec=10 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(CTRL_COMP_ID) name=Управляющая компания field_name=ctrl_comp_id table_name=td_pay_fond field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=32 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(ROUND_SUM) name=Число знаков округления денежных сумм field_name=round_sum table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=38 init_class=1 init_formula=2 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(SPEC_DEP_ID) name=Специализированный депозитарий field_name=spec_dep_id table_name=td_pay_fond field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=42 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_METHOD_ID) name=Метод поиска документа поступления при списании: field_name=out_method_id table_name=td_pay_fond field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=46 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(OUT_SUM_METHOD_ID) name=Метод вычисления цены пая при списании field_name=out_sum_method_id table_name=td_pay_fond field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=47 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(REGISTR_MODE_ID) name=Способ учета ЦБ field_name=registr_mode_id table_name=td_pay_fond field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=48 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(PROFIT_OPER_MODE_ID) name=Способ отражения прибыли при реализации ЦБ field_name=profit_oper_mode_id table_name=td_pay_fond field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=49 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(START_DATE) name=Дата начала первичного размещения паев field_name=start_date table_name=td_pay_fond field_type=datetime field_length=8 field_scale=3 field_prec=23 page=2 order=33 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(FOND_TYPE) name=Тип фонда field_name=fond_type table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=34 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(VAL_TYPE) name=Тип оценки стоимости пая field_name=val_type table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 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(START_PRICE) name=Цена первичного пая размещения field_name=start_price table_name=td_pay_fond field_type=decimal field_length=9 field_scale=8 field_prec=18 page=2 order=36 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(PRICE_CUR_ID) name=Валюта первичного пая размещения field_name=price_cur_id table_name=td_pay_fond field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=37 init_class=0 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(ROUND_QTY) name=Число знаков округления количества паев field_name=round_qty table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=39 init_class=1 init_formula=5 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(SPEC_REG_ID) name=Специализированный регистратор field_name=spec_reg_id table_name=td_pay_fond field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=43 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(FOND_INTERVAL) name=Интервал начисления резервов field_name=fond_interval table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=44 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_ID) name=ID ценной бумаги - пая field_name=stock_id table_name=td_pay_fond field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 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(ROUND_RATE) name=Числ. знаков окуругления курсов ЦБ field_name=round_rate table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=40 init_class=1 init_formula=2 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(ROUND_ASSET) name=Числ. знаков округления цены списания field_name=round_asset table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=41 init_class=1 init_formula=2 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(UK_RESERVE) name=Резерв на вознаграждение УК field_name=uk_reserve table_name=td_pay_fond field_type=money field_length=8 field_scale=4 field_prec=19 page=2 order=50 init_class=1 init_formula=0 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(OTHER_RESERVE) name=Резерв на прочие расходы field_name=other_reserve table_name=td_pay_fond field_type=money field_length=8 field_scale=4 field_prec=19 page=2 order=51 init_class=1 init_formula=0 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(FOND_CALC_TYPE) name=Тип расчета сумм field_name=fond_calc_type table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=53 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(ACC_IN_REG) name=СД ведет реестр field_name=acc_in_reg table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=54 init_class=1 init_formula=0 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(UK_SUBACC_ID) name=Раздел эмис.счета УК в реестре field_name=uk_subacc_id table_name=td_pay_fond field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=55 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_REG_CONTROL) name=Контроль спецрегистратора field_name=is_reg_control table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=56 init_class=1 init_formula=0 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(CLAIM_WAIT_DAYS) name=Срок возврата д.с. по неподтвержденным платежам field_name=claim_wait_days table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=57 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(SD_RESERVE) name=Резерв на СД, СР, аудитора, оценщика field_name=sd_reserve table_name=td_pay_fond field_type=money field_length=8 field_scale=4 field_prec=19 page=2 order=52 init_class=1 init_formula=0 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_ACC_MODE) name=Метод учета паев (1-среднее,2-fifo,3-lifo) field_name=pays_acc_mode table_name=td_pay_fond field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=58 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(START_END_DATE) name=Дата окончания первичного размещения field_name=start_end_date table_name=td_pay_fond field_type=datetime field_length=8 field_scale=3 field_prec=23 page=2 order=59 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(REL9) class=1 type=T_OPERATIONS form=ITEM_OPERS_LIST prop=null idname=item_id_s order=999 $ENDRELATION $RELATION(REL12) class=4 type=D_DEPO_FOLDERS form=null prop=FOLDER_ID idname=null order=null $ENDRELATION $RELATION(REL3) class=0 type=PARTNERS form=null prop=CORRESPONDENT_ID idname=null order=null $ENDRELATION $RELATION(REL2) class=0 type=PARTNERS form=null prop=PAYER_ID idname=null order=null $ENDRELATION $RELATION(REL1) class=0 type=PARTNERS form=null prop=INITIATOR_ID idname=null order=null $ENDRELATION $RELATION(REL5) class=0 type=ITEMS form=null prop=CHANGED_ITEM_ID idname=null order=null $ENDRELATION $RELATION(REL4) class=2 type=PIF_FUND form=PIF_FUND_LIST prop=CHANGED_ITEM_ID idname=null order=null $ENDRELATION $RELATION(REL8) class=1 type=ACTIONS_HISTORY form=UO_ACTIONS_HISTORY_LIST prop=null idname=null order=998 $ENDRELATION $RELATION(REL10) class=1 type=ACTIVDOCS form=ACTION2 prop=null idname=null order=1000 $ENDRELATION $RELATION(REL6) class=1 type=ACTIVDOCS form=ACTION1 prop=null idname=null order=1010 $ENDRELATION $FORM(FORM1) name=Просмотр class=5 filter=null target_state= uo=uo_depodoc_edit dw=d_depodoc_p1 procedure=ap_10000000000004945 patterns=GENERIC_VIEW_ITEM_P1 user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=3145 height=1844 proc_text=$TEXT(20121774) create procedure dbo.%PROC% @sid varchar(30) = null as declare @id numeric, @action_id numeric, @user_id numeric, @state_id numeric, @type_id numeric, @type_id_s varchar(30), @new_state_id numeric, @state_name_id_s varchar(30) begin select @id = convert(numeric, @sid) select @action_id = %ACTION_ID% select @type_id_s = NULL select @state_name_id_s = NULL .CHECK_USER .CHECK_VIEW_ITEM if @id = -1 begin begin tran .GET_PROPS .CHECK_INSERT .INIT_VARS(B) .INSERT_ITEMS .INSERT commit tran end .VIEW_ITEM(ALL,1) end $ENDTEXT(20121774) $ACTION2RELATION(REL5.ITEM_NAME) relation=REL5 where=null prop=ITEM_NAME order=2 alias=changed_item_name $ENDACTION2RELATION $ACTION2RELATION(REL1.PARTNER_CODE) relation=REL1 where=null prop=PARTNER_CODE order=1 alias=ini_code $ENDACTION2RELATION $ACTION2RELATION(REL1.PARTNER_SHORT_NAME) relation=REL1 where=null prop=PARTNER_SHORT_NAME order=4 alias=ini_short_name $ENDACTION2RELATION $ACTION2RELATION(REL3.PARTNER_CODE) relation=REL3 where=null prop=PARTNER_CODE order=1 alias=corespondent_code $ENDACTION2RELATION $ACTION2RELATION(REL3.PARTNER_SHORT_NAME) relation=REL3 where=null prop=PARTNER_SHORT_NAME order=4 alias=corespondent_short_name $ENDACTION2RELATION $ACTION2RELATION(REL2.PARTNER_CODE) relation=REL2 where=null prop=PARTNER_CODE order=1 alias=payer_code $ENDACTION2RELATION $ACTION2RELATION(REL2.PARTNER_SHORT_NAME) relation=REL2 where=null prop=PARTNER_SHORT_NAME order=4 alias=payer_short_name $ENDACTION2RELATION $BIND(BIND1) type=PIF_FUND_CHANGE action=PAY_FOND_CHANG_P2 class=1 order=null idname=null $ENDBIND $ENDFORM $FORM(PAY_FOND_CHANG_P2) name=Данные class=5 filter=null target_state= uo=uo_depo_p2_edit dw=d_pif_fund_edit procedure=null patterns=null user_define=0 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=null $ENDFORM $ACTION(ACTION1) name=Данные (изм.) class=2 form=PAY_FOND_CHANG_P2 target_state=null procedure=ap_10000000000316985 patterns=GENERIC_UPDATE_P2 user_define=1 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(20121776) 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) if @out_method_id is null and @out_sum_method_id=2 .EXIT_MESSAGE('Задайте метод поиска документа при списании') if @out_sum_method_id=1 select @out_method_id=1 .GET_PROPS(ALL,1) if isnull(@acc_in_reg,0) = 1 and @spec_reg_id is null select @spec_reg_id=.SREG_ID if isnull(@acc_in_reg,0) = 1 and @spec_reg_id<>.SREG_ID .EXIT_MESSAGE('Неверно указан спецрегистратор') if isnull(@acc_in_reg,0) = 1 and @stock_id is null .EXIT_MESSAGE('Задайте ЦБ - пай ПИФ') if isnull(@acc_in_reg,0) = 1 and @uk_subacc_id is null .EXIT_MESSAGE('Задайте раздел эмиссионного счета УК в реестре') if (select e.partner_id from td_emitent_info e, td_stock_emis s where s.emmitent_id=e.id and s.id=@stock_id and .ITEMS_EXISTS_BY_TYPE(e.id,'emitent_info')) != @ctrl_comp_id and @stock_id is not null .EXIT_MESSAGE('Эмитентом выбранной ЦБ (пая) должна быть УК ПИФ') if isnull(@acc_in_reg,0) = 1 and @uk_subacc_id is not null and not exists(select 1 from td_depo_subacc s, td_depo_acctypes a, td_depo_subacc_types st, td_depo_accounts ac where s.id=@uk_subacc_id and s.depo_acc_id=ac.id and s.depo_subacc_type_id=st.id and ac.depo_acctypes_id=a.id and ac.partner_id=@ctrl_comp_id and st.depo_subacc_type_code = 'OB' and a.depo_acctype_code = 'EP') .EXIT_MESSAGE('Ошибка при выборе раздела эмиссионного счета УК в реестре') if isnull(@acc_in_reg,0) = 1 select @is_reg_control=0 -- Количество знаков в паях if @round_qty is null or @round_qty>8 or @round_qty<0 select @round_qty=5 .UPDATE_ITEMS .UPDATE(ALL,2) .RELGEN .UPDATE_STATE .ACTION_HISTORY if @class_id =1 begin .MAIN_UPDATE(L,YES,ALL,2,@partner_short_name,Y) end commit tran $ENDTEXT(20121776) $ENDACTION $ACTION(ACTION2) name=Добавить class=1 form=FORM1 target_state=ED procedure=ap_10000000000316986 patterns=GENERIC_INSERT_P1 user_define=0 isvisible=0 istab=1 posx=0 posy=0 width=2889 height=2560 proc_text=$TEXT(20121777) 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) begin tran .UPDATE(ALL,1) .RELGEN .UPDATE_STATE .ACTION_HISTORY if (@class_id =1) begin .TYPE_INIT('PIF_FUND',9) .TYPE_INSERT(MAIN,'BLK',9,N) select @changed_item_id=.TYPE_FIELD(id,9) update td_depo_docs set changed_item_id= @changed_item_id where id=@id .RELGEN end commit tran select @sid = convert(varchar,@id) select @sid end $ENDTEXT(20121777) $BIND(BIND1) type=PIF_FUND_CHANGE action=ACTION1 class=1 order=2 idname=null $ENDBIND $ENDACTION $ACTION(ACTION3) name=Изменить class=2 form=FORM1 target_state=null procedure=ap_10000000000316988 patterns=GENERIC_UPDATE_P1 user_define=0 isvisible=0 istab=1 posx=0 posy=0 width=2885 height=2380 proc_text=$TEXT(20121777) 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) .UPDATE(ALL,1) .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran select sid = convert(varchar, @id) $ENDTEXT(20121777) $BIND(BIND1) type=PIF_FUND_CHANGE action=ACTION1 class=1 order=2 idname=null $ENDBIND $ENDACTION $ACTION(ACTION5) name=На уточнение class=9 form=null target_state=ED procedure=ap_10000000000316990 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(20121777) 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 /*-------Проводки ----------*/ .GET_PROPS if (@class_id != 1) begin .MAIN_MOVE(L,'CRT',YES) end else begin .MAIN_MOVE(L,'BLK',YES) end .ARH_FLAG_CLEAR .OPERS_ROLL commit tran $ENDTEXT(20121777) $BIND(BIND1) type=PIF_FUND_CHANGE action=ACTION1 class=1 order=2 idname=null $ENDBIND $ENDACTION $ACTION(ACTION6) name=Исполнить class=9 form=null target_state=CRT procedure=ap_10000000000316992 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(20121777) 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(@old_state_code) .ASSIGN(@old_state_code,(.ITEM_STATE_CODE(@id))) .CHECK_USER .CHECK_UPDATE .UPDATE_STATE .ACTION_HISTORY /*-------Проводки ----------*/ .GET_PROPS if @changed_item_id is null .EXIT_MESSAGE('Не задан изменяемый документ') .MAIN_BEGIN .ID_VAR(@fund_sum_method) select @fund_sum_method=(select out_sum_method_id from td_pay_fond where id=@changed_item_id) if @class_id=1 or @class_id=2 begin .INT_VAR(@old_round_qty) if isnull(@acc_in_reg,0) = 1 begin if isnull((select a.fund_id from td_depo_accounts a, td_depo_subacc s where s.id=@uk_subacc_id and s.depo_acc_id=a.id),@changed_item_id)<>@changed_item_id .EXIT_MESSAGE('В выбранном эмиссионном счете УК в реестре указан другой фонд') else begin update td_depo_accounts set fund_id=@changed_item_id from td_depo_subacc s where s.id=@uk_subacc_id and s.depo_acc_id=td_depo_accounts.id update td_depo_accounts set fund_id=@changed_item_id from td_depo_subacc s, td_depo_accounts a, td_depo_docs d, td_depo_accounts where s.id=@uk_subacc_id and s.depo_acc_id=a.id and a.id=d.changed_item_id and td_depo_accounts.id=d.id update tr_reg_journal set fund_id=@changed_item_id from td_depo_subacc s, td_depo_accounts a, td_depo_docs d where s.id=@uk_subacc_id and s.depo_acc_id=a.id and a.id=d.changed_item_id and tr_reg_journal.op_id=d.id end end select @old_round_qty=round_qty from td_pay_fond where id=@changed_item_id if @class_id=2 and (@round_qty>4 or @old_round_qty>4) and @round_qty<>@old_round_qty begin .EXIT_MESSAGE('Перед сменой количества знаков после запятой в количестве паев необходима проверка и перечет остатков') /* exec ap_pif_pays_qty_recalc @changed_item_id,@old_round_qty,@round_qty --,0 if @@error != 0 begin rollback tran return end */ end .MAIN_UPDATE(L,YES,ALL,2,(@partner_short_name + ' (' + @regist_sertificate_no + ')'),Y) .MAIN_MOVE(L,'CRT',YES) -- Количество знаков в паях update td_pay_fond set bal_qty_mult= (case when isnull(@round_qty,0)>4 and isnull(@round_qty,0)<=8 then convert(decimal(18,8),power(convert(decimal(18,8),10),@round_qty-4)) else 1 end) where id=@changed_item_id end else if @class_id=3 begin .MAIN_MOVE(L,'DEL',YES) end /*--------------План счетов----------------------------------------*/ .ID_VAR(@fund_plan_id) .ASSIGN(@fund_plan_id,(.ARG_PLAN('PIF_ACCOUNT'))) if (@class_id =1)and not exists(.PLAN2PARTNER_ID(@fund_plan_id, @changed_item_id)) begin .ID_VAR(@fund_plan_id1) .TYPE_INIT('plans2partner',5) .TYPE_ASSIGN(partner_id,@changed_item_id,5) .TYPE_ASSIGN(plan_id,@fund_plan_id,5) .TYPE_INSERT('plans2partner','CRT',5) update td_pay_fond set acc_pattern_id=@fund_plan_id where id=@changed_item_id end -------------------------------------------------------------------------- -- Смена метода учета с партионного на средний - Перевод на общий документ -------------------------------------------------------------------------- declare @operday datetime declare @q_saldo_de_x money declare @saldo_de_x money declare @s1_id_x numeric declare @s2_id_x numeric declare @acc00_id numeric declare @acc_id numeric declare @partion_id numeric declare @pif_plan_id numeric select @partion_id=(select td_depo_docs.id from td_depo_docs where in_no='COMMON_ASSET_INPUT' and .ITEMS_EXISTS_BY_TYPE(td_depo_docs.id,'letter_in')) select @operday=.OPERDAY select @pif_plan_id = .ARG_PLAN('PIF_ACCOUNT') select @acc00_id = .SD_ACCID_FROM_EFFNO(@pif_plan_id,'00') if @class_id=2 begin if @fund_sum_method != @out_sum_method_id and @out_sum_method_id=1 begin .NAME_VAR(@subc_str) .TRANSACTION_SAVE /*--------- Недвижимость и прочие активы ---------*/ select @subc_str='' .SUBC_STR_ADD(@subc_str,'other_assets',null,Y) .SUBC_STR_ADD(@subc_str,'doc_item',null,Y) -- 01.1 select @acc_id = .SD_ACCID_FROM_EFFNO(@pif_plan_id,'01.1') .TOTALS_QUERY(@changed_item_id,@pif_plan_id,@operday,@operday,@acc_id,@subc_str,L,N,Y) declare tmp_cur_x cursor for select q_saldo_de, saldo_de, s1_id, s2_id from #tmp_osv open tmp_cur_x begin tran fetch tmp_cur_x into @q_saldo_de_x, @saldo_de_x, @s1_id_x, @s2_id_x while (.CURSOR_STATE=0) begin if @saldo_de_x !=0 or @q_saldo_de_x !=0 begin .OPERATION(@changed_item_id,@pif_plan_id,@operday,@acc00_id,@acc_id,@saldo_de_x,'RUR',@operday,null,@q_saldo_de_x,'Изменение учетной политики фонда на средневзвешенную',N) .UPDATE_SUBC(K,'other_assets',@s2_id_x,@operation_id,N) .UPDATE_SUBC(К,'doc_item',@s1_id_x,@operation_id,N) .SUBC_CHECK .OPERATION(@changed_item_id,@pif_plan_id,@operday,@acc_id,@acc00_id,@saldo_de_x,'RUR',@operday,@q_saldo_de_x,null,'Изменение учетной политики фонда на средневзвешенную',N) .UPDATE_SUBC(D,'doc_item',@partion_id,@operation_id,N) .UPDATE_SUBC(D,'other_assets',@s2_id_x,@operation_id,N) .SUBC_CHECK end fetch tmp_cur_x into @q_saldo_de_x, @saldo_de_x, @s1_id_x, @s2_id_x end commit tran close tmp_cur_x .DEALLOCATE tmp_cur_x -- 08.1 select @acc_id = .SD_ACCID_FROM_EFFNO(@pif_plan_id,'08.1') .TOTALS_QUERY(@changed_item_id,@pif_plan_id,@operday,@operday,@acc_id,@subc_str,L,N,Y) declare tmp_cur_x cursor for select q_saldo_de, saldo_de, s1_id, s2_id from #tmp_osv open tmp_cur_x begin tran fetch tmp_cur_x into @q_saldo_de_x, @saldo_de_x, @s1_id_x, @s2_id_x while (.CURSOR_STATE=0) begin if @saldo_de_x !=0 or @q_saldo_de_x !=0 begin .OPERATION(@changed_item_id,@pif_plan_id,@operday,@acc00_id,@acc_id,@saldo_de_x,'RUR',@operday,null,@q_saldo_de_x,'Изменение учетной политики фонда на средневзвешенную',N) .UPDATE_SUBC(K,'other_assets',@s2_id_x,@operation_id,N) .UPDATE_SUBC(К,'doc_item',@s1_id_x,@operation_id,N) .SUBC_CHECK .OPERATION(@changed_item_id,@pif_plan_id,@operday,@acc_id,@acc00_id,@saldo_de_x,'RUR',@operday,@q_saldo_de_x,null,'Изменение учетной политики фонда на средневзвешенную',N) .UPDATE_SUBC(D,'doc_item',@partion_id,@operation_id,N) .UPDATE_SUBC(D,'other_assets',@s2_id_x,@operation_id,N) .SUBC_CHECK end fetch tmp_cur_x into @q_saldo_de_x, @saldo_de_x, @s1_id_x, @s2_id_x end commit tran close tmp_cur_x .DEALLOCATE tmp_cur_x -- 58.3 select @acc_id = .SD_ACCID_FROM_EFFNO(@pif_plan_id,'58.3') .TOTALS_QUERY(@changed_item_id,'PIF_ACCOUNT',@operday,@operday,@acc_id,@subc_str,L,N,Y) declare tmp_cur_x cursor for select q_saldo_de, saldo_de, s1_id, s2_id from #tmp_osv open tmp_cur_x begin tran fetch tmp_cur_x into @q_saldo_de_x, @saldo_de_x, @s1_id_x, @s2_id_x while (.CURSOR_STATE=0) begin if @saldo_de_x !=0 or @q_saldo_de_x !=0 begin .OPERATION(@changed_item_id,@pif_plan_id,@operday,@acc00_id,@acc_id,@saldo_de_x,'RUR',@operday,null,@q_saldo_de_x,'Изменение учетной политики фонда на средневзвешенную',N) .UPDATE_SUBC(K,'stock_emis',@s1_id_x,@operation_id,N) .UPDATE_SUBC(К,'doc_item',@s2_id_x,@operation_id,N) .SUBC_CHECK .OPERATION(@changed_item_id,@pif_plan_id,@operday,@acc_id,@acc00_id,@saldo_de_x,'RUR',@operday,@q_saldo_de_x,null,'Изменение учетной политики фонда на средневзвешенную',N) .UPDATE_SUBC(D,'doc_item',@partion_id,@operation_id,N) .UPDATE_SUBC(D,'stock_emis',@s1_id_x,@operation_id,N) .SUBC_CHECK end fetch tmp_cur_x into @q_saldo_de_x, @saldo_de_x, @s1_id_x, @s2_id_x end commit tran close tmp_cur_x .DEALLOCATE tmp_cur_x /*--------- ЦБ ---------*/ select @subc_str='' .SUBC_STR_ADD(@subc_str,'stock_emis',null,Y) .SUBC_STR_ADD(@subc_str,'doc_item',null,Y) -- 58.1 select @acc_id = .SD_ACCID_FROM_EFFNO(@pif_plan_id,'58.1') .TOTALS_QUERY(@changed_item_id,@pif_plan_id,@operday,@operday,@acc_id,@subc_str,L,N,Y) declare tmp_cur_x cursor for select q_saldo_de, saldo_de, s1_id, s2_id from #tmp_osv open tmp_cur_x begin tran fetch tmp_cur_x into @q_saldo_de_x, @saldo_de_x, @s1_id_x, @s2_id_x while (.CURSOR_STATE=0) begin if @saldo_de_x !=0 or @q_saldo_de_x !=0 begin .OPERATION(@changed_item_id,@pif_plan_id,@operday,@acc00_id,@acc_id,@saldo_de_x,'RUR',@operday,null,@q_saldo_de_x,'Изменение учетной политики фонда на средневзвешенную',N) .UPDATE_SUBC(K,'stock_emis',@s1_id_x,@operation_id,N) .UPDATE_SUBC(К,'doc_item',@s2_id_x,@operation_id,N) .SUBC_CHECK .OPERATION(@changed_item_id,@pif_plan_id,@operday,@acc_id,@acc00_id,@saldo_de_x,'RUR',@operday,@q_saldo_de_x,null,'Изменение учетной политики фонда на средневзвешенную',N) .UPDATE_SUBC(D,'doc_item',@partion_id,@operation_id,N) .UPDATE_SUBC(D,'stock_emis',@s1_id_x,@operation_id,N) .SUBC_CHECK end fetch tmp_cur_x into @q_saldo_de_x, @saldo_de_x, @s1_id_x, @s2_id_x end commit tran close tmp_cur_x .DEALLOCATE tmp_cur_x -- 76.6 select @acc_id = .SD_ACCID_FROM_EFFNO(@pif_plan_id,'76.6') .TOTALS_QUERY(@changed_item_id,@pif_plan_id,@operday,@operday,@acc_id,@subc_str,L,N,Y) declare tmp_cur_x cursor for select q_saldo_de, saldo_de, s1_id, s2_id from #tmp_osv open tmp_cur_x begin tran fetch tmp_cur_x into @q_saldo_de_x, @saldo_de_x, @s1_id_x, @s2_id_x while (.CURSOR_STATE=0) begin if @saldo_de_x !=0 or @q_saldo_de_x !=0 begin .OPERATION(@changed_item_id,@pif_plan_id,@operday,@acc00_id,@acc_id,@saldo_de_x,'RUR',@operday,null,@q_saldo_de_x,'Изменение учетной политики фонда на средневзвешенную',N) .UPDATE_SUBC(K,'stock_emis',@s1_id_x,@operation_id,N) .UPDATE_SUBC(К,'doc_item',@s2_id_x,@operation_id,N) .SUBC_CHECK .OPERATION(@changed_item_id,@pif_plan_id,@operday,@acc_id,@acc00_id,@saldo_de_x,'RUR',@operday,@q_saldo_de_x,null,'Изменение учетной политики фонда на средневзвешенную',N) .UPDATE_SUBC(D,'doc_item',@partion_id,@operation_id,N) .UPDATE_SUBC(D,'stock_emis',@s1_id_x,@operation_id,N) .SUBC_CHECK end fetch tmp_cur_x into @q_saldo_de_x, @saldo_de_x, @s1_id_x, @s2_id_x end commit tran close tmp_cur_x .DEALLOCATE tmp_cur_x /*------------------------*/ .DROP_QUERY_TABLES(#tmp_osv) .TRANSACTION_RESTORE end end .ARH_NUMBER_UPDATE commit tran $ENDTEXT(20121777) $BIND(BIND1) type=PIF_FUND_CHANGE action=ACTION1 class=1 order=2 idname=null $ENDBIND $ENDACTION $ACTION(ACTION7) name=Удалить class=9 form=null target_state=DEL procedure=ap_10000000000316994 patterns=GENERIC_MOVE user_define=0 isvisible=0 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(20121777) 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 /*-------Проводки ----------*/ .GET_PROPS if @class_id=1 begin .MAIN_MOVE(L,'DEL',N) end else begin .MAIN_MOVE(L,'CRT',N) end commit tran $ENDTEXT(20121777) $BIND(BIND1) type=PIF_FUND_CHANGE action=ACTION1 class=1 order=2 idname=null $ENDBIND $ENDACTION $ACTION(PIF_PAYS_QTY_RECALC) name=Пересчет количества паев в проводках class=9 form=null target_state=null procedure=ap_pif_pays_qty_recalc patterns=GENERIC_MOVE user_define=1 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(20121779) create procedure dbo.%PROC% @fund_id numeric, @old_round_qty integer, @round_qty integer, @is_decrease_control integer = 1 as if (@round_qty<=4 and @old_round_qty<=4) or @round_qty=@old_round_qty or (@round_qty>8 or @old_round_qty>8) return if (@round_qty<@old_round_qty) and @is_decrease_control=1 .EXIT_MESSAGE('Невозможна автоматическая коррекция проводок при уменьшении количества знаков после запятой') .TRANSACTION_SAVE create table #oper_list( id numeric, head_id numeric, qty_sum money ) create table #manual_opers( id numeric, deb_qty money, cred_qty money ) begin tran .ID_VAR(@fund_plan_id) .ID_VAR(@plans2partner_id) .ID_VAR(@acc86_id) .INT_VAR(@digits) declare @mult money if @round_qty>@old_round_qty select @digits=@round_qty-(case when @old_round_qty>4 then @old_round_qty else 4 end) else select @digits=@old_round_qty-(case when @round_qty>4 then @round_qty else 4 end) select @mult=convert(money,power(convert(decimal(18,8),10),@digits)) if @round_qty<@old_round_qty select @mult=1/@mult select @fund_plan_id=.ARG_PLAN('PIF_ACCOUNT') select @plans2partner_id=.PLAN2PARTNER_ID(@fund_plan_id, @fund_id) select @acc86_id = .SD_ACCID_FROM_EFFNO(@fund_plan_id,'96.1') insert into #oper_list(id, head_id, qty_sum) select ol.id, ol.head_id, ol.qty_sum from t_oper_list ol where ol.acc_id=@acc86_id and ol.partner2plan_id=@plans2partner_id update #oper_list set qty_sum=qty_sum*@mult update t_oper_list set qty_sum=#oper_list.qty_sum from #oper_list where #oper_list.id=t_oper_list.id insert into #manual_opers (id, deb_qty, cred_qty) select mo.id, (case when mo.debet_id=@acc86_id then mo.deb_qty else 0 end), (case when mo.credit_id=@acc86_id then mo.cred_qty else 0 end) from t_manual_opers mo where mo.jour_id in (select mj.id from t_operations o, #oper_list ol, t_man_jours mj where o.id=ol.head_id and o.item_id=mj.id and mj.owner_id=@fund_id) and (mo.debet_id=@acc86_id or mo.credit_id=@acc86_id) update #manual_opers set deb_qty=deb_qty*@mult, cred_qty=cred_qty*@mult update t_manual_opers set deb_qty=#manual_opers.deb_qty from #manual_opers where #manual_opers.id=t_manual_opers.id and #manual_opers.deb_qty<>0 update t_manual_opers set cred_qty=#manual_opers.cred_qty from #manual_opers where #manual_opers.id=t_manual_opers.id and #manual_opers.cred_qty<>0 commit tran drop table #oper_list drop table #manual_opers .TRANSACTION_RESTORE $ENDTEXT(20121779) $ENDACTION $STATE2ACTION(CRT.ACTION1) state=CRT action=ACTION1 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.ACTION2) state=CRT action=ACTION2 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.ACTION3) state=CRT action=ACTION3 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.ACTION5) state=CRT action=ACTION5 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.ACTION6) state=CRT action=ACTION6 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.ACTION7) state=CRT action=ACTION7 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.FORM1) state=CRT action=FORM1 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.PAY_FOND_CHANG_P2) state=CRT action=PAY_FOND_CHANG_P2 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.PIF_PAYS_QTY_RECALC) state=CRT action=PIF_PAYS_QTY_RECALC is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.ACTION1) state=DEL action=ACTION1 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.ACTION2) state=DEL action=ACTION2 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.ACTION3) state=DEL action=ACTION3 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.ACTION5) state=DEL action=ACTION5 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.ACTION6) state=DEL action=ACTION6 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.ACTION7) state=DEL action=ACTION7 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.FORM1) state=DEL action=FORM1 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.PAY_FOND_CHANG_P2) state=DEL action=PAY_FOND_CHANG_P2 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.PIF_PAYS_QTY_RECALC) state=DEL action=PIF_PAYS_QTY_RECALC is_available=0 $ENDSTATE2ACTION $STATE2ACTION(ED.ACTION1) state=ED action=ACTION1 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(ED.ACTION2) state=ED action=ACTION2 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(ED.ACTION3) state=ED action=ACTION3 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(ED.ACTION5) state=ED action=ACTION5 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(ED.ACTION6) state=ED action=ACTION6 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(ED.ACTION7) state=ED action=ACTION7 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(ED.FORM1) state=ED action=FORM1 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(ED.PAY_FOND_CHANG_P2) state=ED action=PAY_FOND_CHANG_P2 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(ED.PIF_PAYS_QTY_RECALC) state=ED action=PIF_PAYS_QTY_RECALC is_available=0 $ENDSTATE2ACTION $STATE2ACTION(NEW.ACTION1) state=NEW action=ACTION1 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(NEW.ACTION2) state=NEW action=ACTION2 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(NEW.ACTION3) state=NEW action=ACTION3 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(NEW.ACTION5) state=NEW action=ACTION5 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(NEW.ACTION6) state=NEW action=ACTION6 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(NEW.ACTION7) state=NEW action=ACTION7 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(NEW.FORM1) state=NEW action=FORM1 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(NEW.PAY_FOND_CHANG_P2) state=NEW action=PAY_FOND_CHANG_P2 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(NEW.PIF_PAYS_QTY_RECALC) state=NEW action=PIF_PAYS_QTY_RECALC is_available=0 $ENDSTATE2ACTION $STATE2PROP(CRT.ACC_IN_REG) state=CRT prop=ACC_IN_REG enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.CHANGED_ITEM_ID) state=CRT prop=CHANGED_ITEM_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.CLAIM_WAIT_DAYS) state=CRT prop=CLAIM_WAIT_DAYS enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.CLASS_ID) state=CRT prop=CLASS_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.CORRESPONDENT_ID) state=CRT prop=CORRESPONDENT_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.CTRL_COMP_ID) state=CRT prop=CTRL_COMP_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.DEPO_DOC_TYPE) state=CRT prop=DEPO_DOC_TYPE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.DOCUMENT_FORM_ID) state=CRT prop=DOCUMENT_FORM_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.DOC_COMMENT) state=CRT prop=DOC_COMMENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.FOLDER_ID) state=CRT prop=FOLDER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.FOND_CALC_TYPE) state=CRT prop=FOND_CALC_TYPE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.FOND_INTERVAL) state=CRT prop=FOND_INTERVAL enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.FOND_TYPE) state=CRT prop=FOND_TYPE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.INITIATOR_ID) state=CRT prop=INITIATOR_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.IN_DATE) state=CRT prop=IN_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.IN_NO) state=CRT prop=IN_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.IS_COMPANY) state=CRT prop=IS_COMPANY enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.IS_REG_CONTROL) state=CRT prop=IS_REG_CONTROL enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.J_BOOKKEEPER_NAME) state=CRT prop=J_BOOKKEEPER_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.J_BOOKKEEPER_STAFF) state=CRT prop=J_BOOKKEEPER_STAFF enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.J_HEAD_LAST_NAME) state=CRT prop=J_HEAD_LAST_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.J_HEAD_STAFF) state=CRT prop=J_HEAD_STAFF enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.LIST_FOLDER_ID) state=CRT prop=LIST_FOLDER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.OTHER_RESERVE) state=CRT prop=OTHER_RESERVE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.OUT_DATE) state=CRT prop=OUT_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.OUT_METHOD_ID) state=CRT prop=OUT_METHOD_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.OUT_NO) state=CRT prop=OUT_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.OUT_SUM_METHOD_ID) state=CRT prop=OUT_SUM_METHOD_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.PARTNER_CODE) state=CRT prop=PARTNER_CODE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.PARTNER_COMMENT) state=CRT prop=PARTNER_COMMENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.PARTNER_NAME) state=CRT prop=PARTNER_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.PARTNER_SHORT_NAME) state=CRT prop=PARTNER_SHORT_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.PARTNER_SHORT_NAME_RP) state=CRT prop=PARTNER_SHORT_NAME_RP enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.PAYER_ID) state=CRT prop=PAYER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.PAYS_ACC_MODE) state=CRT prop=PAYS_ACC_MODE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.PAY_SUM) state=CRT prop=PAY_SUM enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.PRICE_CUR_ID) state=CRT prop=PRICE_CUR_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.PROFIT_OPER_MODE_ID) state=CRT prop=PROFIT_OPER_MODE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.REGISTR_MODE_ID) state=CRT prop=REGISTR_MODE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.REGIST_ORGANISATION) state=CRT prop=REGIST_ORGANISATION enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.REGIST_SERTIFICATE_DATE) state=CRT prop=REGIST_SERTIFICATE_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.REGIST_SERTIFICATE_NO) state=CRT prop=REGIST_SERTIFICATE_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.ROUND_ASSET) state=CRT prop=ROUND_ASSET enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.ROUND_QTY) state=CRT prop=ROUND_QTY enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.ROUND_RATE) state=CRT prop=ROUND_RATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.ROUND_SUM) state=CRT prop=ROUND_SUM enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.SD_RESERVE) state=CRT prop=SD_RESERVE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.SPEC_DEP_ID) state=CRT prop=SPEC_DEP_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.SPEC_REG_ID) state=CRT prop=SPEC_REG_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.START_DATE) state=CRT prop=START_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.START_END_DATE) state=CRT prop=START_END_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.START_PRICE) state=CRT prop=START_PRICE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_ID) state=CRT prop=STOCK_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.SUM_CUR_ID) state=CRT prop=SUM_CUR_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.UK_RESERVE) state=CRT prop=UK_RESERVE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.UK_SUBACC_ID) state=CRT prop=UK_SUBACC_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.VAL_TYPE) state=CRT prop=VAL_TYPE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.WHO_GET) state=CRT prop=WHO_GET enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.WHO_PUT) state=CRT prop=WHO_PUT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ACC_IN_REG) state=DEL prop=ACC_IN_REG enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CHANGED_ITEM_ID) state=DEL prop=CHANGED_ITEM_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CLAIM_WAIT_DAYS) state=DEL prop=CLAIM_WAIT_DAYS enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CLASS_ID) state=DEL prop=CLASS_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CORRESPONDENT_ID) state=DEL prop=CORRESPONDENT_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CTRL_COMP_ID) state=DEL prop=CTRL_COMP_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DEPO_DOC_TYPE) state=DEL prop=DEPO_DOC_TYPE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DOCUMENT_FORM_ID) state=DEL prop=DOCUMENT_FORM_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DOC_COMMENT) state=DEL prop=DOC_COMMENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.FOLDER_ID) state=DEL prop=FOLDER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.FOND_CALC_TYPE) state=DEL prop=FOND_CALC_TYPE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.FOND_INTERVAL) state=DEL prop=FOND_INTERVAL enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.FOND_TYPE) state=DEL prop=FOND_TYPE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INITIATOR_ID) state=DEL prop=INITIATOR_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.IN_DATE) state=DEL prop=IN_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.IN_NO) state=DEL prop=IN_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.IS_COMPANY) state=DEL prop=IS_COMPANY enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.IS_REG_CONTROL) state=DEL prop=IS_REG_CONTROL enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.J_BOOKKEEPER_NAME) state=DEL prop=J_BOOKKEEPER_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.J_BOOKKEEPER_STAFF) state=DEL prop=J_BOOKKEEPER_STAFF enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.J_HEAD_LAST_NAME) state=DEL prop=J_HEAD_LAST_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.J_HEAD_STAFF) state=DEL prop=J_HEAD_STAFF enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.LIST_FOLDER_ID) state=DEL prop=LIST_FOLDER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.OTHER_RESERVE) state=DEL prop=OTHER_RESERVE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.OUT_DATE) state=DEL prop=OUT_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.OUT_METHOD_ID) state=DEL prop=OUT_METHOD_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.OUT_NO) state=DEL prop=OUT_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.OUT_SUM_METHOD_ID) state=DEL prop=OUT_SUM_METHOD_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PARTNER_CODE) state=DEL prop=PARTNER_CODE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PARTNER_COMMENT) state=DEL prop=PARTNER_COMMENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PARTNER_NAME) state=DEL prop=PARTNER_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PARTNER_SHORT_NAME) state=DEL prop=PARTNER_SHORT_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PARTNER_SHORT_NAME_RP) state=DEL prop=PARTNER_SHORT_NAME_RP enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PAYER_ID) state=DEL prop=PAYER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PAYS_ACC_MODE) state=DEL prop=PAYS_ACC_MODE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PAY_SUM) state=DEL prop=PAY_SUM enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PRICE_CUR_ID) state=DEL prop=PRICE_CUR_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PROFIT_OPER_MODE_ID) state=DEL prop=PROFIT_OPER_MODE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.REGISTR_MODE_ID) state=DEL prop=REGISTR_MODE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.REGIST_ORGANISATION) state=DEL prop=REGIST_ORGANISATION enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.REGIST_SERTIFICATE_DATE) state=DEL prop=REGIST_SERTIFICATE_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.REGIST_SERTIFICATE_NO) state=DEL prop=REGIST_SERTIFICATE_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ROUND_ASSET) state=DEL prop=ROUND_ASSET enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ROUND_QTY) state=DEL prop=ROUND_QTY enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ROUND_RATE) state=DEL prop=ROUND_RATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ROUND_SUM) state=DEL prop=ROUND_SUM enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.SD_RESERVE) state=DEL prop=SD_RESERVE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.SPEC_DEP_ID) state=DEL prop=SPEC_DEP_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.SPEC_REG_ID) state=DEL prop=SPEC_REG_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.START_DATE) state=DEL prop=START_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.START_END_DATE) state=DEL prop=START_END_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.START_PRICE) state=DEL prop=START_PRICE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STOCK_ID) state=DEL prop=STOCK_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.SUM_CUR_ID) state=DEL prop=SUM_CUR_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.UK_RESERVE) state=DEL prop=UK_RESERVE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.UK_SUBACC_ID) state=DEL prop=UK_SUBACC_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.VAL_TYPE) state=DEL prop=VAL_TYPE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.WHO_GET) state=DEL prop=WHO_GET enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.WHO_PUT) state=DEL prop=WHO_PUT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(ED.ACC_IN_REG) state=ED prop=ACC_IN_REG enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.CHANGED_ITEM_ID) state=ED prop=CHANGED_ITEM_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.CLAIM_WAIT_DAYS) state=ED prop=CLAIM_WAIT_DAYS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.CLASS_ID) state=ED prop=CLASS_ID 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.CTRL_COMP_ID) state=ED prop=CTRL_COMP_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.DEPO_DOC_TYPE) state=ED prop=DEPO_DOC_TYPE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.DOCUMENT_FORM_ID) state=ED prop=DOCUMENT_FORM_ID enable=1 mandatory=0 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=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.FOND_CALC_TYPE) state=ED prop=FOND_CALC_TYPE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.FOND_INTERVAL) state=ED prop=FOND_INTERVAL enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.FOND_TYPE) state=ED prop=FOND_TYPE enable=1 mandatory=0 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=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.IN_NO) state=ED prop=IN_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.IS_COMPANY) state=ED prop=IS_COMPANY enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.IS_REG_CONTROL) state=ED prop=IS_REG_CONTROL enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.J_BOOKKEEPER_NAME) state=ED prop=J_BOOKKEEPER_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.J_BOOKKEEPER_STAFF) state=ED prop=J_BOOKKEEPER_STAFF enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.J_HEAD_LAST_NAME) state=ED prop=J_HEAD_LAST_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.J_HEAD_STAFF) state=ED prop=J_HEAD_STAFF enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.LIST_FOLDER_ID) state=ED prop=LIST_FOLDER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.OTHER_RESERVE) state=ED prop=OTHER_RESERVE 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_METHOD_ID) state=ED prop=OUT_METHOD_ID 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.OUT_SUM_METHOD_ID) state=ED prop=OUT_SUM_METHOD_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.PARTNER_CODE) state=ED prop=PARTNER_CODE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.PARTNER_COMMENT) state=ED prop=PARTNER_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.PARTNER_NAME) state=ED prop=PARTNER_NAME enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.PARTNER_SHORT_NAME) state=ED prop=PARTNER_SHORT_NAME enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.PARTNER_SHORT_NAME_RP) state=ED prop=PARTNER_SHORT_NAME_RP 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.PAYS_ACC_MODE) state=ED prop=PAYS_ACC_MODE 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.PRICE_CUR_ID) state=ED prop=PRICE_CUR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.PROFIT_OPER_MODE_ID) state=ED prop=PROFIT_OPER_MODE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.REGISTR_MODE_ID) state=ED prop=REGISTR_MODE_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.REGIST_ORGANISATION) state=ED prop=REGIST_ORGANISATION enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.REGIST_SERTIFICATE_DATE) state=ED prop=REGIST_SERTIFICATE_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.REGIST_SERTIFICATE_NO) state=ED prop=REGIST_SERTIFICATE_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.ROUND_ASSET) state=ED prop=ROUND_ASSET enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.ROUND_QTY) state=ED prop=ROUND_QTY enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.ROUND_RATE) state=ED prop=ROUND_RATE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.ROUND_SUM) state=ED prop=ROUND_SUM enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.SD_RESERVE) state=ED prop=SD_RESERVE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.SPEC_DEP_ID) state=ED prop=SPEC_DEP_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.SPEC_REG_ID) state=ED prop=SPEC_REG_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.START_DATE) state=ED prop=START_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.START_END_DATE) state=ED prop=START_END_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.START_PRICE) state=ED prop=START_PRICE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_ID) state=ED prop=STOCK_ID 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.UK_RESERVE) state=ED prop=UK_RESERVE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.UK_SUBACC_ID) state=ED prop=UK_SUBACC_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.VAL_TYPE) state=ED prop=VAL_TYPE 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 $STATE2PROP(NEW.ACC_IN_REG) state=NEW prop=ACC_IN_REG enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.CHANGED_ITEM_ID) state=NEW prop=CHANGED_ITEM_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.CLAIM_WAIT_DAYS) state=NEW prop=CLAIM_WAIT_DAYS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.CLASS_ID) state=NEW prop=CLASS_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.CORRESPONDENT_ID) state=NEW prop=CORRESPONDENT_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.CTRL_COMP_ID) state=NEW prop=CTRL_COMP_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.DEPO_DOC_TYPE) state=NEW prop=DEPO_DOC_TYPE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.DOCUMENT_FORM_ID) state=NEW prop=DOCUMENT_FORM_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.DOC_COMMENT) state=NEW prop=DOC_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.FOLDER_ID) state=NEW prop=FOLDER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.FOND_CALC_TYPE) state=NEW prop=FOND_CALC_TYPE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.FOND_INTERVAL) state=NEW prop=FOND_INTERVAL enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.FOND_TYPE) state=NEW prop=FOND_TYPE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.INITIATOR_ID) state=NEW prop=INITIATOR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.IN_DATE) state=NEW prop=IN_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.IN_NO) state=NEW prop=IN_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.IS_COMPANY) state=NEW prop=IS_COMPANY enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.IS_REG_CONTROL) state=NEW prop=IS_REG_CONTROL enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.J_BOOKKEEPER_NAME) state=NEW prop=J_BOOKKEEPER_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.J_BOOKKEEPER_STAFF) state=NEW prop=J_BOOKKEEPER_STAFF enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.J_HEAD_LAST_NAME) state=NEW prop=J_HEAD_LAST_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.J_HEAD_STAFF) state=NEW prop=J_HEAD_STAFF enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.LIST_FOLDER_ID) state=NEW prop=LIST_FOLDER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.OTHER_RESERVE) state=NEW prop=OTHER_RESERVE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.OUT_DATE) state=NEW prop=OUT_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.OUT_METHOD_ID) state=NEW prop=OUT_METHOD_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.OUT_NO) state=NEW prop=OUT_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.OUT_SUM_METHOD_ID) state=NEW prop=OUT_SUM_METHOD_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PARTNER_CODE) state=NEW prop=PARTNER_CODE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PARTNER_COMMENT) state=NEW prop=PARTNER_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PARTNER_NAME) state=NEW prop=PARTNER_NAME enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PARTNER_SHORT_NAME) state=NEW prop=PARTNER_SHORT_NAME enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PARTNER_SHORT_NAME_RP) state=NEW prop=PARTNER_SHORT_NAME_RP enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PAYER_ID) state=NEW prop=PAYER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PAYS_ACC_MODE) state=NEW prop=PAYS_ACC_MODE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PAY_SUM) state=NEW prop=PAY_SUM enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PRICE_CUR_ID) state=NEW prop=PRICE_CUR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PROFIT_OPER_MODE_ID) state=NEW prop=PROFIT_OPER_MODE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.REGISTR_MODE_ID) state=NEW prop=REGISTR_MODE_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.REGIST_ORGANISATION) state=NEW prop=REGIST_ORGANISATION enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.REGIST_SERTIFICATE_DATE) state=NEW prop=REGIST_SERTIFICATE_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.REGIST_SERTIFICATE_NO) state=NEW prop=REGIST_SERTIFICATE_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.ROUND_ASSET) state=NEW prop=ROUND_ASSET enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.ROUND_QTY) state=NEW prop=ROUND_QTY enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.ROUND_RATE) state=NEW prop=ROUND_RATE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.ROUND_SUM) state=NEW prop=ROUND_SUM enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.SD_RESERVE) state=NEW prop=SD_RESERVE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.SPEC_DEP_ID) state=NEW prop=SPEC_DEP_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.SPEC_REG_ID) state=NEW prop=SPEC_REG_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.START_DATE) state=NEW prop=START_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.START_END_DATE) state=NEW prop=START_END_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.START_PRICE) state=NEW prop=START_PRICE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_ID) state=NEW prop=STOCK_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.SUM_CUR_ID) state=NEW prop=SUM_CUR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.UK_RESERVE) state=NEW prop=UK_RESERVE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.UK_SUBACC_ID) state=NEW prop=UK_SUBACC_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.VAL_TYPE) state=NEW prop=VAL_TYPE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.WHO_GET) state=NEW prop=WHO_GET enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.WHO_PUT) state=NEW prop=WHO_PUT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $ENDDOC