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 (~)	48217
Created	1/13/2013 15:03:13
Last Modified	11/18/2016 23:31:51

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_nonhib_dtl	bigint	8	19	0	True	1 - 1	False	False
id_nonhib_hdr	bigint	8	19	0	False		False	False
INVOICE_NO	varchar	50	0	0	False		False	False
INVDATE	datetime	8	23	3	False		False	False
invdate2	varchar	20	0	0	False		False	False
ITEMNUMBER	varchar	50	0	0	False		False	False
ITEMNUMBER2	varchar	50	0	0	False		False	False
CONTNO	varchar	50	0	0	False		False	False
INVQTY	float	8	53	0	False		False	False
PACK	float	8	53	0	False		False	False
UOMPFX	varchar	50	0	0	False		False	False
CNO	varchar	50	0	0	False		False	False
ORDERNO	varchar	50	0	0	False		False	False
VENDOR	varchar	50	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_nonhib_dtl	id_nonhib_dtl	True

SQL Script

CREATE TABLE dbo.tbl_nonhib_dtl (
  id_nonhib_dtl bigint IDENTITY,
  id_nonhib_hdr bigint NULL,
  INVOICE_NO varchar(50) NULL,
  INVDATE datetime NULL,
  invdate2 varchar(20) NULL,
  ITEMNUMBER varchar(50) NULL,
  ITEMNUMBER2 varchar(50) NULL,
  CONTNO varchar(50) NULL,
  INVQTY float NULL,
  PACK float NULL,
  UOMPFX varchar(50) NULL,
  CNO varchar(50) NULL,
  ORDERNO varchar(50) NULL,
  VENDOR varchar(50) NULL,
  CONSTRAINT PK_tbl_nonhib_dtl PRIMARY KEY CLUSTERED (id_nonhib_dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_nonhib_dtl