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 | True |
| Full Text Catalog | |
| Full Text | |
| Compression | NONE |
| Row Count (~) | 13214 |
| Created | 4/16/2019 09:53:12 |
| Last Modified | 4/16/2019 09:53:12 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CAR | nvarchar | 26 | 0 | 0 | True |
False |
False |
|||||
| Serial | smallint | 2 | 5 | 0 | True |
False |
False |
|||||
| JnsBarangDtl | nvarchar | 2 | 0 | 0 | False |
False |
False |
|||||
| TujuanKirimDtl | nvarchar | 2 | 0 | 0 | False |
False |
False |
|||||
| NoHs | nvarchar | 12 | 0 | 0 | False |
False |
False |
|||||
| SeriTrp | smallint | 2 | 5 | 0 | False |
False |
False |
|||||
| BrgUrai | nvarchar | 95 | 0 | 0 | False |
False |
False |
|||||
| Merk | nvarchar | 15 | 0 | 0 | False |
False |
False |
|||||
| Tipe | nvarchar | 15 | 0 | 0 | False |
False |
False |
|||||
| SpfLain | nvarchar | 15 | 0 | 0 | False |
False |
False |
|||||
| KdBrg | nvarchar | 15 | 0 | 0 | False |
False |
False |
|||||
| Penggunaan | nvarchar | 1 | 0 | 0 | False |
False |
False |
|||||
| KemasJn | nvarchar | 2 | 0 | 0 | False |
False |
False |
|||||
| KemasJm | int | 4 | 10 | 0 | False |
False |
False |
|||||
| KdFasDtl | nvarchar | 2 | 0 | 0 | False |
False |
False |
|||||
| BrgAsal | nvarchar | 2 | 0 | 0 | False |
False |
False |
|||||
| DNilInv | float | 8 | 53 | 0 | False |
False |
False |
|||||
| DCif | float | 8 | 53 | 0 | False |
False |
False |
|||||
| KdSat | nvarchar | 3 | 0 | 0 | False |
False |
False |
|||||
| JmlSat | float | 8 | 53 | 0 | False |
False |
False |
|||||
| NettoDtl | float | 8 | 53 | 0 | False |
False |
False |
|||||
| SatBmJm | float | 8 | 53 | 0 | False |
False |
False |
|||||
| SatCukJm | float | 8 | 53 | 0 | False |
False |
False |
|||||
| DtlOk | bit | 1 | 1 | 0 | True |
False |
False |
SQL Script
CREATE TABLE dbo.tblBC23Dtl_2016 (
CAR nvarchar(26) NOT NULL,
Serial smallint NOT NULL,
JnsBarangDtl nvarchar(2) NULL,
TujuanKirimDtl nvarchar(2) NULL,
NoHs nvarchar(12) NULL,
SeriTrp smallint NULL,
BrgUrai nvarchar(95) NULL,
Merk nvarchar(15) NULL,
Tipe nvarchar(15) NULL,
SpfLain nvarchar(15) NULL,
KdBrg nvarchar(15) NULL,
Penggunaan nvarchar(1) NULL,
KemasJn nvarchar(2) NULL,
KemasJm int NULL,
KdFasDtl nvarchar(2) NULL,
BrgAsal nvarchar(2) NULL,
DNilInv float NULL,
DCif float NULL,
KdSat nvarchar(3) NULL,
JmlSat float NULL,
NettoDtl float NULL,
SatBmJm float NULL,
SatCukJm float NULL,
DtlOk bit NOT NULL
)
ON [PRIMARY]
GO
CAR nvarchar(26) NOT NULL,
Serial smallint NOT NULL,
JnsBarangDtl nvarchar(2) NULL,
TujuanKirimDtl nvarchar(2) NULL,
NoHs nvarchar(12) NULL,
SeriTrp smallint NULL,
BrgUrai nvarchar(95) NULL,
Merk nvarchar(15) NULL,
Tipe nvarchar(15) NULL,
SpfLain nvarchar(15) NULL,
KdBrg nvarchar(15) NULL,
Penggunaan nvarchar(1) NULL,
KemasJn nvarchar(2) NULL,
KemasJm int NULL,
KdFasDtl nvarchar(2) NULL,
BrgAsal nvarchar(2) NULL,
DNilInv float NULL,
DCif float NULL,
KdSat nvarchar(3) NULL,
JmlSat float NULL,
NettoDtl float NULL,
SatBmJm float NULL,
SatCukJm float NULL,
DtlOk bit NOT NULL
)
ON [PRIMARY]
GO
Depends On
No items found
Used By
No items found