dbo.all_item_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	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	21613
Created	1/2/2017 07:01:19
Last Modified	1/2/2017 07:02:12

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
KODE_BARANG	nvarchar	255	0	0	False	False	False
NAMA_BARANG	nvarchar	255	0	0	False	False	False
NO_DOK_IN	nvarchar	255	0	0	False	False	False
DATE_IN	datetime	8	23	3	False	False	False
QTY	float	8	53	0	False	False	False
UNIT	nvarchar	255	0	0	False	False	False
NO_INV	nvarchar	255	0	0	False	False	False
TGL_INV	datetime	8	23	3	False	False	False
query	nvarchar	255	0	0	False	False	False

SQL Script

CREATE TABLE dbo.all_item_invoice_mesin (
  KODE_BARANG nvarchar(255) NULL,
  NAMA_BARANG nvarchar(255) NULL,
  NO_DOK_IN nvarchar(255) NULL,
  DATE_IN datetime NULL,
  QTY float NULL,
  UNIT nvarchar(255) NULL,
  NO_INV nvarchar(255) NULL,
  TGL_INV datetime NULL,
  query nvarchar(255) NULL
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found