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 09:57:24 |
| Last Modified | 9/11/2017 09:57:24 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_item_custom_no | ||
| ms_item_custom_name | ||
| nomor_hs | ||
| tarif_bm | ||
| tarif_ppnbm | ||
| tarif_pph | ||
| tarif_ppn | ||
| tarif_cukai | ||
| create_date | ||
| create_by | ||
| modify_date | ||
| modify_by | ||
| ms_item_custom_h_allow_id | ||
| ms_item_custom_h_tarif_id |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_part_custom
---XencX---with encryption
as
SELECT dt_ms_item_custom.ms_item_custom_no
, dt_ms_item_custom.ms_item_custom_name
, isnull(dt_ms_item_custom_h_tarif.nomor_hs,'') as nomor_hs
, isnull(dt_ms_item_custom_h_tarif.tarif_bm,0) as tarif_bm
, isnull(dt_ms_item_custom_h_tarif.tarif_ppnbm,0) as tarif_ppnbm
, isnull(dt_ms_item_custom_h_tarif.tarif_pph,0) as tarif_pph
, isnull(dt_ms_item_custom_h_tarif.tarif_ppn,0) as tarif_ppn
, isnull(dt_ms_item_custom_h_tarif.tarif_cukai,0) as tarif_cukai
, dt_ms_item_custom.create_date
, users_create.username AS create_by
, dt_ms_item_custom.modify_date
, users_modify.username AS modify_by
, dt_ms_item_custom.ms_item_custom_h_allow_id
, dt_ms_item_custom.ms_item_custom_h_tarif_id
FROM dt_ms_item_custom LEFT OUTER JOIN
dt_ms_item_custom_h_tarif ON dt_ms_item_custom.ms_item_custom_h_tarif_id = dt_ms_item_custom_h_tarif.ms_item_custom_h_tarif_id LEFT OUTER JOIN
users AS users_modify ON dt_ms_item_custom.modify_by = users_modify.id LEFT OUTER JOIN
users AS users_create ON dt_ms_item_custom.create_by = users_create.id
GO
GO
create view dbo.vw_ms_part_custom
---XencX---with encryption
as
SELECT dt_ms_item_custom.ms_item_custom_no
, dt_ms_item_custom.ms_item_custom_name
, isnull(dt_ms_item_custom_h_tarif.nomor_hs,'') as nomor_hs
, isnull(dt_ms_item_custom_h_tarif.tarif_bm,0) as tarif_bm
, isnull(dt_ms_item_custom_h_tarif.tarif_ppnbm,0) as tarif_ppnbm
, isnull(dt_ms_item_custom_h_tarif.tarif_pph,0) as tarif_pph
, isnull(dt_ms_item_custom_h_tarif.tarif_ppn,0) as tarif_ppn
, isnull(dt_ms_item_custom_h_tarif.tarif_cukai,0) as tarif_cukai
, dt_ms_item_custom.create_date
, users_create.username AS create_by
, dt_ms_item_custom.modify_date
, users_modify.username AS modify_by
, dt_ms_item_custom.ms_item_custom_h_allow_id
, dt_ms_item_custom.ms_item_custom_h_tarif_id
FROM dt_ms_item_custom LEFT OUTER JOIN
dt_ms_item_custom_h_tarif ON dt_ms_item_custom.ms_item_custom_h_tarif_id = dt_ms_item_custom_h_tarif.ms_item_custom_h_tarif_id LEFT OUTER JOIN
users AS users_modify ON dt_ms_item_custom.modify_by = users_modify.id LEFT OUTER JOIN
users AS users_create ON dt_ms_item_custom.create_by = users_create.id
GO