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 (~) | 0 |
| Created | 3/22/2013 13:27:45 |
| Last Modified | 11/18/2016 22:54:30 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
id_bc25dtl | bigint | 8 | 19 | 0 | True |
1 - 1 | False |
False |
|||
| id_bc25hdr | bigint | 8 | 19 | 0 | True |
False |
False |
|||||
| CAR | varchar | 50 | 0 | 0 | True |
False |
False |
|||||
| Serial | int | 4 | 10 | 0 | False |
False |
False |
|||||
| JnsBarangDtl | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TujuanKirimDtl | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NoHs | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| SeriTrp | int | 4 | 10 | 0 | False |
False |
False |
|||||
| BrgUrai | varchar | 95 | 0 | 0 | False |
False |
False |
|||||
| Merk | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Tipe | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| SpfLain | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| KdBrg | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Penggunaan | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| KemasJn | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| KemasJm | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| KdFasDtl | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| BrgAsal | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DNilInv | float | 8 | 53 | 0 | False |
False |
False |
|||||
| DCif | float | 8 | 53 | 0 | False |
False |
False |
|||||
| KdSat | varchar | 50 | 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_tblBC25Dtl | id_bc25dtl | True |
SQL Script
CREATE TABLE dbo.tblBC25Dtl (
id_bc25dtl bigint IDENTITY,
id_bc25hdr bigint NOT NULL,
CAR varchar(50) NOT NULL,
Serial int NULL,
JnsBarangDtl varchar(50) NULL,
TujuanKirimDtl varchar(50) NULL,
NoHs varchar(50) NULL,
SeriTrp int NULL,
BrgUrai varchar(95) NULL,
Merk varchar(50) NULL,
Tipe varchar(50) NULL,
SpfLain varchar(50) NULL,
KdBrg varchar(50) NULL,
Penggunaan varchar(50) NULL,
KemasJn varchar(50) NULL,
KemasJm bigint NULL,
KdFasDtl varchar(50) NULL,
BrgAsal varchar(50) NULL,
DNilInv float NULL,
DCif float NULL,
KdSat varchar(50) NULL,
JmlSat float NULL,
NettoDtl float NULL,
SatBmJm float NULL,
SatCukJm float NULL,
DtlOk char(1) NULL,
CONSTRAINT PK_tblBC25Dtl PRIMARY KEY CLUSTERED (id_bc25dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
id_bc25dtl bigint IDENTITY,
id_bc25hdr bigint NOT NULL,
CAR varchar(50) NOT NULL,
Serial int NULL,
JnsBarangDtl varchar(50) NULL,
TujuanKirimDtl varchar(50) NULL,
NoHs varchar(50) NULL,
SeriTrp int NULL,
BrgUrai varchar(95) NULL,
Merk varchar(50) NULL,
Tipe varchar(50) NULL,
SpfLain varchar(50) NULL,
KdBrg varchar(50) NULL,
Penggunaan varchar(50) NULL,
KemasJn varchar(50) NULL,
KemasJm bigint NULL,
KdFasDtl varchar(50) NULL,
BrgAsal varchar(50) NULL,
DNilInv float NULL,
DCif float NULL,
KdSat varchar(50) NULL,
JmlSat float NULL,
NettoDtl float NULL,
SatBmJm float NULL,
SatCukJm float NULL,
DtlOk char(1) NULL,
CONSTRAINT PK_tblBC25Dtl PRIMARY KEY CLUSTERED (id_bc25dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
Depends On
No items found
Used By
No items found