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 10:38:33 |
| Last Modified | 9/11/2017 10:38:33 |
Columns
| Key | Name | Description |
|---|---|---|
| ID | ||
| FLAG_BMT_SEMENTARA | ||
| JENIS_TARIF | ||
| JUMLAH_SATUAN | ||
| KODE_FASILITAS | ||
| KODE_KOMODITI_CUKAI | ||
| KODE_SATUAN | ||
| KODE_SUB_KOMODITI_CUKAI | ||
| KODE_TARIF | ||
| NILAI_BAYAR | ||
| NILAI_FASILITAS | ||
| NILAI_SUDAH_DILUNASI | ||
| SERI_BARANG | ||
| TARIF | ||
| TARIF_FASILITAS | ||
| ID_BARANG | ||
| ID_HEADER |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_ceisa_barang_tarif
---XencX---with encryption
as
SELECT * FROM OPENQUERY (TPBDB,
'SELECT * FROM tpbdb.tpb_barang_tarif')
GO
GO
create view dbo.vw_ms_ceisa_barang_tarif
---XencX---with encryption
as
SELECT * FROM OPENQUERY (TPBDB,
'SELECT * FROM tpbdb.tpb_barang_tarif')
GO
Depends On
No items found
Used By
No items found