dbo.tbl_data_out

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 (~)	12144845
Created	1/12/2013 17:27:58
Last Modified	6/15/2020 04:39:35

Columns

Key	Name	Data Type	Length	Precision	Not Null	Identity	Default	Computed	Persisted
	id_data_out_dtl	bigint	8	19	True	1 - 1		False	False
2	id_data_out_hdr	bigint	8	19	False			False	False
	id_part_number	bigint	8	19	False			False	False
4	out_date	date	3	10	False			False	False
	part_name_customs	varchar	50	0	False			False	False
	part_number	varchar	50	0	False			False	False
	qty	float	8	53	True		(0)	False	False
	qty_supply	float	8	53	True		(0)	False	False
	unit_out	varchar	5	0	False			False	False
	unit_konversi	varchar	10	0	False			False	False
	pengali	float	8	53	False			False	False
	box	float	8	53	False			False	False
	pack	float	8	53	False			False	False
	assy_code	varchar	50	0	False			False	False
5	type_items	varchar	50	0	False			False	False
	place_to	varchar	50	0	False			False	False
	no_return	varchar	50	0	False			False	False
	tgl_return	date	3	10	False			False	False
	qty_return	float	8	53	False			False	False
	status_return	varchar	50	0	False			False	False
	tgl_adj	date	3	10	False			False	False
	qty_adj	float	8	53	False			False	False
	ket_adj	float	8	53	False			False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_data_out_dtl_20161008_0001	id_data_out_hdr	False
ix_auto_tbl_data_out_dtl_20161008_0002	type_items, out_date	False
ix_auto_tbl_data_out_dtl_20161008_0003	type_items, out_date	False
ix_auto_tbl_data_out_dtl_20161008_0004	type_items, out_date	False
ix_auto_tbl_data_out_dtl_20161019_0001	id_data_out_hdr, type_items	False
IX_tbl_data_out_dtl_I	out_date	False
IX_tbl_data_out_dtl_II	part_name_customs	False
IX_tbl_data_out_dtl_III	type_items	False
PK_tbl_data_out_dtl	id_data_out_dtl	True

Foreign Keys

Name	Columns	Description
FK_tbl_data_out_dtl_tbl_data_out_hdr	id_data_out_hdr

SQL Script

CREATE TABLE dbo.tbl_data_out_dtl (
  id_data_out_dtl bigint IDENTITY,
  id_data_out_hdr bigint NULL,
  id_part_number bigint NULL,
  out_date date NULL,
  part_name_customs varchar(50) NULL,
  part_number varchar(50) NULL,
  qty float NOT NULL CONSTRAINT DF_tbl_data_out_dtl_qty DEFAULT (0),
  qty_supply float NOT NULL CONSTRAINT DF_tbl_data_out_dtl_qty_supply DEFAULT (0),
  unit_out varchar(5) NULL,
  unit_konversi varchar(10) NULL,
  pengali float NULL,
  box float NULL,
  pack float NULL,
  assy_code varchar(50) NULL,
  type_items varchar(50) NULL,
  place_to varchar(50) NULL,
  no_return varchar(50) NULL,
  tgl_return date NULL,
  qty_return float NULL,
  status_return varchar(50) NULL,
  tgl_adj date NULL,
  qty_adj float NULL,
  ket_adj float NULL,
  CONSTRAINT PK_tbl_data_out_dtl PRIMARY KEY CLUSTERED (id_data_out_dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_dtl_20161008_0001
  ON dbo.tbl_data_out_dtl (id_data_out_hdr)
  INCLUDE (id_data_out_dtl)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_dtl_20161008_0002
  ON dbo.tbl_data_out_dtl (type_items, out_date)
  INCLUDE (id_data_out_hdr, part_name_customs, qty, unit_out, pengali)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_dtl_20161008_0003
  ON dbo.tbl_data_out_dtl (type_items, out_date)
  INCLUDE (qty, unit_out, assy_code)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_dtl_20161008_0004
  ON dbo.tbl_data_out_dtl (type_items, out_date)
  INCLUDE (id_data_out_hdr, part_name_customs, qty)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_out_dtl_20161019_0001
  ON dbo.tbl_data_out_dtl (id_data_out_hdr, type_items)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX IX_tbl_data_out_dtl_I
  ON dbo.tbl_data_out_dtl (out_date)
  INCLUDE (id_data_out_dtl, id_data_out_hdr, id_part_number, part_name_customs, part_number, qty, qty_supply, unit_out, unit_konversi, pengali, box, pack, assy_code, type_items)
  ON [PRIMARY]
GO

CREATE INDEX IX_tbl_data_out_dtl_II
  ON dbo.tbl_data_out_dtl (part_name_customs)
  INCLUDE (id_data_out_dtl, id_data_out_hdr, id_part_number, out_date, part_number, qty, qty_supply, unit_out, unit_konversi, pengali, box, pack, assy_code, type_items)
  ON [PRIMARY]
GO

CREATE INDEX IX_tbl_data_out_dtl_III
  ON dbo.tbl_data_out_dtl (type_items)
  INCLUDE (id_data_out_hdr, out_date, qty, pengali, assy_code)
  ON [PRIMARY]
GO

ALTER TABLE dbo.tbl_data_out_dtl WITH NOCHECK
  ADD CONSTRAINT FK_tbl_data_out_dtl_tbl_data_out_hdr FOREIGN KEY (id_data_out_hdr) REFERENCES dbo.tbl_data_out_hdr (id_data_out_hdr) NOT FOR REPLICATION
GO

ALTER TABLE dbo.tbl_data_out_dtl
  NOCHECK CONSTRAINT FK_tbl_data_out_dtl_tbl_data_out_hdr
GO

Depends On

dbo.tbl_data_out_hdr

dbo.tbl_data_out_dtl