dbo.tbl_bc_in

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 (~)	56234
Created	1/28/2020 15:14:01
Last Modified	1/28/2020 15:14:19

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	id_bc_in_hdr	bigint	8	19	0	True	1 - 1		False	False
	CAR	varchar	26	0	0	True		('-')	False	False
	KdKpbc	varchar	6	0	0	False			False	False
	Tujuan	varchar	1	0	0	False			False	False
	JnsBarang	varchar	2	0	0	False			False	False
	TujuanKirim	varchar	2	0	0	False			False	False
	PasokNama	varchar	50	0	0	False			False	False
	PasokAlmt	varchar	70	0	0	False			False	False
	PasokNeg	varchar	2	0	0	False			False	False
	UsahaId	varchar	1	0	0	False			False	False
	UsahaNpwp	varchar	15	0	0	False			False	False
	KdTPB	varchar	1	0	0	False			False	False
	Registrasi	varchar	20	0	0	False			False	False
	UsahaNama	varchar	50	0	0	False			False	False
	UsahaAlmt	varchar	70	0	0	False			False	False
	UsahaStatus	varchar	2	0	0	False			False	False
	ApiKd	varchar	1	0	0	False			False	False
	ApiNo	varchar	15	0	0	False			False	False
	PpjkId	varchar	1	0	0	False			False	False
	PpjkNpwp	varchar	15	0	0	False			False	False
	PpjkNama	varchar	50	0	0	False			False	False
	PpjkAlmt	varchar	70	0	0	False			False	False
	PpjkNo	varchar	6	0	0	False			False	False
	PpjkTg	datetime	8	23	3	False			False	False
	IndId	varchar	1	0	0	False			False	False
	IndNpwp	varchar	15	0	0	False			False	False
	IndNama	varchar	50	0	0	False			False	False
	IndAlmt	varchar	70	0	0	False			False	False
	Moda	varchar	1	0	0	False			False	False
	AngkutNama	varchar	20	0	0	False			False	False
	AngkutNo	varchar	17	0	0	False			False	False
	AngkutFl	varchar	2	0	0	False			False	False
	PelBkr	varchar	5	0	0	False			False	False
	PelMuat	varchar	5	0	0	False			False	False
	PelTransit	varchar	5	0	0	False			False	False
	BC23No	varchar	20	0	0	False			False	False
2	BC23Tg	datetime	8	23	3	False			False	False
	KdKpbcBongkar	varchar	6	0	0	False			False	False
	KdKpbcAwas	varchar	6	0	0	False			False	False
	DokTupKd	varchar	1	0	0	False			False	False
	DokTupNo	varchar	6	0	0	False			False	False
	DokTupTg	datetime	8	23	3	False			False	False
	PosNo	varchar	4	0	0	False			False	False
	PosSub	varchar	4	0	0	False			False	False
	TmpTbn	varchar	4	0	0	False			False	False
	KdVal	varchar	3	0	0	False			False	False
	Ndpbm	float	8	53	0	False			False	False
	NilInv	float	8	53	0	False			False	False
	Freight	float	8	53	0	False			False	False
	BTambahan	float	8	53	0	False			False	False
	Diskon	float	8	53	0	False			False	False
	KdAss	varchar	1	0	0	False			False	False
	Asuransi	float	8	53	0	False			False	False
	KdHrg	varchar	1	0	0	False			False	False
	Fob	float	8	53	0	False			False	False
	Cif	float	8	53	0	False			False	False
	Bruto	float	8	53	0	False			False	False
	Netto	float	8	53	0	False			False	False
	JmCont	int	4	10	0	False			False	False
	JmBrg	int	4	10	0	False			False	False
	TglTtd	datetime	8	23	3	False			False	False
	KotaTtd	varchar	30	0	0	False			False	False
	Namattd	varchar	30	0	0	False			False	False
	ContakPerson	varchar	30	0	0	False			False	False
	NoPhone	varchar	25	0	0	False			False	False
	NoFax	varchar	25	0	0	False			False	False
	Email	varchar	50	0	0	False			False	False
	Status	varchar	2	0	0	False			False	False
	Snrf	varchar	10	0	0	False			False	False
	Lengkap	char	1	0	0	False			False	False
	PosSubSub	varchar	4	0	0	False			False	False
	NoKontrak	varchar	30	0	0	False			False	False
	TgKontrak	datetime	8	23	3	False			False	False
	HargaRp	float	8	53	0	False			False	False
	TmpPeriksaFisik	varchar	1	0	0	False			False	False
	AlmtPeriksaFisik	varchar	70	0	0	False			False	False
	TgPeriksaFisik	datetime	8	23	3	False			False	False
	WkPeriksaFisik	varchar	4	0	0	False			False	False
	create_date	datetime	8	23	3	False			False	False
	create_by	varchar	50	0	0	False			False	False
	update_date	datetime	8	23	3	False			False	False
	update_by	varchar	50	0	0	False			False	False
