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	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	1764
Created	4/16/2019 09:53:12
Last Modified	4/16/2019 09:53:12

Columns

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

SQL Script

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

Depends On

No items found

Used By

No items found