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 (~)	134104
Created	9/9/2017 11:07:02
Last Modified	9/9/2017 11:07:06

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_sa_bb	bigint	8	19	0	True	1 - 1	False	False
id_sa_hdr	bigint	8	19	0	True		False	False
SA_NO	varchar	50	0	0	False		False	False
NO_URUT	int	4	10	0	False		False	False
PART_NAME	varchar	250	0	0	False		False	False
QTY	float	8	53	0	False		False	False
UNIT	varchar	5	0	0	False		False	False
STATUS	varchar	50	0	0	False		False	False
CURR	varchar	5	0	0	False		False	False
PRICE	float	8	53	0	False		False	False
CIF	float	8	53	0	False		False	False
NDPMB	float	8	53	0	False		False	False
NDPDM_NOW	float	8	53	0	False		False	False
HARGA_PABEAN	float	8	53	0	False		False	False
HS	varchar	20	0	0	False		False	False
BM	float	8	53	0	False		False	False
PPN	float	8	53	0	False		False	False
PPH	float	8	53	0	False		False	False
BM_RP	float	8	53	0	False		False	False
PPN_RP	float	8	53	0	False		False	False
PPH_RP	float	8	53	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

Indexes

Key	Name	Columns	Unique	Type	Description
	ix_auto_tbl_sa_bb_20161008_0001	id_sa_hdr	False
	PK_tbl_sa_bb	id_sa_bb	True

SQL Script

CREATE TABLE dbo.tbl_sa_bb (
  id_sa_bb bigint IDENTITY,
  id_sa_hdr bigint NOT NULL,
  SA_NO varchar(50) NULL,
  NO_URUT int NULL,
  PART_NAME varchar(250) NULL,
  QTY float NULL,
  UNIT varchar(5) NULL,
  STATUS varchar(50) NULL,
  CURR varchar(5) NULL,
  PRICE float NULL,
  CIF float NULL,
  NDPMB float NULL,
  NDPDM_NOW float NULL,
  HARGA_PABEAN float NULL,
  HS varchar(20) NULL,
  BM float NULL,
  PPN float NULL,
  PPH float NULL,
  BM_RP float NULL,
  PPN_RP float NULL,
  PPH_RP float NULL,
  create_date datetime NULL,
  create_by varchar(50) NULL,
  update_date datetime NULL,
  update_by varchar(50) NULL,
  CONSTRAINT PK_tbl_sa_bb PRIMARY KEY CLUSTERED (id_sa_bb) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_sa_bb_20161008_0001
  ON dbo.tbl_sa_bb (id_sa_hdr)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found