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:15 |
| Last Modified | 9/11/2017 10:38:15 |
Columns
| Key | Name | Description |
|---|---|---|
| ID | ||
| CIF | ||
| CIF_RUPIAH | ||
| HARGA_PENYERAHAN | ||
| HARGA_PEROLEHAN | ||
| JENIS_SATUAN | ||
| JUMLAH_SATUAN | ||
| KODE_ASAL_BAHAN_BAKU | ||
| KODE_BARANG | ||
| KODE_FASILITAS_DOKUMEN | ||
| KODE_JENIS_DOK_ASAL | ||
| KODE_KANTOR | ||
| KODE_SKEMA_TARIF | ||
| KODE_STATUS | ||
| MERK | ||
| NDPBM | ||
| NETTO | ||
| NOMOR_AJU_DOK_ASAL | ||
| NOMOR_DAFTAR_DOK_ASAL | ||
| POS_TARIF | ||
| SERI_BAHAN_BAKU | ||
| SERI_BARANG | ||
| SERI_BARANG_DOK_ASAL | ||
| SPESIFIKASI_LAIN | ||
| TANGGAL_DAFTAR_DOK_ASAL | ||
| TIPE | ||
| UKURAN | ||
| URAIAN | ||
| ID_BARANG | ||
| ID_HEADER |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_ceisa_bahan_baku
---XencX---with encryption
as
SELECT * FROM OPENQUERY (TPBDB,
'SELECT * FROM tpbdb.tpb_bahan_baku')
GO
GO
create view dbo.vw_ms_ceisa_bahan_baku
---XencX---with encryption
as
SELECT * FROM OPENQUERY (TPBDB,
'SELECT * FROM tpbdb.tpb_bahan_baku')
GO
Depends On
No items found
Used By
No items found