dbo.tblBC23Hdr

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 (~)	8680
Created	5/3/2013 08:13:12
Last Modified	11/18/2016 23:30:59

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
CAR	varchar	26	0	True	False	False
KdKpbc	varchar	6	0	False	False	False
Tujuan	varchar	1	0	False	False	False
JnsBarang	varchar	2	0	False	False	False
TujuanKirim	varchar	2	0	False	False	False
PasokNama	varchar	50	0	False	False	False
PasokAlmt	varchar	70	0	False	False	False
PasokNeg	varchar	2	0	False	False	False
UsahaId	varchar	1	0	False	False	False
UsahaNpwp	varchar	15	0	False	False	False
KdTPB	varchar	1	0	False	False	False
Registrasi	varchar	20	0	False	False	False
UsahaNama	varchar	50	0	False	False	False
UsahaAlmt	varchar	70	0	False	False	False
UsahaStatus	varchar	2	0	False	False	False
ApiKd	varchar	1	0	False	False	False
ApiNo	varchar	15	0	False	False	False
PpjkId	varchar	1	0	False	False	False
PpjkNpwp	varchar	15	0	False	False	False
PpjkNama	varchar	50	0	False	False	False
PpjkAlmt	varchar	70	0	False	False	False
PpjkNo	varchar	6	0	False	False	False
PpjkTg	date	3	10	False	False	False
IndId	varchar	1	0	False	False	False
IndNpwp	varchar	15	0	False	False	False
IndNama	varchar	50	0	False	False	False
IndAlmt	varchar	70	0	False	False	False
Moda	varchar	1	0	False	False	False
AngkutNama	varchar	20	0	False	False	False
AngkutNo	varchar	7	0	False	False	False
AngkutFl	varchar	2	0	False	False	False
PelBkr	varchar	5	0	False	False	False
PelMuat	varchar	5	0	False	False	False
PelTransit	varchar	5	0	False	False	False
BC23No	varchar	6	0	False	False	False
BC23Tg	date	3	10	False	False	False
KdKpbcBongkar	varchar	6	0	False	False	False
KdKpbcAwas	varchar	6	0	False	False	False
DokTupKd	varchar	1	0	False	False	False
DokTupNo	varchar	6	0	False	False	False
DokTupTg	date	3	10	False	False	False
PosNo	varchar	4	0	False	False	False
PosSub	varchar	4	0	False	False	False
TmpTbn	varchar	4	0	False	False	False
KdVal	varchar	3	0	False	False	False
Ndpbm	float	8	53	False	False	False
NilInv	float	8	53	False	False	False
Freight	float	8	53	False	False	False
BTambahan	float	8	53	False	False	False
Diskon	float	8	53	False	False	False
KdAss	varchar	1	0	False	False	False
Asuransi	float	8	53	False	False	False
KdHrg	varchar	1	0	False	False	False
Fob	float	8	53	False	False	False
Cif	float	8	53	False	False	False
Bruto	float	8	53	False	False	False
Netto	float	8	53	False	False	False
JmCont	int	4	10	False	False	False
JmBrg	int	4	10	False	False	False
TglTtd	date	3	10	False	False	False
KotaTtd	varchar	30	0	False	False	False
Namattd	varchar	30	0	False	False	False
ContakPerson	varchar	30	0	False	False	False
NoPhone	varchar	25	0	False	False	False
NoFax	varchar	25	0	False	False	False
Email	varchar	50	0	False	False	False
Status	varchar	2	0	False	False	False
Snrf	varchar	10	0	False	False	False
Lengkap	char	1	0	False	False	False
PosSubSub	varchar	4	0	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__tblBC23H__C1FF1949A7AEFE18	CAR	True

SQL Script

CREATE TABLE dbo.tblBC23Hdr (
  CAR varchar(26) NOT NULL,
  KdKpbc varchar(6) NULL,
  Tujuan varchar(1) NULL,
  JnsBarang varchar(2) NULL,
  TujuanKirim varchar(2) NULL,
  PasokNama varchar(50) NULL,
  PasokAlmt varchar(70) NULL,
  PasokNeg varchar(2) NULL,
  UsahaId varchar(1) NULL,
  UsahaNpwp varchar(15) NULL,
  KdTPB varchar(1) NULL,
  Registrasi varchar(20) NULL,
  UsahaNama varchar(50) NULL,
  UsahaAlmt varchar(70) NULL,
  UsahaStatus varchar(2) NULL,
  ApiKd varchar(1) NULL,
  ApiNo varchar(15) NULL,
  PpjkId varchar(1) NULL,
  PpjkNpwp varchar(15) NULL,
  PpjkNama varchar(50) NULL,
  PpjkAlmt varchar(70) NULL,
  PpjkNo varchar(6) NULL,
  PpjkTg date NULL,
  IndId varchar(1) NULL,
  IndNpwp varchar(15) NULL,
  IndNama varchar(50) NULL,
  IndAlmt varchar(70) NULL,
  Moda varchar(1) NULL,
  AngkutNama varchar(20) NULL,
  AngkutNo varchar(7) NULL,
  AngkutFl varchar(2) NULL,
  PelBkr varchar(5) NULL,
  PelMuat varchar(5) NULL,
  PelTransit varchar(5) NULL,
  BC23No varchar(6) NULL,
  BC23Tg date NULL,
  KdKpbcBongkar varchar(6) NULL,
  KdKpbcAwas varchar(6) NULL,
  DokTupKd varchar(1) NULL,
  DokTupNo varchar(6) NULL,
  DokTupTg date NULL,
  PosNo varchar(4) NULL,
  PosSub varchar(4) NULL,
  TmpTbn varchar(4) NULL,
  KdVal varchar(3) NULL,
  Ndpbm float NULL,
  NilInv float NULL,
  Freight float NULL,
  BTambahan float NULL,
  Diskon float NULL,
  KdAss varchar(1) NULL,
  Asuransi float NULL,
  KdHrg varchar(1) NULL,
  Fob float NULL,
  Cif float NULL,
  Bruto float NULL,
  Netto float NULL,
  JmCont int NULL,
  JmBrg int NULL,
  TglTtd date NULL,
  KotaTtd varchar(30) NULL,
  Namattd varchar(30) NULL,
  ContakPerson varchar(30) NULL,
  NoPhone varchar(25) NULL,
  NoFax varchar(25) NULL,
  Email varchar(50) NULL,
  Status varchar(2) NULL,
  Snrf varchar(10) NULL,
  Lengkap char(1) NULL,
  PosSubSub varchar(4) NULL,
  PRIMARY KEY CLUSTERED (CAR) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found