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 (~) | 58883 |
| Created | 5/3/2013 08:14:22 |
| Last Modified | 11/18/2016 23:31:19 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
CAR | varchar | 26 | 0 | 0 | True |
False |
False |
||||
|
|
Serial | int | 4 | 10 | 0 | True |
False |
False |
||||
| JnsBarangDtl | varchar | 2 | 0 | 0 | False |
False |
False |
|||||
| TujuanKirimDtl | varchar | 2 | 0 | 0 | False |
False |
False |
|||||
| NoHs | varchar | 12 | 0 | 0 | False |
False |
False |
|||||
| SeriTrp | int | 4 | 10 | 0 | False |
False |
False |
|||||
| BrgUrai | varchar | 95 | 0 | 0 | False |
False |
False |
|||||
| Merk | varchar | 15 | 0 | 0 | False |
False |
False |
|||||
| Tipe | varchar | 15 | 0 | 0 | False |
False |
False |
|||||
| SpfLain | varchar | 15 | 0 | 0 | False |
False |
False |
|||||
| KdBrg | varchar | 15 | 0 | 0 | False |
False |
False |
|||||
| Penggunaan | varchar | 1 | 0 | 0 | False |
False |
False |
|||||
| KemasJn | varchar | 2 | 0 | 0 | False |
False |
False |
|||||
| KemasJm | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| KdFasDtl | varchar | 2 | 0 | 0 | False |
False |
False |
|||||
| BrgAsal | varchar | 2 | 0 | 0 | False |
False |
False |
|||||
| DNilInv | float | 8 | 53 | 0 | False |
False |
False |
|||||
| DCif | float | 8 | 53 | 0 | False |
False |
False |
|||||
| KdSat | varchar | 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 | char | 1 | 0 | 0 | False |
False |
False |
Indexes
| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
|
|
PK__tblBC23D__F05F1740D747AA34 | CAR, Serial | True |
SQL Script
CREATE TABLE dbo.tblBC23Dtl (
CAR varchar(26) NOT NULL,
Serial int NOT NULL,
JnsBarangDtl varchar(2) NULL,
TujuanKirimDtl varchar(2) NULL,
NoHs varchar(12) NULL,
SeriTrp int NULL,
BrgUrai varchar(95) NULL,
Merk varchar(15) NULL,
Tipe varchar(15) NULL,
SpfLain varchar(15) NULL,
KdBrg varchar(15) NULL,
Penggunaan varchar(1) NULL,
KemasJn varchar(2) NULL,
KemasJm bigint NULL,
KdFasDtl varchar(2) NULL,
BrgAsal varchar(2) NULL,
DNilInv float NULL,
DCif float NULL,
KdSat varchar(3) NULL,
JmlSat float NULL,
NettoDtl float NULL,
SatBmJm float NULL,
SatCukJm float NULL,
DtlOk char(1) NULL,
PRIMARY KEY CLUSTERED (CAR, Serial) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
CAR varchar(26) NOT NULL,
Serial int NOT NULL,
JnsBarangDtl varchar(2) NULL,
TujuanKirimDtl varchar(2) NULL,
NoHs varchar(12) NULL,
SeriTrp int NULL,
BrgUrai varchar(95) NULL,
Merk varchar(15) NULL,
Tipe varchar(15) NULL,
SpfLain varchar(15) NULL,
KdBrg varchar(15) NULL,
Penggunaan varchar(1) NULL,
KemasJn varchar(2) NULL,
KemasJm bigint NULL,
KdFasDtl varchar(2) NULL,
BrgAsal varchar(2) NULL,
DNilInv float NULL,
DCif float NULL,
KdSat varchar(3) NULL,
JmlSat float NULL,
NettoDtl float NULL,
SatBmJm float NULL,
SatCukJm float NULL,
DtlOk char(1) NULL,
PRIMARY KEY CLUSTERED (CAR, Serial) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
Depends On
No items found
Used By
No items found