dbo.tp_ms_item

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
ms_item_id	bigint	8	19	0	True	False	False
part_no	varchar	255	0	0	False	False	False
part_name	varchar	255	0	0	False	False	False
uom	varchar	3	0	0	False	False	False
base_no	varchar	50	0	0	True	False	False
base_name	varchar	255	0	0	False	False	False
category_id	int	4	10	0	True	False	False
category_name	varchar	255	0	0	True	False	False
qty_1	decimal	17	38	8	False	False	False
qty_2	decimal	17	38	8	False	False	False
qty_3	decimal	17	38	8	False	False	False
qty_4	decimal	17	38	8	False	False	False
qty_5	decimal	17	38	8	False	False	False
qty_6	decimal	17	38	8	False	False	False
qty_7	decimal	17	38	8	False	False	False
qty_8	decimal	17	38	8	False	False	False
qty_9	decimal	17	38	8	False	False	False
qty_10	decimal	17	38	8	False	False	False
qty_11	decimal	17	38	8	False	False	False
qty_12	decimal	17	38	8	False	False	False
qty_avg	decimal	9	18	8	False	False	False
stdev_qty	decimal	9	18	8	False	False	False
service_level	decimal	9	18	8	False	False	False
service_factor	decimal	9	18	4	False	False	False
safty_stock	decimal	9	18	4	False	False	False
before_min	decimal	9	18	4	False	False	False
before_max	decimal	9	18	4	False	False	False
after_min	decimal	9	18	4	False	False	False
after_max	decimal	9	18	4	False	False	False
actual_qty	decimal	9	18	4	False	False	False
start_month	bigint	8	19	0	False	False	False
count_moving	int	4	10	0	False	False	False
fast_moving	int	4	10	0	False	False	False
sum_qty	decimal	17	38	4	False	False	False
max_qty	decimal	17	38	4	False	False	False

SQL Script

CREATE TYPE dbo.tp_ms_item_moving AS TABLE (
  ms_item_id bigint NOT NULL,
  part_no varchar(255) NULL,
  part_name varchar(255) NULL,
  uom varchar(3) NULL,
  base_no varchar(50) NOT NULL,
  base_name varchar(255) NULL,
  category_id int NOT NULL,
  category_name varchar(255) NOT NULL,
  qty_1 decimal(38, 8) NULL,
  qty_2 decimal(38, 8) NULL,
  qty_3 decimal(38, 8) NULL,
  qty_4 decimal(38, 8) NULL,
  qty_5 decimal(38, 8) NULL,
  qty_6 decimal(38, 8) NULL,
  qty_7 decimal(38, 8) NULL,
  qty_8 decimal(38, 8) NULL,
  qty_9 decimal(38, 8) NULL,
  qty_10 decimal(38, 8) NULL,
  qty_11 decimal(38, 8) NULL,
  qty_12 decimal(38, 8) NULL,
  qty_avg decimal(18, 8) NULL,
  stdev_qty decimal(18, 8) NULL,
  service_level decimal(18, 8) NULL,
  service_factor decimal(18, 4) NULL,
  safty_stock decimal(18, 4) NULL,
  before_min decimal(18, 4) NULL,
  before_max decimal(18, 4) NULL,
  after_min decimal(18, 4) NULL,
  after_max decimal(18, 4) NULL,
  actual_qty decimal(18, 4) NULL,
  start_month bigint NULL,
  count_moving int NULL,
  fast_moving int NULL,
  sum_qty decimal(38, 4) NULL,
  max_qty decimal(38, 4) NULL,
  PRIMARY KEY CLUSTERED (ms_item_id)
)
GO

Depends On

No items found

Used By

No items found