dbo.tbl_inv

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 (~)	998034
Created	9/23/2013 12:22:21
Last Modified	12/7/2016 17:33:01

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
	inv_dtl	bigint	8	19	0	True	1 - 1	False	False
6	inv_hdr_id	bigint	8	19	0	True		False	False
	seqno	int	4	10	0	False		False	False
	r1	varchar	4	0	0	False		False	False
	r2	varchar	10	0	0	False		False	False
	r3	varchar	25	0	0	False		False	False
	r4	varchar	25	0	0	False		False	False
	r5	varchar	30	0	0	False		False	False
	r6	varchar	12	0	0	False		False	False
	r7	varchar	10	0	0	False		False	False
	r8	varchar	15	0	0	False		False	False
	r9	varchar	50	0	0	False		False	False
	r10	varchar	8	0	0	False		False	False
	r11	varchar	8	0	0	False		False	False
	r12	varchar	10	0	0	False		False	False
	r13	varchar	10	0	0	False		False	False
	r14	varchar	15	0	0	False		False	False
	car	varchar	30	0	0	False		False	False
	nobc	varchar	10	0	0	False		False	False
	tglbc	datetime	8	23	3	False		False	False
	noinv	varchar	50	0	0	False		False	False
	tglinv	varchar	20	0	0	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_inv_dtl_20161008_0001	inv_hdr_id, seqno	False
ix_auto_tbl_inv_dtl_20161008_0002	inv_hdr_id	False
ix_auto_tbl_inv_dtl_20161008_0003	inv_hdr_id	False
ix_auto_tbl_inv_dtl_20161008_0004	inv_hdr_id	False
ix_auto_tbl_inv_dtl_20161008_0005	inv_hdr_id	False
ix_auto_tbl_inv_dtl_20161008_0006	inv_hdr_id	False
PK_tbl_inv_dtl	inv_dtl	True

Foreign Keys

Name	Columns	Description
FK_tbl_inv_dtl_tbl_inv_hdr	inv_hdr_id

SQL Script

CREATE TABLE dbo.tbl_inv_dtl (
  inv_dtl bigint IDENTITY,
  inv_hdr_id bigint NOT NULL,
  seqno int NULL,
  r1 varchar(4) NULL,
  r2 varchar(10) NULL,
  r3 varchar(25) NULL,
  r4 varchar(25) NULL,
  r5 varchar(30) NULL,
  r6 varchar(12) NULL,
  r7 varchar(10) NULL,
  r8 varchar(15) NULL,
  r9 varchar(50) NULL,
  r10 varchar(8) NULL,
  r11 varchar(8) NULL,
  r12 varchar(10) NULL,
  r13 varchar(10) NULL,
  r14 varchar(15) NULL,
  car varchar(30) NULL,
  nobc varchar(10) NULL,
  tglbc datetime NULL,
  noinv varchar(50) NULL,
  tglinv varchar(20) NULL,
  CONSTRAINT PK_tbl_inv_dtl PRIMARY KEY CLUSTERED (inv_dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_dtl_20161008_0001
  ON dbo.tbl_inv_dtl (inv_hdr_id, seqno)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_dtl_20161008_0002
  ON dbo.tbl_inv_dtl (inv_hdr_id)
  INCLUDE (r3, r4)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_dtl_20161008_0003
  ON dbo.tbl_inv_dtl (inv_hdr_id)
  INCLUDE (inv_dtl, r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, r11, r12, r13, r14)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_dtl_20161008_0004
  ON dbo.tbl_inv_dtl (inv_hdr_id)
  INCLUDE (r3, r4, r6, r7, r8, r9, r13)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_dtl_20161008_0005
  ON dbo.tbl_inv_dtl (inv_hdr_id)
  INCLUDE (r3, r4, r7)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_inv_dtl_20161008_0006
  ON dbo.tbl_inv_dtl (inv_hdr_id)
  INCLUDE (inv_dtl, r3, r4, r6, r7, r8, r9, r13, car, nobc, tglbc)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

ALTER TABLE dbo.tbl_inv_dtl WITH NOCHECK
  ADD CONSTRAINT FK_tbl_inv_dtl_tbl_inv_hdr FOREIGN KEY (inv_hdr_id) REFERENCES dbo.tbl_inv_hdr (inv_hdr_id) NOT FOR REPLICATION
GO

ALTER TABLE dbo.tbl_inv_dtl
  NOCHECK CONSTRAINT FK_tbl_inv_dtl_tbl_inv_hdr
GO

Depends On

dbo.tbl_inv_hdr

dbo.tbl_inv_dtl