dbo.tblPebHdr

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 (~)	36503
Created	2/19/2013 14:16:59
Last Modified	3/7/2017 14:22:15

Columns

Key	Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
	idpebhdr	bigint	8	19	True	1 - 1	False	False
	CAR	varchar	200	0	False		False	False
	JnEks	varchar	1	0	False		False	False
	KatEks	varchar	2	0	False		False	False
	JNPEB	varchar	1	0	False		False	False
	JNEKSOld	varchar	1	0	False		False	False
	JNLAIN	varchar	1	0	False		False	False
	JNDAG	varchar	1	0	False		False	False
	JNBYR	varchar	1	0	False		False	False
	IDEKS	varchar	1	0	False		False	False
	NPWPEKS	varchar	15	0	False		False	False
	NamaEks	varchar	50	0	False		False	False
	AlmtEks	varchar	70	0	False		False	False
	NoSiup	varchar	30	0	False		False	False
	TgSiup	date	3	10	False		False	False
	JnPerus	varchar	1	0	False		False	False
	NoTdp	varchar	30	0	False		False	False
	TgTdp	date	3	10	False		False	False
	Niper	varchar	4	0	False		False	False
	StatusH	varchar	2	0	False		False	False
	IdQq	varchar	1	0	False		False	False
	NpwpQq	varchar	15	0	False		False	False
	NamaQq	varchar	50	0	False		False	False
	AlmtQq	varchar	70	0	False		False	False
	NiperQq	varchar	4	0	False		False	False
	NAMABELI	varchar	50	0	False		False	False
	ALMTBELI	varchar	70	0	False		False	False
	NEGBELI	varchar	2	0	False		False	False
	IDPPJK	varchar	1	0	False		False	False
	NPWPPPJK	varchar	15	0	False		False	False
	NamaPpjk	varchar	50	0	False		False	False
	AlmtPpjk	varchar	70	0	False		False	False
	NoPpjk	varchar	30	0	False		False	False
	TgPpjk	date	3	10	False		False	False
	MODA	varchar	1	0	False		False	False
	TGEKS	date	3	10	False		False	False
	CARRIER	varchar	20	0	False		False	False
	VOY	varchar	7	0	False		False	False
	NOSHIPORD	varchar	25	0	False		False	False
	TGSHIPORD	date	3	10	False		False	False
	PELMUAT	varchar	5	0	False		False	False
	PELBONGKAR	varchar	5	0	False		False	False
	PELTRANSIT	varchar	5	0	False		False	False
	NOINV	varchar	25	0	False		False	False
	TGINV	date	3	10	False		False	False
	NOLPSE	varchar	10	0	False		False	False
	TGLPSE	date	3	10	False		False	False
	PROPBRG	varchar	4	0	False		False	False
	NEGTUJU	nvarchar	2	0	False		False	False
	FLSIE	char	1	0	False		False	False
	FLKARANT	char	1	0	False		False	False
	FLSM	char	1	0	False		False	False
	FLIZLAIN	char	1	0	False		False	False
	DELIVERY	varchar	3	0	False		False	False
	KDVAL	varchar	3	0	False		False	False
	KdHrg	varchar	1	0	False		False	False
	NilInv	float	8	53	False		False	False
	FREIGHT	float	8	53	False		False	False
	ASURANSI	float	8	53	False		False	False
	KdAss	varchar	1	0	False		False	False
	FOB	float	8	53	False		False	False
	MERK	varchar	100	0	False		False	False
	JMCONT	float	8	53	False		False	False
	BRUTO	float	8	53	False		False	False
	NETTO	float	8	53	False		False	False
	JMBRG	float	8	53	False		False	False
	JMBRGCTH	float	8	53	False		False	False
	JMBRGGAB	float	8	53	False		False	False
	JMBRGPJT	float	8	53	False		False	False
	NODAFT	varchar	6	0	False		False	False
	TGDAFT	date	3	10	False		False	False
	KDKTR	varchar	6	0	False		False	False
	KTRGATE	varchar	6	0	False		False	False
	NILPE	float	8	53	False		False	False
	KDBANK	varchar	3	0	False		False	False
	LOKBANK	varchar	4	0	False		False	False
	NOSSP	varchar	6	0	False		False	False
	TGSSP	date	3	10	False		False	False
	JNTPB	varchar	3	0	False		False	False
	LOKTPB	varchar	10	0	False		False	False
	KDLOKBRG	varchar	1	0	False		False	False
	KDKTRMUAT	varchar	6	0	False		False	False
	KDKTRPRIKS	varchar	6	0	False		False	False
	TGSIAP	date	3	10	False		False	False
	WKSIAP	varchar	6	0	False		False	False
	ASALDATA	varchar	1	0	False		False	False
	TPNAME	varchar	20	0	False		False	False
	PEBOK	char	1	0	False		False	False
	LENGKAP	char	1	0	False		False	False
	JNPARTOF	varchar	1	0	False		False	False
	BENDERA	varchar	2	0	False		False	False
	TTDPEB	varchar	30	0	False		False	False
	STATUS	varchar	2	0	False		False	False
	SNRF	varchar	10	0	False		False	False
	NOBCF	nvarchar	30	0	False		False	False
	TGBCF	date	3	10	False		False	False
	SERIBCF	float	8	53	False		False	False
	NOMOREDI	varchar	20	0	False		False	False
	KMDT	varchar	1	0	False		False	False
	VOLUME	float	8	53	False		False	False
	KDHANGGAR	varchar	9	0	False		False	False
	KONS	varchar	1	0	False		False	False
	JMLKMSPEB	float	8	53	False		False	False
	PELMUATEKS	varchar	5	0	False		False	False
	NILKURS	float	8	53	False		False	False
	PNBP	float	8	53	False		False	False
	NOBC11	varchar	6	0	False		False	False
	TGBC11	date	3	10	False		False	False
	POSBC11	varchar	4	0	False		False	False
	SUBPOSBC11	varchar	2	0	False		False	False
	jnkemas	varchar	50	0	False		False	False
