dbo.set_decimal

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 (~)	10
Created	10/8/2016 12:25:26
Last Modified	11/18/2016 23:31:46

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
decimal_id	int	4	10	True	False	False
bc_type_id	int	4	10	False	False	False
detail_total	int	4	10	False	False	False
detail_unit	int	4	10	False	False	False
header_total	int	4	10	False	False	False
header_valuta	int	4	10	False	False	False
header_tambahan	int	4	10	False	False	False
header_diskon	int	4	10	False	False	False
header_asuransi	int	4	10	False	False	False
header_freight	int	4	10	False	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_set_decimal	decimal_id	True

SQL Script

CREATE TABLE dbo.set_decimal (
  decimal_id int NOT NULL,
  bc_type_id int NULL,
  detail_total int NULL,
  detail_unit int NULL,
  header_total int NULL,
  header_valuta int NULL,
  header_tambahan int NULL,
  header_diskon int NULL,
  header_asuransi int NULL,
  header_freight int NULL,
  CONSTRAINT PK_set_decimal PRIMARY KEY CLUSTERED (decimal_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found