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/15/2017 06:53:02 |
| Last Modified | 9/15/2017 06:53:02 |
Columns
| Key | Name | Description |
|---|---|---|
| ID | ||
| KODE_JENIS_DOKUMEN | ||
| URAIAN_DOKUMEN | ||
| NOMOR_DOKUMEN | ||
| TANGGAL_DOKUMEN | ||
| ID_HEADER |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_header_bc_in_document
---XencX---with encryption
as
SELECT
dt_ms_tpb_in_dokumen.ID
, dt_ms_tpb_in_dokumen.KODE_JENIS_DOKUMEN
, enum_ms_type_dokumen.URAIAN_DOKUMEN
, dt_ms_tpb_in_dokumen.NOMOR_DOKUMEN
, dt_ms_tpb_in_dokumen.TANGGAL_DOKUMEN
, dt_ms_tpb_in_dokumen.ID_HEADER
FROM dt_ms_tpb_in_dokumen INNER JOIN
enum_ms_type_dokumen ON dt_ms_tpb_in_dokumen.KODE_JENIS_DOKUMEN = enum_ms_type_dokumen.KODE_DOKUMEN AND dt_ms_tpb_in_dokumen.TIPE_DOKUMEN = enum_ms_type_dokumen.TIPE_DOKUMEN
GO
GO
create view dbo.vw_ms_header_bc_in_document
---XencX---with encryption
as
SELECT
dt_ms_tpb_in_dokumen.ID
, dt_ms_tpb_in_dokumen.KODE_JENIS_DOKUMEN
, enum_ms_type_dokumen.URAIAN_DOKUMEN
, dt_ms_tpb_in_dokumen.NOMOR_DOKUMEN
, dt_ms_tpb_in_dokumen.TANGGAL_DOKUMEN
, dt_ms_tpb_in_dokumen.ID_HEADER
FROM dt_ms_tpb_in_dokumen INNER JOIN
enum_ms_type_dokumen ON dt_ms_tpb_in_dokumen.KODE_JENIS_DOKUMEN = enum_ms_type_dokumen.KODE_DOKUMEN AND dt_ms_tpb_in_dokumen.TIPE_DOKUMEN = enum_ms_type_dokumen.TIPE_DOKUMEN
GO