TYPE=VIEW
query=select `db_account_9793090153`.`tbl_invoice_det`.`in_det_id` AS `in_det_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_list_id` AS `in_det_list_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_item_id` AS `in_det_item_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_unit_id` AS `in_det_unit_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_store_id` AS `in_store_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_qty_rec` AS `in_det_qty_rec`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_qty` AS `in_det_qty`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_qty_equal` AS `in_det_qty_equal`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_price` AS `in_det_price`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_discount` AS `in_det_discount`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_cost` AS `in_det_cost`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_gift` AS `in_det_gift`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_currency_id` AS `in_det_currency_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_currency_val` AS `in_det_currency_val`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_notice` AS `in_det_notice`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_date_mfg` AS `in_det_date_mfg`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_date_exp` AS `in_det_date_exp`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_in_out_type` AS `in_det_in_out_type`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_effect_price` AS `in_det_effect_price`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_effect_cost` AS `in_det_effect_cost`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_effect_amount` AS `in_det_effect_amount`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_date_temp` AS `in_det_date_temp`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_const1` AS `in_det_const1`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_indust_percent` AS `in_det_indust_percent`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_id` AS `in_list_id`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_number` AS `in_list_number`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_type_id` AS `in_list_type_id`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_desc` AS `in_list_desc`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_date` AS `in_list_date`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_time` AS `in_list_time`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_datatime` AS `in_list_datetime`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_movetime` AS `in_list_movetime`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_reference` AS `in_list_reference`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_store` AS `in_list_store`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_store_in` AS `in_list_store_in`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_total` AS `in_list_total`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_discount_total` AS `in_list_discount_total`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_net` AS `in_list_net`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_payment` AS `in_list_payment`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_payment_type` AS `in_list_payment_type`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_acc_cust` AS `in_list_acc_cust`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_acc_cash` AS `in_list_acc_cash`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_acc_move` AS `in_list_acc_move`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_currency_id` AS `in_list_currency_id`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_currency_val` AS `in_list_currency_val`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_agent_id` AS `in_list_agent_id`,if((`db_account_9793090153`.`tbl_invoice_det`.`in_det_trans_id` <> 0),-(108),`db_account_9793090153`.`tbl_invoice_list`.`in_list_type_const`) AS `in_list_type_const`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_type_name` AS `in_list_type_name` from (`db_account_9793090153`.`tbl_invoice_det` join `db_account_9793090153`.`tbl_invoice_list` on((`db_account_9793090153`.`tbl_invoice_det`.`in_det_list_id` = `db_account_9793090153`.`tbl_invoice_list`.`in_list_id`)))
md5=29df518112feb32a37db0cc3dfe6cbdd
updatable=1
algorithm=0
definer_user=root
definer_host=%
suid=1
with_check_option=0
timestamp=2014-01-01 21:20:12
create-version=1
source=select
\n  `tbl_invoice_det`.`in_det_id` AS `in_det_id`,
\n  `tbl_invoice_det`.`in_det_list_id` AS `in_det_list_id`,
\n  `tbl_invoice_det`.`in_det_item_id` AS `in_det_item_id`,
\n  `tbl_invoice_det`.`in_det_unit_id` AS `in_det_unit_id`,
\n  `tbl_invoice_det`.`in_det_store_id` AS `in_store_id`,
\n  `tbl_invoice_det`.`in_det_qty_rec` AS `in_det_qty_rec`,
\n  `tbl_invoice_det`.`in_det_qty` AS `in_det_qty`,
\n  `tbl_invoice_det`.`in_det_qty_equal` AS `in_det_qty_equal`,
\n  `tbl_invoice_det`.`in_det_price` AS `in_det_price`,
\n  `tbl_invoice_det`.`in_det_discount` AS `in_det_discount`,
\n  `tbl_invoice_det`.`in_det_cost` AS `in_det_cost`,
\n  `tbl_invoice_det`.`in_det_gift` AS `in_det_gift`,
\n  `tbl_invoice_det`.`in_det_currency_id` AS `in_det_currency_id`,
\n  `tbl_invoice_det`.`in_det_currency_val` AS `in_det_currency_val`,
\n  `tbl_invoice_det`.`in_det_notice` AS `in_det_notice`,
\n  `tbl_invoice_det`.`in_det_date_mfg` AS `in_det_date_mfg`,
\n  `tbl_invoice_det`.`in_det_date_exp` AS `in_det_date_exp`,
\n  `tbl_invoice_det`.`in_det_in_out_type` AS `in_det_in_out_type`,
\n  `tbl_invoice_det`.`in_det_effect_price` AS `in_det_effect_price`,
\n  `tbl_invoice_det`.`in_det_effect_cost` AS `in_det_effect_cost`,
\n  `tbl_invoice_det`.`in_det_effect_amount` AS `in_det_effect_amount`,
\n  `tbl_invoice_det`.`in_det_date_temp` AS `in_det_date_temp`,
\n  `tbl_invoice_det`.`in_det_const1` AS `in_det_const1`,
\n  `tbl_invoice_det`.`in_det_indust_percent` AS `in_det_indust_percent`,
\n  `tbl_invoice_list`.`in_list_id` AS `in_list_id`,
\n  `tbl_invoice_list`.`in_list_number` AS `in_list_number`,
\n  `tbl_invoice_list`.`in_list_type_id` AS `in_list_type_id`,
\n  `tbl_invoice_list`.`in_list_desc` AS `in_list_desc`,
\n  `tbl_invoice_list`.`in_list_date` AS `in_list_date`,
\n  `tbl_invoice_list`.`in_list_time` AS `in_list_time`,
\n  `tbl_invoice_list`.`in_list_datatime` AS `in_list_datetime`,
\n  `tbl_invoice_list`.`in_list_movetime` AS `in_list_movetime`,
\n  `tbl_invoice_list`.`in_list_reference` AS `in_list_reference`,
\n  `tbl_invoice_list`.`in_list_store` AS `in_list_store`,
\n  `tbl_invoice_list`.`in_list_store_in` AS `in_list_store_in`,
\n  `tbl_invoice_list`.`in_list_total` AS `in_list_total`,
\n  `tbl_invoice_list`.`in_list_discount_total` AS `in_list_discount_total`,
\n  `tbl_invoice_list`.`in_list_net` AS `in_list_net`,
\n  `tbl_invoice_list`.`in_list_payment` AS `in_list_payment`,
\n  `tbl_invoice_list`.`in_list_payment_type` AS `in_list_payment_type`,
\n  `tbl_invoice_list`.`in_list_acc_cust` AS `in_list_acc_cust`,
\n  `tbl_invoice_list`.`in_list_acc_cash` AS `in_list_acc_cash`,
\n  `tbl_invoice_list`.`in_list_acc_move` AS `in_list_acc_move`,
\n  `tbl_invoice_list`.`in_list_currency_id` AS `in_list_currency_id`,
\n  `tbl_invoice_list`.`in_list_currency_val` AS `in_list_currency_val`,
\n  `tbl_invoice_list`.`in_list_agent_id` AS `in_list_agent_id`,
\n  if ((`tbl_invoice_det`.`in_det_trans_id` <> 0), -(108), `tbl_invoice_list`.`in_list_type_const`)
\n   AS `in_list_type_const`,
\n  `tbl_invoice_list`.`in_list_type_name` AS `in_list_type_name`
\nfrom
\n  (`tbl_invoice_det`
\n  join `tbl_invoice_list` on ((`tbl_invoice_det`.`in_det_list_id` =
\n   `tbl_invoice_list`.`in_list_id`)))
client_cs_name=cp1256
connection_cl_name=cp1256_general_ci
view_body_utf8=select `db_account_9793090153`.`tbl_invoice_det`.`in_det_id` AS `in_det_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_list_id` AS `in_det_list_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_item_id` AS `in_det_item_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_unit_id` AS `in_det_unit_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_store_id` AS `in_store_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_qty_rec` AS `in_det_qty_rec`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_qty` AS `in_det_qty`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_qty_equal` AS `in_det_qty_equal`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_price` AS `in_det_price`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_discount` AS `in_det_discount`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_cost` AS `in_det_cost`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_gift` AS `in_det_gift`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_currency_id` AS `in_det_currency_id`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_currency_val` AS `in_det_currency_val`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_notice` AS `in_det_notice`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_date_mfg` AS `in_det_date_mfg`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_date_exp` AS `in_det_date_exp`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_in_out_type` AS `in_det_in_out_type`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_effect_price` AS `in_det_effect_price`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_effect_cost` AS `in_det_effect_cost`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_effect_amount` AS `in_det_effect_amount`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_date_temp` AS `in_det_date_temp`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_const1` AS `in_det_const1`,`db_account_9793090153`.`tbl_invoice_det`.`in_det_indust_percent` AS `in_det_indust_percent`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_id` AS `in_list_id`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_number` AS `in_list_number`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_type_id` AS `in_list_type_id`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_desc` AS `in_list_desc`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_date` AS `in_list_date`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_time` AS `in_list_time`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_datatime` AS `in_list_datetime`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_movetime` AS `in_list_movetime`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_reference` AS `in_list_reference`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_store` AS `in_list_store`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_store_in` AS `in_list_store_in`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_total` AS `in_list_total`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_discount_total` AS `in_list_discount_total`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_net` AS `in_list_net`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_payment` AS `in_list_payment`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_payment_type` AS `in_list_payment_type`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_acc_cust` AS `in_list_acc_cust`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_acc_cash` AS `in_list_acc_cash`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_acc_move` AS `in_list_acc_move`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_currency_id` AS `in_list_currency_id`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_currency_val` AS `in_list_currency_val`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_agent_id` AS `in_list_agent_id`,if((`db_account_9793090153`.`tbl_invoice_det`.`in_det_trans_id` <> 0),-(108),`db_account_9793090153`.`tbl_invoice_list`.`in_list_type_const`) AS `in_list_type_const`,`db_account_9793090153`.`tbl_invoice_list`.`in_list_type_name` AS `in_list_type_name` from (`db_account_9793090153`.`tbl_invoice_det` join `db_account_9793090153`.`tbl_invoice_list` on((`db_account_9793090153`.`tbl_invoice_det`.`in_det_list_id` = `db_account_9793090153`.`tbl_invoice_list`.`in_list_id`)))