2	gabinvoice	varchar	100	0	False		False	False
	filename	varchar	500	0	False		False	False
	laodeddate	date	3	10	False		False	False
	noprosesdata	varchar	50	0	False		False	False
	NAMABELI2	varchar	50	0	False		False	False
	ALMTBELI2	varchar	70	0	False		False	False
	NEGBELI2	varchar	2	0	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tblPebHdr_20161008_0001	NOINV, TGINV, gabinvoice	False
ix_auto_tblPebHdr_20161008_0002	gabinvoice	False
ix_auto_tblPebHdr_20161019_0001	STATUS	False
ix_auto_tblPebHdr_20161019_0002	noprosesdata	False
PK_tblPebHdr	idpebhdr	True

SQL Script

CREATE TABLE dbo.tblPebHdr (
  idpebhdr bigint IDENTITY,
  CAR varchar(200) NULL,
  JnEks varchar(1) NULL,
  KatEks varchar(2) NULL,
  JNPEB varchar(1) NULL,
  JNEKSOld varchar(1) NULL,
  JNLAIN varchar(1) NULL,
  JNDAG varchar(1) NULL,
  JNBYR varchar(1) NULL,
  IDEKS varchar(1) NULL,
  NPWPEKS varchar(15) NULL,
  NamaEks varchar(50) NULL,
  AlmtEks varchar(70) NULL,
  NoSiup varchar(30) NULL,
  TgSiup date NULL,
  JnPerus varchar(1) NULL,
  NoTdp varchar(30) NULL,
  TgTdp date NULL,
  Niper varchar(4) NULL,
  StatusH varchar(2) NULL,
  IdQq varchar(1) NULL,
  NpwpQq varchar(15) NULL,
  NamaQq varchar(50) NULL,
  AlmtQq varchar(70) NULL,
  NiperQq varchar(4) NULL,
  NAMABELI varchar(50) NULL,
  ALMTBELI varchar(70) NULL,
  NEGBELI varchar(2) NULL,
  IDPPJK varchar(1) NULL,
  NPWPPPJK varchar(15) NULL,
  NamaPpjk varchar(50) NULL,
  AlmtPpjk varchar(70) NULL,
  NoPpjk varchar(30) NULL,
  TgPpjk date NULL,
  MODA varchar(1) NULL,
  TGEKS date NULL,
  CARRIER varchar(20) NULL,
  VOY varchar(7) NULL,
  NOSHIPORD varchar(25) NULL,
  TGSHIPORD date NULL,
  PELMUAT varchar(5) NULL,
  PELBONGKAR varchar(5) NULL,
  PELTRANSIT varchar(5) NULL,
  NOINV varchar(25) NULL,
  TGINV date NULL,
  NOLPSE varchar(10) NULL,
  TGLPSE date NULL,
  PROPBRG varchar(4) NULL,
  NEGTUJU nvarchar(2) NULL,
  FLSIE char(1) NULL,
  FLKARANT char(1) NULL,
  FLSM char(1) NULL,
  FLIZLAIN char(1) NULL,
  DELIVERY varchar(3) NULL,
  KDVAL varchar(3) NULL,
  KdHrg varchar(1) NULL,
  NilInv float NULL,
  FREIGHT float NULL,
  ASURANSI float NULL,
  KdAss varchar(1) NULL,
  FOB float NULL,
  MERK varchar(100) NULL,
  JMCONT float NULL,
  BRUTO float NULL,
  NETTO float NULL,
  JMBRG float NULL,
  JMBRGCTH float NULL,
  JMBRGGAB float NULL,
  JMBRGPJT float NULL,
  NODAFT varchar(6) NULL,
  TGDAFT date NULL,
  KDKTR varchar(6) NULL,
  KTRGATE varchar(6) NULL,
  NILPE float NULL,
  KDBANK varchar(3) NULL,
  LOKBANK varchar(4) NULL,
  NOSSP varchar(6) NULL,
  TGSSP date NULL,
  JNTPB varchar(3) NULL,
  LOKTPB varchar(10) NULL,
  KDLOKBRG varchar(1) NULL,
  KDKTRMUAT varchar(6) NULL,
  KDKTRPRIKS varchar(6) NULL,
  TGSIAP date NULL,
  WKSIAP varchar(6) NULL,
  ASALDATA varchar(1) NULL,
  TPNAME varchar(20) NULL,
  PEBOK char(1) NULL,
  LENGKAP char(1) NULL,
  JNPARTOF varchar(1) NULL,
  BENDERA varchar(2) NULL,
  TTDPEB varchar(30) NULL,
  STATUS varchar(2) NULL,
  SNRF varchar(10) NULL,
  NOBCF nvarchar(30) NULL,
  TGBCF date NULL,
  SERIBCF float NULL,
  NOMOREDI varchar(20) NULL,
  KMDT varchar(1) NULL,
  VOLUME float NULL,
  KDHANGGAR varchar(9) NULL,
  KONS varchar(1) NULL,
  JMLKMSPEB float NULL,
  PELMUATEKS varchar(5) NULL,
  NILKURS float NULL,
  PNBP float NULL,
  NOBC11 varchar(6) NULL,
  TGBC11 date NULL,
  POSBC11 varchar(4) NULL,
  SUBPOSBC11 varchar(2) NULL,
  jnkemas varchar(50) NULL,
  gabinvoice varchar(100) NULL,
  filename varchar(500) NULL,
  laodeddate date NULL,
  noprosesdata varchar(50) NULL,
  NAMABELI2 varchar(50) NULL,
  ALMTBELI2 varchar(70) NULL,
  NEGBELI2 varchar(2) NULL,
  CONSTRAINT PK_tblPebHdr PRIMARY KEY CLUSTERED (idpebhdr) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tblPebHdr_20161008_0001
  ON dbo.tblPebHdr (NOINV, TGINV, gabinvoice)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tblPebHdr_20161008_0002
  ON dbo.tblPebHdr (gabinvoice)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tblPebHdr_20161019_0001
  ON dbo.tblPebHdr (STATUS)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tblPebHdr_20161019_0002
  ON dbo.tblPebHdr (noprosesdata)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found