dbo.tblBC25Bb

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 (~)	0
Created	3/22/2013 13:27:32
Last Modified	11/18/2016 22:54:29

Columns

Name	Data Type	Length	Precision	Not Null	Identity	Computed	Persisted
id_bc25bb	bigint	8	19	True	1 - 1	False	False
id_bc25hdr	bigint	8	19	True		False	False
CAR	varchar	26	0	False		False	False
Serial	int	4	10	False		False	False
SeriBb	int	4	10	False		False	False
AsalBb	varchar	1	0	False		False	False
Hs	varchar	12	0	False		False	False
UrBrg	varchar	95	0	False		False	False
Merk	varchar	50	0	False		False	False
Tipe	varchar	50	0	False		False	False
Ukuran	varchar	50	0	False		False	False
SpfLain	varchar	50	0	False		False	False
Konversi	float	8	53	False		False	False
KodeBarang	varchar	50	0	False		False	False
StatusBrg	varchar	50	0	False		False	False
JnSatuan	varchar	50	0	False		False	False
JmSatuan	float	8	53	False		False	False
NettoDtl	float	8	53	False		False	False
HrgPenyerahanDtl	float	8	53	False		False	False
KdVal	nvarchar	3	0	False		False	False
Ndpbm	float	8	53	False		False	False
CifDtlBB	float	8	53	False		False	False
DtlOk	char	1	0	False		False	False
Trf-----------	varchar	50	0	False		False	False
TrfBM	float	8	53	False		False	False
KdCukai	varchar	50	0	False		False	False
TrfCukai	float	8	53	False		False	False
TrfPPN	float	8	53	False		False	False
TrfPPnBM	float	8	53	False		False	False
TrfPph	float	8	53	False		False	False
Fas-----------	varchar	50	0	False		False	False
KdFasBM	varchar	50	0	False		False	False
KdFasCukai	varchar	50	0	False		False	False
KdFasPPN	varchar	50	0	False		False	False
KdFasPPnBM	varchar	50	0	False		False	False
KdFasPph	varchar	50	0	False		False	False
TrfFasBM	float	8	53	False		False	False
TrfFasCukai	float	8	53	False		False	False
TrfFasPPN	float	8	53	False		False	False
TrffasPPnBM	float	8	53	False		False	False
TrfFasPph	float	8	53	False		False	False
Nilai---------	varchar	50	0	False		False	False
BM	bigint	8	19	False		False	False
Cukai	bigint	8	19	False		False	False
PPN	bigint	8	19	False		False	False
PPnBM	bigint	8	19	False		False	False
PPh	bigint	8	19	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tblBC25Bb	id_bc25bb	True

SQL Script

CREATE TABLE dbo.tblBC25Bb (
  id_bc25bb bigint IDENTITY,
  id_bc25hdr bigint NOT NULL,
  CAR varchar(26) NULL,
  Serial int NULL,
  SeriBb int NULL,
  AsalBb varchar(1) NULL,
  Hs varchar(12) NULL,
  UrBrg varchar(95) NULL,
  Merk varchar(50) NULL,
  Tipe varchar(50) NULL,
  Ukuran varchar(50) NULL,
  SpfLain varchar(50) NULL,
  Konversi float NULL,
  KodeBarang varchar(50) NULL,
  StatusBrg varchar(50) NULL,
  JnSatuan varchar(50) NULL,
  JmSatuan float NULL,
  NettoDtl float NULL,
  HrgPenyerahanDtl float NULL,
  KdVal nvarchar(3) NULL,
  Ndpbm float NULL,
  CifDtlBB float NULL,
  DtlOk char(1) NULL,
  [Trf-----------] varchar(50) NULL,
  TrfBM float NULL,
  KdCukai varchar(50) NULL,
  TrfCukai float NULL,
  TrfPPN float NULL,
  TrfPPnBM float NULL,
  TrfPph float NULL,
  [Fas-----------] varchar(50) NULL,
  KdFasBM varchar(50) NULL,
  KdFasCukai varchar(50) NULL,
  KdFasPPN varchar(50) NULL,
  KdFasPPnBM varchar(50) NULL,
  KdFasPph varchar(50) NULL,
  TrfFasBM float NULL,
  TrfFasCukai float NULL,
  TrfFasPPN float NULL,
  TrffasPPnBM float NULL,
  TrfFasPph float NULL,
  [Nilai---------] varchar(50) NULL,
  BM bigint NULL,
  Cukai bigint NULL,
  PPN bigint NULL,
  PPnBM bigint NULL,
  PPh bigint NULL,
  CONSTRAINT PK_tblBC25Bb PRIMARY KEY CLUSTERED (id_bc25bb) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found