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 (~) | 173907 |
| Created | 6/1/2013 07:32:21 |
| Last Modified | 11/18/2016 23:29:03 |
Columns
| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
id_bc271_detail | bigint | 8 | 19 | 0 | True |
1 - 1 | False |
False |
|||
| id_bc271_hdr | bigint | 8 | 19 | 0 | False |
False |
False |
|||||
| CAR | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| NoHS | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| BrgUrai | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Merk | nchar | 10 | 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 |
|||||
| KdBrg1 | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| KdSat | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| part_name_customs | varchar | 100 | 0 | 0 | False |
False |
False |
|||||
| JmlSat | float | 8 | 53 | 0 | False |
False |
False |
|||||
| NettoDtl | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DSerah | float | 8 | 53 | 0 | False |
False |
False |
|||||
| DVol | float | 8 | 53 | 0 | False |
False |
False |
|||||
| NoUrut | float | 8 | 53 | 0 | False |
False |
False |
|||||
| NoInvoice | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TgInvoice | date | 3 | 10 | 0 | False |
False |
False |
|||||
| create_date | datetime | 8 | 23 | 3 | False |
False |
False |
|||||
| create_by | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| update_date | datetime | 8 | 23 | 3 | False |
False |
False |
|||||
| update_by | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Status | varchar | 50 | 0 | 0 | False |
False |
False |
Indexes
| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
|
|
PK_tbl_detail_bc27_out | id_bc271_detail | True |
SQL Script
CREATE TABLE dbo.tbl_detail_bc27_out (
id_bc271_detail bigint IDENTITY,
id_bc271_hdr bigint NULL,
CAR varchar(50) NULL,
NoHS varchar(50) NULL,
BrgUrai varchar(50) NULL,
Merk nchar(10) NULL,
Tipe varchar(50) NULL,
SpfLain varchar(50) NULL,
KdBrg varchar(50) NULL,
KdBrg1 varchar(50) NULL,
KdSat varchar(50) NULL,
part_name_customs varchar(100) NULL,
JmlSat float NULL,
NettoDtl varchar(50) NULL,
DSerah float NULL,
DVol float NULL,
NoUrut float NULL,
NoInvoice varchar(50) NULL,
TgInvoice date NULL,
create_date datetime NULL,
create_by varchar(50) NULL,
update_date datetime NULL,
update_by varchar(50) NULL,
Status varchar(50) NULL,
CONSTRAINT PK_tbl_detail_bc27_out PRIMARY KEY CLUSTERED (id_bc271_detail) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
id_bc271_detail bigint IDENTITY,
id_bc271_hdr bigint NULL,
CAR varchar(50) NULL,
NoHS varchar(50) NULL,
BrgUrai varchar(50) NULL,
Merk nchar(10) NULL,
Tipe varchar(50) NULL,
SpfLain varchar(50) NULL,
KdBrg varchar(50) NULL,
KdBrg1 varchar(50) NULL,
KdSat varchar(50) NULL,
part_name_customs varchar(100) NULL,
JmlSat float NULL,
NettoDtl varchar(50) NULL,
DSerah float NULL,
DVol float NULL,
NoUrut float NULL,
NoInvoice varchar(50) NULL,
TgInvoice date NULL,
create_date datetime NULL,
create_by varchar(50) NULL,
update_date datetime NULL,
update_by varchar(50) NULL,
Status varchar(50) NULL,
CONSTRAINT PK_tbl_detail_bc27_out PRIMARY KEY CLUSTERED (id_bc271_detail) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO
Depends On
No items found