dbo.tp_ms_item_avg_pre

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	255	0	0	False	False	False
base_no	varchar	255	0	0	False	False	False
base_name	varchar	255	0	0	False	False	False
category_id	bigint	8	19	0	False	False	False
category_name	varchar	255	0	0	False	False	False
sta_qty	decimal	17	38	5	False	False	False
sta_amount_idr	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_idr	decimal	17	38	5	False	False	False
in_amount_usd	decimal	17	38	5	False	False	False
final_avg_price	decimal	17	38	5	False	False	False
final_avg_price_usd	decimal	17	38	5	False	False	False
out_carline_qty	decimal	17	38	5	False	False	False
out_carline_amount	decimal	17	38	5	False	False	False
out_memo_qty	decimal	17	38	5	False	False	False
out_memo_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
sto_qty	decimal	17	38	5	False	False	False
sto_amount	decimal	17	38	5	False	False	False
retur_qty	decimal	17	38	5	False	False	False
retur_amount	decimal	17	38	5	False	False	False

SQL Script

CREATE TYPE dbo.tp_ms_item_avg_pre_backup AS TABLE (
  ms_item_id bigint NOT NULL,
  part_no varchar(255) NULL,
  part_name varchar(255) NULL,
  uom varchar(255) NULL,
  base_no varchar(255) NULL,
  base_name varchar(255) NULL,
  category_id bigint NULL,
  category_name varchar(255) NULL,
  sta_qty decimal(38, 5) NULL,
  sta_amount_idr decimal(38, 5) NULL,
  sta_amount_usd decimal(38, 5) NULL,
  in_qty decimal(38, 5) NULL,
  in_amount_idr decimal(38, 5) NULL,
  in_amount_usd decimal(38, 5) NULL,
  final_avg_price decimal(38, 5) NULL,
  final_avg_price_usd decimal(38, 5) NULL,
  out_carline_qty decimal(38, 5) NULL,
  out_carline_amount decimal(38, 5) NULL,
  out_memo_qty decimal(38, 5) NULL,
  out_memo_amount decimal(38, 5) NULL,
  adj_qty decimal(38, 5) NULL,
  adj_amount decimal(38, 5) NULL,
  sto_qty decimal(38, 5) NULL,
  sto_amount decimal(38, 5) NULL,
  retur_qty decimal(38, 5) NULL,
  retur_amount decimal(38, 5) NULL,
  PRIMARY KEY CLUSTERED (ms_item_id)
)
GO

Depends On

No items found

Used By

No items found