dbo.tbl_bc_out

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 (~)	29224
Created	4/21/2013 15:06:54
Last Modified	12/11/2019 13:39:47

Columns

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

SQL Script

CREATE TABLE dbo.tbl_bc_out_hdr (
  id_bc_out_hdr bigint IDENTITY,
  CAR varchar(26) 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(10) 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 datetime NULL,
  PROPBRG varchar(4) NULL,
  NEGTUJU varchar(10) 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(20) NULL,
  TGDAFT datetime 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 datetime 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 varchar(30) NULL,
  TGBCF datetime 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,
  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_out_hdr_statusdok DEFAULT (0),
  noinv1 varchar(50) NULL,
  tginv1 datetime NULL,
  inv_hdr_id bigint NULL,
  bc_in_from_in varchar(30) NULL,
  nopol varchar(20) NULL,
  NAMABELI2 varchar(50) NULL,
  ALMTBELI2 varchar(70) NULL,
  NEGBELI2 varchar(2) NULL,
  tujuan_pengiriman int NULL,
  no_faktur varchar(50) NULL,
  tgl_faktur date NULL,
  harga_penyerahan float NULL,
  CONSTRAINT PK__tblPebHd__C1FF19491D3C345A_tbl_doc_out_hdr PRIMARY KEY CLUSTERED (id_bc_out_hdr) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

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

CREATE INDEX ix_auto_tbl_bc_out_hdr_20161019_0002
  ON dbo.tbl_bc_out_hdr (typedok)
  INCLUDE (id_bc_out_hdr, CAR, JnEks, KatEks, JNPEB, JNEKSOld, JNLAIN, JNDAG, JNBYR, IDEKS, NPWPEKS, NamaEks, AlmtEks, NoSiup, TgSiup, JnPerus, NoTdp, TgTdp, Niper, StatusH, IdQq, NpwpQq, NamaQq, AlmtQq, NiperQq, NAMABELI, ALMTBELI, NEGBELI, IDPPJK, NPWPPPJK, NamaPpjk, AlmtPpjk, NoPpjk, TgPpjk, MODA, TGEKS, CARRIER, VOY, NOSHIPORD, TGSHIPORD, PELMUAT, PELBONGKAR, PELTRANSIT, NOINV, TGINV, NOLPSE, TGLPSE, PROPBRG, NEGTUJU, FLSIE, FLKARANT, FLSM, FLIZLAIN, DELIVERY, KDVAL, KdHrg, NilInv, FREIGHT, ASURANSI, KdAss, FOB, MERK, JMCONT, BRUTO, NETTO, JMBRG, JMBRGCTH, JMBRGGAB, JMBRGPJT, NODAFT, TGDAFT, KDKTR, KTRGATE, NILPE, KDBANK, LOKBANK, NOSSP, TGSSP, JNTPB, LOKTPB, KDLOKBRG, KDKTRMUAT, KDKTRPRIKS, TGSIAP, WKSIAP, ASALDATA, TPNAME, PEBOK, LENGKAP, JNPARTOF, BENDERA, TTDPEB, STATUS, SNRF, NOBCF, TGBCF, SERIBCF, NOMOREDI, KMDT, VOLUME, KDHANGGAR, KONS, JMLKMSPEB, PELMUATEKS, NILKURS, PNBP, NOBC11, TGBC11, POSBC11, SUBPOSBC11, create_date, create_by, update_date, update_by, statusdok, noinv1, tginv1, inv_hdr_id, bc_in_from_in, nopol)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_out_hdr_20161019_0003
  ON dbo.tbl_bc_out_hdr (bc_in_from_in)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_bc_out_hdr