dbo.tbl_nonhib

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 (~)	5145
Created	1/13/2013 14:14:39
Last Modified	11/18/2016 23:30:53

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_nonhib_hdr	bigint	8	19	0	True	1 - 1	False	False
from_file_name	varchar	500	0	0	False		False	False
totalitemfile	int	4	10	0	False		False	False
exec_date	datetime	8	23	3	False		False	False
status	varchar	50	0	0	False		False	False
itemcount	int	4	10	0	False		False	False
noinv	varchar	50	0	0	False		False	False
tglinv	date	3	10	0	False		False	False
tglinv2	varchar	50	0	0	False		False	False
nobl	varchar	50	0	0	False		False	False
tgbl	date	3	10	0	False		False	False
vendor	varchar	50	0	0	False		False	False
nocar	varchar	50	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_nonhib	id_nonhib_hdr	True

SQL Script

CREATE TABLE dbo.tbl_nonhib (
  id_nonhib_hdr bigint IDENTITY,
  from_file_name varchar(500) NULL,
  totalitemfile int NULL,
  exec_date datetime NULL,
  status varchar(50) NULL,
  itemcount int NULL,
  noinv varchar(50) NULL,
  tglinv date NULL,
  tglinv2 varchar(50) NULL,
  nobl varchar(50) NULL,
  tgbl date NULL,
  vendor varchar(50) NULL,
  nocar varchar(50) NULL,
  CONSTRAINT PK_tbl_nonhib PRIMARY KEY CLUSTERED (id_nonhib_hdr) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found