# Date: 05/04/06
# Version: 105

$DOC(SESSION_SCRIPTS)
 name=Сессионные скрипты
 class=0
 product=ALD_SQL
 name_formula=null
 remark_formula=null

 $ACTION(DEFAULT)
  name=Сессионный скрипт по умолчанию
  class=9
  form=null
  target_state=null
  procedure=null
  patterns=null
  user_define=1
  isvisible=1
  istab=0
  posx=null
  posy=null
  width=null
  height=null
  proc_text=$TEXT(11561720)
--
-- Таблица для шаблона .BACK_SETUP_BAL_SUM
--
create table #back_setup_sum_bal_ops (
   op_id numeric(18,0) not null,
   item_id numeric(18,0) not null
)
go
create table #back_setup_sum_bal_acc (
   sum_bal money null,
   qty_sum money null,
   sum_accur money null,
   acc_id numeric(18)
)
go
--
-- Таблица для шаблона .BACK_SETUP_PROFIT_OR_LOSS
--
create table #back_setup_profit_or_loss_temp (
   acc_id numeric (18),
   deb_or_cred int, sum_bal money
)
go
--
-- Алиасы
--
create table #t_alias2items (
   id numeric not null,
   alias_code varchar(100) not null,
   money_value money null,
   decimal_value decimal(38,16) null,
   date_value datetime null,
   id_value numeric null,
   str_value varchar(255) null,
   parm_type varchar(30) null,
   alias_id numeric null,
   doc_type_id numeric null,
   primary key(id, alias_code)
)
go
--
-- LIFO-FIFO
--
create table #lifo_fifo_ops (
   mode int,
   id numeric,
   day datetime,
   sum_bal money,
   sum_qty money null,
   deb_or_cred int,
   sub_id numeric,
   sum_bal_accur money
)
go
create table #lifo_fifo_grp (
  saldo_bal money,
   saldo_qty money,
   sub_id numeric,
   saldo_accur money
)
go
--
-- Временные таблицы для списка успешных условий дерева
--
create table #success_conditions (
   id numeric
)
go
--
-- Временные таблицы для диагностики
--
create table #trace_history (
   id numeric,
   doc_id numeric(18,0) null,
   action_id numeric(18,0) null,
   action_date datetime null,
   user_id numeric(18,0) null,
   mes_id numeric(18,0) null,
   dst_id numeric(18,0) null,
   src_id numeric(18,0) null,
   start_date datetime null,
   trace_comment varchar(255) null
)
go
--
-- Врменные таблицы для блоков проводок
--
create table #oper_subconto (
   id numeric(18,0) NULL,
   subconto_type_id numeric(18,0) NULL,
   item_id numeric(18,0) NULL
)
go
-- Времменная таблица  типовых проводок
create table #oper_block_tmp (
   id numeric(18, 0) NOT NULL,
   id_oper numeric(18, 0) NOT NULL,
   sort_order_str varchar(255) null,
   is_exec numeric(18,0) null,
   primary key(id)
)
go
create index oper_block_tmp_sort_order_str on #oper_block_tmp(sort_order_str)
go
--
-- Времменная таблица  типовых проводок добавочная
create table #oper_block_tmp1 (
   id numeric(18, 0) NOT NULL,
   id_oper numeric(18, 0) NOT NULL,
   sort_order_str varchar(255) null,
   is_exec numeric(18,0) null,
   primary key(id)
)
go
create index oper_block_tmp_sort_order_str1 on #oper_block_tmp1(sort_order_str)
go
-- Временные таблицы для комиссий типовых проводок
--
create table #oper_line_comis (
   id numeric(18, 0) NOT NULL,
   id_oper numeric(18, 0) NULL,
   sort_order_str varchar(255) null,
   is_exec numeric(18,0) null,
   primary key(id)
)
go
create index oper_line_comis_sort_order_str on #oper_line_comis(sort_order_str)
go
-- Таблица коммисий
create table #comis_loop (
   id numeric(18, 0) NULL
)
go
--
-- Стек для подсчета выражений алиасов
--
create table #t_stack (
   num float null,
   id numeric(18, 0) NULL
)
go
--
-- Временные таблицы для проводок
--
create table #t_operations (
  id numeric(18,0) NOT NULL,
  partner2plan_id numeric(18,0),
  op_date datetime NOT NULL,
  rate_date datetime null,
  sum_cur_id numeric(18,0) null,
  op_sum money null,
  item_id numeric(18,0) null,
  action_history_id numeric(18,0) null,
  op_name varchar(255) null,
  operation_type int default 0,
  action_id numeric(18,0) null,
  sysdate datetime null,
  is_blocked int null,
        typed_operation_id numeric(18,0) null,
        block_id   numeric(18,0) null
)
go
create table #t_oper_list (
  id numeric(18,0) NOT NULL,
  head_id numeric(18,0) NOT NULL,
  deb_or_cred  smallint NOT NULL,
  acc_id  numeric(18,0) NOT NULL,
  qty_sum money null,
  sum_bal money null,
  rate_bal money null,
  rate_bal_date datetime null,
  sum_accur money null,
  rate_accur money null,
  rate_accur_date datetime null,
  subc_eff_num varchar(255) null,
  is_check_subconto int null,
  partner2plan_id numeric(18,0) null,
  op_date datetime null,
  sysdate datetime null,
  s_1 numeric(18,0) null,
  s_2 numeric(18,0) null,
  subc_eff_name varchar(255) null,
  acc_cur_id numeric(18,0) null,
  branch_id numeric(18,0) null,
  lic_acc_id numeric(18,0) null
)
go

