dbo.dt_ms_item

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	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	0
Created	11/6/2020 18:51:53
Last Modified	11/6/2020 18:51:53

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
id	bigint	8	19	0	False	False	False
ms_type_id	int	4	10	0	False	False	False
ms_item_custom_no	varchar	255	0	0	False	False	False
base_no	varchar	255	0	0	False	False	False
part_no	varchar	255	0	0	False	False	False
part_name	varchar	255	0	0	False	False	False
uom	varchar	50	0	0	False	False	False
consumable	bit	1	1	0	False	False	False
qty_minimum	decimal	17	38	4	False	False	False
end_qty	decimal	17	38	4	False	False	False
end_price	decimal	17	38	4	False	False	False

SQL Script

CREATE TABLE dbo.dt_ms_item_upload (
  id bigint NULL,
  ms_type_id int NULL,
  ms_item_custom_no varchar(255) NULL,
  base_no varchar(255) NULL,
  part_no varchar(255) NULL,
  part_name varchar(255) NULL,
  uom varchar(50) NULL,
  consumable bit NULL,
  qty_minimum decimal(38, 4) NULL,
  end_qty decimal(38, 4) NULL,
  end_price decimal(38, 4) NULL
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found