dbo.tblPebDtl

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 (~)	242865
Created	2/23/2013 07:32:34
Last Modified	11/18/2016 22:54:03

Columns

Key	Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
	idpebdtl	bigint	8	19	True	1 - 1	False	False
2	idpebhdr	bigint	8	19	False		False	False
	CAR	varchar	200	0	False		False	False
	SERIBRG	float	8	53	False		False	False
	HS	varchar	12	0	False		False	False
	URBRG1	varchar	40	0	False		False	False
	URBRG2	varchar	40	0	False		False	False
	URBRG3	varchar	40	0	False		False	False
	URBRG4	varchar	40	0	False		False	False
	DMERK	varchar	15	0	False		False	False
	SIZE	varchar	15	0	False		False	False
	TYPE	varchar	15	0	False		False	False
	KDBRG	varchar	15	0	False		False	False
	KDIZIN	varchar	3	0	False		False	False
	NOIZIN	varchar	30	0	False		False	False
	TGIZIN	date	3	10	False		False	False
	JMKOLI	float	8	53	False		False	False
	JNKOLI	varchar	2	0	False		False	False
	DNilInv	float	8	53	False		False	False
	FOBPERBRG	float	8	53	False		False	False
	FOBPERSAT	float	8	53	False		False	False
	KDPE	varchar	1	0	False		False	False
	TARIPPE	float	8	53	False		False	False
	HPATOK	float	8	53	False		False	False
	JMSATUAN	float	8	53	False		False	False
	JNSATUAN	varchar	3	0	False		False	False
	NETDET	float	8	53	False		False	False
	JMSATPE	float	8	53	False		False	False
	JNSATPE	varchar	3	0	False		False	False
	KDVALPE	varchar	3	0	False		False	False
	NILVALPE	float	8	53	False		False	False
	PEPERBRG	float	8	53	False		False	False
	DTLOK	char	1	0	False		False	False
	NCV	char	1	0	False		False	False
	DVolume	float	8	53	False		False	False
	NegAsal	varchar	2	0	False		False	False
	NOINV	varchar	50	0	False		False	False
	TGINV	date	3	10	False		False	False
	gabinvoice	varchar	100	0	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tblPebDtl_20161008_0001	idpebhdr	False
ix_auto_tblPebDtl_20161008_0002	idpebhdr	False
ix_auto_tblPebDtl_20161019_0001	NOINV, gabinvoice	False
PK_tblPebDtl	idpebdtl	True

SQL Script

CREATE TABLE dbo.tblPebDtl (
  idpebdtl bigint IDENTITY,
  idpebhdr bigint NULL,
  CAR varchar(200) NULL,
  SERIBRG float NULL,
  HS varchar(12) NULL,
  URBRG1 varchar(40) NULL,
  URBRG2 varchar(40) NULL,
  URBRG3 varchar(40) NULL,
  URBRG4 varchar(40) NULL,
  DMERK varchar(15) NULL,
  SIZE varchar(15) NULL,
  TYPE varchar(15) NULL,
  KDBRG varchar(15) NULL,
  KDIZIN varchar(3) NULL,
  NOIZIN varchar(30) NULL,
  TGIZIN date NULL,
  JMKOLI float NULL,
  JNKOLI varchar(2) NULL,
  DNilInv float NULL,
  FOBPERBRG float NULL,
  FOBPERSAT float NULL,
  KDPE varchar(1) NULL,
  TARIPPE float NULL,
  HPATOK float NULL,
  JMSATUAN float NULL,
  JNSATUAN varchar(3) NULL,
  NETDET float NULL,
  JMSATPE float NULL,
  JNSATPE varchar(3) NULL,
  KDVALPE varchar(3) NULL,
  NILVALPE float NULL,
  PEPERBRG float NULL,
  DTLOK char(1) NULL,
  NCV char(1) NULL,
  DVolume float NULL,
  NegAsal varchar(2) NULL,
  NOINV varchar(50) NULL,
  TGINV date NULL,
  gabinvoice varchar(100) NULL,
  CONSTRAINT PK_tblPebDtl PRIMARY KEY CLUSTERED (idpebdtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tblPebDtl_20161008_0001
  ON dbo.tblPebDtl (idpebhdr)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tblPebDtl_20161008_0002
  ON dbo.tblPebDtl (idpebhdr)
  INCLUDE (HS, URBRG1, URBRG2, URBRG3, URBRG4, DMERK, SIZE, TYPE, KDBRG, JMKOLI, JNKOLI, DNilInv, FOBPERBRG, FOBPERSAT, JMSATUAN, JNSATUAN, NETDET, JMSATPE, JNSATPE, DVolume, NegAsal)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tblPebDtl_20161019_0001
  ON dbo.tblPebDtl (NOINV, gabinvoice)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found