dbo.tbl_data_part

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 (~)	28514
Created	1/12/2013 13:50:54
Last Modified	2/27/2020 15:54:07

Columns

Key	Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
	id	bigint	8	19	True	1 - 1	False	False
	part_no	varchar	50	0	True		False	False
	part_name	varchar	50	0	False		False	False
	part_name_customs	varchar	50	0	False		False	False
	hs_code	varchar	20	0	False		False	False
	bm	float	8	53	False		False	False
	cek_price	float	8	53	False		False	False
2	part_no2	varchar	50	0	False		False	False
	kode_barang	varchar	50	0	False		False	False
	part_no_sap	varchar	50	0	False		False	False
	order_number	varchar	50	0	False		False	False
	new_part	varchar	50	0	False		False	False
	shipment_term	varchar	50	0	False		False	False
	supplier	varchar	50	0	False		False	False
	supplier_kode	varchar	50	0	False		False	False
	currency	varchar	50	0	False		False	False
	part_name_added	varchar	50	0	False		False	False
	uom	varchar	50	0	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_data_part_hs_20161008_0001	part_no	False
ix_auto_tbl_data_part_hs_20161019_0001	part_no2	False
ix_auto_tbl_data_part_hs_20161019_0002	part_no2	False
PK_tbl_data_part	id, part_no	True

SQL Script

CREATE TABLE dbo.tbl_data_part_hs (
  id bigint IDENTITY,
  part_no varchar(50) NOT NULL,
  part_name varchar(50) NULL,
  part_name_customs varchar(50) NULL,
  hs_code varchar(20) NULL,
  bm float NULL,
  cek_price float NULL,
  part_no2 varchar(50) NULL,
  kode_barang varchar(50) NULL,
  part_no_sap varchar(50) NULL,
  order_number varchar(50) NULL,
  new_part varchar(50) NULL,
  shipment_term varchar(50) NULL,
  supplier varchar(50) NULL,
  supplier_kode varchar(50) NULL,
  currency varchar(50) NULL,
  part_name_added varchar(50) NULL,
  uom varchar(50) NULL,
  CONSTRAINT PK_tbl_data_part PRIMARY KEY CLUSTERED (id, part_no) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_part_hs_20161008_0001
  ON dbo.tbl_data_part_hs (part_no)
  INCLUDE (part_name_customs)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_part_hs_20161019_0001
  ON dbo.tbl_data_part_hs (part_no2)
  INCLUDE (part_no)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_data_part_hs_20161019_0002
  ON dbo.tbl_data_part_hs (part_no2)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_data_part_hs