dbo.vw_ms_header_bc_out

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 09:48:28
Last Modified	9/15/2017 09:48:28

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_out_document
---XencX---with encryption
as
SELECT
   dt_ms_tpb_out_dokumen.ID
, dt_ms_tpb_out_dokumen.KODE_JENIS_DOKUMEN
, enum_ms_type_dokumen.URAIAN_DOKUMEN
, dt_ms_tpb_out_dokumen.NOMOR_DOKUMEN
, dt_ms_tpb_out_dokumen.TANGGAL_DOKUMEN
, dt_ms_tpb_out_dokumen.ID_HEADER
FROM            dt_ms_tpb_out_dokumen INNER JOIN
                         enum_ms_type_dokumen ON dt_ms_tpb_out_dokumen.KODE_JENIS_DOKUMEN = enum_ms_type_dokumen.KODE_DOKUMEN AND dt_ms_tpb_out_dokumen.TIPE_DOKUMEN = enum_ms_type_dokumen.TIPE_DOKUMEN

GO

Depends On

dbo.dt_ms_tpb_out_dokumen
dbo.enum_ms_type_dokumen

Used By

No items found