dbo.tbl_sa

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 (~)	4240
Created	8/12/2017 18:56:30
Last Modified	10/31/2017 17:07:45

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_sa_hdr	bigint	8	19	0	True	1 - 1	False	False
SA_NO	varchar	50	0	0	False		False	False
status	varchar	50	0	0	False		False	False
NPWP_PEMBELI	varchar	50	0	0	False		False	False
NAMA_PEMBELI	varchar	50	0	0	False		False	False
BC25No	varchar	50	0	0	False		False	False
BC25Tg	date	3	10	0	False		False	False
BC25NAJU	varchar	50	0	0	False		False	False
BC25TGAJU	date	3	10	0	False		False	False
BC25NAJU1	varchar	50	0	0	False		False	False
BC25TGAJU1	date	3	10	0	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	170	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	170	0	0	False		False	False
PenerimaNiper	varchar	50	0	0	False		False	False
PenerimaStatus	varchar	50	0	0	False		False	False
TempatPenimbunan	varchar	50	0	0	False		False	False
TgKeluar	date	3	10	0	False		False	False
TglMusnah	date	3	10	0	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	170	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
jml_inv	int	4	10	0	False		False	False
typedok	varchar	10	0	0	False		False	False
nip_bc	varchar	50	0	0	False		False	False
nama_bc	varchar	50	0	0	False		False	False
create_date	datetime	8	23	3	False		False	False
create_by	varchar	50	0	0	False		False	False
update_date	datetime	8	23	3	False		False	False
update_by	varchar	50	0	0	False		False	False
HargaUSD	decimal	9	18	4	False		False	False

Indexes

Name	Columns	Unique
ix_auto_tbl_sa_hdr_20161008_0001	status	False
ix_auto_tbl_sa_hdr_20161019_0001	BC25Tg	False
PK_tbl_sa_hdr	id_sa_hdr	True

SQL Script

CREATE TABLE dbo.tbl_sa_hdr (
  id_sa_hdr bigint IDENTITY,
  SA_NO varchar(50) NULL,
  status varchar(50) NULL,
  NPWP_PEMBELI varchar(50) NULL,
  NAMA_PEMBELI varchar(50) NULL,
  BC25No varchar(50) NULL,
  BC25Tg date NULL,
  BC25NAJU varchar(50) NULL,
  BC25TGAJU date NULL,
  BC25NAJU1 varchar(50) NULL,
  BC25TGAJU1 date 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(170) NULL,
  UsahaStatus varchar(50) NULL,
  PenerimaID varchar(50) NULL,
  PenerimaNpwp varchar(50) NULL,
  PenerimaNama varchar(50) NULL,
  PenerimaAlmt varchar(170) NULL,
  PenerimaNiper varchar(50) NULL,
  PenerimaStatus varchar(50) NULL,
  TempatPenimbunan varchar(50) NULL,
  TgKeluar date NULL,
  TglMusnah date 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(170) NULL,
  TgPeriksaFisik datetime2 NULL,
  WkPeriksaFisik varchar(50) NULL,
  ContakPerson varchar(50) NULL,
  NoPhone varchar(50) NULL,
  jml_inv int NULL,
  typedok varchar(10) NULL,
  nip_bc varchar(50) NULL,
  nama_bc varchar(50) NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  HargaUSD decimal(18, 4) NULL,
  CONSTRAINT PK_tbl_sa_hdr PRIMARY KEY CLUSTERED (id_sa_hdr) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_sa_hdr_20161008_0001
  ON dbo.tbl_sa_hdr (status)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_sa_hdr_20161019_0001
  ON dbo.tbl_sa_hdr (BC25Tg)
  INCLUDE (id_sa_hdr, BC25No)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_sa_hdr