# Date: 30/01/06 # Version: 105 $DOC(STOCK_EMIS_CHANGE) name=Изменение ЦБ class=3 product=ALD_DSD name_formula=.DEPO_CHANGE_ITEM_NAME remark_formula=@stock_name $STATE(CRT) name=Исполнено class=0 $ENDSTATE $STATE(DEL) name=Удален class=2 $ENDSTATE $STATE(ED) name=В обработке class=0 $ENDSTATE $STATE(ED_END) name=На подтверждении class=0 $ENDSTATE $STATE(NEW) name=Начальный class=1 $ENDSTATE $STATE(WAIT_PAY) name=Ждет оплату class=0 $ENDSTATE $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=1 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(IN_DATE) name=Дата документа field_name=in_date table_name=td_depo_docs field_type=datetime field_length=8 field_scale=3 field_prec=23 page=1 order=2 init_class=1 init_formula=.OPERDAY unique_index=1 numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(WHO_GET) name=Кто принял field_name=who_get table_name=td_depo_docs field_type=varchar field_length=100 field_scale=null field_prec=100 page=1 order=3 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(WHO_PUT) name=Кто отправил field_name=who_put table_name=td_depo_docs field_type=varchar field_length=100 field_scale=null field_prec=100 page=1 order=4 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(OUT_NO) name=Внешний номер field_name=out_no table_name=td_depo_docs field_type=varchar field_length=50 field_scale=null field_prec=50 page=1 order=5 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(IN_NO) name=Номер документа field_name=in_no table_name=td_depo_docs field_type=varchar field_length=50 field_scale=null field_prec=50 page=1 order=6 init_class=0 init_formula=null unique_index=1 numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(CORRESPONDENT_ID) name=Корреспондент field_name=correspondent_id table_name=td_depo_docs field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=7 init_class=0 init_formula=null unique_index=null numerator=null import_type=PARTNERS import_table=null import_field=partner_code import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PAYER_ID) name=Плательщик field_name=payer_id table_name=td_depo_docs field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=8 init_class=0 init_formula=null unique_index=null numerator=null import_type=PARTNERS import_table=null import_field=partner_code 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=9 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(INITIATOR_ID) name=Инициатор field_name=initiator_id table_name=td_depo_docs field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=10 init_class=0 init_formula=null unique_index=null numerator=null import_type=PARTNERS import_table=null import_field=partner_code import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DOCUMENT_FORM_ID) name=Форма документа field_name=document_form_id table_name=td_depo_docs field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=11 init_class=1 init_formula=1 unique_index=null numerator=null import_type=null import_table=null import_field= import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DEPO_DOC_TYPE) name=Входящий исходящий или внутр field_name=depo_doc_type table_name=td_depo_docs field_type=int field_length=4 field_scale=0 field_prec=10 page=1 order=13 init_class=1 init_formula=0 unique_index=1 numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(FOLDER_ID) name=Депозитарная папка field_name=folder_id table_name=td_depo_docs field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=15 init_class=2 init_formula=.DEPO_FOLDER_DEFAULT unique_index=null numerator=null import_type=D_DEPO_FOLDERS import_table=null import_field=depo_folder_code 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=16 init_class=1 init_formula=.CUR("RUR") unique_index=null numerator=null import_type=CUR import_table=null import_field=cur_code 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=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(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=12 init_class=0 init_formula=null unique_index=null numerator=null import_type=TD_STOCK_EMIS import_table=null import_field= import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=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(EMMITENT_ID) name=эммитент field_name=emmitent_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=18 init_class=0 init_formula=null unique_index=null numerator=null import_type=EMITENT_INFO import_table=td_emitent_info import_field=emi_code import_where= ref_table=td_emitent_info ref_key=id ref_display=emi_name ref_alias=partner_short_name ref_where=null $ENDPROP $PROP(EMMISSION_ID) name=emmission_id field_name=emmission_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=19 init_class=0 init_formula=null unique_index=null numerator=null import_type=TD_EMISSIONS import_table=td_emissions import_field=emiss_statereg_no import_where=null ref_table=td_emissions ref_key=id ref_display=stock_emiss_no ref_alias=null ref_where=null $ENDPROP $PROP(STOCK_CODE) name=Шифр бумаги field_name=stock_code table_name=td_stock_emis field_type=varchar field_length=30 field_scale=null field_prec=30 page=2 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(STOCK_NAME) name=название цб field_name=stock_name table_name=td_stock_emis field_type=varchar field_length=150 field_scale=null field_prec=150 page=2 order=21 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(STOCK_NAME_ENG) name=Английское название field_name=stock_name_eng table_name=td_stock_emis field_type=varchar field_length=150 field_scale=null field_prec=150 page=2 order=22 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(STOCK_TYPE_ID) name=Тип ЦБ field_name=stock_type_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 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(ACC_BRANCH_ID) name=Раздел активного счета у регистратора field_name=acc_branch_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=24 init_class=0 init_formula=null unique_index=null numerator=null import_type=DEPO_SUBACC import_table=td_depo_subacc import_field=depo_subacc_no import_where=null ref_table=td_depo_subacc ref_key=id ref_display=depo_subacc_no ref_alias=null ref_where=null $ENDPROP $PROP(VOICES_QTY) name=Количество голосов field_name=voices_qty table_name=td_stock_emis field_type=money field_length=8 field_scale=4 field_prec=19 page=2 order=25 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(ISSUE_FORM_ID) name=Форма выпуска field_name=issue_form_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=26 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DEPLOUMENT_FORM_ID) name=Форма размещения field_name=deploument_form_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=27 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(STOCK_NOMINAL) name=Номинал ЦБ field_name=stock_nominal table_name=td_stock_emis field_type=money field_length=8 field_scale=4 field_prec=19 page=2 order=28 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(STOCK_CURR_ID) name=Валюта номинала field_name=stock_curr_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=29 init_class=0 init_formula=null unique_index=null numerator=null import_type=CUR import_table=t_currencies import_field=cur_code import_where=null ref_table=t_currencies ref_key=id ref_display=cur_name ref_alias=null ref_where=null $ENDPROP $PROP(DIVIDEND_PERIOD_ID) name=Период начисления дивидендов ЦБ field_name=dividend_period_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=30 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(ENTERPRISE_PERCENT) name=Процент от уставного капитала field_name=enterprise_percent table_name=td_stock_emis field_type=money field_length=8 field_scale=4 field_prec=19 page=2 order=31 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DIVIDEND_PERCENT_VALUE) name=Значение процента дивиденда field_name=dividend_percent_value table_name=td_stock_emis field_type=money field_length=8 field_scale=4 field_prec=19 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(PERCENT_VALUE) name=Ставка процента field_name=percent_value table_name=td_stock_emis field_type=money field_length=8 field_scale=4 field_prec=19 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(STOCK_CANCEL_DATE) name=Дата погашения field_name=stock_cancel_date table_name=td_stock_emis field_type=datetime field_length=8 field_scale=3 field_prec=23 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(STOCK_CANCEL_CORSE) name=Причина погашения field_name=stock_cancel_corse table_name=td_stock_emis field_type=varchar field_length=255 field_scale=null field_prec=255 page=2 order=35 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(QTY_IN_EMISSION) name=Количество в выпуске field_name=qty_in_emission table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 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(DEPLOUMENT_QTY) name=Количество размещенных field_name=deploument_qty table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=37 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(LIST_FOLDER_ID) name=Папка справочника field_name=list_folder_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=38 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_COMMENT) name=Комментарий ЦБ field_name=stock_comment table_name=td_stock_emis field_type=varchar field_length=255 field_scale=null field_prec=255 page=2 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(STOCK_RATE_CODE) name=Код в РТС field_name=stock_rate_code table_name=td_stock_emis field_type=varchar field_length=30 field_scale=null field_prec=30 page=2 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(STOCK_ACTIV_FLAG) name=Флаг подтверждения права на актив field_name=stock_activ_flag table_name=td_stock_emis field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=41 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(DATE_B) name=Дата принятия на обслуживание field_name=date_b table_name=td_stock_emis field_type=datetime field_length=8 field_scale=3 field_prec=23 page=2 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(DATE_E) name=Дата снятия с обслуживания field_name=date_e table_name=td_stock_emis field_type=datetime field_length=8 field_scale=3 field_prec=23 page=2 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(STOCK_EMISS_NO) name=Номер выпуска field_name=stock_emiss_no table_name=td_stock_emis field_type=varchar field_length=100 field_scale=null field_prec=100 page=2 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(EMISS_STATEREG_NO) name=Номер гос. регистрации выпуска field_name=emiss_statereg_no table_name=td_stock_emis field_type=varchar field_length=100 field_scale=null field_prec=100 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(EMISS_CANCEL_CORSE) name=Причина погашения выпуска field_name=emiss_cancel_corse table_name=td_stock_emis field_type=varchar field_length=255 field_scale=null field_prec=255 page=2 order=46 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(EMISS_STATEREG_DATE) name=Дата гос. регистрации выпуска field_name=emiss_statereg_date table_name=td_stock_emis field_type=datetime field_length=8 field_scale=3 field_prec=23 page=2 order=47 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(REG_ORGANIS) name=Регистрирующий орган field_name=reg_organis table_name=td_stock_emis field_type=varchar field_length=255 field_scale=null field_prec=255 page=2 order=48 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(RESULTS_REPORT_DATE) name=Дата утверждения итогового отчета field_name=results_report_date table_name=td_stock_emis field_type=datetime field_length=8 field_scale=3 field_prec=23 page=2 order=49 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(BASE_PLACE_ID) name=Площадка базовой котировки field_name=base_place_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=50 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(REEVALUATION) name=Переоценка проводится field_name=reevaluation table_name=td_stock_emis field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=51 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(EMISS_CANCEL_DATE) name=Дата планируемого погашения field_name=emiss_cancel_date table_name=td_stock_emis field_type=datetime field_length=8 field_scale=3 field_prec=23 page=2 order=52 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(QTY_MULT) name=Количественный множитель field_name=qty_mult table_name=td_stock_emis field_type=decimal field_length=9 field_scale=8 field_prec=18 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(STOCK_TYPE_CB_ID) name=Тип ЦБ по классификации Центробанка field_name=stock_type_cb_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=54 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(STOCK_UNIT) name=Единицы учета ЦБ field_name=stock_unit table_name=td_stock_emis field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=55 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(KEEP_MODE) name=Способ хранения field_name=keep_mode table_name=td_stock_emis field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=56 init_class=null 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(LEN_NUMBER) name=Размер номера сертификата field_name=len_number table_name=td_stock_emis field_type=int field_length=4 field_scale=0 field_prec=10 page=2 order=57 init_class=1 init_formula=convert(int,.GET_CONST('DEFAULT_LEN_NUMBER')) 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(QTY_IN_EMISSION_BASE) name=Количество базового актива в выпуске field_name=qty_in_emission_base table_name=td_stock_emis field_type=money field_length=8 field_scale=4 field_prec=19 page=2 order=58 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(ASSET_CODE) name=Код базового актива field_name=asset_code table_name=td_stock_emis field_type=varchar field_length=30 field_scale=null field_prec=30 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 $PROP(ASSET_NAME) name=Наименование базового актива field_name=asset_name table_name=td_stock_emis field_type=varchar field_length=150 field_scale=null field_prec=150 page=2 order=60 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(BASE_ACTIVE_ID) name=Базовый актив field_name=base_active_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=2 order=61 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(REL5) class=1 type=T_OPERATIONS form=ITEM_OPERS_LIST prop=null idname=item_id_s order=999 $ENDRELATION $RELATION(REL10) class=0 type=SIMPLES form=null prop=STOCK_TYPE_CB_ID idname=null order=null $ENDRELATION $RELATION(REL9) class=4 type=D_DEPO_FOLDERS form=null prop=FOLDER_ID idname=null order=null $ENDRELATION $RELATION(REL2) class=0 type=PARTNERS form=null prop=CORRESPONDENT_ID idname=null order=null $ENDRELATION $RELATION(REL8) 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(REL3) class=0 type=ITEMS form=null prop=CHANGED_ITEM_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(REL6) class=1 type=ACTIVDOCS form=ACTION2 prop=null idname=null order=1000 $ENDRELATION $RELATION(REL7) class=2 type=TD_STOCK_EMIS form=UO_STOCKS_LIST prop=CHANGED_ITEM_ID idname=null order=null $ENDRELATION $RELATION(REL11) class=1 type=FOUNDATION_DOCS form=UO_FOUNDATION_DOCS_LIST prop=null idname=depo_doc_id_s order=900 $ENDRELATION $RELATION(REL12) class=1 type=TD_COMIS2OPER form=D_COMIS2OPER_LIST prop=null idname=item_id_s order=910 $ENDRELATION $FORM(D_DEPOSTOCK_P1) name=Просмотр class=5 filter=null target_state= uo=uo_depodoc_edit dw=d_depo_account_p1 procedure=ap_10000000000017140 patterns=GENERIC_VIEW_ITEM_P1 user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=3205 height=1860 proc_text=$TEXT(18205822) 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) /* .ACTION_HISTORY */ end $ENDTEXT(18205822) $ACTION2RELATION(REL3.ITEM_NAME) relation=REL3 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=initiator_code $ENDACTION2RELATION $ACTION2RELATION(REL1.PARTNER_SHORT_NAME) relation=REL1 where=null prop=PARTNER_SHORT_NAME order=4 alias=initiator_short_name $ENDACTION2RELATION $ACTION2RELATION(REL2.PARTNER_CODE) relation=REL2 where=null prop=PARTNER_CODE order=1 alias=corr_code $ENDACTION2RELATION $ACTION2RELATION(REL2.PARTNER_SHORT_NAME) relation=REL2 where=null prop=PARTNER_SHORT_NAME order=4 alias=corr_short_name $ENDACTION2RELATION $ACTION2RELATION(REL8.PARTNER_CODE) relation=REL8 where=null prop=PARTNER_CODE order=1 alias=payer_code $ENDACTION2RELATION $ACTION2RELATION(REL8.PARTNER_SHORT_NAME) relation=REL8 where=null prop=PARTNER_SHORT_NAME order=4 alias=payer_short_name $ENDACTION2RELATION $BIND(BIND3) type=ARH_EDIT action=D_PEREVODARCHIV_P3 class=1 order=2 idname=sid $ENDBIND $BIND(BIND1) type=STOCK_EMIS_CHANGE action=FORM1 class=1 order=1 idname=null $ENDBIND $ENDFORM $FORM(D_STOCK_IMPORT) name=Список для импорта class=5 filter=null target_state= uo=uo_import dw=d_stock_import procedure=null patterns=null user_define=0 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=null $ENDFORM $FORM(FORM1) name=Данные class=5 filter=null target_state= uo=uo_depo_p2_edit dw=d_tmp_stock_group_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=1 form=D_DEPOSTOCK_P1 target_state=ED procedure=ap_10000000000017147 patterns=GENERIC_INSERT_P1 user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=3090 height=2176 proc_text=$TEXT(18205825) 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 .OPERDAY_TEST .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(MAIN) .TYPE_INSERT(MAIN,'BLK') select @changed_item_id=.TYPE_FIELD(id) 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(18205825) $BIND(BIND1) type=STOCK_EMIS_CHANGE action=ACTION7 class=1 order=1 idname=null $ENDBIND $ENDACTION $ACTION(ACTION2) name=Изменить class=2 form=D_DEPOSTOCK_P1 target_state=null procedure=ap_10000000000017150 patterns=GENERIC_UPDATE_P1 user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=3173 height=1880 proc_text=$TEXT(18205825) 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 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) begin tran .UPDATE(ALL,1) .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran select sid = convert(varchar, @id) $ENDTEXT(18205825) $BIND(BIND1) type=STOCK_EMIS_CHANGE action=ACTION7 class=1 order=1 idname=null $ENDBIND $ENDACTION $ACTION(ACTION3) name=Удалить class=3 form=D_DEPOSTOCK_P1 target_state=DEL procedure=ap_10000000000017152 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=3122 height=1644 proc_text=$TEXT(18205825) 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 select @action_id = %ACTION_ID% select @id = convert(numeric, @sid) .CHECK_USER .CHECK_UPDATE .GET_PROPS begin tran .UPDATE_STATE .ACTION_HISTORY if @class_id=1 begin .MAIN_MOVE(L,'DEL',N) end else begin .MAIN_MOVE(L,'CRT',N) end commit tran $ENDTEXT(18205825) $ENDACTION $ACTION(ACTION4) name=Исполнить class=9 form=null target_state=CRT procedure=ap_10000000000017153 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=0 posx=0 posy=0 width=3104 height=1592 proc_text=$TEXT(18205827) 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 declare @operday datetime declare @current_date datetime declare @changed_stock_id numeric declare @old_acc_branch_id numeric declare @is_depo int select @action_id = %ACTION_ID% select @id = convert(numeric, @sid) .CHECK_USER .CHECK_UPDATE .GET_PROPS if @changed_item_id is null .EXIT_MESSAGE('Не задан изменяемый документ') .TRANSACTION_SAVE create table #report( subacc_id numeric null, saldo money null ) create table #oper_list( oper_list_id numeric null, sum_bal money null ) create table #stock_qty ( stock_id numeric, qty money ) select @is_depo=0 select @is_depo=(select isnull((select max(1) from t_partners, t_plans2partner, t_plans where upper(t_partners.partner_code) = 'DEPO' and t_partners.id = t_plans2partner.partner_id and t_plans2partner.plan_id = t_plans.id and upper(t_plans.plan_code) = 'DEPO' and .ITEMS_EXISTS_BY_TYPE(t_partners.id,'PARTNERS_JUR') and .ITEMS_EXISTS(t_plans2partner.id) and .ITEMS_EXISTS(t_plans.id)),0)) if (@class_id=4 or @class_id=3) and @is_depo = 1 begin .DEPO_QUERY_DECLARE(#query) .DEPO_QUERY_CREATE(#query,0) -- Изменяемая бумага insert #query_stocks(id) select td_stock_emis.id from td_stock_emis where .ITEMS_EXISTS_BY_STOCK(td_stock_emis.id) and td_stock_emis.id=@changed_item_id -- Все разделы insert #query_subs(id,acc_id) select td_depo_subacc.id,td_depo_subacc.depo_acc_id from td_depo_subacc where .ITEMS_EXISTS_BY_TYPE(td_depo_subacc.id,'DEPO_SUBACC') and act_or_pass=2 if @@error!=0 return select @operday=.OPERDAY set forceplan on .DEPO_QUERY_EXEC(#query,0,'DEPO','DEPO',@operday,@operday) set forceplan off insert #stock_qty (stock_id,qty) select stock_id,isnull(sum(deb_or_cred*qty),0) from #query_ops group by stock_id .DEPO_QUERY_DESTROY(#query,0) if exists(select 1 from #stock_qty where qty<>0) begin .EXIT_MESSAGE('Нельзя снять с обслуживания(удалить) ЦБ, по которой в системе есть остаток') end end begin tran .ACTION_HISTORY select @current_date = .OPERDAY if (@class_id !=1) begin if ((select .ITEM_STATE_CODE(@changed_item_id) ) = 'BLK') .EXIT_MESSAGE('Данный обьект уже блокирован по изменению данных') .MAIN_MOVE(L,'BLK',YES) end .MAIN_BEGIN select @changed_stock_id = (select t_items.id from t_items,t_item2relation, t_relation where t_relation.s_type_id = @type_id and t_relation.class_id = 2 and t_relation.t_type_id = t_items.type_id and t_item2relation.s_item_id = @id and t_item2relation.rel_id = t_relation.id and t_item2relation.t_item_id = t_items.id) if @class_id=1 begin update td_stock_emis set date_b=@current_date where id in (@id,@changed_item_id) .MAIN_UPDATE(L,YES,ALL,2,@stock_code) .MAIN_MOVE(L,'CRT',YES) end else if @class_id=2 begin select @old_acc_branch_id = (select acc_branch_id from td_stock_emis where id = @changed_stock_id) .UPDATE_EMIS_BRANCH(@changed_stock_id, @old_acc_branch_id, @acc_branch_id, @current_date) .MAIN_UPDATE(L,YES,ALL,2,@stock_code) .MAIN_MOVE(L,'CRT',YES) end else if @class_id=3 begin if exists(select 1 from t_oper_subconto, t_oper_list where t_oper_subconto.item_id = @changed_stock_id and t_oper_subconto.id = t_oper_list.id) .EXIT_MESSAGE('Невозможно удалить ЦБ по которой были проводки') .MAIN_MOVE(L,'DEL',YES) end else if @class_id=4 begin update td_stock_emis set date_e=@current_date where id in (@id,@changed_item_id) .MAIN_MOVE(L,'SFS',YES) end .UPDATE_STATE .CHNG_UPDATE_CATEGOR .ARH_NUMBER_UPDATE commit tran drop table #stock_qty drop table #report drop table #oper_list .TRANSACTION_RESTORE end .EXEC_ACTION(@sid,'STOCK_EMIS_CHANGE','CHANGED_FIELDS') $ENDTEXT(18205827) $ENDACTION $ACTION(ACTION5) name=На уточнение class=9 form=null target_state=ED procedure=ap_10000000000017154 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=0 posx=0 posy=0 width=3296 height=1596 proc_text=$TEXT(18205827) 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 declare @prev_id numeric declare @arch_date datetime select @action_id = %ACTION_ID% select @id = convert(numeric, @sid) .CHECK_USER .CHECK_UPDATE .GET_PROPS begin tran .EXEC_ACTION (@sid, 'STOCK_EMIS_CHANGE', 'CANCELLATION_CHANGES', 1) .UPDATE_STATE .ACTION_HISTORY .OPERS_ROLL if (@class_id !=1) begin if @class_id=4 update td_stock_emis set date_e=null where id=@changed_item_id .MAIN_MOVE(L,'CRT',YES) end else begin .MAIN_MOVE(L,'BLK',YES) end .ARH_FLAG_CLEAR commit tran $ENDTEXT(18205827) $ENDACTION $ACTION(ACTION6) name=На подтверждение class=9 form=null target_state=ED_END procedure=ap_10000000000017155 patterns=GENERIC_MOVE user_define=1 isvisible=1 istab=0 posx=0 posy=0 width=3099 height=1580 proc_text=$TEXT(18205827) 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 select @action_id = %ACTION_ID% select @id = convert(numeric, @sid) .CHECK_USER .CHECK_UPDATE .GET_PROPS if @changed_item_id is null .EXIT_MESSAGE('Не задан изменяемый документ') begin tran .UPDATE_STATE .ACTION_HISTORY if (@class_id !=1) begin if ((select .ITEM_STATE_CODE(@changed_item_id) ) = 'BLK') .EXIT_MESSAGE('Данный обьект уже блокирован по изменению данных') .MAIN_MOVE(L,'BLK',YES) end commit tran $ENDTEXT(18205827) $ENDACTION $ACTION(ACTION7) name=Данные (изм.) class=2 form=FORM1 target_state=null procedure=ap_10000000000017148 patterns=GENERIC_UPDATE_P2 user_define=1 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(18205827) 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 select @action_id = %ACTION_ID% select @id = convert(numeric, @sid) .CHECK_USER .CHECK_UPDATE .ARGCONVERT(ALL, 2) .TEST_UNIQUE(ALL, 2) .GET_PROPS(ALL,1) select @list_folder_id = @folder_id if @qty_mult>1 or isnull(@qty_mult,0)=0 select @qty_mult=1 begin tran .UPDATE_ITEMS .UPDATE(ALL,2) .RELGEN .UPDATE_STATE .ACTION_HISTORY if @class_id =1 begin .MAIN_UPDATE(L,YES,ALL,2,@stock_code) end commit tran $ENDTEXT(18205827) $BIND(BIND1) type=STOCK_EMIS_CHANGE action=FORM1 class=1 order=1 idname=null $ENDBIND $ENDACTION $ACTION(CANCELLATION_CHANGES) name=# Отмена данных class=9 form=null target_state=null procedure=ap_30000000000030330 patterns=null user_define=1 isvisible=1 istab=0 posx=null posy=null width=null height=null proc_text=$TEXT(18205827) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .GET_PROPS .CHECK_CHANGE_AVAILABLE('STOCK_EMIS_CHANGE') if @class_id = 2 and @prev_id is not null begin update td_stock_emis set emmitent_id = t_s.emmitent_id, emmission_id = t_s.emmission_id, stock_code = t_s.stock_code, stock_name = t_s.stock_name, stock_name_eng = t_s.stock_name_eng, stock_type_id = t_s.stock_type_id, acc_branch_id = t_s.acc_branch_id, voices_qty = t_s.voices_qty, issue_form_id = t_s.issue_form_id, deploument_form_id = t_s.deploument_form_id, stock_nominal = t_s.stock_nominal, stock_curr_id = t_s.stock_curr_id, dividend_period_id = t_s.dividend_period_id, enterprise_percent = t_s.enterprise_percent, dividend_percent_value = t_s.dividend_percent_value, percent_value = t_s.percent_value, stock_cancel_date = t_s.stock_cancel_date, stock_cancel_corse = t_s.stock_cancel_corse, qty_in_emission = t_s.qty_in_emission, deploument_qty = t_s.deploument_qty, list_folder_id = t_s.list_folder_id, stock_comment = t_s.stock_comment, stock_rate_code = t_s.stock_rate_code, stock_activ_flag = t_s.stock_activ_flag, date_b = t_s.date_b, date_e = t_s.date_e, stock_emiss_no = t_s.stock_emiss_no, emiss_statereg_no = t_s.emiss_statereg_no, emiss_cancel_corse = t_s.emiss_cancel_corse, emiss_statereg_date = t_s.emiss_statereg_date, reg_organis = t_s.reg_organis, results_report_date = t_s.results_report_date, base_place_id = t_s.base_place_id, reevaluation = t_s.reevaluation, emiss_cancel_date = t_s.emiss_cancel_date, qty_mult = t_s.qty_mult, stock_type_cb_id = t_s.stock_type_cb_id, stock_unit = t_s.stock_unit, payment_place = t_s.payment_place, exch_bill_type_id = t_s.exch_bill_type_id, payer_id = t_s.payer_id, part_payer_id = t_s.part_payer_id, rew_bill_type_id = t_s.rew_bill_type_id, serial = t_s.serial, first_partner_id = t_s.first_partner_id, keep_mode = t_s.keep_mode, endorsement = t_s.endorsement, len_number = t_s.len_number, payer_bill_id = t_s.payer_bill_id, undeploy_date = t_s.undeploy_date from td_stock_emis t_s, td_stock_emis where td_stock_emis.id = @changed_item_id and t_s.id = @prev_id end .END $ENDTEXT(18205827) $ENDACTION $ACTION(CHANGED_FIELDS) name=# Измененные поля class=9 form=null target_state=null procedure=ap_30000000000015535 patterns=GENERIC_MOVE user_define=1 isvisible=1 istab=0 posx=null posy=null width=null height=null proc_text=$TEXT(18205828) create procedure dbo.%PROC% @sid varchar(30) = null as declare @id numeric(18,0) declare @old_id numeric(18,0) declare @operday datetime declare @changed_item_id numeric(18,0) declare @old_emmitent_id numeric(18,0) declare @old_emmitent_name varchar(255) declare @emmitent_name varchar(255) declare @old_stock_code varchar(30) declare @old_stock_name varchar(150) declare @old_stock_type_id numeric(18,0) declare @old_stock_type_name varchar(255) declare @stock_type_name varchar(255) declare @old_acc_branch_id numeric(18,0) declare @old_acc_branch_name varchar(255) declare @acc_branch_name varchar(255) declare @old_issue_form_id numeric(18,0) declare @old_issue_form_name varchar(255) declare @issue_form_name varchar(255) declare @old_deploument_form_id numeric(18,0) declare @old_deploument_form_name varchar(255) declare @deploument_form_name varchar(255) declare @old_stock_nominal money declare @old_stock_curr_id numeric(18,0) declare @old_stock_curr_name varchar(255) declare @stock_curr_name varchar(255) declare @old_stock_cancel_date datetime declare @old_qty_in_emission numeric(18,0) declare @old_deploument_qty numeric(18,0) declare @old_stock_rate_code varchar(30) declare @old_date_b datetime declare @old_date_e datetime declare @old_stock_emiss_no varchar(100) declare @old_emiss_statereg_no varchar(100) declare @old_emiss_statereg_date datetime declare @old_reg_organis varchar(255) declare @old_emiss_cancel_date datetime declare @old_stock_cancel_corse varchar(255) select @id=convert(numeric(18,0),@sid) if @id is null return select @changed_item_id=changed_item_id from td_depo_docs where id = @id delete td_change_fields4partad where chg_id=@id .GET_PROPS(ALL,2) select @operday=(select arch_date from td_depo_docs where id = @id) select @old_id=td_depo_docs.id from td_stock_emis, td_depo_docs where td_depo_docs.changed_item_id = @changed_item_id and .ITEMS_EXISTS_BY_TYPE(td_depo_docs.id,'STOCK_EMIS_CHANGE') and td_depo_docs.id = td_stock_emis.id and td_depo_docs.id < @id and td_depo_docs.arch_date = (select max(depo_docs.arch_date) from td_depo_docs depo_docs where depo_docs.changed_item_id = td_depo_docs.changed_item_id and .ITEMS_EXISTS_BY_TYPE(depo_docs.id,'STOCK_EMIS_CHANGE') and depo_docs.id < @id and depo_docs.arch_date < dateadd(dd,1,@operday)) select @old_emmitent_id = td_stock_emis.emmitent_id, @old_stock_code = td_stock_emis.stock_code, @old_stock_name = td_stock_emis.stock_name, @old_stock_type_id = td_stock_emis.stock_type_id, @old_acc_branch_id = td_stock_emis.acc_branch_id, @old_issue_form_id = td_stock_emis.issue_form_id, @old_deploument_form_id = td_stock_emis.deploument_form_id, @old_stock_nominal = td_stock_emis.stock_nominal, @old_stock_curr_id = td_stock_emis.stock_curr_id, @old_stock_cancel_date = td_stock_emis.stock_cancel_date, @old_stock_cancel_corse = td_stock_emis.stock_cancel_corse, @old_date_b = td_stock_emis.date_b, @old_date_e = td_stock_emis.date_e, @old_stock_emiss_no = td_stock_emis.stock_emiss_no, @old_emiss_statereg_no = td_stock_emis.emiss_statereg_no, @old_emiss_statereg_date = td_stock_emis.emiss_statereg_date, @old_reg_organis = td_stock_emis.reg_organis, @old_emiss_cancel_date = td_stock_emis.emiss_cancel_date from td_stock_emis where td_stock_emis.id=@old_id select @old_emmitent_name=td_emitent_info.emi_code+' : '+td_emitent_info.emi_name from td_emitent_info, td_depo_docs where td_depo_docs.changed_item_id = @old_emmitent_id and .ITEMS_EXISTS_BY_TYPE(td_depo_docs.id,'STOCK_EMIS_CHANGE') and td_depo_docs.id = td_emitent_info.id and td_depo_docs.arch_date = (select max(depo_docs.arch_date) from td_depo_docs depo_docs where depo_docs.changed_item_id = td_depo_docs.changed_item_id and .ITEMS_EXISTS_BY_TYPE(depo_docs.id,'STOCK_EMIS_CHANGE') and depo_docs.arch_date < dateadd(dd,1,@operday)) select @emmitent_name=td_emitent_info.emi_code+' : '+td_emitent_info.emi_name from td_emitent_info, td_depo_docs where td_depo_docs.changed_item_id = @emmitent_id and .ITEMS_EXISTS_BY_TYPE(td_depo_docs.id,'STOCK_EMIS_CHANGE') and td_depo_docs.id = td_emitent_info.id and td_depo_docs.arch_date = (select max(depo_docs.arch_date) from td_depo_docs depo_docs where depo_docs.changed_item_id = td_depo_docs.changed_item_id and .ITEMS_EXISTS_BY_TYPE(depo_docs.id,'STOCK_EMIS_CHANGE') and depo_docs.arch_date < dateadd(dd,1,@operday)) if isnull(@emmitent_name,'') = '' select @emmitent_name=td_emitent_info.emi_code+' : '+td_emitent_info.emi_name from td_emitent_info where td_emitent_info.id = @emmitent_id if isnull(@old_emmitent_name,'') = '' and @old_emmitent_id is not null select @old_emmitent_name=td_emitent_info.emi_code+' : '+td_emitent_info.emi_name from td_emitent_info where td_emitent_info.id = @old_emmitent_id select @old_stock_type_name=stock_type_name from t_stock_types where id = @old_stock_type_id select @stock_type_name=stock_type_name from t_stock_types where id = @stock_type_id select @old_acc_branch_name=td_depo_subacc.depo_subacc_no+' : '+td_depo_subacc.depo_subacc_name from td_depo_subacc, td_depo_docs where td_depo_docs.changed_item_id = @old_acc_branch_id and .ITEMS_EXISTS_BY_TYPE(td_depo_docs.id,'DEPO_SUBACC_CHANGE') and td_depo_docs.id = td_depo_subacc.id and td_depo_docs.arch_date = (select max(depo_docs.arch_date) from td_depo_docs depo_docs where depo_docs.changed_item_id = td_depo_docs.changed_item_id and .ITEMS_EXISTS_BY_TYPE(depo_docs.id,'DEPO_SUBACC_CHANGE') and depo_docs.arch_date < dateadd(dd,1,@operday)) select @acc_branch_name=td_depo_subacc.depo_subacc_no+' : '+td_depo_subacc.depo_subacc_name from td_depo_subacc, td_depo_docs where td_depo_docs.changed_item_id = @acc_branch_id and .ITEMS_EXISTS_BY_TYPE(td_depo_docs.id,'DEPO_SUBACC_CHANGE') and td_depo_docs.id = td_depo_subacc.id and td_depo_docs.arch_date = (select max(depo_docs.arch_date) from td_depo_docs depo_docs where depo_docs.changed_item_id = td_depo_docs.changed_item_id and .ITEMS_EXISTS_BY_TYPE(depo_docs.id,'DEPO_SUBACC_CHANGE') and depo_docs.arch_date < dateadd(dd,1,@operday)) select @old_issue_form_name=simple_name from t_simples where id = @old_issue_form_id and type_id = 3017 select @issue_form_name=simple_name from t_simples where id = @issue_form_id and type_id = 3017 select @old_deploument_form_name=simple_name from t_simples where id = @old_deploument_form_id and type_id = 3030 select @deploument_form_name=simple_name from t_simples where id = @deploument_form_id and type_id = 3030 select @old_stock_curr_name=cur_code from t_currencies where id = @old_stock_curr_id select @stock_curr_name=cur_code from t_currencies where id = @stock_curr_id begin tran .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Эмитент', @old_emmitent_name, @emmitent_name ) .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Внутрениий код ЦБ', @old_stock_code, @stock_code ) .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Наименование ЦБ', @old_stock_name, @stock_name ) .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Тип ЦБ', @old_stock_type_name, @stock_type_name ) .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Реестр ЦБ', @old_acc_branch_name, @acc_branch_name ) .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Форма выпуска', @old_issue_form_name, @issue_form_name ) .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Форма размещение', @old_deploument_form_name, @deploument_form_name ) .CHANGE_TABLE_INSERT_OTHER( @id, @changed_item_id, 'Номинал', @old_stock_nominal, @stock_nominal, (convert(varchar(18),@old_stock_nominal)), (convert(varchar(18),@old_stock_nominal)), 0 ) .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Валюта номинала', @old_stock_curr_name, @stock_curr_name ) .CHANGE_TABLE_INSERT_OTHER( @id, @changed_item_id, 'Дата погашения', @old_stock_cancel_date, @stock_cancel_date, (convert(varchar(10),@old_stock_cancel_date,104)), (convert(varchar(10),@stock_cancel_date,104)), '' ) .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Причина погашения', @old_stock_cancel_corse, @stock_cancel_corse ) .CHANGE_TABLE_INSERT_OTHER( @id, @changed_item_id, 'Дата принятия на обслуживание', @old_date_b, @date_b, (convert(varchar(10),@old_date_b,104)), (convert(varchar(10),@date_b,104)), '' ) .CHANGE_TABLE_INSERT_OTHER( @id, @changed_item_id, 'Дата снятия с обслуживания', @old_date_e, @date_e, (convert(varchar(10),@old_date_e,104)), (convert(varchar(10),@date_e,104)), '' ) .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Номер выпуска', @old_stock_emiss_no, @stock_emiss_no ) .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Номер гос. рег. выпуска', @old_emiss_statereg_no, @emiss_statereg_no ) .CHANGE_TABLE_INSERT_OTHER( @id, @changed_item_id, 'Дата гос. рег. выпуска', @old_emiss_statereg_date, @emiss_statereg_date, (convert(varchar(10),@old_emiss_statereg_date,104)), (convert(varchar(10),@emiss_statereg_date,104)), '' ) .CHANGE_TABLE_INSERT_STR( @id, @changed_item_id, 'Регистрирующий орган', @old_reg_organis, @reg_organis ) .CHANGE_TABLE_INSERT_OTHER( @id, @changed_item_id, 'Дата план.погаш. выпуска', @old_emiss_cancel_date, @emiss_cancel_date, (convert(varchar(10),@old_emiss_cancel_date,104)), (convert(varchar(10),@emiss_cancel_date,104)), '' ) delete td_change_fields4partad where isnull(old_value,'!!!!!') = isnull(new_value,'!!!!!') commit tran $ENDTEXT(18205828) $ENDACTION $STATE2ACTION(CRT.ACTION5) state=CRT action=ACTION5 $ENDSTATE2ACTION $STATE2ACTION(CRT.ACTION6) state=CRT action=ACTION6 $ENDSTATE2ACTION $STATE2ACTION(CRT.D_DEPOSTOCK_P1) state=CRT action=D_DEPOSTOCK_P1 $ENDSTATE2ACTION $STATE2ACTION(CRT.FORM1) state=CRT action=FORM1 $ENDSTATE2ACTION $STATE2ACTION(DEL.D_DEPOSTOCK_P1) state=DEL action=D_DEPOSTOCK_P1 $ENDSTATE2ACTION $STATE2ACTION(DEL.FORM1) state=DEL action=FORM1 $ENDSTATE2ACTION $STATE2ACTION(ED.ACTION2) state=ED action=ACTION2 $ENDSTATE2ACTION $STATE2ACTION(ED.ACTION3) state=ED action=ACTION3 $ENDSTATE2ACTION $STATE2ACTION(ED.ACTION4) state=ED action=ACTION4 $ENDSTATE2ACTION $STATE2ACTION(ED.ACTION5) state=ED action=ACTION5 $ENDSTATE2ACTION $STATE2ACTION(ED.ACTION7) state=ED action=ACTION7 $ENDSTATE2ACTION $STATE2ACTION(ED.D_DEPOSTOCK_P1) state=ED action=D_DEPOSTOCK_P1 $ENDSTATE2ACTION $STATE2ACTION(ED.FORM1) state=ED action=FORM1 $ENDSTATE2ACTION $STATE2ACTION(ED_END.ACTION5) state=ED_END action=ACTION5 $ENDSTATE2ACTION $STATE2ACTION(ED_END.D_DEPOSTOCK_P1) state=ED_END action=D_DEPOSTOCK_P1 $ENDSTATE2ACTION $STATE2ACTION(ED_END.FORM1) state=ED_END action=FORM1 $ENDSTATE2ACTION $STATE2ACTION(NEW.ACTION1) state=NEW action=ACTION1 $ENDSTATE2ACTION $STATE2ACTION(NEW.ACTION7) state=NEW action=ACTION7 $ENDSTATE2ACTION $STATE2ACTION(WAIT_PAY.ACTION4) state=WAIT_PAY action=ACTION4 $ENDSTATE2ACTION $STATE2ACTION(WAIT_PAY.ACTION5) state=WAIT_PAY action=ACTION5 $ENDSTATE2ACTION $STATE2ACTION(WAIT_PAY.D_DEPOSTOCK_P1) state=WAIT_PAY action=D_DEPOSTOCK_P1 $ENDSTATE2ACTION $STATE2ACTION(WAIT_PAY.FORM1) state=WAIT_PAY action=FORM1 $ENDSTATE2ACTION $STATE2PROP(CRT.DOC_COMMENT) state=CRT prop=DOC_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.ACC_BRANCH_ID) state=ED prop=ACC_BRANCH_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.ASSET_CODE) state=ED prop=ASSET_CODE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.ASSET_NAME) state=ED prop=ASSET_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.BASE_ACTIVE_ID) state=ED prop=BASE_ACTIVE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.BASE_PLACE_ID) state=ED prop=BASE_PLACE_ID 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.CORRESPONDENT_ID) state=ED prop=CORRESPONDENT_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.DATE_B) state=ED prop=DATE_B enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.DATE_E) state=ED prop=DATE_E enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.DEPLOUMENT_FORM_ID) state=ED prop=DEPLOUMENT_FORM_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.DEPLOUMENT_QTY) state=ED prop=DEPLOUMENT_QTY enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.DEPO_DOC_TYPE) state=ED prop=DEPO_DOC_TYPE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.DIVIDEND_PERCENT_VALUE) state=ED prop=DIVIDEND_PERCENT_VALUE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.DIVIDEND_PERIOD_ID) state=ED prop=DIVIDEND_PERIOD_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.DOCUMENT_FORM_ID) state=ED prop=DOCUMENT_FORM_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.DOC_COMMENT) state=ED prop=DOC_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.EMISS_CANCEL_CORSE) state=ED prop=EMISS_CANCEL_CORSE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.EMISS_CANCEL_DATE) state=ED prop=EMISS_CANCEL_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.EMISS_STATEREG_DATE) state=ED prop=EMISS_STATEREG_DATE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.EMISS_STATEREG_NO) state=ED prop=EMISS_STATEREG_NO enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.EMMISSION_ID) state=ED prop=EMMISSION_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.EMMITENT_ID) state=ED prop=EMMITENT_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.ENTERPRISE_PERCENT) state=ED prop=ENTERPRISE_PERCENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.FOLDER_ID) state=ED prop=FOLDER_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.INITIATOR_ID) state=ED prop=INITIATOR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.IN_DATE) state=ED prop=IN_DATE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.IN_NO) state=ED prop=IN_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.ISSUE_FORM_ID) state=ED prop=ISSUE_FORM_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.KEEP_MODE) state=ED prop=KEEP_MODE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.LEN_NUMBER) state=ED prop=LEN_NUMBER 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.OUT_DATE) state=ED prop=OUT_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.OUT_NO) state=ED prop=OUT_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.PAYER_ID) state=ED prop=PAYER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.PAY_SUM) state=ED prop=PAY_SUM enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.PERCENT_VALUE) state=ED prop=PERCENT_VALUE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.QTY_IN_EMISSION) state=ED prop=QTY_IN_EMISSION enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.QTY_IN_EMISSION_BASE) state=ED prop=QTY_IN_EMISSION_BASE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.QTY_MULT) state=ED prop=QTY_MULT enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.REEVALUATION) state=ED prop=REEVALUATION enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.REG_ORGANIS) state=ED prop=REG_ORGANIS enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.RESULTS_REPORT_DATE) state=ED prop=RESULTS_REPORT_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_ACTIV_FLAG) state=ED prop=STOCK_ACTIV_FLAG enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_CANCEL_CORSE) state=ED prop=STOCK_CANCEL_CORSE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_CANCEL_DATE) state=ED prop=STOCK_CANCEL_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_CODE) state=ED prop=STOCK_CODE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_COMMENT) state=ED prop=STOCK_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_CURR_ID) state=ED prop=STOCK_CURR_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_EMISS_NO) state=ED prop=STOCK_EMISS_NO enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_NAME) state=ED prop=STOCK_NAME enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_NAME_ENG) state=ED prop=STOCK_NAME_ENG enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_NOMINAL) state=ED prop=STOCK_NOMINAL enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_RATE_CODE) state=ED prop=STOCK_RATE_CODE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_TYPE_ID) state=ED prop=STOCK_TYPE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.STOCK_UNIT) state=ED prop=STOCK_UNIT enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.SUM_CUR_ID) state=ED prop=SUM_CUR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(ED.VOICES_QTY) state=ED prop=VOICES_QTY 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(ED_END.DOC_COMMENT) state=ED_END prop=DOC_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.ACC_BRANCH_ID) state=NEW prop=ACC_BRANCH_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.ASSET_CODE) state=NEW prop=ASSET_CODE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.ASSET_NAME) state=NEW prop=ASSET_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.BASE_ACTIVE_ID) state=NEW prop=BASE_ACTIVE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.BASE_PLACE_ID) state=NEW prop=BASE_PLACE_ID 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.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.DATE_B) state=NEW prop=DATE_B enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.DATE_E) state=NEW prop=DATE_E enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.DEPLOUMENT_FORM_ID) state=NEW prop=DEPLOUMENT_FORM_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.DEPLOUMENT_QTY) state=NEW prop=DEPLOUMENT_QTY enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.DEPO_DOC_TYPE) state=NEW prop=DEPO_DOC_TYPE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.DIVIDEND_PERCENT_VALUE) state=NEW prop=DIVIDEND_PERCENT_VALUE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.DIVIDEND_PERIOD_ID) state=NEW prop=DIVIDEND_PERIOD_ID 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.EMISS_CANCEL_CORSE) state=NEW prop=EMISS_CANCEL_CORSE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.EMISS_CANCEL_DATE) state=NEW prop=EMISS_CANCEL_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.EMISS_STATEREG_DATE) state=NEW prop=EMISS_STATEREG_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.EMISS_STATEREG_NO) state=NEW prop=EMISS_STATEREG_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.EMMISSION_ID) state=NEW prop=EMMISSION_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.EMMITENT_ID) state=NEW prop=EMMITENT_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.ENTERPRISE_PERCENT) state=NEW prop=ENTERPRISE_PERCENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.FOLDER_ID) state=NEW prop=FOLDER_ID enable=1 mandatory=1 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=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.IN_NO) state=NEW prop=IN_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.ISSUE_FORM_ID) state=NEW prop=ISSUE_FORM_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.KEEP_MODE) state=NEW prop=KEEP_MODE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.LEN_NUMBER) state=NEW prop=LEN_NUMBER 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.OUT_DATE) state=NEW prop=OUT_DATE 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.PAYER_ID) state=NEW prop=PAYER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PAY_SUM) state=NEW prop=PAY_SUM enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.PERCENT_VALUE) state=NEW prop=PERCENT_VALUE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.QTY_IN_EMISSION) state=NEW prop=QTY_IN_EMISSION enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.QTY_IN_EMISSION_BASE) state=NEW prop=QTY_IN_EMISSION_BASE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.QTY_MULT) state=NEW prop=QTY_MULT enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.REEVALUATION) state=NEW prop=REEVALUATION enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.REG_ORGANIS) state=NEW prop=REG_ORGANIS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.RESULTS_REPORT_DATE) state=NEW prop=RESULTS_REPORT_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_ACTIV_FLAG) state=NEW prop=STOCK_ACTIV_FLAG enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_CANCEL_CORSE) state=NEW prop=STOCK_CANCEL_CORSE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_CANCEL_DATE) state=NEW prop=STOCK_CANCEL_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_CODE) state=NEW prop=STOCK_CODE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_COMMENT) state=NEW prop=STOCK_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_CURR_ID) state=NEW prop=STOCK_CURR_ID enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_EMISS_NO) state=NEW prop=STOCK_EMISS_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_NAME) state=NEW prop=STOCK_NAME enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_NAME_ENG) state=NEW prop=STOCK_NAME_ENG enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_NOMINAL) state=NEW prop=STOCK_NOMINAL enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_RATE_CODE) state=NEW prop=STOCK_RATE_CODE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_TYPE_CB_ID) state=NEW prop=STOCK_TYPE_CB_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_TYPE_ID) state=NEW prop=STOCK_TYPE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(NEW.STOCK_UNIT) state=NEW prop=STOCK_UNIT 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.VOICES_QTY) state=NEW prop=VOICES_QTY 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 $STATE2PROP(WAIT_PAY.DOC_COMMENT) state=WAIT_PAY prop=DOC_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $ENDDOC