# Date: 11/10/06 # Version: 105 $DOC(TD_STOCK_EMIS_GROUP) name=Группа всех активов class=5 product=ALD_DSD name_formula=null remark_formula=null $STATE(CRT) name=Создан class=0 $ENDSTATE $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=0 order=1 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(EMMISSION_ID) name=Выпуск field_name=emmission_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=0 order=2 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_CODE) name=Шифр бумаги field_name=stock_code table_name=td_stock_emis field_type=varchar field_length=255 field_scale=null field_prec=255 page=0 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(STOCK_NAME) name=название цб field_name=stock_name table_name=td_stock_emis field_type=varchar field_length=255 field_scale=null field_prec=255 page=0 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(STOCK_NAME_ENG) name=Английское название field_name=stock_name_eng table_name=td_stock_emis field_type=varchar field_length=255 field_scale=null field_prec=255 page=0 order=5 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 order=6 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 order=7 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 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(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=0 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(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=0 order=10 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 order=11 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 order=12 init_class=0 init_formula=null unique_index=null numerator=null import_type=null 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(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=0 order=13 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 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(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=0 order=15 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 order=16 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 order=17 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=0 order=18 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 order=19 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 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(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=0 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(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=0 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(STOCK_RATE_CODE) name=Код в РТС field_name=stock_rate_code table_name=td_stock_emis field_type=varchar field_length=255 field_scale=null field_prec=255 page=0 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(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=0 order=24 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=0 order=25 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(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=0 order=26 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(STOCK_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=0 order=27 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 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(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=0 order=29 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 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(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=0 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(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=0 order=32 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 order=33 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(REEVALUATION) name=Переоценка проводится field_name=reevaluation table_name=td_stock_emis field_type=int field_length=4 field_scale=0 field_prec=10 page=0 order=34 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 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(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=0 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(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=0 order=36 init_class=1 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 order=37 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 order=38 init_class=1 init_formula=1 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=0 order=39 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(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=0 order=41 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(ASSET_CODE) name=Код базового актива field_name=asset_code table_name=td_stock_emis field_type=varchar field_length=255 field_scale=null field_prec=255 page=0 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(ASSET_NAME) name=Наименование базового актива field_name=asset_name table_name=td_stock_emis field_type=varchar field_length=255 field_scale=null field_prec=255 page=0 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(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=0 order=40 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(PRICE_STRIKE) name=Цена исполнения опциона (strike) field_name=price_strike table_name=td_stock_emis field_type=decimal field_length=9 field_scale=8 field_prec=18 page=0 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 $RELATION(REL4) class=0 type=CUR form=null prop=STOCK_CURR_ID idname=null order=null $ENDRELATION $RELATION(REL14) class=5 type=CUR form=D_CURRENCY_EDIT prop=null idname=null order=null $ENDRELATION $RELATION(REL5) class=0 type=SIMPLES form=null prop=ISSUE_FORM_ID idname=null order=null $ENDRELATION $RELATION(REL6) class=0 type=SIMPLES form=null prop=STOCK_TYPE_CB_ID idname=null order=null $ENDRELATION $RELATION(REL1) class=5 type=TD_STOCK_EMIS form=STOCK_ITEM prop=null idname=null order=10 $ENDRELATION $RELATION(REL7) class=0 type=EMITENT_INFO form=null prop=EMMITENT_ID idname=null order=null $ENDRELATION $RELATION(REL8) class=0 type=DEPO_SUBACC form=null prop=ACC_BRANCH_ID idname=null order=null $ENDRELATION $RELATION(REL2) class=5 type=FUTURES_OPTIONS form=D_FUCHER_OPCION_EDIT prop=null idname=null order=30 $ENDRELATION $RELATION(REL3) class=5 type=EXCHANGE_BILL form=D_EXCH_BILL_EDIT prop=null idname=null order=20 $ENDRELATION $RELATION(REL12) class=5 type=REALTY_OTHER_ASSETS form=D_REALTY_OTHER_ASSETS_EDID prop=null idname=null order=40 $ENDRELATION $RELATION(REL9) class=0 type=STOCK_TYPE form=null prop=STOCK_TYPE_ID idname=null order=null $ENDRELATION $RELATION(REL15) class=5 type=HP_BOND form=HP_BOND_VIEW prop=null idname=null order=50 $ENDRELATION $FORM(BASE_ACTIVES_LIST) name=Базовый актив class=4 filter=FORM_FILTER target_state= uo=uo_list dw=d_all_stocks_list procedure=ap_21535000002729381 patterns=GENERIC_VIEW_LIST user_define=1 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(13351662) create procedure dbo.%PROC% @sid varchar(30) = null .ARGLIST_FILTER as .BEGIN('N') create table #class(stock_id numeric(18,0) null) .CHECK_USER .CHECK_VIEW_LIST .ARGCONVERT_FILTER if @class_flag is null select @class_flag = 0 if @class_flag = 0 begin .VIEW_LIST and td_stock_emis.id in (select base_active_id from td_stock_emis where base_active_id is not null and .ITEMS_EXISTS_BY_TYPE(td_stock_emis.id, 'FUTURES_OPTIONS')) end else if @class_flag = 1 begin -- По значению классификатора insert into #class(stock_id) select distinct t_item2class.item_id from t_item2class, t_classvalues where t_classvalues.class_id = @class_type_id and t_item2class.value_id = t_classvalues.id --and (t_item2class.value_id=@class_value_id) and t_classvalues.id=@class_value_id --and (t_item2class.value_id between @class_value_id_bb and @class_value_id_ee or @class_value_id_nn is null) .VIEW_LIST and exists(select 1 from #class where #class.stock_id = t_items.id) and td_stock_emis.id in (select base_active_id from td_stock_emis where base_active_id is not null and .ITEMS_EXISTS_BY_TYPE(td_stock_emis.id, 'FUTURES_OPTIONS')) end else if @class_flag = 2 begin -- По НЕ установленному значению классификатора insert into #class(stock_id) select distinct t_item2class.item_id from t_item2class, t_classvalues where t_classvalues.class_id = @class_type_id and t_item2class.value_id = t_classvalues.id and t_classvalues.id=@class_value_id --and (t_item2class.value_id between @class_value_id_bb and @class_value_id_ee or @class_value_id_nn is null) --and (t_item2class.value_id=@class_value_id) .VIEW_LIST and NOT exists(select 1 from #class where #class.stock_id = t_items.id) and td_stock_emis.id in (select base_active_id from td_stock_emis where base_active_id is not null and .ITEMS_EXISTS_BY_TYPE(td_stock_emis.id, 'FUTURES_OPTIONS')) end .END $ENDTEXT(13351662) $ACTION2RELATION(REL4.CUR_CODE) relation=REL4 where=null prop=CUR_CODE order=15 alias=cur_code $ENDACTION2RELATION $ACTION2RELATION(REL6.SIMPLE_NAME) relation=REL6 where=type_id=10200 prop=SIMPLE_NAME order=1 alias=stock_type_cb $ENDACTION2RELATION $ACTION2RELATION(REL5.SIMPLE_NAME) relation=REL5 where=type_id=3017 prop=SIMPLE_NAME order=1 alias=issue_form_name $ENDACTION2RELATION $ACTION2RELATION(REL8.DEPO_SUBACC_NAME) relation=REL8 where=null prop=DEPO_SUBACC_NAME order=18 alias=depo_subacc_name $ENDACTION2RELATION $ACTION2RELATION(REL8.DEPO_SUBACC_NO) relation=REL8 where=null prop=DEPO_SUBACC_NO order=17 alias=depo_subacc_no $ENDACTION2RELATION $ACTION2RELATION(REL9.STOCK_TYPE_NAME) relation=REL9 where=null prop=STOCK_TYPE_NAME order=6 alias=stock_type_name $ENDACTION2RELATION $ACTION2RELATION(REL7.EMI_CODE) relation=REL7 where=null prop=EMI_CODE order=5 alias=emi_code $ENDACTION2RELATION $ACTION2RELATION(REL7.EMI_NAME) relation=REL7 where=null prop=EMI_NAME order=7 alias=emi_name $ENDACTION2RELATION $ENDFORM $FORM(FORM_FILTER) name=Фильтр class=6 filter=null target_state= uo=uo_filter dw=d_all_stocks_filter procedure=null patterns=null user_define=0 isvisible=1 istab=0 posx=0 posy=0 width=2167 height=1288 proc_text=null $FILTER(STOCK_EMISS_NO) type=3 label=Номер выпуска prop=STOCK_EMISS_NO arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(EMISS_STATEREG_NO) type=3 label=Номер гос. регистрации выпуска prop=EMISS_STATEREG_NO arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(STOCK_NAME) type=3 label=название цб prop=STOCK_NAME arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(STOCK_CODE) type=3 label=Шифр бумаги prop=STOCK_CODE arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(STOCK_TYPE_ID) type=1 label=Вид ценных бумаг prop=STOCK_TYPE_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(EMMITENT_ID) type=1 label=Эмитент prop=EMMITENT_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(ISSUE_FORM_ID) type=1 label=Форма выпуска prop=ISSUE_FORM_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(CLASS_TYPE_ID) type=11 label=Тип классификатора prop=null arg_code=class_type_id arg_type=numeric arg_length=null arg_prec=18 arg_scale=0 $ENDFILTER $FILTER(CLASS_VALUE_ID) type=11 label=Значение классификатора prop=null arg_code=class_value_id arg_type=numeric arg_length=null arg_prec=18 arg_scale=0 $ENDFILTER $FILTER(CLASS_FLAG) type=11 label=Флаг выбора классификатора prop=null arg_code=class_flag arg_type=int arg_length=null arg_prec=null arg_scale=null $ENDFILTER $ENDFORM $FORM(UO_STOCK4EMI) name=Список ЦБ по эмитенту class=4 filter=null target_state= uo=uo_list dw=d_all_stocks_list procedure=ap_21535000000804212 patterns=GENERIC_VIEW_LIST user_define=0 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(13351664) create procedure dbo.%PROC% @sid varchar(30) = null .ARGLIST_FILTER as .BEGIN('N') .CHECK_USER .CHECK_VIEW_LIST .ARGCONVERT_FILTER .VIEW_LIST .END $ENDTEXT(13351664) $ACTION2RELATION(REL4.CUR_CODE) relation=REL4 where=null prop=CUR_CODE order=15 alias=cur_code $ENDACTION2RELATION $ACTION2RELATION(REL6.SIMPLE_NAME) relation=REL6 where=type_id=10200 prop=SIMPLE_NAME order=1 alias=stock_type_cb $ENDACTION2RELATION $ACTION2RELATION(REL5.SIMPLE_NAME) relation=REL5 where=type_id=3017 prop=SIMPLE_NAME order=1 alias=issue_form_name $ENDACTION2RELATION $ACTION2RELATION(REL8.DEPO_SUBACC_NAME) relation=REL8 where=null prop=DEPO_SUBACC_NAME order=17 alias=depo_subacc_name $ENDACTION2RELATION $ACTION2RELATION(REL8.DEPO_SUBACC_NO) relation=REL8 where=null prop=DEPO_SUBACC_NO order=18 alias=depo_subacc_no $ENDACTION2RELATION $ACTION2RELATION(REL7.EMI_CODE) relation=REL7 where=null prop=EMI_CODE order=13 alias=emi_code $ENDACTION2RELATION $ACTION2RELATION(REL7.EMI_NAME) relation=REL7 where=null prop=EMI_NAME order=14 alias=emi_name $ENDACTION2RELATION $ACTION2RELATION(REL9.STOCK_TYPE_NAME) relation=REL9 where=null prop=STOCK_TYPE_NAME order=6 alias=stock_type_name $ENDACTION2RELATION $FILTER(EMMITENT_ID) type=11 label=эмитент prop=EMMITENT_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $CALC(FO_TYPE_NAME) class=1 type=varchar calc_lenght=255 calc_prec=null calc_scale=null formula=null label=Тип ЦБ для фьючерсов и опционов order=1 $ENDCALC $ENDFORM $FORM(UO_STOCKS4DEALS_LIST) name=Список ЦБ для выбора в сделке class=4 filter=FORM_FILTER target_state= uo=uo_list dw=d_all_stocks4deals_list procedure=ap_stocks4deals_list patterns=null user_define=1 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(13351664) create procedure dbo.%PROC% @sid varchar(30) = null, @rate_place_id_s varchar(30) = null .ARGLIST_FILTER as .BEGIN('N') create table #class(stock_id numeric(18,0) null) .CHECK_USER .CHECK_VIEW_LIST .ARGCONVERT_FILTER -- Первоначальный текст этой процедуры можно посмотреть в процедуре метода "uo_stock_all_list" -- 09/11/2005 Богаковский добавил фильтрацию фьючерсов и опционов по площадке: -- на площадке, на которой указано значение "Срочные ценные бумаги (фьючерсы и опционы)" классификатора "Типы ЦБ" -- в список ЦБ для выбора в сделке должны попадать только фьючерсы и опционы. -- Должно заполняться поле "Тип ЦБ" для всех ЦБ, включая фьючерсы и опционы. declare @rate_place_id numeric select @rate_place_id=null if isnull(@rate_place_id_s, '')<>'' and isnumeric(@rate_place_id_s)=1 select @rate_place_id = convert(numeric, @rate_place_id_s) /* if @rate_place_id is null .EXIT_MESSAGE('Площадка не задана. Нажмите кнопку поля "Портфель менеджера", выберите реквизиты, а затем выбирайте ЦБ. ') */ --------------------------------------------------------------------------------------------------------- if @class_flag is null select @class_flag = 0 if @class_flag = 0 begin --09/11/2005 Богаковский -- Если площадка проклассифицирована значением "Срочные ценные бумаги (фьючерсы и опционы)" -- то в списке ЦБ должны быть только фьючерсы и опционы -- если площадка не проклассифицирована значением "Срочные ценные бумаги (фьючерсы и опционы)" -- то в списке ЦБ должны быть все ЦБ, кроме фьючерсов и опционов. -- Если площадка не выбрана, то в списке должны быть все ЦБ. if exists(select 1 from t_classes, t_classvalues, td_rate_places where t_classvalues.class_id = t_classes.id and t_classes.id = td_rate_places.class_rate_id and t_classvalues.id = td_rate_places.classvalue_rate_id and td_rate_places.id = @rate_place_id and upper(ltrim(rtrim(t_classvalues.code))) = 'FUTURE_OPTION') .VIEW_LIST and td_stock_emis.base_place_id = @rate_place_id -- Строго по площадке and upper(rtrim(ltrim((select t_types.type_code from t_types where t_types.id=t_items.type_id))))='FUTURES_OPTIONS' else .VIEW_LIST -- and (td_stock_emis.stock_type_id not in (6,7) or @rate_place_id is null) and ((upper(rtrim(ltrim((select t_types.type_code from t_types where t_types.id=t_items.type_id))))<>'FUTURES_OPTIONS') or @rate_place_id is null) end else if @class_flag = 1 begin -- По значению классификатора insert into #class(stock_id) select distinct t_item2class.item_id from t_item2class, t_classvalues where t_classvalues.class_id = @class_type_id and t_item2class.value_id = t_classvalues.id --and (t_item2class.value_id=@class_value_id) and t_classvalues.id=@class_value_id --and (t_item2class.value_id between @class_value_id_bb and @class_value_id_ee or @class_value_id_nn is null) --09/11/2005 Богаковский -- Если площадка проклассифицирована значением "Срочные ценные бумаги (фьючерсы и опционы)" -- то в списке ЦБ должны быть только фьючерсы и опционы -- если площадка не проклассифицирована значением "Срочные ценные бумаги (фьючерсы и опционы)" -- то в списке ЦБ должны быть все ЦБ, кроме фьючерсов и опционов. if exists(select 1 from t_classes, t_classvalues, td_rate_places where t_classvalues.class_id = t_classes.id and t_classes.id = td_rate_places.class_rate_id and t_classvalues.id = td_rate_places.classvalue_rate_id and td_rate_places.id = @rate_place_id and upper(ltrim(rtrim(t_classvalues.code))) = 'FUTURE_OPTION') .VIEW_LIST and td_stock_emis.base_place_id = @rate_place_id -- Строго по площадке and upper(rtrim(ltrim((select t_types.type_code from t_types where t_types.id=t_items.type_id))))='FUTURES_OPTIONS' and exists(select 1 from #class where #class.stock_id = t_items.id) else .VIEW_LIST and ((upper(rtrim(ltrim((select t_types.type_code from t_types where t_types.id=t_items.type_id))))<>'FUTURES_OPTIONS') or @rate_place_id is null) and exists(select 1 from #class where #class.stock_id = t_items.id) end else if @class_flag = 2 begin -- По НЕ установленному значению классификатора insert into #class(stock_id) select distinct t_item2class.item_id from t_item2class, t_classvalues where t_classvalues.class_id = @class_type_id and t_item2class.value_id = t_classvalues.id and t_classvalues.id=@class_value_id --and (t_item2class.value_id between @class_value_id_bb and @class_value_id_ee or @class_value_id_nn is null) --and (t_item2class.value_id=@class_value_id) --09/11/2005 Богаковский -- Если площадка проклассифицирована значением "Срочные ценные бумаги (фьючерсы и опционы)" -- то в списке ЦБ должны быть только фьючерсы и опционы -- если площадка не проклассифицирована значением "Срочные ценные бумаги (фьючерсы и опционы)" -- то в списке ЦБ должны быть все ЦБ, кроме фьючерсов и опционов. if exists(select 1 from t_classes, t_classvalues, td_rate_places where t_classvalues.class_id = t_classes.id and t_classes.id = td_rate_places.class_rate_id and t_classvalues.id = td_rate_places.classvalue_rate_id and td_rate_places.id = @rate_place_id and upper(ltrim(rtrim(t_classvalues.code))) = 'FUTURE_OPTION') .VIEW_LIST and td_stock_emis.base_place_id = @rate_place_id -- Строго по площадке and upper(rtrim(ltrim((select t_types.type_code from t_types where t_types.id=t_items.type_id))))='FUTURES_OPTIONS' and NOT exists(select 1 from #class where #class.stock_id = t_items.id) else .VIEW_LIST and ((upper(rtrim(ltrim((select t_types.type_code from t_types where t_types.id=t_items.type_id))))<>'FUTURES_OPTIONS') or @rate_place_id is null) and NOT exists(select 1 from #class where #class.stock_id = t_items.id) end .END $ENDTEXT(13351664) $ACTION2RELATION(REL4.CUR_CODE) relation=REL4 where=null prop=CUR_CODE order=15 alias=cur_code $ENDACTION2RELATION $ACTION2RELATION(REL6.SIMPLE_NAME) relation=REL6 where=type_id=10200 prop=SIMPLE_NAME order=1 alias=stock_type_cb $ENDACTION2RELATION $ACTION2RELATION(REL5.SIMPLE_NAME) relation=REL5 where=type_id=3017 prop=SIMPLE_NAME order=1 alias=issue_form_name $ENDACTION2RELATION $ACTION2RELATION(REL8.DEPO_SUBACC_NAME) relation=REL8 where=null prop=DEPO_SUBACC_NAME order=9 alias=depo_subacc_name $ENDACTION2RELATION $ACTION2RELATION(REL8.DEPO_SUBACC_NO) relation=REL8 where=null prop=DEPO_SUBACC_NO order=1 alias=depo_subacc_no $ENDACTION2RELATION $ACTION2RELATION(REL7.EMI_CODE) relation=REL7 where=null prop=EMI_CODE order=13 alias=emi_code $ENDACTION2RELATION $ACTION2RELATION(REL7.EMI_NAME) relation=REL7 where=null prop=EMI_NAME order=14 alias=emi_name $ENDACTION2RELATION $ACTION2RELATION(REL9.STOCK_TYPE_NAME) relation=REL9 where=null prop=STOCK_TYPE_NAME order=6 alias=stock_type_name $ENDACTION2RELATION $ACTION2RELATION(REL9.STOCK_TYPE_ID) relation=REL9 where=null prop=STOCK_TYPE_ID order=5 alias=stock_base_type_id_s $ENDACTION2RELATION $ENDFORM $FORM(UO_STOCKS_ALL_LIST) name=Список ЦБ для выбора class=4 filter=FORM_FILTER target_state= uo=uo_list dw=d_all_stocks_list procedure=ap_stocks_all_list patterns=GENERIC_VIEW_LIST user_define=1 isvisible=1 istab=0 posx=0 posy=0 width=2940 height=1706 proc_text=$TEXT(13351664) create procedure dbo.%PROC% @sid varchar(30) = null .ARGLIST_FILTER as .BEGIN('N') create table #class(stock_id numeric(18,0) null) .CHECK_USER .CHECK_VIEW_LIST .ARGCONVERT_FILTER if @class_flag is null select @class_flag = 0 if @class_flag = 0 begin .VIEW_LIST and td_stock_emis.stock_activ_flag = 1 --kashuba_av Бумага не отбражается в списке если в "права на актив" стоит "Нет" end else if @class_flag = 1 begin -- По значению классификатора insert into #class(stock_id) select distinct t_item2class.item_id from t_item2class, t_classvalues where t_classvalues.class_id = @class_type_id and t_item2class.value_id = t_classvalues.id --and (t_item2class.value_id=@class_value_id) and t_classvalues.id=@class_value_id --and (t_item2class.value_id between @class_value_id_bb and @class_value_id_ee or @class_value_id_nn is null) .VIEW_LIST and exists(select 1 from #class where #class.stock_id = t_items.id) and td_stock_emis.stock_activ_flag = 1 end else if @class_flag = 2 begin -- По НЕ установленному значению классификатора insert into #class(stock_id) select distinct t_item2class.item_id from t_item2class, t_classvalues where t_classvalues.class_id = @class_type_id and t_item2class.value_id = t_classvalues.id and t_classvalues.id=@class_value_id --and (t_item2class.value_id between @class_value_id_bb and @class_value_id_ee or @class_value_id_nn is null) --and (t_item2class.value_id=@class_value_id) .VIEW_LIST and NOT exists(select 1 from #class where #class.stock_id = t_items.id) and td_stock_emis.stock_activ_flag = 1 end .END $ENDTEXT(13351664) $ACTION2RELATION(REL4.CUR_CODE) relation=REL4 where=null prop=CUR_CODE order=14 alias=cur_code $ENDACTION2RELATION $ACTION2RELATION(REL6.SIMPLE_NAME) relation=REL6 where=type_id=10200 prop=SIMPLE_NAME order=1 alias=stock_type_cb $ENDACTION2RELATION $ACTION2RELATION(REL5.SIMPLE_NAME) relation=REL5 where=type_id=3017 prop=SIMPLE_NAME order=1 alias=issue_form_name $ENDACTION2RELATION $ACTION2RELATION(REL8.DEPO_SUBACC_NAME) relation=REL8 where=null prop=DEPO_SUBACC_NAME order=9 alias=depo_subacc_name $ENDACTION2RELATION $ACTION2RELATION(REL8.DEPO_SUBACC_NO) relation=REL8 where=null prop=DEPO_SUBACC_NO order=1 alias=depo_subacc_no $ENDACTION2RELATION $ACTION2RELATION(REL9.STOCK_TYPE_NAME) relation=REL9 where=null prop=STOCK_TYPE_NAME order=5 alias=stock_type_name $ENDACTION2RELATION $ACTION2RELATION(REL7.EMI_CODE) relation=REL7 where=null prop=EMI_CODE order=13 alias=emi_code $ENDACTION2RELATION $ACTION2RELATION(REL7.EMI_NAME) relation=REL7 where=null prop=EMI_NAME order=14 alias=emi_name $ENDACTION2RELATION $CALC(FO_TYPE_NAME) class=1 type=varchar calc_lenght=255 calc_prec=null calc_scale=null formula=null label=Тип ЦБ для фьючерсов и опционов order=1 $ENDCALC $CALC(STOCK_BASE_TYPE_ID_S) class=1 type=varchar calc_lenght=30 calc_prec=null calc_scale=null formula=$TEXT(13351664) select t_stock_types.stock_type_id from t_stock_types where td_stock_emis.id=t_items.id and t_stock_types.id = td_stock_emis.stock_type_id $ENDTEXT(13351664) label=ID базового типа ЦБ из простого справочника (6 - фьючерс, 7 - опцион) order=2 $ENDCALC $ENDFORM $STATE2ACTION(CRT.BASE_ACTIVES_LIST) state=CRT action=BASE_ACTIVES_LIST is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.FORM_FILTER) state=CRT action=FORM_FILTER is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.UO_STOCK4EMI) state=CRT action=UO_STOCK4EMI is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.UO_STOCKS4DEALS_LIST) state=CRT action=UO_STOCKS4DEALS_LIST is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.UO_STOCKS_ALL_LIST) state=CRT action=UO_STOCKS_ALL_LIST is_available=1 $ENDSTATE2ACTION $STATE2PROP(CRT.ACC_BRANCH_ID) state=CRT prop=ACC_BRANCH_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.ASSET_CODE) state=CRT prop=ASSET_CODE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.ASSET_NAME) state=CRT prop=ASSET_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.BASE_ACTIVE_ID) state=CRT prop=BASE_ACTIVE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.BASE_PLACE_ID) state=CRT prop=BASE_PLACE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.DATE_B) state=CRT prop=DATE_B enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.DATE_E) state=CRT prop=DATE_E enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.DEPLOUMENT_FORM_ID) state=CRT prop=DEPLOUMENT_FORM_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.DEPLOUMENT_QTY) state=CRT prop=DEPLOUMENT_QTY enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.DIVIDEND_PERCENT_VALUE) state=CRT prop=DIVIDEND_PERCENT_VALUE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.DIVIDEND_PERIOD_ID) state=CRT prop=DIVIDEND_PERIOD_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.EMISS_CANCEL_CORSE) state=CRT prop=EMISS_CANCEL_CORSE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.EMISS_CANCEL_DATE) state=CRT prop=EMISS_CANCEL_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.EMISS_STATEREG_DATE) state=CRT prop=EMISS_STATEREG_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.EMISS_STATEREG_NO) state=CRT prop=EMISS_STATEREG_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.EMMISSION_ID) state=CRT prop=EMMISSION_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.EMMITENT_ID) state=CRT prop=EMMITENT_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.ENTERPRISE_PERCENT) state=CRT prop=ENTERPRISE_PERCENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.ISSUE_FORM_ID) state=CRT prop=ISSUE_FORM_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.KEEP_MODE) state=CRT prop=KEEP_MODE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.LEN_NUMBER) state=CRT prop=LEN_NUMBER 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.PERCENT_VALUE) state=CRT prop=PERCENT_VALUE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.PRICE_STRIKE) state=CRT prop=PRICE_STRIKE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.QTY_IN_EMISSION) state=CRT prop=QTY_IN_EMISSION enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.QTY_IN_EMISSION_BASE) state=CRT prop=QTY_IN_EMISSION_BASE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.QTY_MULT) state=CRT prop=QTY_MULT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.REEVALUATION) state=CRT prop=REEVALUATION enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.REG_ORGANIS) state=CRT prop=REG_ORGANIS enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.RESULTS_REPORT_DATE) state=CRT prop=RESULTS_REPORT_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_ACTIV_FLAG) state=CRT prop=STOCK_ACTIV_FLAG enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_CANCEL_CORSE) state=CRT prop=STOCK_CANCEL_CORSE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_CANCEL_DATE) state=CRT prop=STOCK_CANCEL_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_CODE) state=CRT prop=STOCK_CODE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_COMMENT) state=CRT prop=STOCK_COMMENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_CURR_ID) state=CRT prop=STOCK_CURR_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_EMISS_NO) state=CRT prop=STOCK_EMISS_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_NAME) state=CRT prop=STOCK_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_NAME_ENG) state=CRT prop=STOCK_NAME_ENG enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_NOMINAL) state=CRT prop=STOCK_NOMINAL enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_RATE_CODE) state=CRT prop=STOCK_RATE_CODE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_TYPE_CB_ID) state=CRT prop=STOCK_TYPE_CB_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_TYPE_ID) state=CRT prop=STOCK_TYPE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_UNIT) state=CRT prop=STOCK_UNIT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.VOICES_QTY) state=CRT prop=VOICES_QTY enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $ENDDOC