create table #t_oper_subconto (
  id numeric(18,0) NOT NULL,
  subconto_type_id numeric(18,0) NOT NULL,
  item_id  numeric(18,0) null
)
go
create table #t_oper_subconto_tmp (
  num int identity not null,
  subconto_type_id numeric(18,0) NOT NULL,
  item_id  numeric(18,0) null

)
go
create table #t_items (
  id numeric(18,0) NOT NULL ,
  state_id numeric(18,0) null,

)
go
create table #t_actions_history (
  id numeric(18,0) NOT NULL ,
  start_date datetime null ,
  action_date datetime null,
  doc_id numeric(18,0) null ,
  action_id numeric(18,0) null,
  src_id numeric(18,0) null,
  dst_id numeric(18,0) null,
  user_id numeric(18,0) null,
  mes_id numeric(18,0) null
)
go
create table #t_account_now(
  id numeric(18,0) NOT NULL,
  plan2partner_id numeric(18,0) NOT NULL,
  acc_id numeric(18,0) NOT NULL,
  subc_eff_num varchar(255) NULL,
  deb_or_cred smallint not null,
  saldo money null,
  saldo_qty money null,
  saldo_accur money null,
  last_date datetime null,
  acc_cur_id numeric(18,0)  NULL,
  branch_id numeric(18,0)  NULL,
  lic_acc_id numeric(18,0)  NULL
)
go
create table #t_accnow_subconto (
    id numeric(18,0) NOT NULL,
  subconto_type_id numeric(18,0) NOT NULL,
  item_id  numeric(18,0) null

)
go
--
-- Таблицы для .TOTALS_QUERY
--
create table #tmp_osv_a (
  acc_id numeric null,
  acc_num_eff_rep varchar(255) null,
  head_acc_id numeric null
)
go
create index #tmp_osv_a_pk on #tmp_osv_a(acc_id)
go
create table #tmp_osv_ca (
  acc_id numeric null,
