dbo.tbl_scrap

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 (~)	7
Created	5/2/2013 14:19:29
Last Modified	11/18/2016 23:29:03

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id_scrap	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
part_no2	varchar	50	0	False		False	False
kode_barang	varchar	50	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_scrap_data	id_scrap	True

SQL Script

CREATE TABLE dbo.tbl_scrap_data (
  id_scrap 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,
  CONSTRAINT PK_tbl_scrap_data PRIMARY KEY CLUSTERED (id_scrap) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

dbo.f_mutasi_scr