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:08 |
| Last Modified | 9/11/2017 10:38:08 |
Columns
| Key | Name | Description |
|---|---|---|
| ID | ||
| ASURANSI | ||
| CIF | ||
| CIF_RUPIAH | ||
| DISKON | ||
| FLAG_KENDARAAN | ||
| FOB | ||
| FREIGHT | ||
| HARGA_BARANG_LDP | ||
| HARGA_INVOICE | ||
| HARGA_PENYERAHAN | ||
| HARGA_SATUAN | ||
| JENIS_KENDARAAN | ||
| JUMLAH_BAHAN_BAKU | ||
| JUMLAH_KEMASAN | ||
| JUMLAH_SATUAN | ||
| KAPASITAS_SILINDER | ||
| KATEGORI_BARANG | ||
| KODE_ASAL_BARANG | ||
| KODE_BARANG | ||
| KODE_FASILITAS_DOKUMEN | ||
| KODE_GUNA | ||
| KODE_JENIS_NILAI | ||
| KODE_KEMASAN | ||
| KODE_LEBIH_DARI4TAHUN | ||
| KODE_NEGARA_ASAL | ||
| KODE_SATUAN | ||
| KODE_SKEMA_TARIF | ||
| KODE_STATUS | ||
| KONDISI_BARANG | ||
| MERK | ||
| NETTO | ||
| NILAI_INCOTERM | ||
| NILAI_PABEAN | ||
| NOMOR_MESIN | ||
| NOMOR_RANGKA | ||
| POS_TARIF | ||
| SERI_BARANG | ||
| SERI_IJIN | ||
| SERI_POS_TARIF | ||
| SPESIFIKASI_LAIN | ||
| TAHUN_PEMBUATAN | ||
| TIPE | ||
| UKURAN | ||
| URAIAN | ||
| VOLUME | ||
| ID_HEADER |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
create view dbo.vw_ms_ceisa_barang
---XencX---with encryption
as
SELECT * FROM OPENQUERY (TPBDB,
'SELECT * FROM tpbdb.tpb_barang')
GO
GO
create view dbo.vw_ms_ceisa_barang
---XencX---with encryption
as
SELECT * FROM OPENQUERY (TPBDB,
'SELECT * FROM tpbdb.tpb_barang')
GO
Depends On
No items found
Used By
No items found