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 | 10/31/2017 00:35:12 |
| Last Modified | 10/31/2017 00:35:12 |
Columns
| Key | Name | Description |
|---|---|---|
| ms_tpb_in_barang_id | ||
| KODE_BARANG | ||
| URAIAN | ||
| KODE_SATUAN | ||
| TIPE | ||
| UKURAN | ||
| MERK | ||
| KODE_NEGARA_ASAL | ||
| mapping_ms_item_id | ||
| ms_type_id | ||
| ms_item_custom_no | ||
| ms_item_custom_name | ||
| nomor_hs | ||
| base_no | ||
| part_no | ||
| part_name | ||
| uom | ||
| qty_pakai | ||
| JUMLAH_SATUAN | ||
| HARGA_TOTAL | ||
| KODE_KEMASAN | ||
| JUMLAH_KEMASAN | ||
| NETTO | ||
| SERI_BARANG | ||
| VOLUME | ||
| KONDISI_BARANG | ||
| ID_ORI | ||
| ID_HEADER | ||
| ID_HEADER_ORI | ||
| POS_TARIF | ||
| BM | ||
| BM_ID | ||
| PPNBM | ||
| PPNBM_ID | ||
| PPH | ||
| PPH_ID | ||
| PPN | ||
| PPN_ID | ||
| is_get | ||
| mode_source | ||
| mode_source_name | ||
| id_source | ||
| create_date | ||
| create_by | ||
| modify_date | ||
| modify_by | ||
| mapping_date | ||
| mapping_by | ||
| header_mode_source | ||
| TAHUN_PEMBUATAN | ||
| series | ||
| po_no | ||
| po_date |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_header_bc_in_item
---XencX---with encryption
as
SELECT dt_ms_tpb_in_barang.ID AS ms_tpb_in_barang_id
, dt_ms_tpb_in_barang.KODE_BARANG
, dt_ms_tpb_in_barang.URAIAN
, dt_ms_tpb_in_barang.KODE_SATUAN
, dt_ms_tpb_in_barang.TIPE
, dt_ms_tpb_in_barang.UKURAN
, dt_ms_tpb_in_barang.MERK
, dt_ms_tpb_in_barang.KODE_NEGARA_ASAL
, dt_ms_tpb_in_barang.mapping_ms_item_id
, dt_ms_item.ms_type_id
, dt_ms_item.ms_item_custom_no
, dt_ms_item_custom.ms_item_custom_name
, dt_ms_item_custom_h_tarif.nomor_hs
, dt_ms_item.ms_item_base_no as base_no
, dt_ms_item.part_no
, dt_ms_item.part_name
, dt_ms_item.uom
, dt_ms_tpb_in_barang.qty_pakai
, dt_ms_tpb_in_barang.JUMLAH_SATUAN
, case when dt_ms_tpb_in_header.KODE_DOKUMEN_PABEAN='23' or dt_ms_tpb_in_header.KODE_DOKUMEN_PABEAN='262' or dt_ms_tpb_in_header.KODE_DOKUMEN_PABEAN='271' then dt_ms_tpb_in_barang.CIF else dt_ms_tpb_in_barang.HARGA_PENYERAHAN end HARGA_TOTAL
, dt_ms_tpb_in_barang.KODE_KEMASAN
, dt_ms_tpb_in_barang.JUMLAH_KEMASAN
, dt_ms_tpb_in_barang.NETTO
, dt_ms_tpb_in_barang.SERI_BARANG
, dt_ms_tpb_in_barang.VOLUME
, dt_ms_tpb_in_barang.KONDISI_BARANG
, dt_ms_tpb_in_barang.ID_ORI
, dt_ms_tpb_in_barang.ID_HEADER
, dt_ms_tpb_in_barang.ID_HEADER_ORI
, dt_ms_tpb_in_barang.POS_TARIF
, isnull(vw_ms_header_bc_in_item_tarif.BM,0) as BM
,isnull( vw_ms_header_bc_in_item_tarif.BM_ID,-1) as BM_ID
, isnull(vw_ms_header_bc_in_item_tarif.PPNBM,0) as PPNBM
, isnull(vw_ms_header_bc_in_item_tarif.PPNBM_ID,-1) as PPNBM_ID
, isnull(vw_ms_header_bc_in_item_tarif.PPH,0) as PPH
, isnull(vw_ms_header_bc_in_item_tarif.PPH_ID,-1) as PPH_ID
, isnull(vw_ms_header_bc_in_item_tarif.PPN,0) as PPN
, isnull(vw_ms_header_bc_in_item_tarif.PPN_ID,-1) as PPN_ID
, isnull(dt_ms_tpb_in_barang.is_get,0) as is_get
, dt_ms_tpb_in_barang.mode_source
, enum_ms_mode_source_tpb_in_barang.mode_source_name
, dt_ms_tpb_in_barang.id_source
, dt_ms_tpb_in_barang.create_date
, users_create.username AS create_by
, dt_ms_tpb_in_barang.modify_date
, users_modify.username AS modify_by
, dt_ms_tpb_in_barang.mapping_date
, users_mapping.username AS mapping_by
, dt_ms_tpb_in_header.mode_source as header_mode_source
, dt_ms_tpb_in_barang.TAHUN_PEMBUATAN
, dt_ms_tpb_in_barang.series
, dt_ms_tpb_in_barang.po_no
, dt_ms_tpb_in_barang.po_date
FROM dt_ms_item_custom INNER JOIN
dt_ms_item ON dt_ms_item_custom.ms_item_custom_no = dt_ms_item.ms_item_custom_no INNER JOIN
enum_ms_type ON dt_ms_item.ms_type_id = enum_ms_type.ms_type_id 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 RIGHT OUTER JOIN
dt_ms_tpb_in_header INNER JOIN
dt_ms_tpb_in_barang ON dt_ms_tpb_in_header.ID_HEADER = dt_ms_tpb_in_barang.ID_HEADER INNER JOIN
enum_ms_mode_source_tpb_in_barang ON dt_ms_tpb_in_barang.mode_source = enum_ms_mode_source_tpb_in_barang.mode_source LEFT OUTER JOIN
vw_ms_header_bc_in_item_tarif ON dt_ms_tpb_in_barang.ID = vw_ms_header_bc_in_item_tarif.ID_BARANG ON dt_ms_item.ms_item_id = dt_ms_tpb_in_barang.mapping_ms_item_id LEFT OUTER JOIN
users AS users_mapping ON dt_ms_tpb_in_barang.mapping_by = users_mapping.id LEFT OUTER JOIN
users AS users_create ON dt_ms_tpb_in_barang.create_by = users_create.id LEFT OUTER JOIN
users AS users_modify ON dt_ms_tpb_in_barang.modify_by = users_modify.id
GO
GO
create view dbo.vw_ms_header_bc_in_item
---XencX---with encryption
as
SELECT dt_ms_tpb_in_barang.ID AS ms_tpb_in_barang_id
, dt_ms_tpb_in_barang.KODE_BARANG
, dt_ms_tpb_in_barang.URAIAN
, dt_ms_tpb_in_barang.KODE_SATUAN
, dt_ms_tpb_in_barang.TIPE
, dt_ms_tpb_in_barang.UKURAN
, dt_ms_tpb_in_barang.MERK
, dt_ms_tpb_in_barang.KODE_NEGARA_ASAL
, dt_ms_tpb_in_barang.mapping_ms_item_id
, dt_ms_item.ms_type_id
, dt_ms_item.ms_item_custom_no
, dt_ms_item_custom.ms_item_custom_name
, dt_ms_item_custom_h_tarif.nomor_hs
, dt_ms_item.ms_item_base_no as base_no
, dt_ms_item.part_no
, dt_ms_item.part_name
, dt_ms_item.uom
, dt_ms_tpb_in_barang.qty_pakai
, dt_ms_tpb_in_barang.JUMLAH_SATUAN
, case when dt_ms_tpb_in_header.KODE_DOKUMEN_PABEAN='23' or dt_ms_tpb_in_header.KODE_DOKUMEN_PABEAN='262' or dt_ms_tpb_in_header.KODE_DOKUMEN_PABEAN='271' then dt_ms_tpb_in_barang.CIF else dt_ms_tpb_in_barang.HARGA_PENYERAHAN end HARGA_TOTAL
, dt_ms_tpb_in_barang.KODE_KEMASAN
, dt_ms_tpb_in_barang.JUMLAH_KEMASAN
, dt_ms_tpb_in_barang.NETTO
, dt_ms_tpb_in_barang.SERI_BARANG
, dt_ms_tpb_in_barang.VOLUME
, dt_ms_tpb_in_barang.KONDISI_BARANG
, dt_ms_tpb_in_barang.ID_ORI
, dt_ms_tpb_in_barang.ID_HEADER
, dt_ms_tpb_in_barang.ID_HEADER_ORI
, dt_ms_tpb_in_barang.POS_TARIF
, isnull(vw_ms_header_bc_in_item_tarif.BM,0) as BM
,isnull( vw_ms_header_bc_in_item_tarif.BM_ID,-1) as BM_ID
, isnull(vw_ms_header_bc_in_item_tarif.PPNBM,0) as PPNBM
, isnull(vw_ms_header_bc_in_item_tarif.PPNBM_ID,-1) as PPNBM_ID
, isnull(vw_ms_header_bc_in_item_tarif.PPH,0) as PPH
, isnull(vw_ms_header_bc_in_item_tarif.PPH_ID,-1) as PPH_ID
, isnull(vw_ms_header_bc_in_item_tarif.PPN,0) as PPN
, isnull(vw_ms_header_bc_in_item_tarif.PPN_ID,-1) as PPN_ID
, isnull(dt_ms_tpb_in_barang.is_get,0) as is_get
, dt_ms_tpb_in_barang.mode_source
, enum_ms_mode_source_tpb_in_barang.mode_source_name
, dt_ms_tpb_in_barang.id_source
, dt_ms_tpb_in_barang.create_date
, users_create.username AS create_by
, dt_ms_tpb_in_barang.modify_date
, users_modify.username AS modify_by
, dt_ms_tpb_in_barang.mapping_date
, users_mapping.username AS mapping_by
, dt_ms_tpb_in_header.mode_source as header_mode_source
, dt_ms_tpb_in_barang.TAHUN_PEMBUATAN
, dt_ms_tpb_in_barang.series
, dt_ms_tpb_in_barang.po_no
, dt_ms_tpb_in_barang.po_date
FROM dt_ms_item_custom INNER JOIN
dt_ms_item ON dt_ms_item_custom.ms_item_custom_no = dt_ms_item.ms_item_custom_no INNER JOIN
enum_ms_type ON dt_ms_item.ms_type_id = enum_ms_type.ms_type_id 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 RIGHT OUTER JOIN
dt_ms_tpb_in_header INNER JOIN
dt_ms_tpb_in_barang ON dt_ms_tpb_in_header.ID_HEADER = dt_ms_tpb_in_barang.ID_HEADER INNER JOIN
enum_ms_mode_source_tpb_in_barang ON dt_ms_tpb_in_barang.mode_source = enum_ms_mode_source_tpb_in_barang.mode_source LEFT OUTER JOIN
vw_ms_header_bc_in_item_tarif ON dt_ms_tpb_in_barang.ID = vw_ms_header_bc_in_item_tarif.ID_BARANG ON dt_ms_item.ms_item_id = dt_ms_tpb_in_barang.mapping_ms_item_id LEFT OUTER JOIN
users AS users_mapping ON dt_ms_tpb_in_barang.mapping_by = users_mapping.id LEFT OUTER JOIN
users AS users_create ON dt_ms_tpb_in_barang.create_by = users_create.id LEFT OUTER JOIN
users AS users_modify ON dt_ms_tpb_in_barang.modify_by = users_modify.id
GO