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/11/2017 10:06:00 |
| Last Modified | 9/11/2017 10:06:00 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_item_base_h_report_car_line_sum_id | ||
| ms_item_base_no | ||
| ms_item_base_name | ||
| create_date | ||
| create_by | ||
| ms_report_car_line_sum_id |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_setting_report_car_line_list_base_part
---XencX---with encryption
as
SELECT
dt_ms_item_base_h_report_car_line_sum.ms_item_base_h_report_car_line_sum_id
, dt_ms_item_base.ms_item_base_no
, dt_ms_item_base.ms_item_base_name
, dt_ms_item_base_h_report_car_line_sum.create_date
, users.username as create_by
, dt_ms_item_base_h_report_car_line_sum.ms_report_car_line_sum_id
FROM dt_ms_item_base_h_report_car_line_sum INNER JOIN
dt_ms_item_base ON dt_ms_item_base_h_report_car_line_sum.ms_item_base_h_report_car_line_sum_id = dt_ms_item_base.ms_item_base_h_report_car_line_sum_id INNER JOIN
users ON dt_ms_item_base_h_report_car_line_sum.create_by = users.id
GO
GO
create view dbo.vw_ms_setting_report_car_line_list_base_part
---XencX---with encryption
as
SELECT
dt_ms_item_base_h_report_car_line_sum.ms_item_base_h_report_car_line_sum_id
, dt_ms_item_base.ms_item_base_no
, dt_ms_item_base.ms_item_base_name
, dt_ms_item_base_h_report_car_line_sum.create_date
, users.username as create_by
, dt_ms_item_base_h_report_car_line_sum.ms_report_car_line_sum_id
FROM dt_ms_item_base_h_report_car_line_sum INNER JOIN
dt_ms_item_base ON dt_ms_item_base_h_report_car_line_sum.ms_item_base_h_report_car_line_sum_id = dt_ms_item_base.ms_item_base_h_report_car_line_sum_id INNER JOIN
users ON dt_ms_item_base_h_report_car_line_sum.create_by = users.id
GO
Used By
No items found