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 (~)	756
Created	9/5/2017 14:57:54
Last Modified	9/5/2017 14:57:54

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_sa	bigint	8	19	0	True	1 - 1	False	False
id_sa_hdr	bigint	8	19	0	True		False	False
NO_AJU	varchar	50	0	0	False		False	False
SA_NO	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
ALAMAT	varchar	190	0	0	False		False	False
INV_NO	varchar	50	0	0	False		False	False
ASSY_CODE	varchar	50	0	0	False		False	False
ASSY_NO	varchar	150	0	0	False		False	False
TOTAL_SET	float	8	53	0	False		False	False
SATUAN	varchar	5	0	0	False		False	False
JUMLAH_COLI	float	8	53	0	False		False	False
GROSSWEIGHT	float	8	53	0	False		False	False
SATUANGROSS	varchar	5	0	0	False		False	False
NETWEIGHT	float	8	53	0	False		False	False
SATUANNET	varchar	5	0	0	False		False	False
PRICE	float	8	53	0	False		False	False
AMOUNT	float	8	53	0	False		False	False
KD_VAL	varchar	50	0	0	False		False	False
TGL_INV	varchar	15	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
HS_KODE	varchar	50	0	0	False		False	False
SERI_BRG	int	4	10	0	False		False	False
SATUAN_COLI	varchar	50	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_sa_hn001	id_sa	True

SQL Script

CREATE TABLE dbo.tbl_sa_hn001 (
  id_sa bigint IDENTITY,
  id_sa_hdr bigint NOT NULL,
  NO_AJU varchar(50) NULL,
  SA_NO varchar(50) NULL,
  NPWP_PEMBELI varchar(50) NULL,
  NAMA_PEMBELI varchar(50) NULL,
  ALAMAT varchar(190) NULL,
  INV_NO varchar(50) NULL,
  ASSY_CODE varchar(50) NULL,
  ASSY_NO varchar(150) NULL,
  TOTAL_SET float NULL,
  SATUAN varchar(5) NULL,
  JUMLAH_COLI float NULL,
  GROSSWEIGHT float NULL,
  SATUANGROSS varchar(5) NULL,
  NETWEIGHT float NULL,
  SATUANNET varchar(5) NULL,
  PRICE float NULL,
  AMOUNT float NULL,
  KD_VAL varchar(50) NULL,
  TGL_INV varchar(15) NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  HS_KODE varchar(50) NULL,
  SERI_BRG int NULL,
  SATUAN_COLI varchar(50) NULL,
  CONSTRAINT PK_tbl_sa_hn001 PRIMARY KEY CLUSTERED (id_sa) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found