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 (~)	264831
Created	2/23/2013 07:53:29
Last Modified	11/18/2016 22:54:22

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id_bc_out_dtl	bigint	8	19	True	1 - 1	False	False
id_bc_out_hdr	bigint	8	19	True		False	False
CAR	varchar	26	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

Indexes

Key	Name	Columns	Unique	Type	Description
	ix_auto_tbl_bc_out_dtl_20161008_0001	id_bc_out_hdr	False
	PK_tbl_bc_out_dtl	id_bc_out_dtl	True

SQL Script

CREATE TABLE dbo.tbl_bc_out_dtl (
  id_bc_out_dtl bigint IDENTITY,
  id_bc_out_hdr bigint NOT NULL,
  CAR varchar(26) 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,
  CONSTRAINT PK_tbl_bc_out_dtl PRIMARY KEY CLUSTERED (id_bc_out_dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_bc_out_dtl_20161008_0001
  ON dbo.tbl_bc_out_dtl (id_bc_out_hdr)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_bc_out_dtl