dbo.tp_ms_avg_catergory_detail_in

Description

Properties

Name	Value
Collation	SQL_Latin1_General_CP1_CI_AS
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
category_id	bigint	8	19	0	True	False	False
category_name	varchar	255	0	0	False	False	False
category_initial	varchar	255	0	0	False	False	False
category_color	varchar	255	0	0	False	False	False
show	bit	1	1	0	False	False	False
order_by	int	4	10	0	False	False	False
sta_qty	decimal	17	38	5	False	False	False
sta_amount_usd	decimal	17	38	5	False	False	False
in_qty	decimal	17	38	5	False	False	False
in_amount_usd	decimal	17	38	5	False	False	False
out_qty	decimal	17	38	5	False	False	False
out_amount	decimal	17	38	5	False	False	False
adj_qty	decimal	17	38	5	False	False	False
adj_amount	decimal	17	38	5	False	False	False
end_qty	decimal	17	38	5	False	False	False
end_amount	decimal	17	38	5	False	False	False

SQL Script

CREATE TYPE dbo.tp_ms_avg_catergory_detail_in_out AS TABLE (
  category_id bigint NOT NULL,
  category_name varchar(255) NULL,
  category_initial varchar(255) NULL,
  category_color varchar(255) NULL,
  show bit NULL,
  order_by int NULL,
  sta_qty decimal(38, 5) NULL,
  sta_amount_usd decimal(38, 5) NULL,
  in_qty decimal(38, 5) NULL,
  in_amount_usd decimal(38, 5) NULL,
  out_qty decimal(38, 5) NULL,
  out_amount decimal(38, 5) NULL,
  adj_qty decimal(38, 5) NULL,
  adj_amount decimal(38, 5) NULL,
  end_qty decimal(38, 5) NULL,
  end_amount decimal(38, 5) NULL,
  PRIMARY KEY CLUSTERED (category_id)
)
GO

Depends On

No items found

Used By

No items found