Description
Properties
| Name | Value |
|---|---|
| Collation | |
| File Group | |
| Filestream File Group | |
| Is Partitioned | False |
| Partitioned Column | |
| Partition Scheme | |
| File Groups | |
| Filestream Partition Scheme | |
| Filestream File Groups | |
| Heap | False |
| Full Text Catalog | |
| Full Text | |
| Compression | NONE |
| Row Count (~) | 83 |
| Created | 8/14/2017 15:33:24 |
| Last Modified | 8/14/2017 15:33:24 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ID | bigint | 8 | 19 | 0 | True |
False |
False |
||||
| JENIS_TARIF_BM | varchar | 255 | 0 | 0 | False |
(NULL) | False |
False |
||||
| JENIS_TARIF_CUKAI | varchar | 255 | 0 | 0 | False |
(NULL) | False |
False |
||||
| KODE_SATUAN_BM | varchar | 255 | 0 | 0 | False |
(NULL) | False |
False |
||||
| KODE_SATUAN_CUKAI | varchar | 255 | 0 | 0 | False |
(NULL) | False |
False |
||||
| NOMOR_HS | varchar | 255 | 0 | 0 | False |
(NULL) | False |
False |
||||
| SERI_HS | bigint | 8 | 19 | 0 | False |
(NULL) | False |
False |
||||
| TARIF_BM | decimal | 13 | 20 | 2 | False |
(NULL) | False |
False |
||||
| TARIF_CUKAI | decimal | 13 | 20 | 2 | False |
(NULL) | False |
False |
||||
| TARIF_PPH | decimal | 13 | 20 | 2 | False |
(NULL) | False |
False |
||||
| TARIF_PPN | decimal | 13 | 20 | 2 | False |
(NULL) | False |
False |
||||
| TARIF_PPNBM | decimal | 13 | 20 | 2 | False |
(NULL) | False |
False |
Indexes
| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
|
|
PK__referens__3214EC27263D3CD6 | ID | True |
SQL Script
CREATE TABLE dbo.referensi_pos_tarif (
ID bigint NOT NULL,
JENIS_TARIF_BM varchar(255) NULL CONSTRAINT DF__referensi__JENIS__08E75C01 DEFAULT (NULL),
JENIS_TARIF_CUKAI varchar(255) NULL CONSTRAINT DF__referensi__JENIS__09DB803A DEFAULT (NULL),
KODE_SATUAN_BM varchar(255) NULL CONSTRAINT DF__referensi__KODE___0ACFA473 DEFAULT (NULL),
KODE_SATUAN_CUKAI varchar(255) NULL CONSTRAINT DF__referensi__KODE___0BC3C8AC DEFAULT (NULL),
NOMOR_HS varchar(255) NULL CONSTRAINT DF__referensi__NOMOR__0CB7ECE5 DEFAULT (NULL),
SERI_HS bigint NULL CONSTRAINT DF__referensi__SERI___0DAC111E DEFAULT (NULL),
TARIF_BM decimal(20, 2) NULL CONSTRAINT DF__referensi__TARIF__0EA03557 DEFAULT (NULL),
TARIF_CUKAI decimal(20, 2) NULL CONSTRAINT DF__referensi__TARIF__0F945990 DEFAULT (NULL),
TARIF_PPH decimal(20, 2) NULL CONSTRAINT DF__referensi__TARIF__10887DC9 DEFAULT (NULL),
TARIF_PPN decimal(20, 2) NULL CONSTRAINT DF__referensi__TARIF__117CA202 DEFAULT (NULL),
TARIF_PPNBM decimal(20, 2) NULL CONSTRAINT DF__referensi__TARIF__1270C63B DEFAULT (NULL),
CONSTRAINT PK__referens__3214EC27263D3CD6 PRIMARY KEY CLUSTERED (ID)
)
ON [PRIMARY]
GO
ID bigint NOT NULL,
JENIS_TARIF_BM varchar(255) NULL CONSTRAINT DF__referensi__JENIS__08E75C01 DEFAULT (NULL),
JENIS_TARIF_CUKAI varchar(255) NULL CONSTRAINT DF__referensi__JENIS__09DB803A DEFAULT (NULL),
KODE_SATUAN_BM varchar(255) NULL CONSTRAINT DF__referensi__KODE___0ACFA473 DEFAULT (NULL),
KODE_SATUAN_CUKAI varchar(255) NULL CONSTRAINT DF__referensi__KODE___0BC3C8AC DEFAULT (NULL),
NOMOR_HS varchar(255) NULL CONSTRAINT DF__referensi__NOMOR__0CB7ECE5 DEFAULT (NULL),
SERI_HS bigint NULL CONSTRAINT DF__referensi__SERI___0DAC111E DEFAULT (NULL),
TARIF_BM decimal(20, 2) NULL CONSTRAINT DF__referensi__TARIF__0EA03557 DEFAULT (NULL),
TARIF_CUKAI decimal(20, 2) NULL CONSTRAINT DF__referensi__TARIF__0F945990 DEFAULT (NULL),
TARIF_PPH decimal(20, 2) NULL CONSTRAINT DF__referensi__TARIF__10887DC9 DEFAULT (NULL),
TARIF_PPN decimal(20, 2) NULL CONSTRAINT DF__referensi__TARIF__117CA202 DEFAULT (NULL),
TARIF_PPNBM decimal(20, 2) NULL CONSTRAINT DF__referensi__TARIF__1270C63B DEFAULT (NULL),
CONSTRAINT PK__referens__3214EC27263D3CD6 PRIMARY KEY CLUSTERED (ID)
)
ON [PRIMARY]
GO
Depends On
No items found