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 | 11/6/2020 19:07:41 |
| Last Modified | 11/6/2020 19:07:41 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_cost_final_avg_pabrikasi_id | ||
| final_avg_pabrikasi_name | ||
| start_date | ||
| end_date | ||
| info | ||
| create_date | ||
| create_by | ||
| ms_cost_final_avg_pabrikasi_status_id | ||
| ms_cost_final_avg_pabrikasi_status | ||
| status_info | ||
| status_date | ||
| status_by |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE view dbo.vw_ms_item_final_avg_pabrikasi
---XencX---with encryption
as
SELECT
dt_ms_cost_final_avg_pabrikasi.ms_cost_final_avg_pabrikasi_id
, dt_ms_cost_final_avg_pabrikasi.final_avg_pabrikasi_name
, dt_ms_cost_final_avg_pabrikasi.start_date
, dt_ms_cost_final_avg_pabrikasi.end_date
, dt_ms_cost_final_avg_pabrikasi.info
, dt_ms_cost_final_avg_pabrikasi.create_date
, users_create.username as create_by
, dt_ms_cost_final_avg_pabrikasi_h_status.ms_cost_final_avg_pabrikasi_status_id
, enum_ms_cost_final_avg_pabrikasi_status.ms_cost_final_avg_pabrikasi_status
, dt_ms_cost_final_avg_pabrikasi_h_status.status_info
, dt_ms_cost_final_avg_pabrikasi_h_status.create_date AS status_date
, user_status.username AS status_by
FROM dt_ms_cost_final_avg_pabrikasi INNER JOIN
users AS users_create ON dt_ms_cost_final_avg_pabrikasi.create_by = users_create.id INNER JOIN
dt_ms_cost_final_avg_pabrikasi_h_status ON dt_ms_cost_final_avg_pabrikasi.ms_cost_final_avg_pabrikasi_h_status_id = dt_ms_cost_final_avg_pabrikasi_h_status.ms_cost_final_avg_pabrikasi_h_status_id INNER JOIN
enum_ms_cost_final_avg_pabrikasi_status ON dt_ms_cost_final_avg_pabrikasi_h_status.ms_cost_final_avg_pabrikasi_status_id = enum_ms_cost_final_avg_pabrikasi_status.ms_cost_final_avg_pabrikasi_status_id INNER JOIN
users AS user_status ON dt_ms_cost_final_avg_pabrikasi_h_status.create_by = user_status.id
WHERE (dt_ms_cost_final_avg_pabrikasi.ms_cost_final_avg_pabrikasi_id > 0)
GO
GO
CREATE view dbo.vw_ms_item_final_avg_pabrikasi
---XencX---with encryption
as
SELECT
dt_ms_cost_final_avg_pabrikasi.ms_cost_final_avg_pabrikasi_id
, dt_ms_cost_final_avg_pabrikasi.final_avg_pabrikasi_name
, dt_ms_cost_final_avg_pabrikasi.start_date
, dt_ms_cost_final_avg_pabrikasi.end_date
, dt_ms_cost_final_avg_pabrikasi.info
, dt_ms_cost_final_avg_pabrikasi.create_date
, users_create.username as create_by
, dt_ms_cost_final_avg_pabrikasi_h_status.ms_cost_final_avg_pabrikasi_status_id
, enum_ms_cost_final_avg_pabrikasi_status.ms_cost_final_avg_pabrikasi_status
, dt_ms_cost_final_avg_pabrikasi_h_status.status_info
, dt_ms_cost_final_avg_pabrikasi_h_status.create_date AS status_date
, user_status.username AS status_by
FROM dt_ms_cost_final_avg_pabrikasi INNER JOIN
users AS users_create ON dt_ms_cost_final_avg_pabrikasi.create_by = users_create.id INNER JOIN
dt_ms_cost_final_avg_pabrikasi_h_status ON dt_ms_cost_final_avg_pabrikasi.ms_cost_final_avg_pabrikasi_h_status_id = dt_ms_cost_final_avg_pabrikasi_h_status.ms_cost_final_avg_pabrikasi_h_status_id INNER JOIN
enum_ms_cost_final_avg_pabrikasi_status ON dt_ms_cost_final_avg_pabrikasi_h_status.ms_cost_final_avg_pabrikasi_status_id = enum_ms_cost_final_avg_pabrikasi_status.ms_cost_final_avg_pabrikasi_status_id INNER JOIN
users AS user_status ON dt_ms_cost_final_avg_pabrikasi_h_status.create_by = user_status.id
WHERE (dt_ms_cost_final_avg_pabrikasi.ms_cost_final_avg_pabrikasi_id > 0)
GO