Description
Properties
| Name | Value |
|---|---|
| Collation | SQL_Latin1_General_CP1_CI_AS |
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Schema Bound | False |
| Created | 9/19/2017 03:01:16 |
| Last Modified | 9/19/2017 03:01:16 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_adj_sto_id | ||
| status_adj_sto_name | ||
| doc_code | ||
| doc_date | ||
| info | ||
| total_detail | ||
| total_item | ||
| count_plus | ||
| count_minus | ||
| create_date | ||
| create_by | ||
| modify_date | ||
| modify_by | ||
| status_adj_sto_id | ||
| status_info | ||
| status_date | ||
| status_by | ||
| ms_date_business_id | ||
| is_move_business_date | ||
| ms_date_business_id_from | ||
| cancel_ms_cost_final_avg_id | ||
| approve_ms_cost_final_avg_id | ||
| ms_date_business | ||
| ms_date_business_from |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_adjustment_header
---XencX---with encryption
as
SELECT
dt_ms_adj_sto.ms_adj_sto_id
, enum_ms_status_adj_sto.status_adj_sto_name
, dt_ms_adj_sto.doc_code
, dt_ms_adj_sto.doc_date
, dt_ms_adj_sto.info
, vw_ms_adjustment_detail_sum.total_detail
, vw_ms_adjustment_item_sum.count_item as total_item
, vw_ms_adjustment_item_sum.count_plus
, vw_ms_adjustment_item_sum.count_minus
, dt_ms_adj_sto.create_date
, users_create.username AS create_by
, dt_ms_adj_sto.modify_date
, users_modify.username AS modify_by
, dt_ms_adj_sto_h_status.status_adj_sto_id
, dt_ms_adj_sto_h_status.status_info
, dt_ms_adj_sto_h_status.create_date AS status_date
, users_status.username AS status_by
, dt_ms_adj_sto.ms_date_business_id
, dt_ms_adj_sto.is_move_business_date
, dt_ms_adj_sto.ms_date_business_id_from
, dt_ms_adj_sto.cancel_ms_cost_final_avg_id
, dt_ms_adj_sto.approve_ms_cost_final_avg_id
, isnull(dt_ms_date_business.ms_date_business, dt_ms_adj_sto.doc_date ) as ms_date_business
, isnull(dt_ms_date_business_from.ms_date_business, dt_ms_adj_sto.doc_date ) AS ms_date_business_from
FROM dt_ms_adj_sto INNER JOIN
dt_ms_adj_sto_h_status ON dt_ms_adj_sto.ms_adj_sto_h_status_id = dt_ms_adj_sto_h_status.ms_adj_sto_h_status_id INNER JOIN
enum_ms_adj_sto_mode ON dt_ms_adj_sto.adj_sto_mode_id = enum_ms_adj_sto_mode.adj_sto_mode_id INNER JOIN
enum_ms_status_adj_sto ON dt_ms_adj_sto_h_status.status_adj_sto_id = enum_ms_status_adj_sto.status_adj_sto_id INNER JOIN
users AS users_create ON dt_ms_adj_sto.create_by = users_create.id INNER JOIN
users AS users_modify ON dt_ms_adj_sto.modify_by = users_modify.id INNER JOIN
users AS users_status ON dt_ms_adj_sto_h_status.create_by = users_status.id LEFT OUTER JOIN
dt_ms_date_business AS dt_ms_date_business_from ON dt_ms_adj_sto.ms_date_business_id_from = dt_ms_date_business_from.ms_date_business_id LEFT OUTER JOIN
dt_ms_date_business ON dt_ms_adj_sto.ms_date_business_id = dt_ms_date_business.ms_date_business_id LEFT OUTER JOIN
vw_ms_adjustment_detail_sum ON dt_ms_adj_sto.ms_adj_sto_id = vw_ms_adjustment_detail_sum.id_source_header LEFT OUTER JOIN
vw_ms_adjustment_item_sum ON dt_ms_adj_sto.ms_adj_sto_id = vw_ms_adjustment_item_sum.id_source_header
WHERE (dt_ms_adj_sto.adj_sto_mode_id = 0)
GO
GO
create view dbo.vw_ms_adjustment_header
---XencX---with encryption
as
SELECT
dt_ms_adj_sto.ms_adj_sto_id
, enum_ms_status_adj_sto.status_adj_sto_name
, dt_ms_adj_sto.doc_code
, dt_ms_adj_sto.doc_date
, dt_ms_adj_sto.info
, vw_ms_adjustment_detail_sum.total_detail
, vw_ms_adjustment_item_sum.count_item as total_item
, vw_ms_adjustment_item_sum.count_plus
, vw_ms_adjustment_item_sum.count_minus
, dt_ms_adj_sto.create_date
, users_create.username AS create_by
, dt_ms_adj_sto.modify_date
, users_modify.username AS modify_by
, dt_ms_adj_sto_h_status.status_adj_sto_id
, dt_ms_adj_sto_h_status.status_info
, dt_ms_adj_sto_h_status.create_date AS status_date
, users_status.username AS status_by
, dt_ms_adj_sto.ms_date_business_id
, dt_ms_adj_sto.is_move_business_date
, dt_ms_adj_sto.ms_date_business_id_from
, dt_ms_adj_sto.cancel_ms_cost_final_avg_id
, dt_ms_adj_sto.approve_ms_cost_final_avg_id
, isnull(dt_ms_date_business.ms_date_business, dt_ms_adj_sto.doc_date ) as ms_date_business
, isnull(dt_ms_date_business_from.ms_date_business, dt_ms_adj_sto.doc_date ) AS ms_date_business_from
FROM dt_ms_adj_sto INNER JOIN
dt_ms_adj_sto_h_status ON dt_ms_adj_sto.ms_adj_sto_h_status_id = dt_ms_adj_sto_h_status.ms_adj_sto_h_status_id INNER JOIN
enum_ms_adj_sto_mode ON dt_ms_adj_sto.adj_sto_mode_id = enum_ms_adj_sto_mode.adj_sto_mode_id INNER JOIN
enum_ms_status_adj_sto ON dt_ms_adj_sto_h_status.status_adj_sto_id = enum_ms_status_adj_sto.status_adj_sto_id INNER JOIN
users AS users_create ON dt_ms_adj_sto.create_by = users_create.id INNER JOIN
users AS users_modify ON dt_ms_adj_sto.modify_by = users_modify.id INNER JOIN
users AS users_status ON dt_ms_adj_sto_h_status.create_by = users_status.id LEFT OUTER JOIN
dt_ms_date_business AS dt_ms_date_business_from ON dt_ms_adj_sto.ms_date_business_id_from = dt_ms_date_business_from.ms_date_business_id LEFT OUTER JOIN
dt_ms_date_business ON dt_ms_adj_sto.ms_date_business_id = dt_ms_date_business.ms_date_business_id LEFT OUTER JOIN
vw_ms_adjustment_detail_sum ON dt_ms_adj_sto.ms_adj_sto_id = vw_ms_adjustment_detail_sum.id_source_header LEFT OUTER JOIN
vw_ms_adjustment_item_sum ON dt_ms_adj_sto.ms_adj_sto_id = vw_ms_adjustment_item_sum.id_source_header
WHERE (dt_ms_adj_sto.adj_sto_mode_id = 0)
GO