dbo.tblbc27dtl

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 (~)	17816
Created	8/7/2020 15:02:41
Last Modified	8/7/2020 15:02:43

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
idbc27dtl	bigint	8	19	True	1 - 1	False	False
idbc27hdr	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	30	0	False		False	False
KDBRG	varchar	30	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

Key	Name	Columns	Unique	Type	Description
	PK_tblbc27dtl	idbc27dtl	True

SQL Script

CREATE TABLE dbo.tblbc27dtl (
  idbc27dtl bigint IDENTITY,
  idbc27hdr 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(30) NULL,
  KDBRG varchar(30) 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_tblbc27dtl PRIMARY KEY CLUSTERED (idbc27dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found