6	typedok	varchar	5	0	0	False			False	False
3	statusdok	varchar	50	0	0	False		(0)	False	False
	noinv	varchar	50	0	0	False			False	False
	tginv	datetime	8	23	3	False			False	False
	inv_hdr_id	bigint	8	19	0	False			False	False
	bc_in_from_in	varchar	30	0	0	False			False	False
	nopol	varchar	20	0	0	False			False	False
2	nobl	varchar	50	0	0	False			False	False
2	tglbl	date	3	10	0	False			False	False
	tgaju	date	3	10	0	False			False	False
	tujuan_pengiriman	int	4	10	0	False			False	False
	tujuan_pemasukan	int	4	10	0	False			False	False
	no_faktur	varchar	50	0	0	False			False	False
	tgl_faktur	date	3	10	0	False			False	False
	harga_penyerahan	float	8	53	0	False			False	False

Indexes

Name	Columns	Unique
index_ImpId	UsahaId	False
index_INDID	IndId	False
index_PpjkId	PpjkId	False
index_SNRF	KdKpbcBongkar, Snrf	False
ix_auto_tbl_bc_in_hdr_20161008_0001	typedok	False
ix_auto_tbl_bc_in_hdr_20161008_0002	CAR	False
ix_auto_tbl_bc_in_hdr_20161008_0003	statusdok	False
ix_auto_tbl_bc_in_hdr_20161008_0004	typedok	False
ix_auto_tbl_bc_in_hdr_20161008_0005	statusdok	False
ix_auto_tbl_bc_in_hdr_20161008_0006	typedok	False
ix_auto_tbl_bc_in_hdr_20161019_0001	nobl, tglbl	False
ix_auto_tbl_bc_in_hdr_20161019_0002	typedok, BC23Tg	False
ix_auto_tbl_bc_in_hdr_20161019_0003	typedok, statusdok, nobl, tglbl	False
ix_auto_tbl_bc_in_hdr_20161019_0004	BC23Tg, typedok	False
ix_auto_tbl_bc_in_hdr_20161019_0005	JnsBarang	False
tbl_bc_in_hdr_pk	id_bc_in_hdr	True

SQL Script