acc_num_eff_rep varchar(255) null,
head_acc_id numeric null
)
go
create index #tmp_osv_ca_pk on #tmp_osv_ca(acc_id)
go
create table #tmp_osv
(
  rec_type int null, /*1- OBORANDSALDO,2-CROSSOBOR*/
    acc_id            numeric               null,
    acc_type_id     numeric                null,
    parent_id       numeric                null    ,
    acc_name        varchar(100)           null    ,
    cur_id          numeric                null    ,
    acc_cur_id          numeric                null    ,
    branch_id          numeric                null    ,
    lic_acc_id          numeric                null    ,
    acc_cur_code          varchar(50)                null    ,
    branch_code          varchar(100)                null    ,
    lic_acc_no          varchar(50)                null    ,
    is_out_balance  tinyint                null    ,
    is_last         tinyint                null    ,
    is_qty          tinyint                null    ,
    acc_num_eff     varchar(255)           null    ,
    cur_code        varchar(30)            null    ,
    subc_eff_num     varchar(255)         null    ,
    subc_eff_name     varchar(255)      null    ,

    cor_acc_id            numeric               null,
    cor_acc_type_id     numeric                null,
    cor_parent_id       numeric                null    ,
    cor_acc_name        varchar(100)           null    ,
    cor_cur_id          numeric                null    ,
    cor_acc_cur_id          numeric                null    ,
    cor_branch_id          numeric             null    ,
    cor_lic_acc_id          numeric            null    ,
    cor_acc_cur_code          varchar(50)      null    ,
    cor_branch_code          varchar(100)      null    ,
    cor_lic_acc_no          varchar(50)        null    ,
    cor_is_out_balance  tinyint                null    ,
    cor_is_last         tinyint                null    ,
    cor_is_qty          tinyint                null    ,
    cor_acc_num_eff     varchar(255)           null    ,
    cor_cur_code        varchar(30)            null    ,
    cor_subc_eff_num     varchar(255)      null    ,
    cor_subc_eff_name     varchar(255)      null    ,

    op_date    datetime           null    ,
    date_end   datetime           null    ,
    sysdate   datetime           null    ,
    op_id    numeric           null    ,
    op_name   varchar(100)           null    ,
    item_id   numeric           null    ,
    item_name   varchar(100)           null    ,
    history_id  numeric           null    ,
    history_name   varchar(150)           null    ,
    period_name     numeric               null,
    period_dates_name     numeric               null,

    saldo_db money null,
    ac_saldo_db money null,
    q_saldo_db money null,

    saldo_cb  money null,
    ac_saldo_cb money null,
    q_saldo_cb money null,

    obor_d  money null,
    ac_obor_d money null,
    q_obor_d money null,

    obor_c  money null,
    ac_obor_c money null,
    q_obor_c money null,

    saldo_de money null,
    ac_saldo_de money null,
    q_saldo_de money null,

    saldo_ce  money null,
    ac_saldo_ce money null,
    q_saldo_ce money null,

    s1_id  numeric null,
    s2_id  numeric null,
    s3_id  numeric null,
    s4_id  numeric null,
    s5_id  numeric null,
    s6_id  numeric null,
    cor_s1_id  numeric null,
    cor_s2_id  numeric null,
    cor_s3_id  numeric null,
    cor_s4_id  numeric null,
    cor_s5_id  numeric null,
    cor_s6_id  numeric null
)
go
create index #tmp_osv_idx on #tmp_osv(subc_eff_num)
go
create table #tmp_osv_t(
  rec_type int null, /*1- OBORANDSALDO, 2-CROSSOBOR*/
    acc_id            numeric               null,
    acc_num_eff_rep     varchar(255)  null    ,
    acc_cur_id          numeric                null    ,
    branch_id          numeric                null    ,
    lic_acc_id          numeric                null    ,
    cor_acc_id numeric null,
    cor_acc_num_eff_rep     varchar(255)  null    ,
    cor_acc_cur_id          numeric                null    ,
    cor_branch_id          numeric                null    ,
    cor_lic_acc_id          numeric                null    ,
    subc_eff_num     varchar(255)           null    ,
    cor_subc_eff_num     varchar(255)           null    ,
    op_date    datetime           null    ,
    sysdate   datetime           null    ,
    op_id    numeric           null    ,
    item_id   numeric           null    ,
    saldo_db  money null,
    ac_saldo_db money null,
    q_saldo_db money null,
    obor_d  money null,
    ac_obor_d money null,
    q_obor_d money null,
    saldo_cb  money null,
    ac_saldo_cb money null,
    q_saldo_cb money null,
    obor_c  money null,
    ac_obor_c money null,
    q_obor_c money null,
    s1_id  numeric null,
    s2_id  numeric null,
    s3_id  numeric null,
    s4_id  numeric null,
    s5_id  numeric null,
    s6_id  numeric null,

    cor_s1_id  numeric null,
    cor_s2_id  numeric null,
    cor_s3_id  numeric null,
    cor_s4_id  numeric null,
    cor_s5_id  numeric null,
    cor_s6_id  numeric null,
    subc_eff_num_tmp     varchar(255)           null    ,
    cor_subc_eff_num_tmp     varchar(255)           null,
    subc_eff_name     varchar(255)           null,
    cor_subc_eff_name     varchar(255)   null
)
go
create index #tmp_osv_t_idx on #tmp_osv_t(subc_eff_num)
go

