dbo.tblBC25Hdr

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	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	0
Created	3/22/2013 13:20:35
Last Modified	3/22/2013 13:20:35

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_bc25hdr	bigint	8	19	0	True	1 - 1	False	False
CAR	varchar	50	0	0	False		False	False
BC25No	varchar	50	0	0	False		False	False
BC25Tg	datetime	8	23	3	False		False	False
KdKpbc	varchar	50	0	0	False		False	False
KdKpbcTujuan	varchar	50	0	0	False		False	False
JnBC25	varchar	50	0	0	False		False	False
JnBarang	varchar	50	0	0	False		False	False
Kondisi	varchar	50	0	0	False		False	False
Dari	varchar	50	0	0	False		False	False
Tujuan	varchar	50	0	0	False		False	False
TujuanKirim	varchar	50	0	0	False		False	False
UsahaID	varchar	50	0	0	False		False	False
UsahaNpwp	varchar	50	0	0	False		False	False
UsahaNama	varchar	50	0	0	False		False	False
UsahaAlmt	varchar	70	0	0	False		False	False
UsahaStatus	varchar	50	0	0	False		False	False
PenerimaID	varchar	50	0	0	False		False	False
PenerimaNpwp	varchar	50	0	0	False		False	False
PenerimaNama	varchar	50	0	0	False		False	False
PenerimaAlmt	varchar	70	0	0	False		False	False
PenerimaNiper	varchar	50	0	0	False		False	False
PenerimaStatus	varchar	50	0	0	False		False	False
PpjkId	varchar	50	0	0	False		False	False
PpjkNpwp	varchar	50	0	0	False		False	False
PpjkNama	varchar	50	0	0	False		False	False
PpjkAlmt	varchar	70	0	0	False		False	False
PpjkNo	varchar	50	0	0	False		False	False
PpjkTg	datetime	8	23	3	False		False	False
TempatPenimbunan	nvarchar	50	0	0	False		False	False
TgKeluar	datetime	8	23	3	False		False	False
TglMusnah	datetime	8	23	3	False		False	False
BAMusnah	varchar	50	0	0	False		False	False
KdVal	varchar	50	0	0	False		False	False
Ndpbm	float	8	53	0	False		False	False
HargaRp	float	8	53	0	False		False	False
HargaBBRp	float	8	53	0	False		False	False
Bruto	float	8	53	0	False		False	False
Netto	float	8	53	0	False		False	False
JmBrg	int	4	10	0	False		False	False
JmBB	int	4	10	0	False		False	False
JmCont	int	4	10	0	False		False	False
KotaTtd	varchar	50	0	0	False		False	False
TglTtd	datetime2	8	27	7	False		False	False
NamaTtd	varchar	50	0	0	False		False	False
KotattdPenerima	varchar	50	0	0	False		False	False
TglTtdPenerima	datetime2	8	27	7	False		False	False
NamaTtdPenerima	varchar	50	0	0	False		False	False
TmpPeriksaFisik	varchar	50	0	0	False		False	False
AlmtPeriksaFisik	varchar	70	0	0	False		False	False
TgPeriksaFisik	datetime2	8	27	7	False		False	False
WkPeriksaFisik	varchar	50	0	0	False		False	False
ContakPerson	varchar	50	0	0	False		False	False
NoPhone	varchar	50	0	0	False		False	False
Snrf	varchar	50	0	0	False		False	False
Lengkap	char	1	0	0	False		False	False
Status	varchar	50	0	0	False		False	False

SQL Script

CREATE TABLE dbo.tblBC25Hdr (
  id_bc25hdr bigint IDENTITY,
  CAR varchar(50) NULL,
  BC25No varchar(50) NULL,
  BC25Tg datetime NULL,
  KdKpbc varchar(50) NULL,
  KdKpbcTujuan varchar(50) NULL,
  JnBC25 varchar(50) NULL,
  JnBarang varchar(50) NULL,
  Kondisi varchar(50) NULL,
  Dari varchar(50) NULL,
  Tujuan varchar(50) NULL,
  TujuanKirim varchar(50) NULL,
  UsahaID varchar(50) NULL,
  UsahaNpwp varchar(50) NULL,
  UsahaNama varchar(50) NULL,
  UsahaAlmt varchar(70) NULL,
  UsahaStatus varchar(50) NULL,
  PenerimaID varchar(50) NULL,
  PenerimaNpwp varchar(50) NULL,
  PenerimaNama varchar(50) NULL,
  PenerimaAlmt varchar(70) NULL,
  PenerimaNiper varchar(50) NULL,
  PenerimaStatus varchar(50) NULL,
  PpjkId varchar(50) NULL,
  PpjkNpwp varchar(50) NULL,
  PpjkNama varchar(50) NULL,
  PpjkAlmt varchar(70) NULL,
  PpjkNo varchar(50) NULL,
  PpjkTg datetime NULL,
  TempatPenimbunan nvarchar(50) NULL,
  TgKeluar datetime NULL,
  TglMusnah datetime NULL,
  BAMusnah varchar(50) NULL,
  KdVal varchar(50) NULL,
  Ndpbm float NULL,
  HargaRp float NULL,
  HargaBBRp float NULL,
  Bruto float NULL,
  Netto float NULL,
  JmBrg int NULL,
  JmBB int NULL,
  JmCont int NULL,
  KotaTtd varchar(50) NULL,
  TglTtd datetime2 NULL,
  NamaTtd varchar(50) NULL,
  KotattdPenerima varchar(50) NULL,
  TglTtdPenerima datetime2 NULL,
  NamaTtdPenerima varchar(50) NULL,
  TmpPeriksaFisik varchar(50) NULL,
  AlmtPeriksaFisik varchar(70) NULL,
  TgPeriksaFisik datetime2 NULL,
  WkPeriksaFisik varchar(50) NULL,
  ContakPerson varchar(50) NULL,
  NoPhone varchar(50) NULL,
  Snrf varchar(50) NULL,
  Lengkap char(1) NULL,
  Status varchar(50) NULL
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found