# Date: 02/10/06 # Version: 105 $DOC(HP_PYMNT_SCHEDULE) name=График платежей class=1 product=ALD_HIPO name_formula=null remark_formula=null $STATE(BEG) name=Начальный class=1 $ENDSTATE $STATE(CHARGED) name=В обработке class=0 $ENDSTATE $STATE(CONF) name=Подтвержден class=0 $ENDSTATE $STATE(CRT) name=Создан class=0 $ENDSTATE $STATE(DEL) name=Удален class=2 $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=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PAYER_ID) name=Плательщик field_name=payer_id table_name=td_depo_docs field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=8 init_class=0 init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PAY_SUM) name=Сумма field_name=pay_sum table_name=td_depo_docs field_type=money field_length=8 field_scale=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=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DOCUMENT_FORM_ID) name=Форма документа field_name=document_form_id table_name=td_depo_docs field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=11 init_class=1 init_formula=1 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DEPO_DOC_TYPE) name=Входящий исходящий или внутр field_name=depo_doc_type table_name=td_depo_docs field_type=int field_length=4 field_scale=0 field_prec=10 page=1 order=12 init_class=1 init_formula=0 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(FOLDER_ID) name=Депозитарная папка field_name=folder_id table_name=td_depo_docs field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=13 init_class=2 init_formula=.DEPO_FOLDER_DEFAULT unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(SUM_CUR_ID) name=Валюта суммы field_name=sum_cur_id table_name=td_depo_docs field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=14 init_class=1 init_formula=.CUR("RUR") unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DOC_COMMENT) name=Коментарии field_name=doc_comment table_name=td_depo_docs field_type=varchar field_length=255 field_scale=null field_prec=255 page=1 order=15 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(OPER_DATE_0) name=Подтверждено field_name=oper_date table_name=td_depo_docs field_type=datetime field_length=8 field_scale=3 field_prec=23 page=4 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(HIPO_BOND_ID) name=ID ЗИП field_name=hipo_bond_id table_name=td_hipo_pymnt_schedule field_type=numeric field_length=null field_scale=0 field_prec=18 page=2 order=16 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(CALC_BEG_DATE_3) name=Дата начала расчета field_name=calc_beg_date table_name=td_hipo_pymnt_schedule field_type=datetime field_length=8 field_scale=3 field_prec=23 page=3 order=17 init_class=0 init_formula=(select td_hipo_object.issue_date from td_hipo_object where td_hipo_object.id=@hipo_bond_id) 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(FIRST_PYMNT_DATE_3) name=Дата первой выплаты field_name=first_pymnt_date table_name=td_hipo_pymnt_schedule field_type=datetime field_length=8 field_scale=3 field_prec=23 page=3 order=18 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DEBT_3) name=Сумма основного долга field_name=debt table_name=td_hipo_pymnt_schedule field_type=money field_length=8 field_scale=4 field_prec=19 page=3 order=19 init_class=0 init_formula=(select td_stock_emis.stock_nominal from td_stock_emis where td_stock_emis.id=@hipo_bond_id) 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(INTERESTED_PERIOD_3) name=Процентный период(дней) field_name=interested_period table_name=td_hipo_pymnt_schedule field_type=int field_length=4 field_scale=0 field_prec=10 page=3 order=20 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(CLEARING_DATE_3) name=Дата погашения field_name=clearing_date table_name=td_hipo_pymnt_schedule field_type=datetime field_length=8 field_scale=3 field_prec=23 page=3 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(INTEREST_3) name=Процентная ставка field_name=interest table_name=td_hipo_pymnt_schedule field_type=money field_length=8 field_scale=4 field_prec=19 page=3 order=22 init_class=0 init_formula=(select td_stock_emis.percent_value from td_stock_emis where td_stock_emis.id=@hipo_bond_id) 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(SET_INTEREST_PERIOD_3) name=Задание проц.периода field_name=set_interest_period table_name=td_hipo_pymnt_schedule field_type=int field_length=4 field_scale=0 field_prec=10 page=3 order=23 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(INTERESTED_PERIOD_QTY_3) name=Кол-во проц.периодов field_name=interested_period_qty table_name=td_hipo_pymnt_schedule field_type=int field_length=4 field_scale=0 field_prec=10 page=3 order=24 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PYMNT_PERIOD_3) name=Платежный период field_name=pymnt_period table_name=td_hipo_pymnt_schedule field_type=int field_length=4 field_scale=0 field_prec=10 page=3 order=25 init_class=0 init_formula=0 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $RELATION(REL3) class=0 type=PARTNERS form=null prop=CORRESPONDENT_ID idname=null order=null $ENDRELATION $RELATION(REL2) class=0 type=PARTNERS form=null prop=PAYER_ID idname=null order=null $ENDRELATION $RELATION(REL1) class=0 type=PARTNERS form=null prop=INITIATOR_ID idname=null order=null $ENDRELATION $RELATION(REL4) class=1 type=ACTIVDOCS form=ACTION2 prop=null idname=sid order=40 $ENDRELATION $RELATION(REL6) class=1 type=FORM_REPORT form=ACTION_UPDATE1 prop=null idname=item_id_s order=100 $ENDRELATION $RELATION(REL7) class=0 type=HP_BOND form=null prop=HIPO_BOND_ID idname=null order=40 $ENDRELATION $RELATION(REL5) class=1 type=HP_PYMNT_SCHED_ROWS form=PAY_LIST prop=null idname=pymnt_schedule_id_s order=30 $ENDRELATION $FORM(FORM1) name=Просмотр class=5 filter=null target_state= uo=uo_edit dw=d_depooper_p1 procedure=ap_30000000000264231 patterns=GENERIC_VIEW_ITEM_P1 user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=2203 height=1604 proc_text=$TEXT(19004839) 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(19004839) $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(REL3.PARTNER_CODE) relation=REL3 where=null prop=PARTNER_CODE order=1 alias=corr_code $ENDACTION2RELATION $ACTION2RELATION(REL3.PARTNER_SHORT_NAME) relation=REL3 where=null prop=PARTNER_SHORT_NAME order=4 alias=corr_short_name $ENDACTION2RELATION $ACTION2RELATION(REL2.PARTNER_CODE) relation=REL2 where=null prop=PARTNER_CODE order=1 alias=payer_code $ENDACTION2RELATION $ACTION2RELATION(REL2.PARTNER_SHORT_NAME) relation=REL2 where=null prop=PARTNER_SHORT_NAME order=4 alias=payer_short_name $ENDACTION2RELATION $BIND(BIND1) type=HP_PYMNT_SCHEDULE action=PARENT_HIPO_BOND class=1 order=10 idname=sid $ENDBIND $BIND(BIND2) type=ARH_EDIT action=D_PEREVODARCHIV_P3 class=1 order=30 idname=sid $ENDBIND $BIND(BIND3) type=HP_PYMNT_SCHEDULE action=PYMNT_SCHED_COND class=1 order=20 idname=null $ENDBIND $ENDFORM $FORM(GLOBAL_SCHED_LIST) name=Общий список графиков class=4 filter=GLOBAL_SCHED_LIST_FILTER target_state= uo=uo_list dw=d_global_sched_list procedure=ap_30000000000264244 patterns=GENERIC_VIEW_LIST user_define=1 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004840) create procedure dbo.%PROC% @sid varchar(30) = null .ARGLIST_FILTER as .BEGIN('N') .CHECK_USER .CHECK_VIEW_LIST .ARGCONVERT_FILTER .VIEW_LIST .END $ENDTEXT(19004840) $ACTION2RELATION(REL7.Z_LAST_NAME_5) relation=REL7 where=null prop=Z_LAST_NAME_5 order=90 alias=depositor $ENDACTION2RELATION $ACTION2RELATION(REL7.NAME_4) relation=REL7 where=null prop=NAME_4 order=89 alias=mortgagor $ENDACTION2RELATION $ACTION2RELATION(REL7.STOCK_EMISS_NO) relation=REL7 where=null prop=STOCK_EMISS_NO order=95 alias=stock_emiss_no $ENDACTION2RELATION $ACTION2RELATION(REL7.EMISS_STATEREG_NO) relation=REL7 where=null prop=EMISS_STATEREG_NO order=97 alias=emiss_statereg_no $ENDACTION2RELATION $ACTION2RELATION(REL7.EMISS_STATEREG_DATE) relation=REL7 where=null prop=EMISS_STATEREG_DATE order=96 alias=emiss_statereg_date $ENDACTION2RELATION $ENDFORM $FORM(GLOBAL_SCHED_LIST_FILTER) name=Фильтр общего списка class=6 filter=null target_state= uo=uo_filter dw=d_global_sched_list_filter procedure=null patterns=null user_define=0 isvisible=1 istab=0 posx=0 posy=0 width=2345 height=1744 proc_text=null $FILTER(DEPO_DOC_TYPE) type=1 label=Тип корреспонденции prop=DEPO_DOC_TYPE arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(IN_DATE) type=2 label=Дата prop=IN_DATE arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(IN_NO) type=3 label=Номер prop=IN_NO arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(OUT_DATE) type=2 label=Внешняя дата prop=OUT_DATE arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(OUT_NO) type=3 label=Внешний номер prop=OUT_NO arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(CORRESPONDENT_ID) type=1 label=Корреспондент prop=CORRESPONDENT_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(PAYER_ID) type=1 label=Плательщик prop=PAYER_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(PAY_SUM) type=2 label=Сумма платежа prop=PAY_SUM arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(SUM_CUR_ID) type=1 label=Валюта prop=SUM_CUR_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(INITIATOR_ID) type=1 label=Инициатор prop=INITIATOR_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(HIPO_BOND_ID) type=1 label=Закладная prop=HIPO_BOND_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(DOC_COMMENT) type=3 label=Коментарий prop=DOC_COMMENT arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(DOCUMENT_FORM_ID) type=1 label=Форма prop=DOCUMENT_FORM_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $ENDFORM $FORM(PARENT_HIPO_BOND) name=Ипотечная закладная class=5 filter=null target_state= uo=uo_edit dw=d_pymnt_sched_bond procedure=ap_30000000000264241 patterns=GENERIC_VIEW_ITEM_P2 user_define=0 isvisible=1 istab=1 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004843) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_VIEW_ITEM .VIEW_ITEM(ALL,2) .END $ENDTEXT(19004843) $ACTION2RELATION(REL7.Z_LAST_NAME_5) relation=REL7 where=null prop=Z_LAST_NAME_5 order=87 alias=depositor $ENDACTION2RELATION $ACTION2RELATION(REL7.NAME_4) relation=REL7 where=null prop=NAME_4 order=86 alias=mortgagor $ENDACTION2RELATION $ACTION2RELATION(REL7.STOCK_NOMINAL) relation=REL7 where=null prop=STOCK_NOMINAL order=97 alias=stock_nominal $ENDACTION2RELATION $ACTION2RELATION(REL7.STOCK_CURR_ID) relation=REL7 where=null prop=STOCK_CURR_ID order=92 alias=stock_curr_id $ENDACTION2RELATION $ACTION2RELATION(REL7.STOCK_EMISS_NO) relation=REL7 where=null prop=STOCK_EMISS_NO order=93 alias=stock_emiss_no $ENDACTION2RELATION $ACTION2RELATION(REL7.EMISS_STATEREG_NO) relation=REL7 where=null prop=EMISS_STATEREG_NO order=96 alias=emiss_statereg_no $ENDACTION2RELATION $ACTION2RELATION(REL7.EMISS_STATEREG_DATE) relation=REL7 where=null prop=EMISS_STATEREG_DATE order=94 alias=emiss_statereg_date $ENDACTION2RELATION $ACTION2RELATION(REL7.SERIAL) relation=REL7 where=null prop=SERIAL order=95 alias=serial $ENDACTION2RELATION $ENDFORM $FORM(PYMNT_SCHED_COND) name=Условия для расчета class=5 filter=null target_state= uo=uo_edit dw=d_pymnt_sched_cond procedure=ap_30000000000268354 patterns=GENERIC_VIEW_ITEM_P3 user_define=0 isvisible=1 istab=0 posx=null posy=null width=null height=null proc_text=$TEXT(19004845) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_VIEW_ITEM .VIEW_ITEM(ALL,3) .END $ENDTEXT(19004845) $ENDFORM $FORM(PYMNT_SCHED_LIST) name=Графики платежей class=4 filter=null target_state= uo=uo_list dw=d_pymnt_sched_list procedure=ap_30000000000263860 patterns=GENERIC_VIEW_LIST user_define=1 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004846) create procedure dbo.%PROC% @sid varchar(30) = null .ARGLIST_FILTER as .BEGIN('N') .CHECK_USER .CHECK_VIEW_LIST .ARGCONVERT_FILTER .VIEW_LIST .END $ENDTEXT(19004846) $FILTER(HIPO_BOND_ID) type=11 label=Закладная prop=HIPO_BOND_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $ENDFORM $ACTION(ACTION1) name=Добавить class=1 form=FORM1 target_state=CRT procedure=ap_30000000000264275 patterns=GENERIC_INSERT_P1 user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=2217 height=1612 proc_text=$TEXT(19004846) create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST(ALL,1), .ARGLIST(ALL,2) as .BEGIN('N') .CHECK_USER .CHECK_UPDATE .ARGCONVERT(ALL,1) .ARGCONVERT(ALL,2) .INIT_VARS(AFTER,ALL,1) .DEPO_GEN_NO(@in_no,@depo_doc_type) .TEST_UNIQUE(ALL,1) begin tran .UPDATE(ALL,1) .UPDATE(ALL,2) .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran select sid = convert(varchar,@id) .END $ENDTEXT(19004846) $BIND(BIND1) type=HP_PYMNT_SCHEDULE action=SCHED_COND_EDIT class=1 order=20 idname=null $ENDBIND $ENDACTION $ACTION(ACTION2) name=Изменить class=2 form=FORM1 target_state=null procedure=ap_30000000000264276 patterns=GENERIC_UPDATE_P1 user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=2747 height=2172 proc_text=$TEXT(19004846) create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST(ALL,1) as declare @action_id numeric, @id numeric, @user_id numeric, @state_id numeric, @type_id numeric, @item_name varchar(100), @new_state_id numeric begin tran select @action_id = %ACTION_ID% select @id = convert(numeric, @sid) .CHECK_USER .CHECK_UPDATE .ARGCONVERT(ALL,1) .DEPO_GEN_NO(@in_no,@depo_doc_type) .DEPO_CHK_NO(@id,@in_no,@depo_doc_type) .UPDATE(ALL,1) .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran select sid = convert(varchar, @id) $ENDTEXT(19004846) $BIND(BIND1) type=HP_PYMNT_SCHEDULE action=PARENT_HIPO_BOND class=1 order=10 idname=null $ENDBIND $BIND(BIND2) type=HP_PYMNT_SCHEDULE action=SCHED_COND_EDIT class=1 order=20 idname=null $ENDBIND $ENDACTION $ACTION(CHECK) name=Проверить график class=9 form=null target_state=null procedure=null patterns=null user_define=null isvisible=0 istab=0 posx=null posy=null width=null height=null proc_text=null $ENDACTION $ACTION(CONF_SCHED) name=Подтвердить class=9 form=null target_state=CONF procedure=ap_30000000000264279 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004848) create procedure dbo.%PROC% @sid varchar(30) = null as declare @action_id numeric, @id numeric, @user_id numeric, @state_id numeric, @new_state_id numeric, @type_id numeric begin tran select @action_id = %ACTION_ID% select @id = convert(numeric, @sid) /*-- проверка: подтверждение пустого графика бессмысленно --*/ if not exists (select 1 from td_hipo_pymnt_schedule_rows where td_hipo_pymnt_schedule_rows.pymnt_schedule_id=@id and .ITEMS_EXISTS(td_hipo_pymnt_schedule_rows.id) ) .EXIT_MESSAGE('В графике нет ни одного платежа') .CHECK_USER .CHECK_UPDATE .UPDATE_STATE .ACTION_HISTORY .ARH_NUMBER_UPDATE /*--- фиксация подтверждения ---*/ .GET_PROPS(ALL,4) select @oper_date = getdate() .UPDATE(ALL,4) /*--Перевод платежей этого графика в статус подтвержденных --*/ .ID_VAR(@item_state_id) select @item_state_id = .GET_STATE('HP_PYMNT_SCHED_ROWS', 'CONF') if ((@item_state_id = null) OR (@item_state_id = -1)) .EXIT_MESSAGE('Статус CONF документа HP_PYMNT_SCHED_ROWS не найден') update t_items set state_id = @item_state_id where id in (select td_hipo_pymnt_schedule_rows.id from td_hipo_pymnt_schedule_rows where td_hipo_pymnt_schedule_rows.pymnt_schedule_id=@id and .ITEMS_EXISTS(td_hipo_pymnt_schedule_rows.id) ) if @@error !=0 .EXIT_MESSAGE('Перевод в подтвержденные платежей этого графика не прошел') ---- commit tran $ENDTEXT(19004848) $ENDACTION $ACTION(DEL_ROWS) name=Удаление платежей(строк) class=9 form=null target_state=null procedure=ap_30000000000266831 patterns=GENERIC_MOVE user_define=1 isvisible=1 istab=0 posx=null posy=null width=null height=null proc_text=$TEXT(19004848) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') --.CHECK_USER --.CHECK_UPDATE begin tran --.UPDATE_STATE --.ACTION_HISTORY /*--Перевод в удаленные платежей этого графика--*/ .ID_VAR(@item_state_id) select @item_state_id = .GET_STATE('HP_PYMNT_SCHED_ROWS', 'DEL') if ((@item_state_id = null) OR (@item_state_id = -1)) begin rollback tran raiserror 40000 'Статус DEL документа HP_PYMNT_SCHED_ROWS не найден' return end update t_items set state_id = @item_state_id where id in (select td_hipo_pymnt_schedule_rows.id from td_hipo_pymnt_schedule_rows where td_hipo_pymnt_schedule_rows.pymnt_schedule_id=@id and .ITEMS_EXISTS(td_hipo_pymnt_schedule_rows.id) ) if @@error !=0 begin rollback tran raiserror 40000 'Перевод в удаленные платежей этого графика не прошел' return end ---- commit tran .END $ENDTEXT(19004848) $ENDACTION $ACTION(DEL_SCHEDULE) name=Удалить class=3 form=FORM1 target_state=DEL procedure=ap_30000000000264278 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004848) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_UPDATE begin tran .UPDATE_STATE .ACTION_HISTORY /*-------Проводки ----------*/ commit tran .END $ENDTEXT(19004848) $BIND(BIND1) type=HP_PYMNT_SCHEDULE action=DEL_ROWS class=0 order=10 idname=sid $ENDBIND $ENDACTION $ACTION(PYMNT_SCHED_RECALC) name=Расcчитать стандартный график class=9 form=null target_state=null procedure=ap_30000000000264281 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004848) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_UPDATE begin tran -- проверка: пересчет заполненного запрещен -- if exists (select 1 from td_hipo_pymnt_schedule_rows where td_hipo_pymnt_schedule_rows.pymnt_schedule_id=@id and .ITEMS_EXISTS(td_hipo_pymnt_schedule_rows.id) ) .EXIT_MESSAGE('График уже содержит платежи') .UPDATE_STATE .ACTION_HISTORY /*-- формирование и(или) извлечение исходных данных для стандартного расчета --*/ .GET_PROPS .INIT_VARS(AFTER,ALL,3) if (@clearing_date <= @calc_beg_date) select @clearing_date = null if @set_interest_period = 1 ---------процентный период - календарный месяц begin if not @interested_period_qty is null -- дата погашения всегда перерасчитывается, если введено кол-во периодов select @clearing_date = dateadd(mm,@interested_period_qty,@calc_beg_date) else if @clearing_date is null -- оба поля пусты: рассчитываем по данным из закладной begin select @interested_period_qty = td_stock_emis.deploument_qty from td_stock_emis where td_stock_emis.id=@hipo_bond_id select @clearing_date = dateadd(mm,@interested_period_qty,@calc_beg_date) end else --введена дата погашения и кол-во периодов пусто: рассчитываем кол-во периодов select @interested_period_qty = datediff(mm,@calc_beg_date,@clearing_date) end if @set_interest_period = 2 ---------процентный период - в днях begin if ((not @interested_period is null) and (not @interested_period_qty is null)) --период описан полностью - дата погашения всегда перерасчитывается select @clearing_date = dateadd(dd,@interested_period*@interested_period_qty,@calc_beg_date) else if ((@interested_period is null) and (@interested_period_qty is null)) --период не описан вовсе - рассчитать ничего невозможно .EXIT_MESSAGE('Введите недостающие данные для расчета процентных периодов') else if (@clearing_date is null) --дата погашения не введена - недостаточно данных для расчета .EXIT_MESSAGE('Введите недостающие данные для расчета процентных периодов') else if (@interested_period is null) --расч. длину проц. периода begin if (datediff(dd,@calc_beg_date,@clearing_date)/@interested_period_qty*@interested_period_qty) <> datediff(dd,@calc_beg_date,@clearing_date) .EXIT_MESSAGE('Нецелое число дней в процентном периоде') else select @interested_period = datediff(dd,@calc_beg_date,@clearing_date) / @interested_period_qty end else --расч. кол-во проц. периодов begin if (datediff(dd,@calc_beg_date,@clearing_date)/@interested_period*@interested_period) <> datediff(dd,@calc_beg_date,@clearing_date) .EXIT_MESSAGE('Нецелое число процентных периодов') else select @interested_period_qty = datediff(dd,@calc_beg_date,@clearing_date) / @interested_period end end .UPDATE(ALL,3) /*-----Расчет аннуитета-------*/ declare @annuitet decimal(19,8) declare @debt_rest decimal(19,8) --остаток долга declare @annuitet_round int --округление аннуитета declare @period_rate decimal(19,8) --проц.ставка за проц.период declare @interest_part decimal(19,8) --проценты в платеже declare @debt_part decimal(19,8) -- основной долг в платеже if @set_interest_period = 1 select @period_rate = (convert(decimal(19,8),@interest*0.01))/12 if @set_interest_period = 2 select @period_rate = (convert(decimal(19,8),@interest*0.01))/((convert(decimal(19,8),365))/@interested_period) select @annuitet_round=td_stock_emis.stock_unit from td_stock_emis where td_stock_emis.id=@hipo_bond_id if @annuitet_round is null select @annuitet_round = 0 select @annuitet = (convert(decimal(19,8), @debt)) * @period_rate / (1 - power((1 + @period_rate),((@interested_period_qty-1) * (-1)))) select @annuitet = round(@annuitet,@annuitet_round,0) select @debt_rest = (convert(decimal(19,8), @debt)) --select @debt_rest = round(@debt_rest,@annuitet_round,0) /*-----Формирование платежей-------*/ .TYPE_INIT('HP_PYMNT_SCHED_ROWS',1) .INT_VAR(@counter) .INT_VAR(@dpp) .DATE_VAR(@tmp_dt) select @counter = 1 while (@counter <= @interested_period_qty and @debt_rest > 0) begin if @set_interest_period = 1 begin select @tmp_dt = dateadd(mm, @counter, @calc_beg_date) select @dpp = datediff(dd,(dateadd(mm, @counter-1, @calc_beg_date)),@tmp_dt) end if @set_interest_period = 2 begin select @tmp_dt = dateadd(dd, @counter*@interested_period, @calc_beg_date) select @dpp = @interested_period end select @interest_part = @debt_rest * @period_rate -- select @interest_part = round(@interest_part,@annuitet_round,0) select @debt_part = @annuitet - @interest_part -- select @debt_part = round(@debt_part,@annuitet_round,0) if (@annuitet > (@debt_rest + @interest_part)) or (@counter = @interested_period_qty) begin select @annuitet = round((@debt_rest + @interest_part),@annuitet_round,0) select @debt_part = @debt_rest end .TYPE_ASSIGN(pay_num, @counter, 1) .TYPE_ASSIGN(interest_period,@tmp_dt,1) .TYPE_ASSIGN(interest_period_days,@dpp,1) .TYPE_ASSIGN(b_period_of_payment,@tmp_dt,1) .TYPE_ASSIGN(e_period_of_payment,(dateadd(dd,@pymnt_period,@tmp_dt)),1) .TYPE_ASSIGN(debt_plan,@debt_rest,1) .TYPE_ASSIGN(interest_debt_plan,@interest_part,1) .TYPE_ASSIGN(debt_before,@annuitet,1) .TYPE_ASSIGN(debt_clear,@debt_part,1) .TYPE_ASSIGN(debt_after,(@debt_rest - @debt_part),1) .TYPE_ASSIGN(pymnt_schedule_id,@id,1) .TYPE_ASSIGN(hipo_bond_id,@hipo_bond_id,1) .TYPE_INSERT('HP_PYMNT_SCHED_ROWS','CRT',1) select @debt_rest = @debt_rest - @debt_part select @counter = @counter + 1 end commit tran .END $ENDTEXT(19004848) $ENDACTION $ACTION(SCHED_COND_EDIT) name=Условия для расчета(изм.) class=2 form=PYMNT_SCHED_COND target_state=null procedure=ap_30000000000268386 patterns=GENERIC_UPDATE_P2 user_define=1 isvisible=1 istab=0 posx=null posy=null width=null height=null proc_text=$TEXT(19004848) create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST(ALL, 3) as .BEGIN('N') .CHECK_USER .CHECK_UPDATE .ARGCONVERT(ALL, 3) .TEST_UNIQUE(ALL, 3) .GET_PROPS(ALL,1) begin tran .UPDATE_ITEMS .UPDATE(ALL,3) .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran .END $ENDTEXT(19004848) $ENDACTION $ACTION(UNCONF_SCHED) name=Отменить подтверждение class=9 form=null target_state=CRT procedure=ap_30000000000264280 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004850) create procedure dbo.%PROC% @sid varchar(30) = null as declare @action_id numeric, @id numeric, @user_id numeric, @state_id numeric, @new_state_id numeric, @type_id numeric begin tran select @action_id = %ACTION_ID% select @id = convert(numeric, @sid) .CHECK_USER .CHECK_UPDATE .UPDATE_STATE .ACTION_HISTORY .ARH_FLAG_CLEAR /* --- Очистка даты подтверждения --- */ .GET_PROPS(ALL,4) select @oper_date = null .UPDATE(ALL,4) /*-- Возврат платежей этого графика из подтвержденных в статус созданные --*/ .ID_VAR(@item_state_id) select @item_state_id = .GET_STATE('HP_PYMNT_SCHED_ROWS', 'CRT') if ((@item_state_id = null) OR (@item_state_id = -1)) .EXIT_MESSAGE('Статус CRT документа HP_PYMNT_SCHED_ROWS не найден') update t_items set state_id = @item_state_id where id in (select td_hipo_pymnt_schedule_rows.id from td_hipo_pymnt_schedule_rows where td_hipo_pymnt_schedule_rows.pymnt_schedule_id=@id and .ITEMS_EXISTS(td_hipo_pymnt_schedule_rows.id) ) if @@error !=0 .EXIT_MESSAGE('Возврат в созданные платежей этого графика не прошел') ---- commit tran $ENDTEXT(19004850) $ENDACTION $ACTION(СLEAR_SCHED) name=Очистить график class=9 form=null target_state=null procedure=ap_30000000000266595 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=0 posx=null posy=null width=null height=null proc_text=$TEXT(19004850) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_UPDATE begin tran .UPDATE_STATE .ACTION_HISTORY commit tran .END $ENDTEXT(19004850) $BIND(BIND1) type=HP_PYMNT_SCHEDULE action=DEL_ROWS class=0 order=10 idname=sid $ENDBIND $ENDACTION $STATE2ACTION(BEG.ACTION1) state=BEG action=ACTION1 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(BEG.ACTION2) state=BEG action=ACTION2 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.CHECK) state=BEG action=CHECK is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.CONF_SCHED) state=BEG action=CONF_SCHED is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.DEL_ROWS) state=BEG action=DEL_ROWS is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.DEL_SCHEDULE) state=BEG action=DEL_SCHEDULE is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.FORM1) state=BEG action=FORM1 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.GLOBAL_SCHED_LIST) state=BEG action=GLOBAL_SCHED_LIST is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.GLOBAL_SCHED_LIST_FILTER) state=BEG action=GLOBAL_SCHED_LIST_FILTER is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.PARENT_HIPO_BOND) state=BEG action=PARENT_HIPO_BOND is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.PYMNT_SCHED_COND) state=BEG action=PYMNT_SCHED_COND is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.PYMNT_SCHED_LIST) state=BEG action=PYMNT_SCHED_LIST is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.PYMNT_SCHED_RECALC) state=BEG action=PYMNT_SCHED_RECALC is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.SCHED_COND_EDIT) state=BEG action=SCHED_COND_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.UNCONF_SCHED) state=BEG action=UNCONF_SCHED is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.СLEAR_SCHED) state=BEG action=СLEAR_SCHED is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.ACTION1) state=CHARGED action=ACTION1 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.ACTION2) state=CHARGED action=ACTION2 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.CHECK) state=CHARGED action=CHECK is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.CONF_SCHED) state=CHARGED action=CONF_SCHED is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.DEL_ROWS) state=CHARGED action=DEL_ROWS is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.DEL_SCHEDULE) state=CHARGED action=DEL_SCHEDULE is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.FORM1) state=CHARGED action=FORM1 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.GLOBAL_SCHED_LIST) state=CHARGED action=GLOBAL_SCHED_LIST is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.GLOBAL_SCHED_LIST_FILTER) state=CHARGED action=GLOBAL_SCHED_LIST_FILTER is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.PARENT_HIPO_BOND) state=CHARGED action=PARENT_HIPO_BOND is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.PYMNT_SCHED_COND) state=CHARGED action=PYMNT_SCHED_COND is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.PYMNT_SCHED_LIST) state=CHARGED action=PYMNT_SCHED_LIST is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.PYMNT_SCHED_RECALC) state=CHARGED action=PYMNT_SCHED_RECALC is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.SCHED_COND_EDIT) state=CHARGED action=SCHED_COND_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.UNCONF_SCHED) state=CHARGED action=UNCONF_SCHED is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CHARGED.СLEAR_SCHED) state=CHARGED action=СLEAR_SCHED is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.ACTION1) state=CONF action=ACTION1 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.ACTION2) state=CONF action=ACTION2 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.CHECK) state=CONF action=CHECK is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.CONF_SCHED) state=CONF action=CONF_SCHED is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.DEL_ROWS) state=CONF action=DEL_ROWS is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.DEL_SCHEDULE) state=CONF action=DEL_SCHEDULE is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.FORM1) state=CONF action=FORM1 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CONF.GLOBAL_SCHED_LIST) state=CONF action=GLOBAL_SCHED_LIST is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CONF.GLOBAL_SCHED_LIST_FILTER) state=CONF action=GLOBAL_SCHED_LIST_FILTER is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.PARENT_HIPO_BOND) state=CONF action=PARENT_HIPO_BOND is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CONF.PYMNT_SCHED_COND) state=CONF action=PYMNT_SCHED_COND is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CONF.PYMNT_SCHED_LIST) state=CONF action=PYMNT_SCHED_LIST is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CONF.PYMNT_SCHED_RECALC) state=CONF action=PYMNT_SCHED_RECALC is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.SCHED_COND_EDIT) state=CONF action=SCHED_COND_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.UNCONF_SCHED) state=CONF action=UNCONF_SCHED is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CONF.СLEAR_SCHED) state=CONF action=СLEAR_SCHED is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.ACTION1) state=CRT action=ACTION1 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.ACTION2) state=CRT action=ACTION2 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.CHECK) state=CRT action=CHECK is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.CONF_SCHED) state=CRT action=CONF_SCHED is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.DEL_ROWS) state=CRT action=DEL_ROWS is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.DEL_SCHEDULE) state=CRT action=DEL_SCHEDULE is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.FORM1) state=CRT action=FORM1 is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.GLOBAL_SCHED_LIST) state=CRT action=GLOBAL_SCHED_LIST is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.GLOBAL_SCHED_LIST_FILTER) state=CRT action=GLOBAL_SCHED_LIST_FILTER is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.PARENT_HIPO_BOND) state=CRT action=PARENT_HIPO_BOND is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.PYMNT_SCHED_COND) state=CRT action=PYMNT_SCHED_COND is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.PYMNT_SCHED_LIST) state=CRT action=PYMNT_SCHED_LIST is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.PYMNT_SCHED_RECALC) state=CRT action=PYMNT_SCHED_RECALC is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.SCHED_COND_EDIT) state=CRT action=SCHED_COND_EDIT is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.UNCONF_SCHED) state=CRT action=UNCONF_SCHED is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.СLEAR_SCHED) state=CRT action=СLEAR_SCHED is_available=1 $ENDSTATE2ACTION $STATE2ACTION(DEL.ACTION1) state=DEL action=ACTION1 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.ACTION2) state=DEL action=ACTION2 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.CHECK) state=DEL action=CHECK is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.CONF_SCHED) state=DEL action=CONF_SCHED is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.DEL_ROWS) state=DEL action=DEL_ROWS is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.DEL_SCHEDULE) state=DEL action=DEL_SCHEDULE is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.FORM1) state=DEL action=FORM1 is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.GLOBAL_SCHED_LIST) state=DEL action=GLOBAL_SCHED_LIST is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.GLOBAL_SCHED_LIST_FILTER) state=DEL action=GLOBAL_SCHED_LIST_FILTER is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.PARENT_HIPO_BOND) state=DEL action=PARENT_HIPO_BOND is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.PYMNT_SCHED_COND) state=DEL action=PYMNT_SCHED_COND is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.PYMNT_SCHED_LIST) state=DEL action=PYMNT_SCHED_LIST is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.PYMNT_SCHED_RECALC) state=DEL action=PYMNT_SCHED_RECALC is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.SCHED_COND_EDIT) state=DEL action=SCHED_COND_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.UNCONF_SCHED) state=DEL action=UNCONF_SCHED is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.СLEAR_SCHED) state=DEL action=СLEAR_SCHED is_available=0 $ENDSTATE2ACTION $STATE2PROP(BEG.CALC_BEG_DATE_3) state=BEG prop=CALC_BEG_DATE_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.CLEARING_DATE_3) state=BEG prop=CLEARING_DATE_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.CORRESPONDENT_ID) state=BEG prop=CORRESPONDENT_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DEBT_3) state=BEG prop=DEBT_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DEPO_DOC_TYPE) state=BEG prop=DEPO_DOC_TYPE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DOCUMENT_FORM_ID) state=BEG prop=DOCUMENT_FORM_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DOC_COMMENT) state=BEG prop=DOC_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.FIRST_PYMNT_DATE_3) state=BEG prop=FIRST_PYMNT_DATE_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.FOLDER_ID) state=BEG prop=FOLDER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.HIPO_BOND_ID) state=BEG prop=HIPO_BOND_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INITIATOR_ID) state=BEG prop=INITIATOR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INTERESTED_PERIOD_3) state=BEG prop=INTERESTED_PERIOD_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INTERESTED_PERIOD_QTY_3) state=BEG prop=INTERESTED_PERIOD_QTY_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INTEREST_3) state=BEG prop=INTEREST_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.IN_DATE) state=BEG prop=IN_DATE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.IN_NO) state=BEG prop=IN_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.OPER_DATE_0) state=BEG prop=OPER_DATE_0 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(BEG.OUT_DATE) state=BEG prop=OUT_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.OUT_NO) state=BEG prop=OUT_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PAYER_ID) state=BEG prop=PAYER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PAY_SUM) state=BEG prop=PAY_SUM enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PYMNT_PERIOD_3) state=BEG prop=PYMNT_PERIOD_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.SET_INTEREST_PERIOD_3) state=BEG prop=SET_INTEREST_PERIOD_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.SUM_CUR_ID) state=BEG prop=SUM_CUR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.WHO_GET) state=BEG prop=WHO_GET enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.WHO_PUT) state=BEG prop=WHO_PUT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.CALC_BEG_DATE_3) state=CHARGED prop=CALC_BEG_DATE_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.CLEARING_DATE_3) state=CHARGED prop=CLEARING_DATE_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.CORRESPONDENT_ID) state=CHARGED prop=CORRESPONDENT_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.DEBT_3) state=CHARGED prop=DEBT_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.DEPO_DOC_TYPE) state=CHARGED prop=DEPO_DOC_TYPE enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.DOCUMENT_FORM_ID) state=CHARGED prop=DOCUMENT_FORM_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.DOC_COMMENT) state=CHARGED prop=DOC_COMMENT enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.FIRST_PYMNT_DATE_3) state=CHARGED prop=FIRST_PYMNT_DATE_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.FOLDER_ID) state=CHARGED prop=FOLDER_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.HIPO_BOND_ID) state=CHARGED prop=HIPO_BOND_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.INITIATOR_ID) state=CHARGED prop=INITIATOR_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.INTERESTED_PERIOD_3) state=CHARGED prop=INTERESTED_PERIOD_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.INTERESTED_PERIOD_QTY_3) state=CHARGED prop=INTERESTED_PERIOD_QTY_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.INTEREST_3) state=CHARGED prop=INTEREST_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.IN_DATE) state=CHARGED prop=IN_DATE enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.IN_NO) state=CHARGED prop=IN_NO enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.OPER_DATE_0) state=CHARGED prop=OPER_DATE_0 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.OUT_DATE) state=CHARGED prop=OUT_DATE enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.OUT_NO) state=CHARGED prop=OUT_NO enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.PAYER_ID) state=CHARGED prop=PAYER_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.PAY_SUM) state=CHARGED prop=PAY_SUM enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.PYMNT_PERIOD_3) state=CHARGED prop=PYMNT_PERIOD_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.SET_INTEREST_PERIOD_3) state=CHARGED prop=SET_INTEREST_PERIOD_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.SUM_CUR_ID) state=CHARGED prop=SUM_CUR_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.WHO_GET) state=CHARGED prop=WHO_GET enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CHARGED.WHO_PUT) state=CHARGED prop=WHO_PUT enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.CALC_BEG_DATE_3) state=CONF prop=CALC_BEG_DATE_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.CLEARING_DATE_3) state=CONF prop=CLEARING_DATE_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.CORRESPONDENT_ID) state=CONF prop=CORRESPONDENT_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.DEBT_3) state=CONF prop=DEBT_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.DEPO_DOC_TYPE) state=CONF prop=DEPO_DOC_TYPE enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.DOCUMENT_FORM_ID) state=CONF prop=DOCUMENT_FORM_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.DOC_COMMENT) state=CONF prop=DOC_COMMENT enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.FIRST_PYMNT_DATE_3) state=CONF prop=FIRST_PYMNT_DATE_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.FOLDER_ID) state=CONF prop=FOLDER_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.HIPO_BOND_ID) state=CONF prop=HIPO_BOND_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.INITIATOR_ID) state=CONF prop=INITIATOR_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.INTERESTED_PERIOD_3) state=CONF prop=INTERESTED_PERIOD_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.INTERESTED_PERIOD_QTY_3) state=CONF prop=INTERESTED_PERIOD_QTY_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.INTEREST_3) state=CONF prop=INTEREST_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.IN_DATE) state=CONF prop=IN_DATE enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.IN_NO) state=CONF prop=IN_NO enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.OPER_DATE_0) state=CONF prop=OPER_DATE_0 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.OUT_DATE) state=CONF prop=OUT_DATE enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.OUT_NO) state=CONF prop=OUT_NO enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.PAYER_ID) state=CONF prop=PAYER_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.PAY_SUM) state=CONF prop=PAY_SUM enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.PYMNT_PERIOD_3) state=CONF prop=PYMNT_PERIOD_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.SET_INTEREST_PERIOD_3) state=CONF prop=SET_INTEREST_PERIOD_3 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.SUM_CUR_ID) state=CONF prop=SUM_CUR_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.WHO_GET) state=CONF prop=WHO_GET enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.WHO_PUT) state=CONF prop=WHO_PUT enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.CALC_BEG_DATE_3) state=CRT prop=CALC_BEG_DATE_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.CLEARING_DATE_3) state=CRT prop=CLEARING_DATE_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.CORRESPONDENT_ID) state=CRT prop=CORRESPONDENT_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DEBT_3) state=CRT prop=DEBT_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DEPO_DOC_TYPE) state=CRT prop=DEPO_DOC_TYPE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DOCUMENT_FORM_ID) state=CRT prop=DOCUMENT_FORM_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DOC_COMMENT) state=CRT prop=DOC_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.FIRST_PYMNT_DATE_3) state=CRT prop=FIRST_PYMNT_DATE_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.FOLDER_ID) state=CRT prop=FOLDER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.HIPO_BOND_ID) state=CRT prop=HIPO_BOND_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INITIATOR_ID) state=CRT prop=INITIATOR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INTERESTED_PERIOD_3) state=CRT prop=INTERESTED_PERIOD_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INTERESTED_PERIOD_QTY_3) state=CRT prop=INTERESTED_PERIOD_QTY_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INTEREST_3) state=CRT prop=INTEREST_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.IN_DATE) state=CRT prop=IN_DATE enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.IN_NO) state=CRT prop=IN_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.OPER_DATE_0) state=CRT prop=OPER_DATE_0 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.OUT_DATE) state=CRT prop=OUT_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.OUT_NO) state=CRT prop=OUT_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PAYER_ID) state=CRT prop=PAYER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PAY_SUM) state=CRT prop=PAY_SUM enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PYMNT_PERIOD_3) state=CRT prop=PYMNT_PERIOD_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.SET_INTEREST_PERIOD_3) state=CRT prop=SET_INTEREST_PERIOD_3 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.SUM_CUR_ID) state=CRT prop=SUM_CUR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.WHO_GET) state=CRT prop=WHO_GET enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.WHO_PUT) state=CRT prop=WHO_PUT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(DEL.CALC_BEG_DATE_3) state=DEL prop=CALC_BEG_DATE_3 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CLEARING_DATE_3) state=DEL prop=CLEARING_DATE_3 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CORRESPONDENT_ID) state=DEL prop=CORRESPONDENT_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DEBT_3) state=DEL prop=DEBT_3 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DEPO_DOC_TYPE) state=DEL prop=DEPO_DOC_TYPE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DOCUMENT_FORM_ID) state=DEL prop=DOCUMENT_FORM_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DOC_COMMENT) state=DEL prop=DOC_COMMENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.FIRST_PYMNT_DATE_3) state=DEL prop=FIRST_PYMNT_DATE_3 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.FOLDER_ID) state=DEL prop=FOLDER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.HIPO_BOND_ID) state=DEL prop=HIPO_BOND_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INITIATOR_ID) state=DEL prop=INITIATOR_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INTERESTED_PERIOD_3) state=DEL prop=INTERESTED_PERIOD_3 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INTERESTED_PERIOD_QTY_3) state=DEL prop=INTERESTED_PERIOD_QTY_3 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INTEREST_3) state=DEL prop=INTEREST_3 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.IN_DATE) state=DEL prop=IN_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.IN_NO) state=DEL prop=IN_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.OPER_DATE_0) state=DEL prop=OPER_DATE_0 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.OUT_DATE) state=DEL prop=OUT_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.OUT_NO) state=DEL prop=OUT_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PAYER_ID) state=DEL prop=PAYER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PAY_SUM) state=DEL prop=PAY_SUM enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PYMNT_PERIOD_3) state=DEL prop=PYMNT_PERIOD_3 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.SET_INTEREST_PERIOD_3) state=DEL prop=SET_INTEREST_PERIOD_3 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.SUM_CUR_ID) state=DEL prop=SUM_CUR_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.WHO_GET) state=DEL prop=WHO_GET enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.WHO_PUT) state=DEL prop=WHO_PUT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $ENDDOC $DOC(HP_PYMNT_SCHED_ROWS) name=Платежи в график class=1 product=ALD_HIPO name_formula=null remark_formula=null $STATE(BEG) name=Начальный class=1 $ENDSTATE $STATE(CONF) name=Подтвержден class=0 $ENDSTATE $STATE(CRT) name=Создан class=0 $ENDSTATE $STATE(DEL) name=Удален class=2 $ENDSTATE $PROP(PAY_NUM) name=Номер строки(платежа) field_name=pay_num table_name=td_hipo_pymnt_schedule_rows field_type=numeric field_length=null field_scale=0 field_prec=18 page=1 order=1 init_class=1 init_formula=$TEXT(19004875) (isnull((select max(td_hipo_pymnt_schedule_rows.pay_num) + 1 from td_hipo_pymnt_schedule_rows where td_hipo_pymnt_schedule_rows.pymnt_schedule_id=@pymnt_schedule_id and .ITEMS_EXISTS(td_hipo_pymnt_schedule_rows.id)),1)) $ENDTEXT(19004875) 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(INTEREST_PERIOD) name=Конец процентного периода field_name=interest_period table_name=td_hipo_pymnt_schedule_rows field_type=datetime field_length=null field_scale=null field_prec=null page=1 order=2 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(INTEREST_PERIOD_DAYS) name=Кол-во дней в проц.периоде field_name=interest_period_days table_name=td_hipo_pymnt_schedule_rows field_type=int field_length=null field_scale=null field_prec=null page=1 order=3 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(B_PERIOD_OF_PAYMENT) name=Начало срока платежа field_name=b_period_of_payment table_name=td_hipo_pymnt_schedule_rows field_type=datetime field_length=null field_scale=null field_prec=null page=1 order=4 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(E_PERIOD_OF_PAYMENT) name=Конец срока платежа field_name=e_period_of_payment table_name=td_hipo_pymnt_schedule_rows field_type=datetime field_length=null field_scale=null field_prec=null page=1 order=5 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DEBT_PLAN) name=Основной долг(план) field_name=debt_plan table_name=td_hipo_pymnt_schedule_rows field_type=money field_length=null field_scale=null field_prec=null page=1 order=6 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(INTEREST_DEBT_PLAN) name=Проценты(план) field_name=interest_debt_plan table_name=td_hipo_pymnt_schedule_rows field_type=money field_length=null field_scale=null field_prec=null page=1 order=7 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DEBT_BEFORE) name=Платеж field_name=debt_before table_name=td_hipo_pymnt_schedule_rows field_type=money field_length=null field_scale=null field_prec=null page=1 order=8 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(DEBT_AFTER) name=Основной долг после платежа field_name=debt_after table_name=td_hipo_pymnt_schedule_rows field_type=money field_length=null field_scale=null field_prec=null page=1 order=9 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(CHARGE) name=Признак начисления field_name=charge table_name=td_hipo_pymnt_schedule_rows field_type=int field_length=null field_scale=null field_prec=null page=1 order=10 init_class=1 init_formula=0 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PYMNT_SCHEDULE_ID) name=ID графика field_name=pymnt_schedule_id table_name=td_hipo_pymnt_schedule_rows field_type=numeric field_length=null field_scale=0 field_prec=18 page=1 order=11 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(HIPO_BOND_ID) name=ID ИПЗ field_name=hipo_bond_id table_name=td_hipo_pymnt_schedule_rows field_type=numeric field_length=null field_scale=0 field_prec=18 page=1 order=12 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DEBT_CLEAR_1) name=В пог. основного долга field_name=debt_clear table_name=td_hipo_pymnt_schedule_rows field_type=money field_length=8 field_scale=4 field_prec=19 page=1 order=13 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DUE_FOR_DELAY_1) name=Проценты за просроченный период field_name=due_for_delay table_name=td_hipo_pymnt_schedule_rows field_type=money field_length=8 field_scale=4 field_prec=19 page=1 order=14 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PENALTY_1) name=Пени и штрафы field_name=penalty table_name=td_hipo_pymnt_schedule_rows field_type=money field_length=8 field_scale=4 field_prec=19 page=1 order=15 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $FORM(PAYMNT) name=Просмотр class=5 filter=null target_state= uo=uo_edit dw=d_pymnt_view procedure=ap_30000000000265145 patterns=GENERIC_VIEW_ITEM user_define=1 isvisible=0 istab=1 posx=null posy=null width=null height=null proc_text=$TEXT(19004881) create procedure dbo.%PROC% @sid varchar(30) = null, @pymnt_schedule_id_s varchar(30) as .BEGIN('N') .CHECK_USER .CHECK_VIEW_ITEM if @id = -1 begin begin tran .GET_PROPS select @pymnt_schedule_id = convert(numeric, @pymnt_schedule_id_s) .CHECK_INSERT .INIT_VARS(B) .INSERT_ITEMS .INSERT commit tran end .VIEW_ITEM .END $ENDTEXT(19004881) $ENDFORM $FORM(PAY_LIST) name=Платежи class=4 filter=null target_state= uo=uo_list dw=d_pymnt_sched_pays procedure=ap_30000000000264159 patterns=GENERIC_VIEW_LIST user_define=1 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004881) create procedure dbo.%PROC% @sid varchar(30) = null .ARGLIST_FILTER as .BEGIN('N') .CHECK_USER .CHECK_VIEW_LIST .ARGCONVERT_FILTER .VIEW_LIST .END $ENDTEXT(19004881) $FILTER(PYMNT_SCHEDULE_ID) type=11 label=Родительский график prop=PYMNT_SCHEDULE_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $ENDFORM $ACTION(ADD_PAY) name=Добавить class=1 form=PAYMNT target_state=CRT procedure=ap_30000000000264161 patterns=GENERIC_INSERT user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004881) create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST as .BEGIN('N') .CHECK_USER .CHECK_UPDATE .ARGCONVERT if .ITEM_STATE_CODE(@pymnt_schedule_id) = 'CONF' .EXIT_MESSAGE('График подтвержден - добавлять ничего нельзя') .INIT_VARS .TEST_UNIQUE begin tran .UPDATE_ITEMS /* -- Несколько проверок на непротиворечивость графика -- */ declare @prev_period datetime if (@pay_num = 1) and ((@interest_period is null) or (@interest_period_days is null)) .EXIT_MESSAGE('Для первого платежа: введите конец периода и кол-во дней') if (@pay_num > 1) begin if (@interest_period is null) and (@interest_period_days is null) .EXIT_MESSAGE('Для платежа: введите конец периода или кол-во дней') select @prev_period=(select td_hipo_pymnt_schedule_rows.interest_period from td_hipo_pymnt_schedule_rows where td_hipo_pymnt_schedule_rows.pymnt_schedule_id=@pymnt_schedule_id and td_hipo_pymnt_schedule_rows.pay_num = @pay_num - 1 and .ITEMS_EXISTS(td_hipo_pymnt_schedule_rows.id)) if (@interest_period is null) select @interest_period = dateadd(dd, @interest_period_days, @prev_period) if (@interest_period_days is null) select @interest_period_days = datediff(dd, @prev_period, @interest_period) if (@interest_period_days < 1) .EXIT_MESSAGE('Некорректно введены дата окончания или продолжительность процентного периода') end .UPDATE .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran select sid = convert(varchar, @id) .END $ENDTEXT(19004881) $ENDACTION $ACTION(DEL_PAY) name=Удалить class=3 form=PAYMNT target_state=DEL procedure=ap_30000000000265150 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=1 posx=null posy=null width=null height=null proc_text=$TEXT(19004882) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_UPDATE begin tran .UPDATE_STATE .ACTION_HISTORY /*-------Проводки ----------*/ commit tran .END $ENDTEXT(19004882) $ENDACTION $ACTION(EDIT_PAY) name=Изменить class=2 form=PAYMNT target_state=null procedure=ap_30000000000265154 patterns=GENERIC_UPDATE user_define=1 isvisible=0 istab=1 posx=null posy=null width=null height=null proc_text=$TEXT(19004882) create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST as .BEGIN('N') .CHECK_USER .CHECK_UPDATE .ARGCONVERT .TEST_UNIQUE begin tran .UPDATE_ITEMS /* -- Несколько проверок на непротиворечивость графика -- */ declare @prev_period datetime declare @next_period_b datetime declare @p_n int declare @p_m int if exists (select 1 from td_hipo_pymnt_schedule_rows where td_hipo_pymnt_schedule_rows.pymnt_schedule_id=@pymnt_schedule_id and td_hipo_pymnt_schedule_rows.pay_num = @pay_num and td_hipo_pymnt_schedule_rows.id <> @id and .ITEMS_EXISTS(td_hipo_pymnt_schedule_rows.id)) .EXIT_MESSAGE('В графике уже есть платеж с таким номером') if (@pay_num = 1) and ((@interest_period is null) or (@interest_period_days is null)) .EXIT_MESSAGE('Для первого платежа: введите конец периода и кол-во дней') if (@pay_num > 1) begin if (@interest_period is null) and (@interest_period_days is null) .EXIT_MESSAGE('Для платежа: введите конец периода или кол-во дней') select @prev_period=(select td_hipo_pymnt_schedule_rows.interest_period from td_hipo_pymnt_schedule_rows where td_hipo_pymnt_schedule_rows.pymnt_schedule_id=@pymnt_schedule_id and td_hipo_pymnt_schedule_rows.pay_num = @pay_num - 1 and .ITEMS_EXISTS(td_hipo_pymnt_schedule_rows.id)) if (@interest_period is null) select @interest_period = dateadd(dd, @interest_period_days, @prev_period) if (@interest_period_days is null) select @interest_period_days = datediff(dd, @prev_period, @interest_period) if (@interest_period_days < 1) .EXIT_MESSAGE('Дата окончания попадает в предыдущий период') end /* ------------------------------------------------------------------------ */ .UPDATE .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran .END $ENDTEXT(19004882) $ENDACTION $STATE2ACTION(BEG.ADD_PAY) state=BEG action=ADD_PAY is_available=1 $ENDSTATE2ACTION $STATE2ACTION(BEG.DEL_PAY) state=BEG action=DEL_PAY is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.EDIT_PAY) state=BEG action=EDIT_PAY is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.PAYMNT) state=BEG action=PAYMNT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.PAY_LIST) state=BEG action=PAY_LIST is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.ADD_PAY) state=CONF action=ADD_PAY is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.DEL_PAY) state=CONF action=DEL_PAY is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.EDIT_PAY) state=CONF action=EDIT_PAY is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CONF.PAYMNT) state=CONF action=PAYMNT is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CONF.PAY_LIST) state=CONF action=PAY_LIST is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.ADD_PAY) state=CRT action=ADD_PAY is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.DEL_PAY) state=CRT action=DEL_PAY is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.EDIT_PAY) state=CRT action=EDIT_PAY is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.PAYMNT) state=CRT action=PAYMNT is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.PAY_LIST) state=CRT action=PAY_LIST is_available=1 $ENDSTATE2ACTION $STATE2ACTION(DEL.ADD_PAY) state=DEL action=ADD_PAY is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.DEL_PAY) state=DEL action=DEL_PAY is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.EDIT_PAY) state=DEL action=EDIT_PAY is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.PAYMNT) state=DEL action=PAYMNT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.PAY_LIST) state=DEL action=PAY_LIST is_available=0 $ENDSTATE2ACTION $STATE2PROP(BEG.B_PERIOD_OF_PAYMENT) state=BEG prop=B_PERIOD_OF_PAYMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.CHARGE) state=BEG prop=CHARGE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DEBT_AFTER) state=BEG prop=DEBT_AFTER enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DEBT_BEFORE) state=BEG prop=DEBT_BEFORE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DEBT_CLEAR_1) state=BEG prop=DEBT_CLEAR_1 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DEBT_PLAN) state=BEG prop=DEBT_PLAN enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DUE_FOR_DELAY_1) state=BEG prop=DUE_FOR_DELAY_1 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.E_PERIOD_OF_PAYMENT) state=BEG prop=E_PERIOD_OF_PAYMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.HIPO_BOND_ID) state=BEG prop=HIPO_BOND_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INTEREST_DEBT_PLAN) state=BEG prop=INTEREST_DEBT_PLAN enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INTEREST_PERIOD) state=BEG prop=INTEREST_PERIOD enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INTEREST_PERIOD_DAYS) state=BEG prop=INTEREST_PERIOD_DAYS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PAY_NUM) state=BEG prop=PAY_NUM enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PENALTY_1) state=BEG prop=PENALTY_1 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PYMNT_SCHEDULE_ID) state=BEG prop=PYMNT_SCHEDULE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.B_PERIOD_OF_PAYMENT) state=CONF prop=B_PERIOD_OF_PAYMENT enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.CHARGE) state=CONF prop=CHARGE enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.DEBT_AFTER) state=CONF prop=DEBT_AFTER enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.DEBT_BEFORE) state=CONF prop=DEBT_BEFORE enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.DEBT_CLEAR_1) state=CONF prop=DEBT_CLEAR_1 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.DEBT_PLAN) state=CONF prop=DEBT_PLAN enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.DUE_FOR_DELAY_1) state=CONF prop=DUE_FOR_DELAY_1 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.E_PERIOD_OF_PAYMENT) state=CONF prop=E_PERIOD_OF_PAYMENT enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.HIPO_BOND_ID) state=CONF prop=HIPO_BOND_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.INTEREST_DEBT_PLAN) state=CONF prop=INTEREST_DEBT_PLAN enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.INTEREST_PERIOD) state=CONF prop=INTEREST_PERIOD enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.INTEREST_PERIOD_DAYS) state=CONF prop=INTEREST_PERIOD_DAYS enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.PAY_NUM) state=CONF prop=PAY_NUM enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.PENALTY_1) state=CONF prop=PENALTY_1 enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CONF.PYMNT_SCHEDULE_ID) state=CONF prop=PYMNT_SCHEDULE_ID enable=0 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.B_PERIOD_OF_PAYMENT) state=CRT prop=B_PERIOD_OF_PAYMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.CHARGE) state=CRT prop=CHARGE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DEBT_AFTER) state=CRT prop=DEBT_AFTER enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DEBT_BEFORE) state=CRT prop=DEBT_BEFORE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DEBT_CLEAR_1) state=CRT prop=DEBT_CLEAR_1 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DEBT_PLAN) state=CRT prop=DEBT_PLAN enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DUE_FOR_DELAY_1) state=CRT prop=DUE_FOR_DELAY_1 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.E_PERIOD_OF_PAYMENT) state=CRT prop=E_PERIOD_OF_PAYMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.HIPO_BOND_ID) state=CRT prop=HIPO_BOND_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INTEREST_DEBT_PLAN) state=CRT prop=INTEREST_DEBT_PLAN enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INTEREST_PERIOD) state=CRT prop=INTEREST_PERIOD enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INTEREST_PERIOD_DAYS) state=CRT prop=INTEREST_PERIOD_DAYS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PAY_NUM) state=CRT prop=PAY_NUM enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PENALTY_1) state=CRT prop=PENALTY_1 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PYMNT_SCHEDULE_ID) state=CRT prop=PYMNT_SCHEDULE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(DEL.B_PERIOD_OF_PAYMENT) state=DEL prop=B_PERIOD_OF_PAYMENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CHARGE) state=DEL prop=CHARGE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DEBT_AFTER) state=DEL prop=DEBT_AFTER enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DEBT_BEFORE) state=DEL prop=DEBT_BEFORE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DEBT_CLEAR_1) state=DEL prop=DEBT_CLEAR_1 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DEBT_PLAN) state=DEL prop=DEBT_PLAN enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DUE_FOR_DELAY_1) state=DEL prop=DUE_FOR_DELAY_1 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.E_PERIOD_OF_PAYMENT) state=DEL prop=E_PERIOD_OF_PAYMENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.HIPO_BOND_ID) state=DEL prop=HIPO_BOND_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INTEREST_DEBT_PLAN) state=DEL prop=INTEREST_DEBT_PLAN enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INTEREST_PERIOD) state=DEL prop=INTEREST_PERIOD enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INTEREST_PERIOD_DAYS) state=DEL prop=INTEREST_PERIOD_DAYS enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PAY_NUM) state=DEL prop=PAY_NUM enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PENALTY_1) state=DEL prop=PENALTY_1 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PYMNT_SCHEDULE_ID) state=DEL prop=PYMNT_SCHEDULE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $ENDDOC $DOC(HP_BOND) name=Ипотечная закладная class=1 product=ALD_HIPO name_formula=@stock_code + ': ' + @stock_emiss_no remark_formula=null $STATE(BEG) name=Начальный class=1 $ENDSTATE $STATE(CRT) name=Создан class=0 $ENDSTATE $STATE(DEL) name=Удален class=2 $ENDSTATE $PROP(FACE_TYPE_4) name=Д-тип лица field_name=face_type table_name=td_hipo_debtor field_type=int field_length=4 field_scale=0 field_prec=10 page=4 order=68 init_class=0 init_formula=0 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(NAME_4) name=Фамилия(Наименование) должника field_name=last_name table_name=td_hipo_debtor field_type=varchar field_length=255 field_scale=null field_prec=null page=4 order=69 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(FIRST_NAME_4) name=Имя(ИНН) должника field_name=first_name table_name=td_hipo_debtor field_type=varchar field_length=50 field_scale=null field_prec=50 page=4 order=70 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(MIDDLE_NAME_4) name=Д-Отчество field_name=middle_name table_name=td_hipo_debtor field_type=varchar field_length=50 field_scale=null field_prec=50 page=4 order=71 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(BIRTHDAY_4) name=Д-дата рождения field_name=birthday table_name=td_hipo_debtor field_type=datetime field_length=8 field_scale=3 field_prec=23 page=4 order=72 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(BIRTHDAY_PLACE_4) name=Д-место рождения field_name=birthday_place table_name=td_hipo_debtor field_type=varchar field_length=150 field_scale=null field_prec=150 page=4 order=73 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(PERSON_DOC_TYPE_ID_4) name=Д-тип документа field_name=person_doc_type_id table_name=td_hipo_debtor field_type=numeric field_length=9 field_scale=0 field_prec=18 page=4 order=74 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DOC_SERIAL_4) name=Д-серия field_name=doc_serial table_name=td_hipo_debtor field_type=varchar field_length=20 field_scale=null field_prec=20 page=4 order=75 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(DOC_NUMBER_4) name=Д-номер field_name=doc_number table_name=td_hipo_debtor field_type=varchar field_length=150 field_scale=null field_prec=150 page=4 order=76 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(WHO_ISSUED_4) name=Д-кем выдан field_name=who_issued table_name=td_hipo_debtor field_type=varchar field_length=150 field_scale=null field_prec=150 page=4 order=77 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(BANK_ID_4) name=Д-Банк field_name=bank_id table_name=td_hipo_debtor field_type=numeric field_length=9 field_scale=0 field_prec=18 page=4 order=79 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(ADRESS_4) name=Д-адрес field_name=adress table_name=td_hipo_debtor field_type=varchar field_length=255 field_scale=null field_prec=255 page=4 order=80 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(POST_ADRESS_4) name=Д-почтовый адрес field_name=post_adress table_name=td_hipo_debtor field_type=varchar field_length=255 field_scale=null field_prec=255 page=4 order=81 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(ACCOUNT_4) name=Д-Расч.счет field_name=account table_name=td_hipo_debtor field_type=varchar field_length=255 field_scale=null field_prec=255 page=4 order=82 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(ISSUE_DATE_4) name=Д-когда выдан field_name=d_issue_date table_name=td_hipo_debtor field_type=datetime field_length=null field_scale=null field_prec=null page=4 order=78 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(CMNT_4) name=Д-комментарий field_name=cmnt table_name=td_hipo_debtor field_type=varchar field_length=255 field_scale=null field_prec=255 page=4 order=99 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(SHORT_NAME_1_0) name=Д-короткое имя field_name=short_name table_name=td_hipo_debtor field_type=varchar field_length=255 field_scale=null field_prec=255 page=0 order=101 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(Z_FACE_TYPE_5) name=з-тп лица field_name=face_type table_name=td_hipo_depositor field_type=int field_length=4 field_scale=0 field_prec=10 page=5 order=83 init_class=1 init_formula=0 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(Z_LAST_NAME_5) name=Фамилия(Наименование) залогодателя field_name=last_name table_name=td_hipo_depositor field_type=varchar field_length=255 field_scale=null field_prec=255 page=5 order=84 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(Z_FIRST_NAME_5) name=Имя(ИНН) залогодателя field_name=first_name table_name=td_hipo_depositor field_type=varchar field_length=50 field_scale=null field_prec=50 page=5 order=85 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(Z_MIDDLE_NAME_5) name=з-отч field_name=middle_name table_name=td_hipo_depositor field_type=varchar field_length=50 field_scale=null field_prec=50 page=5 order=86 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(Z_BIRTHDAY_5) name=З-др field_name=birthday table_name=td_hipo_depositor field_type=datetime field_length=8 field_scale=3 field_prec=23 page=5 order=87 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(Z_BIRTHDAY_PLACE_5) name=з-место рожд field_name=birthday_place table_name=td_hipo_depositor field_type=varchar field_length=150 field_scale=null field_prec=150 page=5 order=88 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(Z_PERSON_DOC_TYPE_ID_5) name=з-тип док field_name=person_doc_type_id table_name=td_hipo_depositor field_type=numeric field_length=9 field_scale=0 field_prec=18 page=5 order=89 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(Z_DOC_SERIAL_5) name=з-серия field_name=doc_serial table_name=td_hipo_depositor field_type=varchar field_length=20 field_scale=null field_prec=20 page=5 order=90 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(Z_DOC_NUMBER_5) name=з-номер док field_name=doc_number table_name=td_hipo_depositor field_type=varchar field_length=150 field_scale=null field_prec=150 page=5 order=91 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(Z_WHO_ISSUED_5) name=з-кем выдан field_name=who_issued table_name=td_hipo_depositor field_type=varchar field_length=150 field_scale=null field_prec=150 page=5 order=92 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(Z_BANK_ID_5) name=з-банк field_name=bank_id table_name=td_hipo_depositor field_type=numeric field_length=9 field_scale=0 field_prec=18 page=5 order=94 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(Z_ADRESS_5) name=з-адрес field_name=adress table_name=td_hipo_depositor field_type=varchar field_length=255 field_scale=null field_prec=255 page=5 order=95 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(Z_POST_ADRESS_5) name=з-почт.адрес field_name=post_adress table_name=td_hipo_depositor field_type=varchar field_length=255 field_scale=null field_prec=255 page=5 order=96 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(Z_ACCOUNT_5) name=з-расч.счет field_name=account table_name=td_hipo_depositor field_type=varchar field_length=255 field_scale=null field_prec=255 page=5 order=97 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(Z_ISSUE_DATE_5) name=з-когда выдан field_name=d_issue_date table_name=td_hipo_depositor field_type=datetime field_length=8 field_scale=3 field_prec=23 page=5 order=93 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(CMNT_5) name=З-комментарий field_name=cmnt table_name=td_hipo_depositor field_type=varchar field_length=255 field_scale=null field_prec=255 page=5 order=100 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(SHORT_NAME_2_0) name=З-короткое имя field_name=short_name table_name=td_hipo_depositor field_type=varchar field_length=255 field_scale=null field_prec=255 page=0 order=102 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(REGION_CODE) name=Код региона field_name=region_code table_name=td_hipo_object field_type=varchar field_length=50 field_scale=null field_prec=null page=2 order=35 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(CITY) name=Город field_name=city table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null page=2 order=36 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(STREET) name=Улица field_name=street table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null page=2 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(BUILDING) name=Дом field_name=building table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null page=2 order=38 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(CORPS) name=Корпус field_name=corps table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null 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(FLAT) name=Номер квартиры field_name=flat table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null 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(LIVING) name=Жилая площадь field_name=living table_name=td_hipo_object field_type=money field_length=null field_scale=null field_prec=null page=2 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(SQUARE) name=Общая площадь field_name=square table_name=td_hipo_object field_type=money field_length=null field_scale=null field_prec=null 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(ROOM_QTY) name=Количество комнат field_name=room_qty table_name=td_hipo_object field_type=int field_length=null field_scale=null field_prec=null 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(REALTY_TYPE) name=Тип недвижимости field_name=realty_type table_name=td_hipo_object field_type=numeric field_length=null field_scale=0 field_prec=18 page=2 order=44 init_class=0 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(FLOOR_QTY) name=Этажность field_name=floor_qty table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null 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(PRICE_FROM_BOND) name=Оценочная стоимость из закладной field_name=price_from_bond table_name=td_hipo_object field_type=money field_length=null field_scale=null field_prec=null 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(PRICE_FOR_SALE) name=Продажная стоимость field_name=price_for_sale table_name=td_hipo_object field_type=money field_length=null field_scale=null field_prec=null 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(VALUER_NAME) name=Оценщик-наименование field_name=valuer_name table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null 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(VALUER_ADRESS) name=Оценщик-адрес field_name=valuer_adress table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null 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(VALUER_LICENCE) name=Оценщик-лицензия field_name=valuer_licence table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null 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(VALUER_DATE) name=Дата оценки field_name=valuer_date table_name=td_hipo_object field_type=datetime field_length=null field_scale=null field_prec=null 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(VALUER_PRICE) name=Оценочная стоимость из отчета field_name=valuer_price table_name=td_hipo_object field_type=money field_length=null field_scale=null field_prec=null 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(HIPO_REGISTR) name=Регистратор ипотеки field_name=hipo_registr table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null page=2 order=53 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(HIPO_REGISTR_DATE) name=Дата регистрации ипотеки field_name=hipo_registr_date table_name=td_hipo_object field_type=datetime field_length=null field_scale=null field_prec=null 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(DEPO_NAME) name=Депозитарий хранения закладной field_name=depo_name table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null page=2 order=55 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(ISSUE_DATE) name=Дата выдачи кредита field_name=issue_date table_name=td_hipo_object field_type=datetime field_length=null field_scale=null field_prec=null page=1 order=56 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(INSUR_DOG_NAME) name=Страх.-Наим.договора field_name=insur_dog_name table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null page=3 order=57 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(INSUR_DOG_NUM) name=Страх.-номер договора field_name=insur_dog_num table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null page=3 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(INSUR_DOG_DATE) name=Страх.-дата договора field_name=insur_dog_date table_name=td_hipo_object field_type=datetime field_length=null field_scale=null field_prec=null page=3 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(INSUR_SUM) name=Страх.-сумма field_name=insur_sum table_name=td_hipo_object field_type=money field_length=null field_scale=null field_prec=null page=3 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(INSUR_B) name=Страх.-начало field_name=insur_b table_name=td_hipo_object field_type=datetime field_length=null field_scale=null field_prec=null page=3 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 $PROP(INSUR_E) name=Страх.-конец field_name=insur_e table_name=td_hipo_object field_type=datetime field_length=null field_scale=null field_prec=null page=3 order=62 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(INSUR_COMPANY_NAME) name=Страх.-Наименование СК field_name=insur_company_name table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null page=3 order=63 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(INSUR_COMPANY_ADRESS) name=Страх.-адрес СК field_name=insur_company_adress table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null page=3 order=64 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(INSUR_LICENCE) name=Страх.-Лицензия СК field_name=insur_licence table_name=td_hipo_object field_type=varchar field_length=255 field_scale=null field_prec=null page=3 order=65 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(COMPLIANCE) name=Выгодоприобретатель соответствует field_name=compliance table_name=td_hipo_object field_type=int field_length=null field_scale=null field_prec=null page=3 order=66 init_class=0 init_formula=0 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(TO_ZALOG) name=Это имущество field_name=to_zalog table_name=td_hipo_object field_type=int field_length=null field_scale=null field_prec=null page=3 order=67 init_class=0 init_formula=0 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=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(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=1 order=6 init_class=0 init_formula=$TEXT(19004917) isnull(@stock_emiss_no,'')+(select '/'+@serial where len(@serial)>0) $ENDTEXT(19004917) 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=1 order=7 init_class=0 init_formula='Ипотечная закладная гос.№ ' + @stock_emiss_no + ': кред. договор № ' + @emiss_statereg_no + ' от ' + convert(varchar(30),@emiss_statereg_date,4) + ' на сумму ' + convert(varchar(150),@stock_nominal) 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=Вид ценной бумаги (read only) field_name=stock_type_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=2 init_class=2 init_formula=$TEXT(19004917) (select min(t_stock_types.id) from t_stock_types where stock_type_id=12 and .ITEMS_EXISTS_BY_TYPE(t_stock_types.id,'STOCK_TYPE')) $ENDTEXT(19004917) 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=1 order=20 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(ISSUE_FORM_ID) name=Форма выпуска (read only) field_name=issue_form_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=3 init_class=2 init_formula=2 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=9 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=10 init_class=2 init_formula=.CUR('RUR') unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=34 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=16 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=15 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=11 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=8 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(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=1 order=33 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=21 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=22 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(STOCK_ACTIV_FLAG_0) 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=98 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=1 order=29 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=30 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=25 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=1 order=32 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=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(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=1 order=18 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(REEVALUATION) name=Депонирован в депозитарии field_name=reevaluation table_name=td_stock_emis field_type=int field_length=4 field_scale=0 field_prec=10 page=1 order=19 init_class=2 init_formula=0 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PAYMENT_PLACE) name=Место платежа field_name=payment_place table_name=td_stock_emis field_type=varchar field_length=255 field_scale=null field_prec=255 page=1 order=12 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(EXCH_BILL_TYPE_ID) name=Тип векселя field_name=exch_bill_type_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=4 init_class=2 init_formula=1 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PAYER_ID) name=Залогодатель field_name=payer_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=31 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PART_PAYER_ID) name=Фонд field_name=part_payer_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=14 init_class=0 init_formula=.ORGANIZATION_PIF 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(REW_BILL_TYPE_ID) name=Тип по вознаграждению field_name=rew_bill_type_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=5 init_class=2 init_formula=1 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(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=1 order=23 init_class=1 init_formula=0 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(SERIAL) name=Номер закладной у агента field_name=serial table_name=td_stock_emis field_type=varchar field_length=50 field_scale=null field_prec=50 page=1 order=24 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(FIRST_PARTNER_ID) name=Банк-первоначальный залогодержатель field_name=first_partner_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=26 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(ENDORSEMENT) name=Индоссамент (закрыт - 0/открыт - 1) field_name=endorsement table_name=td_stock_emis field_type=int field_length=4 field_scale=0 field_prec=10 page=1 order=27 init_class=1 init_formula=0 unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(PAYER_BILL_ID) name=Должник field_name=payer_bill_id table_name=td_stock_emis field_type=numeric field_length=9 field_scale=0 field_prec=18 page=1 order=13 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $PROP(UNDEPLOY_DATE) name=Дата погашения field_name=undeploy_date table_name=td_stock_emis field_type=datetime field_length=8 field_scale=3 field_prec=23 page=1 order=28 init_class=null init_formula=null unique_index=null numerator=null import_type=null import_table=null import_field=null import_where=null ref_table=null ref_key=null ref_display=null ref_alias=null ref_where=null $ENDPROP $RELATION(REL1) class=0 type=CUR form=null prop=STOCK_CURR_ID idname=null order=50 $ENDRELATION $RELATION(REL7) class=0 type=PARTNERS form=null prop=EMMITENT_ID idname=null order=45 $ENDRELATION $RELATION(REL4) class=0 type=BANKS form=null prop=FIRST_PARTNER_ID idname=null order=20 $ENDRELATION $RELATION(REL8) class=0 type=BANKS form=null prop=BANK_ID_4 idname=null order=60 $ENDRELATION $RELATION(REL9) class=0 type=BANKS form=null prop=Z_BANK_ID_5 idname=null order=70 $ENDRELATION $RELATION(REL6) class=0 type=STOCK_TYPE form=null prop=STOCK_TYPE_ID idname=null order=10 $ENDRELATION $RELATION(REL5) class=1 type=HP_PYMNT_SCHEDULE form=PYMNT_SCHED_LIST prop=null idname=hipo_bond_id_s order=100 $ENDRELATION $FORM(HP_BOND_LIST) name=Список class=4 filter=HP_BOND_LIST_FILTER target_state= uo=uo_list dw=d_h_bond_list procedure=ap_30000000000263863 patterns=GENERIC_VIEW_LIST_P1 user_define=1 isvisible=1 istab=0 posx=0 posy=0 width=5783 height=1012 proc_text=$TEXT(19004929) create procedure dbo.%PROC% @sid varchar(30) = null .ARGLIST_FILTER as .BEGIN('N') .CHECK_USER .CHECK_VIEW_LIST .ARGCONVERT_FILTER .VIEW_LIST(ALL,1) and isnull(rtrim(ltrim(upper(convert(varchar(255),(select td_hipo_debtor.last_name from td_hipo_debtor where td_hipo_debtor.id = t_items.id))))),'') LIKE isnull('%'+rtrim(ltrim(upper(@mortgagor_filter_nn)))+'%','%') and isnull(rtrim(ltrim(upper(convert(varchar(255),(select td_hipo_depositor.last_name from td_hipo_depositor where td_hipo_depositor.id = t_items.id))))),'') LIKE isnull('%'+rtrim(ltrim(upper(@depositor_filter_nn)))+'%','%') .END $ENDTEXT(19004929) $ACTION2RELATION(REL4.BANK_NAME) relation=REL4 where=null prop=BANK_NAME order=11 alias=bank_name $ENDACTION2RELATION $ACTION2RELATION(REL1.CUR_CODE) relation=REL1 where=null prop=CUR_CODE order=15 alias=cur_code $ENDACTION2RELATION $ACTION2RELATION(REL7.PARTNER_SHORT_NAME) relation=REL7 where=null prop=PARTNER_SHORT_NAME order=10 alias=partner_short_name $ENDACTION2RELATION $CALC(MORTGAGOR) class=1 type=varchar calc_lenght=255 calc_prec=null calc_scale=null formula=$TEXT(19004931) select td_hipo_debtor.short_name from td_hipo_debtor where td_hipo_debtor.id = t_items.id $ENDTEXT(19004931) label=Должник order=10 $ENDCALC $CALC(DEPOSITOR) class=1 type=varchar calc_lenght=255 calc_prec=null calc_scale=null formula=$TEXT(19004931) select td_hipo_depositor.short_name from td_hipo_depositor where td_hipo_depositor.id = t_items.id $ENDTEXT(19004931) label=Залогодатель order=11 $ENDCALC $ENDFORM $FORM(HP_BOND_LIST_FILTER) name=Фильтр class=6 filter=null target_state= uo=uo_filter dw=d_h_bond_list_filter procedure=null patterns=null user_define=0 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=null $FILTER(MORTGAGOR_FILTER) type=3 label=Должник prop=null arg_code=mortgagor_filter arg_type=varchar arg_length=255 arg_prec=null arg_scale=null $ENDFILTER $FILTER(DEPOSITOR_FILTER) type=3 label=Залогодатель prop=null arg_code=depositor_filter arg_type=varchar arg_length=255 arg_prec=null arg_scale=null $ENDFILTER $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(FIRST_PARTNER_ID) type=1 label=Банк-перв.залогодержатель prop=FIRST_PARTNER_ID arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $FILTER(EMISS_STATEREG_DATE) type=2 label=Дата кред.договора prop=EMISS_STATEREG_DATE 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_NOMINAL) type=2 label=Сумма кредита prop=STOCK_NOMINAL arg_code=null arg_type=null arg_length=null arg_prec=null arg_scale=null $ENDFILTER $ENDFORM $FORM(HP_BOND_VIEW) name=Просмотр class=5 filter=null target_state= uo=uo_edit dw=d_h_bond_edit procedure=ap_30000000000263882 patterns=GENERIC_VIEW_ITEM_P1 user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=4224 height=2528 proc_text=$TEXT(19004932) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_VIEW_ITEM .INT_VAR(@stock_activ_flag) if @id = -1 begin begin tran --.GET_PROPS .GET_PROPS(ALL,1) .GET_PROPS(ALL,2) .GET_PROPS(ALL,3) .GET_PROPS(ALL,4) declare @short_name varchar(255) .CHECK_INSERT .INIT_VARS(B) .INSERT_ITEMS .INSERT commit tran end .VIEW_ITEM(ALL,1) .END $ENDTEXT(19004932) $ACTION2RELATION(REL6.STOCK_TYPE_NAME) relation=REL6 where=null prop=STOCK_TYPE_NAME order=6 alias=stock_type_name $ENDACTION2RELATION $ACTION2RELATION(REL4.BANK_CODE) relation=REL4 where=null prop=BANK_CODE order=19 alias=bank_code $ENDACTION2RELATION $ACTION2RELATION(REL4.BANK_NAME) relation=REL4 where=null prop=BANK_NAME order=18 alias=bank_name $ENDACTION2RELATION $ACTION2RELATION(REL7.PARTNER_CODE) relation=REL7 where=null prop=PARTNER_CODE order=21 alias=partner_code $ENDACTION2RELATION $ACTION2RELATION(REL7.PARTNER_SHORT_NAME) relation=REL7 where=null prop=PARTNER_SHORT_NAME order=10 alias=partner_short_name $ENDACTION2RELATION $BIND(BIND3) type=HP_BOND action=HP_DEPOSITOR class=1 order=40 idname=null $ENDBIND $BIND(BIND1) type=HP_BOND action=HP_OBJECT class=1 order=10 idname=sid $ENDBIND $BIND(BIND2) type=HP_BOND action=HP_OBJECT_INSUR class=1 order=20 idname=sid $ENDBIND $BIND(BIND4) type=HP_BOND action=HP_MORT class=1 order=30 idname=sid $ENDBIND $ENDFORM $FORM(HP_DEPOSITOR) name=Залогодатель class=5 filter=null target_state= uo=uo_edit dw=d_h_debtor procedure=ap_30000000000283694 patterns=GENERIC_VIEW_ITEM_P3 user_define=1 isvisible=1 istab=0 posx=null posy=null width=null height=null proc_text=$TEXT(19004934) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_VIEW_ITEM .VIEW_ITEM(ALL,5) .END $ENDTEXT(19004934) $ACTION2RELATION(REL9.BANK_CODE) relation=REL9 where=null prop=BANK_CODE order=17 alias=bank_code $ENDACTION2RELATION $ACTION2RELATION(REL9.BANK_NAME) relation=REL9 where=null prop=BANK_NAME order=11 alias=bank_name $ENDACTION2RELATION $ENDFORM $FORM(HP_MORT) name=Должник class=5 filter=null target_state= uo=uo_edit dw=d_h_debtor procedure=ap_30000000000282750 patterns=GENERIC_VIEW_ITEM_P2 user_define=1 isvisible=1 istab=0 posx=null posy=null width=null height=null proc_text=$TEXT(19004934) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_VIEW_ITEM .VIEW_ITEM(ALL,4) .END $ENDTEXT(19004934) $ACTION2RELATION(REL8.BANK_CODE) relation=REL8 where=null prop=BANK_CODE order=17 alias=bank_code $ENDACTION2RELATION $ACTION2RELATION(REL8.BANK_NAME) relation=REL8 where=null prop=BANK_NAME order=11 alias=bank_name $ENDACTION2RELATION $ENDFORM $FORM(HP_OBJECT) name=Объект залога class=5 filter=null target_state= uo=uo_edit dw=d_h_bond_object procedure=ap_30000000000263897 patterns=GENERIC_VIEW_ITEM_P2 user_define=0 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004934) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_VIEW_ITEM .VIEW_ITEM(ALL,2) .END $ENDTEXT(19004934) $ENDFORM $FORM(HP_OBJECT_INSUR) name=Страхование объекта class=5 filter=null target_state= uo=uo_edit dw=d_h_bond_insur procedure=ap_30000000000263899 patterns=GENERIC_VIEW_ITEM_P3 user_define=0 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004935) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_VIEW_ITEM .VIEW_ITEM(ALL,3) .END $ENDTEXT(19004935) $ENDFORM $ACTION(ADD_H_BOND) name=Добавить class=1 form=HP_BOND_VIEW target_state=CRT procedure=ap_30000000000263901 patterns=GENERIC_INSERT_P1 user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004935) create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST(ALL,1) as .BEGIN('N') .CHECK_USER .CHECK_UPDATE .ARGCONVERT(ALL,1) .INIT_VARS(AFTER,ALL,1) .TEST_ORGANIZATION_PIF(@part_payer_id) .TEST_UNIQUE(ALL,1) begin tran .UPDATE(ALL,1) .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran select sid = convert(varchar,@id) .END $ENDTEXT(19004935) $BIND(BIND3) type=HP_BOND action=HP_DEPOSITOR_EDIT class=1 order=40 idname=null $ENDBIND $BIND(BIND1) type=HP_BOND action=HP_OBJECT_EDIT class=1 order=10 idname=null $ENDBIND $BIND(BIND2) type=HP_BOND action=HP_OBJECT_INSUR_EDIT class=1 order=20 idname=null $ENDBIND $BIND(BIND4) type=HP_BOND action=HP_MORT_EDIT class=1 order=30 idname=null $ENDBIND $ENDACTION $ACTION(DEL_H_BOND) name=Удалить class=3 form=HP_BOND_VIEW target_state=DEL procedure=ap_30000000000263906 patterns=GENERIC_MOVE user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004935) create procedure dbo.%PROC% @sid varchar(30) = null as .BEGIN('N') .CHECK_USER .CHECK_UPDATE begin tran .UPDATE_STATE .ACTION_HISTORY /*--Удаление графиков платежей этой закладной--*/ .ID_VAR(@cur_sched_id) declare @cur_sched_sid varchar(30) declare my_schedules cursor for select td_hipo_pymnt_schedule.id from td_hipo_pymnt_schedule where hipo_bond_id=@id and .ITEMS_EXISTS(td_hipo_pymnt_schedule.id) open my_schedules fetch my_schedules into @cur_sched_id while(.CURSOR_STATE = 0) begin select @cur_sched_sid = convert(varchar(30), @cur_sched_id) .EXEC_ACTION(@cur_sched_sid,'HP_PYMNT_SCHEDULE','DEL_ROWS') --удаление платежей из графика .EXEC_ACTION(@cur_sched_sid,'HP_PYMNT_SCHEDULE','DEL_SCHEDULE') --удаление самого графика fetch my_schedules into @cur_sched_id end commit tran .END $ENDTEXT(19004935) $BIND(BIND1) type=HP_BOND action=HP_OBJECT class=1 order=10 idname=null $ENDBIND $ENDACTION $ACTION(HP_DEPOSITOR_EDIT) name=Залогодатель(изм.) class=2 form=HP_DEPOSITOR target_state=null procedure=ap_30000000000283699 patterns=GENERIC_UPDATE_P2 user_define=1 isvisible=1 istab=0 posx=null posy=null width=null height=null proc_text=$TEXT(19004937) create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST(ALL, 5) as .BEGIN('N') .CHECK_USER .CHECK_UPDATE .ARGCONVERT(ALL, 5) .TEST_UNIQUE(ALL, 5) .GET_PROPS(ALL,1) begin tran .UPDATE_ITEMS --заполнение короткого имени-- declare @short_name varchar(255) if @face_type = 0 begin select @short_name = @last_name + " " + .FIRST_LETTER(@first_name) + "." if not @middle_name is null select @short_name = @short_name + .FIRST_LETTER(@middle_name) + "." end if @face_type = 1 select @short_name = @last_name + " (ИНН:" + @first_name + ")" update td_hipo_depositor set short_name = @short_name where id=@id .UPDATE(ALL,5) .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran .END $ENDTEXT(19004937) $ENDACTION $ACTION(HP_MORT_EDIT) name=Должник(изм.) class=2 form=HP_MORT target_state=null procedure=ap_30000000000282755 patterns=GENERIC_UPDATE_P2 user_define=1 isvisible=1 istab=0 posx=null posy=null width=null height=null proc_text=$TEXT(19004937) create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST(ALL, 4) as .BEGIN('N') .CHECK_USER .CHECK_UPDATE .ARGCONVERT(ALL, 4) .TEST_UNIQUE(ALL, 4) .GET_PROPS(ALL,1) begin tran .UPDATE_ITEMS --заполнение короткого имени-- declare @short_name varchar(255) if @face_type = 0 begin select @short_name = @last_name + " " + .FIRST_LETTER(@first_name) + "." if not @middle_name is null select @short_name = @short_name + .FIRST_LETTER(@middle_name) + "." end if @face_type = 1 select @short_name = @last_name + " (ИНН:" + @first_name + ")" update td_hipo_debtor set short_name = @short_name where id=@id .UPDATE(ALL,4) .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran .END $ENDTEXT(19004937) $ENDACTION $ACTION(HP_OBJECT_EDIT) name=Объект залога (изм.) class=2 form=HP_OBJECT target_state=null procedure=ap_30000000000263902 patterns=GENERIC_UPDATE_P2 user_define=0 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004937) create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST(ALL, 2) as .BEGIN('N') .CHECK_USER .CHECK_UPDATE .ARGCONVERT(ALL, 2) .TEST_UNIQUE(ALL, 2) .GET_PROPS(ALL,1) begin tran .UPDATE_ITEMS .UPDATE(ALL,2) .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran .END $ENDTEXT(19004937) $ENDACTION $ACTION(HP_OBJECT_INSUR_EDIT) name=Страхование объекта(изм.) class=2 form=HP_OBJECT_INSUR target_state=null procedure=ap_30000000000263904 patterns=GENERIC_UPDATE_P2 user_define=0 isvisible=1 istab=0 posx=0 posy=0 width=0 height=0 proc_text=$TEXT(19004937) create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST(ALL, 3) as .BEGIN('N') .CHECK_USER .CHECK_UPDATE .ARGCONVERT(ALL, 3) .TEST_UNIQUE(ALL, 3) .GET_PROPS(ALL,1) begin tran .UPDATE_ITEMS .UPDATE(ALL,3) .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran .END $ENDTEXT(19004937) $ENDACTION $ACTION(UPD_H_BOND) name=Изменить class=2 form=HP_BOND_VIEW target_state=null procedure=ap_30000000000263909 patterns=GENERIC_UPDATE_P1 user_define=1 isvisible=0 istab=1 posx=0 posy=0 width=3442 height=2580 proc_text=$TEXT(19004937) create procedure dbo.%PROC% @sid varchar(30) = null, .ARGLIST(ALL,1) as .BEGIN('N') .CHECK_USER .CHECK_UPDATE .ARGCONVERT(ALL,1) .TEST_UNIQUE(ALL,1) begin tran .UPDATE(ALL,1) .RELGEN .UPDATE_STATE .ACTION_HISTORY commit tran select sid = convert(varchar, @id) .END $ENDTEXT(19004937) $BIND(BIND3) type=HP_BOND action=HP_DEPOSITOR_EDIT class=1 order=40 idname=null $ENDBIND $BIND(BIND4) type=HP_BOND action=HP_MORT_EDIT class=1 order=30 idname=null $ENDBIND $BIND(BIND2) type=HP_BOND action=HP_OBJECT_INSUR_EDIT class=1 order=20 idname=sid $ENDBIND $BIND(BIND1) type=HP_BOND action=HP_OBJECT_EDIT class=1 order=10 idname=sid $ENDBIND $ENDACTION $STATE2ACTION(BEG.ADD_H_BOND) state=BEG action=ADD_H_BOND is_available=1 $ENDSTATE2ACTION $STATE2ACTION(BEG.DEL_H_BOND) state=BEG action=DEL_H_BOND is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.HP_BOND_LIST) state=BEG action=HP_BOND_LIST is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.HP_BOND_LIST_FILTER) state=BEG action=HP_BOND_LIST_FILTER is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.HP_BOND_VIEW) state=BEG action=HP_BOND_VIEW is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.HP_DEPOSITOR) state=BEG action=HP_DEPOSITOR is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.HP_DEPOSITOR_EDIT) state=BEG action=HP_DEPOSITOR_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.HP_MORT) state=BEG action=HP_MORT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.HP_MORT_EDIT) state=BEG action=HP_MORT_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.HP_OBJECT) state=BEG action=HP_OBJECT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.HP_OBJECT_EDIT) state=BEG action=HP_OBJECT_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.HP_OBJECT_INSUR) state=BEG action=HP_OBJECT_INSUR is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.HP_OBJECT_INSUR_EDIT) state=BEG action=HP_OBJECT_INSUR_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(BEG.UPD_H_BOND) state=BEG action=UPD_H_BOND is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.ADD_H_BOND) state=CRT action=ADD_H_BOND is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.DEL_H_BOND) state=CRT action=DEL_H_BOND is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.HP_BOND_LIST) state=CRT action=HP_BOND_LIST is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.HP_BOND_LIST_FILTER) state=CRT action=HP_BOND_LIST_FILTER is_available=0 $ENDSTATE2ACTION $STATE2ACTION(CRT.HP_BOND_VIEW) state=CRT action=HP_BOND_VIEW is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.HP_DEPOSITOR) state=CRT action=HP_DEPOSITOR is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.HP_DEPOSITOR_EDIT) state=CRT action=HP_DEPOSITOR_EDIT is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.HP_MORT) state=CRT action=HP_MORT is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.HP_MORT_EDIT) state=CRT action=HP_MORT_EDIT is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.HP_OBJECT) state=CRT action=HP_OBJECT is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.HP_OBJECT_EDIT) state=CRT action=HP_OBJECT_EDIT is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.HP_OBJECT_INSUR) state=CRT action=HP_OBJECT_INSUR is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.HP_OBJECT_INSUR_EDIT) state=CRT action=HP_OBJECT_INSUR_EDIT is_available=1 $ENDSTATE2ACTION $STATE2ACTION(CRT.UPD_H_BOND) state=CRT action=UPD_H_BOND is_available=1 $ENDSTATE2ACTION $STATE2ACTION(DEL.ADD_H_BOND) state=DEL action=ADD_H_BOND is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.DEL_H_BOND) state=DEL action=DEL_H_BOND is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.HP_BOND_LIST) state=DEL action=HP_BOND_LIST is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.HP_BOND_LIST_FILTER) state=DEL action=HP_BOND_LIST_FILTER is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.HP_BOND_VIEW) state=DEL action=HP_BOND_VIEW is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.HP_DEPOSITOR) state=DEL action=HP_DEPOSITOR is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.HP_DEPOSITOR_EDIT) state=DEL action=HP_DEPOSITOR_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.HP_MORT) state=DEL action=HP_MORT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.HP_MORT_EDIT) state=DEL action=HP_MORT_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.HP_OBJECT) state=DEL action=HP_OBJECT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.HP_OBJECT_EDIT) state=DEL action=HP_OBJECT_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.HP_OBJECT_INSUR) state=DEL action=HP_OBJECT_INSUR is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.HP_OBJECT_INSUR_EDIT) state=DEL action=HP_OBJECT_INSUR_EDIT is_available=0 $ENDSTATE2ACTION $STATE2ACTION(DEL.UPD_H_BOND) state=DEL action=UPD_H_BOND is_available=0 $ENDSTATE2ACTION $STATE2PROP(BEG.ACCOUNT_4) state=BEG prop=ACCOUNT_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.ACC_BRANCH_ID) state=BEG prop=ACC_BRANCH_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.ADRESS_4) state=BEG prop=ADRESS_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.BANK_ID_4) state=BEG prop=BANK_ID_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.BIRTHDAY_4) state=BEG prop=BIRTHDAY_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.BIRTHDAY_PLACE_4) state=BEG prop=BIRTHDAY_PLACE_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.BUILDING) state=BEG prop=BUILDING enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.CITY) state=BEG prop=CITY enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.CMNT_4) state=BEG prop=CMNT_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.CMNT_5) state=BEG prop=CMNT_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.COMPLIANCE) state=BEG prop=COMPLIANCE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.CORPS) state=BEG prop=CORPS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DATE_B) state=BEG prop=DATE_B enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DATE_E) state=BEG prop=DATE_E enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DEPLOUMENT_QTY) state=BEG prop=DEPLOUMENT_QTY enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DEPO_NAME) state=BEG prop=DEPO_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DIVIDEND_PERCENT_VALUE) state=BEG prop=DIVIDEND_PERCENT_VALUE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DOC_NUMBER_4) state=BEG prop=DOC_NUMBER_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.DOC_SERIAL_4) state=BEG prop=DOC_SERIAL_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.EMISS_STATEREG_DATE) state=BEG prop=EMISS_STATEREG_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.EMISS_STATEREG_NO) state=BEG prop=EMISS_STATEREG_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.EMMITENT_ID) state=BEG prop=EMMITENT_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.ENDORSEMENT) state=BEG prop=ENDORSEMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.ENTERPRISE_PERCENT) state=BEG prop=ENTERPRISE_PERCENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.EXCH_BILL_TYPE_ID) state=BEG prop=EXCH_BILL_TYPE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.FACE_TYPE_4) state=BEG prop=FACE_TYPE_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.FIRST_NAME_4) state=BEG prop=FIRST_NAME_4 enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.FIRST_PARTNER_ID) state=BEG prop=FIRST_PARTNER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.FLAT) state=BEG prop=FLAT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.FLOOR_QTY) state=BEG prop=FLOOR_QTY enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.HIPO_REGISTR) state=BEG prop=HIPO_REGISTR enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.HIPO_REGISTR_DATE) state=BEG prop=HIPO_REGISTR_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INSUR_B) state=BEG prop=INSUR_B enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INSUR_COMPANY_ADRESS) state=BEG prop=INSUR_COMPANY_ADRESS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INSUR_COMPANY_NAME) state=BEG prop=INSUR_COMPANY_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INSUR_DOG_DATE) state=BEG prop=INSUR_DOG_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INSUR_DOG_NAME) state=BEG prop=INSUR_DOG_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INSUR_DOG_NUM) state=BEG prop=INSUR_DOG_NUM enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INSUR_E) state=BEG prop=INSUR_E enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INSUR_LICENCE) state=BEG prop=INSUR_LICENCE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.INSUR_SUM) state=BEG prop=INSUR_SUM enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.ISSUE_DATE) state=BEG prop=ISSUE_DATE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.ISSUE_DATE_4) state=BEG prop=ISSUE_DATE_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.ISSUE_FORM_ID) state=BEG prop=ISSUE_FORM_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.LIST_FOLDER_ID) state=BEG prop=LIST_FOLDER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.LIVING) state=BEG prop=LIVING enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.MIDDLE_NAME_4) state=BEG prop=MIDDLE_NAME_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.NAME_4) state=BEG prop=NAME_4 enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PART_PAYER_ID) state=BEG prop=PART_PAYER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PAYER_BILL_ID) state=BEG prop=PAYER_BILL_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PAYER_ID) state=BEG prop=PAYER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PAYMENT_PLACE) state=BEG prop=PAYMENT_PLACE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PERCENT_VALUE) state=BEG prop=PERCENT_VALUE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PERSON_DOC_TYPE_ID_4) state=BEG prop=PERSON_DOC_TYPE_ID_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.POST_ADRESS_4) state=BEG prop=POST_ADRESS_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PRICE_FOR_SALE) state=BEG prop=PRICE_FOR_SALE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.PRICE_FROM_BOND) state=BEG prop=PRICE_FROM_BOND enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.QTY_IN_EMISSION) state=BEG prop=QTY_IN_EMISSION enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.REALTY_TYPE) state=BEG prop=REALTY_TYPE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.REEVALUATION) state=BEG prop=REEVALUATION enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.REGION_CODE) state=BEG prop=REGION_CODE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.REG_ORGANIS) state=BEG prop=REG_ORGANIS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.REW_BILL_TYPE_ID) state=BEG prop=REW_BILL_TYPE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.ROOM_QTY) state=BEG prop=ROOM_QTY enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.SERIAL) state=BEG prop=SERIAL enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.SHORT_NAME_1_0) state=BEG prop=SHORT_NAME_1_0 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.SHORT_NAME_2_0) state=BEG prop=SHORT_NAME_2_0 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.SQUARE) state=BEG prop=SQUARE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.STOCK_ACTIV_FLAG_0) state=BEG prop=STOCK_ACTIV_FLAG_0 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(BEG.STOCK_CANCEL_DATE) state=BEG prop=STOCK_CANCEL_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.STOCK_CODE) state=BEG prop=STOCK_CODE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(BEG.STOCK_COMMENT) state=BEG prop=STOCK_COMMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.STOCK_CURR_ID) state=BEG prop=STOCK_CURR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.STOCK_EMISS_NO) state=BEG prop=STOCK_EMISS_NO enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.STOCK_NAME) state=BEG prop=STOCK_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.STOCK_NOMINAL) state=BEG prop=STOCK_NOMINAL enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.STOCK_TYPE_ID) state=BEG prop=STOCK_TYPE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(BEG.STOCK_UNIT) state=BEG prop=STOCK_UNIT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.STREET) state=BEG prop=STREET enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.TO_ZALOG) state=BEG prop=TO_ZALOG enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.UNDEPLOY_DATE) state=BEG prop=UNDEPLOY_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.VALUER_ADRESS) state=BEG prop=VALUER_ADRESS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.VALUER_DATE) state=BEG prop=VALUER_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.VALUER_LICENCE) state=BEG prop=VALUER_LICENCE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.VALUER_NAME) state=BEG prop=VALUER_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.VALUER_PRICE) state=BEG prop=VALUER_PRICE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.WHO_ISSUED_4) state=BEG prop=WHO_ISSUED_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_ACCOUNT_5) state=BEG prop=Z_ACCOUNT_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_ADRESS_5) state=BEG prop=Z_ADRESS_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_BANK_ID_5) state=BEG prop=Z_BANK_ID_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_BIRTHDAY_5) state=BEG prop=Z_BIRTHDAY_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_BIRTHDAY_PLACE_5) state=BEG prop=Z_BIRTHDAY_PLACE_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_DOC_NUMBER_5) state=BEG prop=Z_DOC_NUMBER_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_DOC_SERIAL_5) state=BEG prop=Z_DOC_SERIAL_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_FACE_TYPE_5) state=BEG prop=Z_FACE_TYPE_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_FIRST_NAME_5) state=BEG prop=Z_FIRST_NAME_5 enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_ISSUE_DATE_5) state=BEG prop=Z_ISSUE_DATE_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_LAST_NAME_5) state=BEG prop=Z_LAST_NAME_5 enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_MIDDLE_NAME_5) state=BEG prop=Z_MIDDLE_NAME_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_PERSON_DOC_TYPE_ID_5) state=BEG prop=Z_PERSON_DOC_TYPE_ID_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_POST_ADRESS_5) state=BEG prop=Z_POST_ADRESS_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(BEG.Z_WHO_ISSUED_5) state=BEG prop=Z_WHO_ISSUED_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.ACCOUNT_4) state=CRT prop=ACCOUNT_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.ACC_BRANCH_ID) state=CRT prop=ACC_BRANCH_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.ADRESS_4) state=CRT prop=ADRESS_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.BANK_ID_4) state=CRT prop=BANK_ID_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.BIRTHDAY_4) state=CRT prop=BIRTHDAY_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.BIRTHDAY_PLACE_4) state=CRT prop=BIRTHDAY_PLACE_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.BUILDING) state=CRT prop=BUILDING enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.CITY) state=CRT prop=CITY enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.CMNT_4) state=CRT prop=CMNT_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.CMNT_5) state=CRT prop=CMNT_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.COMPLIANCE) state=CRT prop=COMPLIANCE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.CORPS) state=CRT prop=CORPS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DATE_B) state=CRT prop=DATE_B enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DATE_E) state=CRT prop=DATE_E enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DEPLOUMENT_QTY) state=CRT prop=DEPLOUMENT_QTY enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DEPO_NAME) state=CRT prop=DEPO_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DIVIDEND_PERCENT_VALUE) state=CRT prop=DIVIDEND_PERCENT_VALUE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DOC_NUMBER_4) state=CRT prop=DOC_NUMBER_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.DOC_SERIAL_4) state=CRT prop=DOC_SERIAL_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.EMISS_STATEREG_DATE) state=CRT prop=EMISS_STATEREG_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.EMISS_STATEREG_NO) state=CRT prop=EMISS_STATEREG_NO enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.EMMITENT_ID) state=CRT prop=EMMITENT_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.ENDORSEMENT) state=CRT prop=ENDORSEMENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.ENTERPRISE_PERCENT) state=CRT prop=ENTERPRISE_PERCENT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.EXCH_BILL_TYPE_ID) state=CRT prop=EXCH_BILL_TYPE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.FACE_TYPE_4) state=CRT prop=FACE_TYPE_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.FIRST_NAME_4) state=CRT prop=FIRST_NAME_4 enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.FIRST_PARTNER_ID) state=CRT prop=FIRST_PARTNER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.FLAT) state=CRT prop=FLAT enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.FLOOR_QTY) state=CRT prop=FLOOR_QTY enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.HIPO_REGISTR) state=CRT prop=HIPO_REGISTR enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.HIPO_REGISTR_DATE) state=CRT prop=HIPO_REGISTR_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INSUR_B) state=CRT prop=INSUR_B enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INSUR_COMPANY_ADRESS) state=CRT prop=INSUR_COMPANY_ADRESS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INSUR_COMPANY_NAME) state=CRT prop=INSUR_COMPANY_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INSUR_DOG_DATE) state=CRT prop=INSUR_DOG_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INSUR_DOG_NAME) state=CRT prop=INSUR_DOG_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INSUR_DOG_NUM) state=CRT prop=INSUR_DOG_NUM enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INSUR_E) state=CRT prop=INSUR_E enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INSUR_LICENCE) state=CRT prop=INSUR_LICENCE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.INSUR_SUM) state=CRT prop=INSUR_SUM enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.ISSUE_DATE) state=CRT prop=ISSUE_DATE enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.ISSUE_DATE_4) state=CRT prop=ISSUE_DATE_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.ISSUE_FORM_ID) state=CRT prop=ISSUE_FORM_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.LIST_FOLDER_ID) state=CRT prop=LIST_FOLDER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.LIVING) state=CRT prop=LIVING enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.MIDDLE_NAME_4) state=CRT prop=MIDDLE_NAME_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.NAME_4) state=CRT prop=NAME_4 enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PART_PAYER_ID) state=CRT prop=PART_PAYER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PAYER_BILL_ID) state=CRT prop=PAYER_BILL_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PAYER_ID) state=CRT prop=PAYER_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PAYMENT_PLACE) state=CRT prop=PAYMENT_PLACE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PERCENT_VALUE) state=CRT prop=PERCENT_VALUE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PERSON_DOC_TYPE_ID_4) state=CRT prop=PERSON_DOC_TYPE_ID_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.POST_ADRESS_4) state=CRT prop=POST_ADRESS_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PRICE_FOR_SALE) state=CRT prop=PRICE_FOR_SALE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.PRICE_FROM_BOND) state=CRT prop=PRICE_FROM_BOND enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.QTY_IN_EMISSION) state=CRT prop=QTY_IN_EMISSION enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.REALTY_TYPE) state=CRT prop=REALTY_TYPE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.REEVALUATION) state=CRT prop=REEVALUATION enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.REGION_CODE) state=CRT prop=REGION_CODE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.REG_ORGANIS) state=CRT prop=REG_ORGANIS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.REW_BILL_TYPE_ID) state=CRT prop=REW_BILL_TYPE_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.ROOM_QTY) state=CRT prop=ROOM_QTY enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.SERIAL) state=CRT prop=SERIAL enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.SHORT_NAME_1_0) state=CRT prop=SHORT_NAME_1_0 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.SHORT_NAME_2_0) state=CRT prop=SHORT_NAME_2_0 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.SQUARE) state=CRT prop=SQUARE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_ACTIV_FLAG_0) state=CRT prop=STOCK_ACTIV_FLAG_0 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_CANCEL_DATE) state=CRT prop=STOCK_CANCEL_DATE enable=1 mandatory=0 visible=1 $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=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_CURR_ID) state=CRT prop=STOCK_CURR_ID enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_EMISS_NO) state=CRT prop=STOCK_EMISS_NO enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_NAME) state=CRT prop=STOCK_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.STOCK_NOMINAL) state=CRT prop=STOCK_NOMINAL enable=1 mandatory=0 visible=1 $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=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.STREET) state=CRT prop=STREET enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.TO_ZALOG) state=CRT prop=TO_ZALOG enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.UNDEPLOY_DATE) state=CRT prop=UNDEPLOY_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.VALUER_ADRESS) state=CRT prop=VALUER_ADRESS enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.VALUER_DATE) state=CRT prop=VALUER_DATE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.VALUER_LICENCE) state=CRT prop=VALUER_LICENCE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.VALUER_NAME) state=CRT prop=VALUER_NAME enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.VALUER_PRICE) state=CRT prop=VALUER_PRICE enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.WHO_ISSUED_4) state=CRT prop=WHO_ISSUED_4 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_ACCOUNT_5) state=CRT prop=Z_ACCOUNT_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_ADRESS_5) state=CRT prop=Z_ADRESS_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_BANK_ID_5) state=CRT prop=Z_BANK_ID_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_BIRTHDAY_5) state=CRT prop=Z_BIRTHDAY_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_BIRTHDAY_PLACE_5) state=CRT prop=Z_BIRTHDAY_PLACE_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_DOC_NUMBER_5) state=CRT prop=Z_DOC_NUMBER_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_DOC_SERIAL_5) state=CRT prop=Z_DOC_SERIAL_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_FACE_TYPE_5) state=CRT prop=Z_FACE_TYPE_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_FIRST_NAME_5) state=CRT prop=Z_FIRST_NAME_5 enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_ISSUE_DATE_5) state=CRT prop=Z_ISSUE_DATE_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_LAST_NAME_5) state=CRT prop=Z_LAST_NAME_5 enable=1 mandatory=1 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_MIDDLE_NAME_5) state=CRT prop=Z_MIDDLE_NAME_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_PERSON_DOC_TYPE_ID_5) state=CRT prop=Z_PERSON_DOC_TYPE_ID_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_POST_ADRESS_5) state=CRT prop=Z_POST_ADRESS_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(CRT.Z_WHO_ISSUED_5) state=CRT prop=Z_WHO_ISSUED_5 enable=1 mandatory=0 visible=1 $ENDSTATE2PROP $STATE2PROP(DEL.ACCOUNT_4) state=DEL prop=ACCOUNT_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ACC_BRANCH_ID) state=DEL prop=ACC_BRANCH_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ADRESS_4) state=DEL prop=ADRESS_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.BANK_ID_4) state=DEL prop=BANK_ID_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.BIRTHDAY_4) state=DEL prop=BIRTHDAY_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.BIRTHDAY_PLACE_4) state=DEL prop=BIRTHDAY_PLACE_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.BUILDING) state=DEL prop=BUILDING enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CITY) state=DEL prop=CITY enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CMNT_4) state=DEL prop=CMNT_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CMNT_5) state=DEL prop=CMNT_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.COMPLIANCE) state=DEL prop=COMPLIANCE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.CORPS) state=DEL prop=CORPS enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DATE_B) state=DEL prop=DATE_B enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DATE_E) state=DEL prop=DATE_E enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DEPLOUMENT_QTY) state=DEL prop=DEPLOUMENT_QTY enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DEPO_NAME) state=DEL prop=DEPO_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DIVIDEND_PERCENT_VALUE) state=DEL prop=DIVIDEND_PERCENT_VALUE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DOC_NUMBER_4) state=DEL prop=DOC_NUMBER_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.DOC_SERIAL_4) state=DEL prop=DOC_SERIAL_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.EMISS_STATEREG_DATE) state=DEL prop=EMISS_STATEREG_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.EMISS_STATEREG_NO) state=DEL prop=EMISS_STATEREG_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.EMMITENT_ID) state=DEL prop=EMMITENT_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ENDORSEMENT) state=DEL prop=ENDORSEMENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ENTERPRISE_PERCENT) state=DEL prop=ENTERPRISE_PERCENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.EXCH_BILL_TYPE_ID) state=DEL prop=EXCH_BILL_TYPE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.FACE_TYPE_4) state=DEL prop=FACE_TYPE_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.FIRST_NAME_4) state=DEL prop=FIRST_NAME_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.FIRST_PARTNER_ID) state=DEL prop=FIRST_PARTNER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.FLAT) state=DEL prop=FLAT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.FLOOR_QTY) state=DEL prop=FLOOR_QTY enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.HIPO_REGISTR) state=DEL prop=HIPO_REGISTR enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.HIPO_REGISTR_DATE) state=DEL prop=HIPO_REGISTR_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INSUR_B) state=DEL prop=INSUR_B enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INSUR_COMPANY_ADRESS) state=DEL prop=INSUR_COMPANY_ADRESS enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INSUR_COMPANY_NAME) state=DEL prop=INSUR_COMPANY_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INSUR_DOG_DATE) state=DEL prop=INSUR_DOG_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INSUR_DOG_NAME) state=DEL prop=INSUR_DOG_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INSUR_DOG_NUM) state=DEL prop=INSUR_DOG_NUM enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INSUR_E) state=DEL prop=INSUR_E enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INSUR_LICENCE) state=DEL prop=INSUR_LICENCE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.INSUR_SUM) state=DEL prop=INSUR_SUM enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ISSUE_DATE) state=DEL prop=ISSUE_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ISSUE_DATE_4) state=DEL prop=ISSUE_DATE_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ISSUE_FORM_ID) state=DEL prop=ISSUE_FORM_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.LIST_FOLDER_ID) state=DEL prop=LIST_FOLDER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.LIVING) state=DEL prop=LIVING enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.MIDDLE_NAME_4) state=DEL prop=MIDDLE_NAME_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.NAME_4) state=DEL prop=NAME_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PART_PAYER_ID) state=DEL prop=PART_PAYER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PAYER_BILL_ID) state=DEL prop=PAYER_BILL_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PAYER_ID) state=DEL prop=PAYER_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PAYMENT_PLACE) state=DEL prop=PAYMENT_PLACE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PERCENT_VALUE) state=DEL prop=PERCENT_VALUE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PERSON_DOC_TYPE_ID_4) state=DEL prop=PERSON_DOC_TYPE_ID_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.POST_ADRESS_4) state=DEL prop=POST_ADRESS_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PRICE_FOR_SALE) state=DEL prop=PRICE_FOR_SALE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.PRICE_FROM_BOND) state=DEL prop=PRICE_FROM_BOND enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.QTY_IN_EMISSION) state=DEL prop=QTY_IN_EMISSION enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.REALTY_TYPE) state=DEL prop=REALTY_TYPE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.REEVALUATION) state=DEL prop=REEVALUATION enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.REGION_CODE) state=DEL prop=REGION_CODE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.REG_ORGANIS) state=DEL prop=REG_ORGANIS enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.REW_BILL_TYPE_ID) state=DEL prop=REW_BILL_TYPE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.ROOM_QTY) state=DEL prop=ROOM_QTY enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.SERIAL) state=DEL prop=SERIAL enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.SHORT_NAME_1_0) state=DEL prop=SHORT_NAME_1_0 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.SHORT_NAME_2_0) state=DEL prop=SHORT_NAME_2_0 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.SQUARE) state=DEL prop=SQUARE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STOCK_ACTIV_FLAG_0) state=DEL prop=STOCK_ACTIV_FLAG_0 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STOCK_CANCEL_DATE) state=DEL prop=STOCK_CANCEL_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STOCK_CODE) state=DEL prop=STOCK_CODE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STOCK_COMMENT) state=DEL prop=STOCK_COMMENT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STOCK_CURR_ID) state=DEL prop=STOCK_CURR_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STOCK_EMISS_NO) state=DEL prop=STOCK_EMISS_NO enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STOCK_NAME) state=DEL prop=STOCK_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STOCK_NOMINAL) state=DEL prop=STOCK_NOMINAL enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STOCK_TYPE_ID) state=DEL prop=STOCK_TYPE_ID enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STOCK_UNIT) state=DEL prop=STOCK_UNIT enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.STREET) state=DEL prop=STREET enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.TO_ZALOG) state=DEL prop=TO_ZALOG enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.UNDEPLOY_DATE) state=DEL prop=UNDEPLOY_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.VALUER_ADRESS) state=DEL prop=VALUER_ADRESS enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.VALUER_DATE) state=DEL prop=VALUER_DATE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.VALUER_LICENCE) state=DEL prop=VALUER_LICENCE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.VALUER_NAME) state=DEL prop=VALUER_NAME enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.VALUER_PRICE) state=DEL prop=VALUER_PRICE enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.WHO_ISSUED_4) state=DEL prop=WHO_ISSUED_4 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_ACCOUNT_5) state=DEL prop=Z_ACCOUNT_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_ADRESS_5) state=DEL prop=Z_ADRESS_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_BANK_ID_5) state=DEL prop=Z_BANK_ID_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_BIRTHDAY_5) state=DEL prop=Z_BIRTHDAY_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_BIRTHDAY_PLACE_5) state=DEL prop=Z_BIRTHDAY_PLACE_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_DOC_NUMBER_5) state=DEL prop=Z_DOC_NUMBER_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_DOC_SERIAL_5) state=DEL prop=Z_DOC_SERIAL_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_FACE_TYPE_5) state=DEL prop=Z_FACE_TYPE_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_FIRST_NAME_5) state=DEL prop=Z_FIRST_NAME_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_ISSUE_DATE_5) state=DEL prop=Z_ISSUE_DATE_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_LAST_NAME_5) state=DEL prop=Z_LAST_NAME_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_MIDDLE_NAME_5) state=DEL prop=Z_MIDDLE_NAME_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_PERSON_DOC_TYPE_ID_5) state=DEL prop=Z_PERSON_DOC_TYPE_ID_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_POST_ADRESS_5) state=DEL prop=Z_POST_ADRESS_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $STATE2PROP(DEL.Z_WHO_ISSUED_5) state=DEL prop=Z_WHO_ISSUED_5 enable=0 mandatory=0 visible=0 $ENDSTATE2PROP $ENDDOC