dbo.tp_ms_avg

Description

Properties

Name	Value
Collation
File Group
Filestream File Group
Is Partitioned
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	False
Full Text Catalog
Full Text
Compression
Row Count (~)
Created
Last Modified

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
ms_item_id	bigint	8	19	0	True	False	False
business_date_start_recalculate	date	3	10	0	False	False	False
qty_avg_final	decimal	17	38	5	False	False	False
price_avg_idr_final	decimal	17	38	5	False	False	False
price_avg_usd_final	decimal	17	38	5	False	False	False

SQL Script

CREATE TYPE dbo.tp_ms_avg_item AS TABLE (
  ms_item_id bigint NOT NULL,
  business_date_start_recalculate date NULL,
  qty_avg_final decimal(38, 5) NULL,
  price_avg_idr_final decimal(38, 5) NULL,
  price_avg_usd_final decimal(38, 5) NULL,
  PRIMARY KEY CLUSTERED (ms_item_id)
)
GO

Depends On

No items found

Used By

No items found