create table #tmp_oss
(
  rec_type int null, /*1- OBORANDSALDO ONLY*/
    acc_id          numeric                null,
    acc_type_id     numeric                null,
    parent_id       numeric                null,
    acc_name        varchar(100)           null    ,
    cur_id          numeric                null,
    is_out_balance  tinyint                null,
    is_last         tinyint                null,
    is_qty          tinyint                null,
    acc_num_eff     varchar(255)           null,
    cur_code        varchar(30)            null,
    acc_cur_id          numeric                null    ,
    branch_id          numeric              null    ,
    lic_acc_id         numeric              null    ,
    acc_cur_code       varchar(50)          null    ,
    branch_code        varchar(100)         null    ,
    lic_acc_no         varchar(50)          null    ,
    cor_acc_id            numeric               null,
    cor_acc_type_id     numeric                null,
    cor_parent_id       numeric                null,
    cor_cur_id          numeric                null,
    cor_is_out_balance  tinyint                null,
    cor_is_last         tinyint                null,
    cor_is_qty          tinyint                null,
    cor_acc_num_eff     varchar(255)           null,
    cor_cur_code        varchar(30)            null,
    cor_acc_cur_id          numeric                null    ,
    cor_branch_id          numeric                null    ,
    cor_lic_acc_id          numeric                null    ,
    cor_acc_cur_code          varchar(50)          null    ,
    cor_branch_code           varchar(100)         null    ,
    cor_lic_acc_no            varchar(50)          null    ,
    subc1_id     numeric         null,
    subc2_id     numeric         null,
    subc_eff_num     varchar(255)     null,
    subc_eff_name    varchar(255)     null,
    cor_subc_eff_num     varchar(255)  null,
    cor_subc_eff_name    varchar(255)  null,
    op_date    datetime           null,
    sysdate   datetime           null    ,
    date_end   datetime           null,
    op_id    numeric           null,
    op_name   varchar(100)           null,
    item_id   numeric           null,
    history_id  numeric           null,

    saldo_db money null,
    ac_saldo_db money null,
    q_saldo_db money null,

    saldo_cb  money null,
    ac_saldo_cb money null,
    q_saldo_cb money null,

    obor_d  money null,
    ac_obor_d money null,
    q_obor_d money null,

    obor_c  money null,
    ac_obor_c money null,
    q_obor_c money null,

    saldo_de money null,
    ac_saldo_de money null,
    q_saldo_de money null,

    saldo_ce  money null,
    ac_saldo_ce money null,
    q_saldo_ce money null,
    s1_id  numeric null,
    s2_id  numeric null,
    s3_id  numeric null,
    s4_id  numeric null,
    s5_id  numeric null,
    s6_id  numeric null,
    cor_s1_id  numeric null,
    cor_s2_id  numeric null,
    cor_s3_id  numeric null,
    cor_s4_id  numeric null,
    cor_s5_id  numeric null,
    cor_s6_id  numeric null
)
go
create index #tmp_oss_idx on #tmp_oss(subc_eff_num)
go
create table #tmp_oss_t(
  rec_type int null, /*1- OBORANDSALDO,2-CROSSOBOR*/
    acc_id            numeric               null,
    acc_num_eff_rep     varchar(255)  null,
    subc1_id     numeric         null,
    subc1_name     varchar(150)      null,

    subc2_id     numeric         null,
    subc2_name     varchar(150)      null,

    acc_cur_id          numeric                null    ,
    branch_id          numeric                null    ,
    lic_acc_id          numeric                null    ,
    op_date    datetime           null,
    sysdate   datetime           null    ,
    op_id    numeric           null,
    item_id   numeric           null,
    saldo_db  money null,
    ac_saldo_db money null,
    q_saldo_db money null,
    obor_d  money null,
    ac_obor_d money null,
    q_obor_d money null,
    saldo_cb  money null,
    ac_saldo_cb money null,
    q_saldo_cb money null,
    obor_c  money null,
    ac_obor_c money null,
    q_obor_c money null,
    s1_id  numeric null,
    s2_id  numeric null,
    s3_id  numeric null,
    s4_id  numeric null,
    s5_id  numeric null,
    s6_id  numeric null,

    cor_s1_id  numeric null,
    cor_s2_id  numeric null,
    cor_s3_id  numeric null,
    cor_s4_id  numeric null,
    cor_s5_id  numeric null,
    cor_s6_id  numeric null,
    subc_eff_num_tmp     varchar(255)           null,
    cor_subc_eff_num_tmp     varchar(255)           null,
    subc_eff_name     varchar(255)           null,
    cor_subc_eff_name     varchar(255)   null
)
go
create table #t_error
(
  error numeric(18,0) null
)
go
-- таблицы для подсчета маржи
create table #t_lic_accounts_tzs
(
id numeric(18,0) not null,
lic_acc_no varchar(255) null,
lic_acc_name varchar(255) null,
lic_acc_no_ext varchar(255) null,
plan_id numeric(18,0) null,
owner_id numeric(18,0) null,
sint_acc_id numeric(18,0)  null,
lic_acc_type_id numeric(18,0)  null,
cur_id numeric(18,0) null,
branch_id numeric(18,0) null,
state_rep_symbol_id numeric(18,0) null,
profit_rep_symbol_id numeric(18,0) null,
serial_no_i numeric(18,0) null,
acc_or_pass int null,
lic_acc_name_ext varchar(255) null,
plan_close_date datetime null,
close_date datetime null,
subc_eff_num varchar(255) null,
subc_eff_name varchar(255) null,
open_date datetime null,
lic_acc_isexp int null,
lic_acc_isrep int null,
s1 numeric(18,0) null,
s2 numeric(18,0) null,
s3 numeric(18,0) null,
s4 numeric(18,0) null,
s5 numeric(18,0) null,
s6 numeric(18,0) null,
s7 numeric(18,0) null,
s8 numeric(18,0) null,
s9 numeric(18,0) null,
s10 numeric(18,0) null,
s11 numeric(18,0) null,
s12 numeric(18,0) null,
s13 numeric(18,0) null,
s14 numeric(18,0) null,
s15 numeric(18,0) null
)
go
create table #t_account_now_tzs
(
  id numeric(18,0) NOT NULL,
  plan2partner_id numeric(18,0) NOT NULL,
  acc_id numeric(18,0) NOT NULL,
  acc_num_eff varchar(255),
  acc_type_id numeric(18,0) null,
  subc_eff_num varchar(255) NULL,
  deb_or_cred smallint not null,
  saldo money null,
  saldo_qty money null,
  saldo_accur money null,
  acc_cur_id numeric(18,0) NULL
)
go
create table #t_accnow_subconto_tzs
(
  id numeric(18,0) NOT NULL,
  subconto_type_id numeric(18,0) NOT NULL,
  item_id  numeric(18,0) null
)
go
create table #res_stock
(
  acc_id numeric(18,0) not null,
  acc_num_eff varchar(255) null,
  stock_id numeric(18,0) not null,
  qty money null,
  act_or_pas int,
  stock_rate money null
)
go
create table #res_money
(
  acc_id numeric(18,0) not null,
  acc_num_eff varchar(255) null,
  saldo money null,
  cur_id numeric null,
  rate_value money null,
  act_or_pas int
)
go
create table #t_report_result
(
 field_name varchar(255) not null,
 field_code varchar(255) not null,
 field_1 varchar(255) null,
 field_2 varchar(255) null,
 field_3 varchar(255) null,
 field_4 varchar(255) null,
 font_size int default 8,
 font_style int default 1,
 is_head int default 0,
 id  numeric(18,0) not null,
 parent_id numeric(18,0) not null,
 sort_order_str varchar(255) null,
 design_folder int null,
 font_style_italic int null,
 font_style_underline int null,
 align_str int null

)
go
create table #t_lic_accounts
(
id numeric(18,0) not null,
lic_acc_no varchar(255) null,
lic_acc_name varchar(255) null,
lic_acc_no_ext varchar(255) null,
plan_id numeric(18,0) not null,
owner_id numeric(18,0) not null,
sint_acc_id numeric(18,0) not null,
lic_acc_type_id numeric(18,0) not null,
cur_id numeric(18,0) null,
branch_id numeric(18,0) null,
state_rep_symbol_id numeric(18,0) null,
profit_rep_symbol_id numeric(18,0) null,
serial_no_i numeric(18,0) null,
acc_or_pass int null,
lic_acc_name_ext varchar(255) null,
plan_close_date datetime null,
close_date datetime null,
subc_eff_num varchar(255) null,
subc_eff_name varchar(255) null,
open_date datetime null,
lic_acc_isexp int null,
lic_acc_isrep int null,
s1 numeric(18,0) null,
s2 numeric(18,0) null,
s3 numeric(18,0) null,
s4 numeric(18,0) null,
s5 numeric(18,0) null,
s6 numeric(18,0) null,
s7 numeric(18,0) null,
s8 numeric(18,0) null,
s9 numeric(18,0) null,
s10 numeric(18,0) null,
s11 numeric(18,0) null,
s12 numeric(18,0) null,
s13 numeric(18,0) null,
s14 numeric(18,0) null,
s15 numeric(18,0) null
)
go
 create table #t_items_i (
    id numeric(18,0) not null,
    type_id  numeric(18,0) not null,
    state_id numeric(18,0) not null,
   item_name varchar(255) null,
   item_remark varchar(255) null
    )
go
create table #t_acc_lic2subc (
 lic_acc_id  numeric(18,0) not null,
 subconto_type_id numeric(18,0) null,
 item_id numeric(18,0) null)
--
  $ENDTEXT(11561720)
 $ENDACTION
$ENDDOC