CREATE TABLE dbo.tbl_bc_in_hdr (
  id_bc_in_hdr bigint IDENTITY,
  CAR varchar(26) NOT NULL CONSTRAINT DF_tbl_bc_in_hdr_CAR DEFAULT ('-'),
  KdKpbc varchar(6) NULL,
  Tujuan varchar(1) NULL,
  JnsBarang varchar(2) NULL,
  TujuanKirim varchar(2) NULL,
  PasokNama varchar(50) NULL,
  PasokAlmt varchar(70) NULL,
  PasokNeg varchar(2) NULL,
  UsahaId varchar(1) NULL,
  UsahaNpwp varchar(15) NULL,
  KdTPB varchar(1) NULL,
  Registrasi varchar(20) NULL,
  UsahaNama varchar(50) NULL,
  UsahaAlmt varchar(70) NULL,
  UsahaStatus varchar(2) NULL,
  ApiKd varchar(1) NULL,
  ApiNo varchar(15) NULL,
  PpjkId varchar(1) NULL,
  PpjkNpwp varchar(15) NULL,
  PpjkNama varchar(50) NULL,
  PpjkAlmt varchar(70) NULL,
  PpjkNo varchar(6) NULL,
  PpjkTg datetime NULL,
  IndId varchar(1) NULL,
  IndNpwp varchar(15) NULL,
  IndNama varchar(50) NULL,
  IndAlmt varchar(70) NULL,
  Moda varchar(1) NULL,
  AngkutNama varchar(20) NULL,
  AngkutNo varchar(17) NULL,
  AngkutFl varchar(2) NULL,
  PelBkr varchar(5) NULL,
  PelMuat varchar(5) NULL,
  PelTransit varchar(5) NULL,
  BC23No varchar(20) NULL,
  BC23Tg datetime NULL,
  KdKpbcBongkar varchar(6) NULL,
  KdKpbcAwas varchar(6) NULL,
  DokTupKd varchar(1) NULL,
  DokTupNo varchar(6) NULL,
  DokTupTg datetime NULL,
  PosNo varchar(4) NULL,
  PosSub varchar(4) NULL,
  TmpTbn varchar(4) NULL,
  KdVal varchar(3) NULL,
  Ndpbm float NULL,
  NilInv float NULL,
  Freight float NULL,
  BTambahan float NULL,
  Diskon float NULL,
  KdAss varchar(1) NULL,
  Asuransi float NULL,
  KdHrg varchar(1) NULL,
  Fob float NULL,
  Cif float NULL,
  Bruto float NULL,
  Netto float NULL,
  JmCont int NULL,
  JmBrg int NULL,
  TglTtd datetime NULL,
  KotaTtd varchar(30) NULL,
  Namattd varchar(30) NULL,
  ContakPerson varchar(30) NULL,
  NoPhone varchar(25) NULL,
  NoFax varchar(25) NULL,
  Email varchar(50) NULL,
  Status varchar(2) NULL,
  Snrf varchar(10) NULL,
  Lengkap char(1) NULL,
  PosSubSub varchar(4) NULL,
  NoKontrak varchar(30) NULL,
  TgKontrak datetime NULL,
  HargaRp float NULL,
  TmpPeriksaFisik varchar(1) NULL,
  AlmtPeriksaFisik varchar(70) NULL,
  TgPeriksaFisik datetime NULL,
  WkPeriksaFisik varchar(4) NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  typedok varchar(5) NULL,
  statusdok varchar(50) NULL CONSTRAINT DF__tbl_bc_in__statu__14B10FFA DEFAULT (0),
  noinv varchar(50) NULL,
  tginv datetime NULL,
  inv_hdr_id bigint NULL,
  bc_in_from_in varchar(30) NULL,
  nopol varchar(20) NULL,
  nobl varchar(50) NULL,
  tglbl date NULL,
  tgaju date NULL,
  tujuan_pengiriman int NULL,
  tujuan_pemasukan int NULL,
  no_faktur varchar(50) NULL,
  tgl_faktur date NULL,
  harga_penyerahan float NULL,
  CONSTRAINT tbl_bc_in_hdr_pk PRIMARY KEY CLUSTERED (id_bc_in_hdr) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX index_ImpId
  ON dbo.tbl_bc_in_hdr (UsahaId)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX index_INDID
  ON dbo.tbl_bc_in_hdr (IndId)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX index_PpjkId
  ON dbo.tbl_bc_in_hdr (PpjkId)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX index_SNRF
  ON dbo.tbl_bc_in_hdr (KdKpbcBongkar, Snrf)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_hdr_20161008_0001
  ON dbo.tbl_bc_in_hdr (typedok)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_hdr_20161008_0002
  ON dbo.tbl_bc_in_hdr (CAR)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_hdr_20161008_0003
  ON dbo.tbl_bc_in_hdr (statusdok)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_hdr_20161008_0004
  ON dbo.tbl_bc_in_hdr (typedok)
  INCLUDE (nobl)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_hdr_20161008_0005
  ON dbo.tbl_bc_in_hdr (statusdok)
  INCLUDE (id_bc_in_hdr, CAR, KdKpbc, Tujuan, JnsBarang, noinv, tginv, inv_hdr_id, nobl, tglbl, WkPeriksaFisik, create_date, create_by, update_date, update_by, typedok, NoKontrak, TgKontrak, HargaRp, TmpPeriksaFisik, AlmtPeriksaFisik, TgPeriksaFisik, NoFax, Email, Status, Snrf, Lengkap, PosSubSub, JmBrg, TglTtd, KotaTtd, Namattd, ContakPerson, NoPhone, KdHrg, Fob, Cif, Bruto, Netto, JmCont, NilInv, Freight, BTambahan, Diskon, KdAss, Asuransi, DokTupTg, PosNo, PosSub, TmpTbn, KdVal, Ndpbm, BC23No, BC23Tg, KdKpbcBongkar, KdKpbcAwas, DokTupKd, DokTupNo, AngkutNama, AngkutNo, AngkutFl, PelBkr, PelMuat, PelTransit, PpjkTg, IndId, IndNpwp, IndNama, IndAlmt, Moda, ApiNo, PpjkId, PpjkNpwp, PpjkNama, PpjkAlmt, PpjkNo, KdTPB, Registrasi, UsahaNama, UsahaAlmt, UsahaStatus, ApiKd, TujuanKirim, PasokNama, PasokAlmt, PasokNeg, UsahaId, UsahaNpwp)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_hdr_20161008_0006
  ON dbo.tbl_bc_in_hdr (typedok)
  INCLUDE (id_bc_in_hdr, CAR, KdKpbc, Tujuan, JnsBarang, tgaju, noinv, tginv, inv_hdr_id, bc_in_from_in, nobl, tglbl, WkPeriksaFisik, create_date, create_by, update_date, update_by, statusdok, NoKontrak, TgKontrak, HargaRp, TmpPeriksaFisik, AlmtPeriksaFisik, TgPeriksaFisik, NoFax, Email, Status, Snrf, Lengkap, PosSubSub, JmBrg, TglTtd, KotaTtd, Namattd, ContakPerson, NoPhone, KdHrg, Fob, Cif, Bruto, Netto, JmCont, NilInv, Freight, BTambahan, Diskon, KdAss, Asuransi, DokTupTg, PosNo, PosSub, TmpTbn, KdVal, Ndpbm, BC23No, BC23Tg, KdKpbcBongkar, KdKpbcAwas, DokTupKd, DokTupNo, AngkutNama, AngkutNo, AngkutFl, PelBkr, PelMuat, PelTransit, PpjkTg, IndId, IndNpwp, IndNama, IndAlmt, Moda, ApiNo, PpjkId, PpjkNpwp, PpjkNama, PpjkAlmt, PpjkNo, KdTPB, Registrasi, UsahaNama, UsahaAlmt, UsahaStatus, ApiKd, TujuanKirim, PasokNama, PasokAlmt, PasokNeg, UsahaId, UsahaNpwp)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_hdr_20161019_0001
  ON dbo.tbl_bc_in_hdr (nobl, tglbl)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_hdr_20161019_0002
  ON dbo.tbl_bc_in_hdr (typedok, BC23Tg)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_hdr_20161019_0003
  ON dbo.tbl_bc_in_hdr (typedok, statusdok, nobl, tglbl)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_hdr_20161019_0004
  ON dbo.tbl_bc_in_hdr (BC23Tg, typedok)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_in_hdr_20161019_0005
  ON dbo.tbl_bc_in_hdr (JnsBarang)
  INCLUDE (id_bc_in_hdr, CAR, PasokNama, PasokAlmt, PasokNeg)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_bc_in_hdr