dbo.tbl_bc_in

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 (~)	1073870
Created	1/10/2013 21:38:07
Last Modified	11/16/2020 15:40:39

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_bc_in_dtl	bigint	8	19	0	True	1 - 1	False	False
id_bc_in_hdr	bigint	8	19	0	False		False	False
CAR	varchar	26	0	0	False		False	False
Serial	int	4	10	0	False		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	smallint	2	5	0	False		False	False
BrgUrai	varchar	95	0	0	False		False	False
Merk	varchar	15	0	0	False		False	False
Tipe	varchar	100	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	int	4	10	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
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

Indexes

Name	Columns	Unique
ix_auto_tbl_bc_in_dtl_20161008_0001	id_bc_in_hdr	False
ix_auto_tbl_bc_in_dtl_20161008_0002	CAR, Serial	False
ix_auto_tbl_bc_in_dtl_20161019_0001	KdBrg	False
tbl_bc_in_dtl_pk	id_bc_in_dtl	True

Foreign Keys

Name	Columns	Description
FK_tbl_bc_in_dtl_tbl_bc_in_hdr	id_bc_in_hdr

SQL Script

CREATE TABLE dbo.tbl_bc_in_dtl (
  id_bc_in_dtl bigint IDENTITY,
  id_bc_in_hdr bigint NULL,
  CAR varchar(26) NULL,
  Serial int NULL,
  JnsBarangDtl varchar(2) NULL,
  TujuanKirimDtl varchar(2) NULL,
  NoHs varchar(12) NULL,
  SeriTrp smallint NULL,
  BrgUrai varchar(95) NULL,
  Merk varchar(15) NULL,
  Tipe varchar(100) NULL,
  SpfLain varchar(15) NULL,
  KdBrg varchar(15) NULL,
  Penggunaan varchar(1) NULL,
  KemasJn varchar(2) NULL,
  KemasJm int 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,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  CONSTRAINT tbl_bc_in_dtl_pk PRIMARY KEY CLUSTERED (id_bc_in_dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_dtl_20161008_0001
  ON dbo.tbl_bc_in_dtl (id_bc_in_hdr)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_dtl_20161008_0002
  ON dbo.tbl_bc_in_dtl (CAR, Serial)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_dtl_20161019_0001
  ON dbo.tbl_bc_in_dtl (KdBrg)
  INCLUDE (id_bc_in_dtl, id_bc_in_hdr, CAR, Serial, JnsBarangDtl, TujuanKirimDtl, NoHs, SeriTrp, BrgUrai, Merk, Tipe, SpfLain, Penggunaan, KemasJn, KemasJm, KdFasDtl, BrgAsal, DNilInv, DCif, KdSat, JmlSat, NettoDtl, SatBmJm, SatCukJm, DtlOk, create_date, create_by, update_date, update_by)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

ALTER TABLE dbo.tbl_bc_in_dtl WITH NOCHECK
  ADD CONSTRAINT FK_tbl_bc_in_dtl_tbl_bc_in_hdr FOREIGN KEY (id_bc_in_hdr) REFERENCES dbo.tbl_bc_in_hdr (id_bc_in_hdr) NOT FOR REPLICATION
GO

ALTER TABLE dbo.tbl_bc_in_dtl
  NOCHECK CONSTRAINT FK_tbl_bc_in_dtl_tbl_bc_in_hdr
GO

Depends On

dbo.tbl_bc_in_hdr

dbo.tbl_bc_in_dtl