dbo.tbl_invoice_mesinsparepart

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 (~)	464
Created	9/3/2013 08:24:30
Last Modified	9/11/2019 13:36:13

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_invoice_mesinsparepart	bigint	8	19	0	True	1 - 1	False	False
part_name	varchar	50	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
nobl	varchar	50	0	0	False		False	False
tglbl	date	3	10	0	False		False	False
nocar	varchar	50	0	0	False		False	False
tglaju	date	3	10	0	False		False	False
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

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_invoice_mesinsparepart	id_invoice_mesinsparepart	True

SQL Script

CREATE TABLE dbo.tbl_invoice_mesinsparepart_old (
  id_invoice_mesinsparepart bigint IDENTITY,
  part_name varchar(50) 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,
  CONSTRAINT PK_tbl_invoice_mesinsparepart PRIMARY KEY CLUSTERED (id_invoice_mesinsparepart) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found