dbo.tbl_bc_in_dtl

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 (~)	1954244
Created	2/23/2013 23:35:25
Last Modified	1/28/2020 15:14:18

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	id_bc_in_dtl_partnumber	bigint	8	19	0	True	1 - 1	False	False
	inv_dtl	bigint	8	19	0	True		False	False
	inv_hdr_id	bigint	8	19	0	True		False	False
	id_partnumber	bigint	8	19	0	False		False	False
2	id_bc_in_hdr	bigint	8	19	0	False		False	False
	noinv	varchar	50	0	0	False		False	False
	car	varchar	26	0	0	False		False	False
	nobc	varchar	20	0	0	False		False	False
	tglbc	datetime	8	23	3	False		False	False
	seri_detil	int	4	10	0	False		False	False
	part_no2	varchar	50	0	0	False		False	False
	part_number	varchar	30	0	0	False		False	False
	part_name	varchar	100	0	0	False		False	False
	part_name_customs	varchar	50	0	0	False		False	False
	hscode	varchar	20	0	0	False		False	False
	bm	float	8	53	0	False		False	False
	qty	float	8	53	0	False		False	False
	unit	varchar	5	0	0	False		False	False
	harga	float	8	53	0	False		False	False
	kdval	varchar	5	0	0	False		False	False
	box	float	8	53	0	False		False	False
	pack	float	8	53	0	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_bc_in_dtl_partnumber_20161008_0001	id_bc_in_hdr	False
ix_auto_tbl_bc_in_dtl_partnumber_20161008_0002	id_bc_in_hdr	False
PK_tbl_bc_in_dtl_partnumber	id_bc_in_dtl_partnumber	True

Foreign Keys

Name	Columns	Description
FK_tbl_bc_in_dtl_partnumber_tbl_bc_in_hdr	id_bc_in_hdr

SQL Script

CREATE TABLE dbo.tbl_bc_in_dtl_partnumber (
  id_bc_in_dtl_partnumber bigint IDENTITY,
  inv_dtl bigint NOT NULL,
  inv_hdr_id bigint NOT NULL,
  id_partnumber bigint NULL,
  id_bc_in_hdr bigint NULL,
  noinv varchar(50) NULL,
  car varchar(26) NULL,
  nobc varchar(20) NULL,
  tglbc datetime NULL,
  seri_detil int NULL,
  part_no2 varchar(50) NULL,
  part_number varchar(30) NULL,
  part_name varchar(100) NULL,
  part_name_customs varchar(50) NULL,
  hscode varchar(20) NULL,
  bm float NULL,
  qty float NULL,
  unit varchar(5) NULL,
  harga float NULL,
  kdval varchar(5) NULL,
  box float NULL,
  pack float NULL,
  CONSTRAINT PK_tbl_bc_in_dtl_partnumber PRIMARY KEY CLUSTERED (id_bc_in_dtl_partnumber) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

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

CREATE INDEX ix_auto_tbl_bc_in_dtl_partnumber_20161008_0002
  ON dbo.tbl_bc_in_dtl_partnumber (id_bc_in_hdr)
  INCLUDE (id_bc_in_dtl_partnumber, inv_dtl, inv_hdr_id, id_partnumber, noinv, car, nobc, tglbc, seri_detil, part_no2, part_number, part_name, part_name_customs, hscode, bm, qty, unit, harga, kdval, box, pack)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

ALTER TABLE dbo.tbl_bc_in_dtl_partnumber WITH NOCHECK
  ADD CONSTRAINT FK_tbl_bc_in_dtl_partnumber_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_partnumber
  NOCHECK CONSTRAINT FK_tbl_bc_in_dtl_partnumber_tbl_bc_in_hdr
GO

Depends On

dbo.tbl_bc_in_hdr

dbo.tbl_bc_in_dtl_partnumber