dbo.tbl

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 (~)	192099
Created	9/9/2017 11:09:31
Last Modified	9/9/2017 11:09:43

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	id_sa	bigint	8	19	0	True	1 - 1	False	False
4	id_sa_hdr	bigint	8	19	0	True		False	False
	SA_NO	varchar	50	0	0	False		False	False
	NPWP_PEMBELI	varchar	250	0	0	False		False	False
	NAMA_PEMBELI	varchar	250	0	0	False		False	False
	ALAMAT	varchar	250	0	0	False		False	False
	INV_NO	varchar	250	0	0	False		False	False
	ASSY_CODE	varchar	50	0	0	False		False	False
	ASSY_NO	varchar	150	0	0	False		False	False
	TOTAL_SET	float	8	53	0	False		False	False
	SATUAN	varchar	5	0	0	False		False	False
	JUMLAH_COLI	float	8	53	0	False		False	False
	GROSSWEIGHT	float	8	53	0	False		False	False
	SATUANGROSS	varchar	5	0	0	False		False	False
	NETWEIGHT	float	8	53	0	False		False	False
	SATUANNET	varchar	5	0	0	False		False	False
	PRICE	float	8	53	0	False		False	False
	AMOUNT	float	8	53	0	False		False	False
	KD_VAL	varchar	50	0	0	False		False	False
	TGL_INV	varchar	15	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
	HS_KODE	varchar	50	0	0	False		False	False
	SERI_BRG	int	4	10	0	False		False	False
	SATUAN_COLI	varchar	50	0	0	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_sa_20161008_0001	id_sa_hdr	False
ix_auto_tbl_sa_20161008_0002	id_sa_hdr	False
ix_auto_tbl_sa_20161008_0003	id_sa_hdr	False
ix_auto_tbl_sa_20161008_0004	id_sa_hdr	False
PK_tbl_sa	id_sa	True

SQL Script

CREATE TABLE dbo.tbl_sa (
  id_sa bigint IDENTITY,
  id_sa_hdr bigint NOT NULL,
  SA_NO varchar(50) NULL,
  NPWP_PEMBELI varchar(250) NULL,
  NAMA_PEMBELI varchar(250) NULL,
  ALAMAT varchar(250) NULL,
  INV_NO varchar(250) NULL,
  ASSY_CODE varchar(50) NULL,
  ASSY_NO varchar(150) NULL,
  TOTAL_SET float NULL,
  SATUAN varchar(5) NULL,
  JUMLAH_COLI float NULL,
  GROSSWEIGHT float NULL,
  SATUANGROSS varchar(5) NULL,
  NETWEIGHT float NULL,
  SATUANNET varchar(5) NULL,
  PRICE float NULL,
  AMOUNT float NULL,
  KD_VAL varchar(50) NULL,
  TGL_INV varchar(15) NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  HS_KODE varchar(50) NULL,
  SERI_BRG int NULL,
  SATUAN_COLI varchar(50) NULL,
  CONSTRAINT PK_tbl_sa PRIMARY KEY CLUSTERED (id_sa) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_sa_20161008_0001
  ON dbo.tbl_sa (id_sa_hdr)
  INCLUDE (id_sa, SA_NO, NPWP_PEMBELI, NAMA_PEMBELI, ALAMAT, GROSSWEIGHT, SATUANGROSS, PRICE, AMOUNT, create_date, create_by, ASSY_NO, TOTAL_SET, update_date, update_by, SATUAN, JUMLAH_COLI, NETWEIGHT, SATUANNET, INV_NO, ASSY_CODE)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_sa_20161008_0002
  ON dbo.tbl_sa (id_sa_hdr)
  INCLUDE (SA_NO, INV_NO)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_sa_20161008_0003
  ON dbo.tbl_sa (id_sa_hdr)
  INCLUDE (INV_NO)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_sa_20161008_0004
  ON dbo.tbl_sa (id_sa_hdr)
  INCLUDE (ASSY_CODE, ASSY_NO, TOTAL_SET, SATUAN, JUMLAH_COLI)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_sa