dbo.tbl_invoice

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 (~)	39671
Created	3/20/2020 15:42:18
Last Modified	3/20/2020 15:42:24

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	id_invoice_bc40	bigint	8	19	0	True	1 - 1	False	False
	part_name	varchar	90	0	0	False		False	False
	part_no	varchar	50	0	0	False		False	False
	kode_barang	varchar	50	0	0	False		False	False
	kode_supplier	varchar	50	0	0	False		False	False
	maker	varchar	50	0	0	False		False	False
	order_qty	float	8	53	0	False		False	False
	order_no	varchar	50	0	0	False		False	False
	order_date	date	3	10	0	False		False	False
	req_eta_date	date	3	10	0	False		False	False
	shipping_by	varchar	50	0	0	False		False	False
	invoice_no	varchar	50	0	0	False		False	False
	invoice_date	date	3	10	0	False		False	False
	inv_qty	float	8	53	0	False		False	False
	inv_unit	varchar	50	0	0	False		False	False
	rec_date	date	3	10	0	False		False	False
	rec_qty	float	8	53	0	False		False	False
	status_inv	varchar	50	0	0	False		False	False
	amount	float	8	53	0	False		False	False
	price	float	8	53	0	False		False	False
	remark	varchar	100	0	0	False		False	False
2	nobl	varchar	50	0	0	False		False	False
2	tglbl	date	3	10	0	False		False	False
	nocar	varchar	50	0	0	False		False	False
	tglaju	date	3	10	0	False		False	False
3	status_data	varchar	50	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
	netto	float	8	53	0	False		False	False
	bruto	float	8	53	0	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_invoice_bc40_20161008_0001	nobl, tglbl, status_data	False
ix_auto_tbl_invoice_bc40_20161008_0002	status_data	False
ix_auto_tbl_invoice_bc40_20161008_0003	status_data	False
ix_auto_tbl_invoice_bc40_20161008_0004	part_no, invoice_no, invoice_date, nobl, tglbl	False
PK_tbl_invoice_bc40	id_invoice_bc40	True

SQL Script

CREATE TABLE dbo.tbl_invoice_bc40 (
  id_invoice_bc40 bigint IDENTITY,
  part_name varchar(90) NULL,
  part_no varchar(50) NULL,
  kode_barang varchar(50) NULL,
  kode_supplier varchar(50) NULL,
  maker varchar(50) NULL,
  order_qty float NULL,
  order_no varchar(50) NULL,
  order_date date NULL,
  req_eta_date date NULL,
  shipping_by varchar(50) NULL,
  invoice_no varchar(50) NULL,
  invoice_date date NULL,
  inv_qty float NULL,
  inv_unit varchar(50) NULL,
  rec_date date NULL,
  rec_qty float NULL,
  status_inv varchar(50) NULL,
  amount float NULL,
  price float NULL,
  remark varchar(100) NULL,
  nobl varchar(50) NULL,
  tglbl date NULL,
  nocar varchar(50) NULL,
  tglaju date NULL,
  status_data varchar(50) NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  netto float NULL,
  bruto float NULL,
  CONSTRAINT PK_tbl_invoice_bc40 PRIMARY KEY CLUSTERED (id_invoice_bc40) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_invoice_bc40_20161008_0001
  ON dbo.tbl_invoice_bc40 (nobl, tglbl, status_data)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_invoice_bc40_20161008_0002
  ON dbo.tbl_invoice_bc40 (status_data)
  INCLUDE (kode_supplier, order_no, order_date, invoice_no, invoice_date)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_invoice_bc40_20161008_0003
  ON dbo.tbl_invoice_bc40 (status_data)
  INCLUDE (kode_supplier, order_no, order_date, invoice_no, invoice_date, nobl, tglbl)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_invoice_bc40_20161008_0004
  ON dbo.tbl_invoice_bc40 (part_no, invoice_no, invoice_date, nobl, tglbl)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_invoice_bc40