dbo.dt_ms_item_list

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	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	8499
Created	11/10/2017 11:36:20
Last Modified	7/17/2020 11:07:35

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
ms_item_list_sta_id	bigint	8	19	0	True	1 - 1	False	False
ms_item_id	bigint	8	19	0	False		False	False
source_sta_id	int	4	10	0	False		False	False
CAR	varchar	50	0	0	False		False	False
BC_NO	varchar	50	0	0	False		False	False
BC_DATE	date	3	10	0	False		False	False
KODE_KANTOR	varchar	6	0	0	False		False	False
KODE_VALUTA	varchar	3	0	0	False		False	False
NDPBM	decimal	17	38	4	False		False	False
receive_no	varchar	255	0	0	False		False	False
receive_date	date	3	10	0	False		False	False
qty_pakai	decimal	17	38	4	False		False	False
harga_total	decimal	17	38	4	False		False	False
SERI_BARANG	int	4	10	0	False		False	False
id_bc_in_dtl	bigint	8	19	0	False		False	False
bc_in_qty	decimal	17	38	4	False		False	False

Indexes

Name	Columns	Unique
NonClusteredIndex-20200717-110705	ms_item_id	False
NonClusteredIndex-20200717-110712	source_sta_id	False
NonClusteredIndex-20200717-110719	receive_date	False
NonClusteredIndex-20200717-110730	BC_DATE	False
PK_dt_ms_item_list_sta	ms_item_list_sta_id	True

Foreign Keys

Name	Columns	Description
FK_dt_ms_item_list_sta_dt_ms_item	ms_item_id
FK_dt_ms_item_list_sta_enum_ms_source_sta	source_sta_id
FK_dt_ms_item_list_sta_tbl_bc_in_dtl	id_bc_in_dtl

SQL Script

CREATE TABLE dbo.dt_ms_item_list_sta (
  ms_item_list_sta_id bigint IDENTITY,
  ms_item_id bigint NULL,
  source_sta_id int NULL,
  CAR varchar(50) NULL,
  BC_NO varchar(50) NULL,
  BC_DATE date NULL,
  KODE_KANTOR varchar(6) NULL,
  KODE_VALUTA varchar(3) NULL,
  NDPBM decimal(38, 4) NULL,
  receive_no varchar(255) NULL,
  receive_date date NULL,
  qty_pakai decimal(38, 4) NULL,
  harga_total decimal(38, 4) NULL,
  SERI_BARANG int NULL,
  id_bc_in_dtl bigint NULL,
  bc_in_qty decimal(38, 4) NULL,
  CONSTRAINT PK_dt_ms_item_list_sta PRIMARY KEY CLUSTERED (ms_item_list_sta_id)
)
ON [PRIMARY]
GO

CREATE INDEX [NonClusteredIndex-20200717-110705]
  ON dbo.dt_ms_item_list_sta (ms_item_id)
  ON [PRIMARY]
GO

CREATE INDEX [NonClusteredIndex-20200717-110712]
  ON dbo.dt_ms_item_list_sta (source_sta_id)
  ON [PRIMARY]
GO

CREATE INDEX [NonClusteredIndex-20200717-110719]
  ON dbo.dt_ms_item_list_sta (receive_date)
  ON [PRIMARY]
GO

CREATE INDEX [NonClusteredIndex-20200717-110730]
  ON dbo.dt_ms_item_list_sta (BC_DATE)
  ON [PRIMARY]
GO

ALTER TABLE dbo.dt_ms_item_list_sta WITH NOCHECK
  ADD CONSTRAINT FK_dt_ms_item_list_sta_dt_ms_item FOREIGN KEY (ms_item_id) REFERENCES dbo.dt_ms_item (ms_item_id) NOT FOR REPLICATION
GO

ALTER TABLE dbo.dt_ms_item_list_sta
  NOCHECK CONSTRAINT FK_dt_ms_item_list_sta_dt_ms_item
GO

ALTER TABLE dbo.dt_ms_item_list_sta WITH NOCHECK
  ADD CONSTRAINT FK_dt_ms_item_list_sta_enum_ms_source_sta FOREIGN KEY (source_sta_id) REFERENCES dbo.enum_ms_source_sta (source_sta_id) NOT FOR REPLICATION
GO

ALTER TABLE dbo.dt_ms_item_list_sta
  NOCHECK CONSTRAINT FK_dt_ms_item_list_sta_enum_ms_source_sta
GO

ALTER TABLE dbo.dt_ms_item_list_sta WITH NOCHECK
  ADD CONSTRAINT FK_dt_ms_item_list_sta_tbl_bc_in_dtl FOREIGN KEY (id_bc_in_dtl) REFERENCES dbo.tbl_bc_in_dtl (id_bc_in_dtl) NOT FOR REPLICATION
GO

ALTER TABLE dbo.dt_ms_item_list_sta
  NOCHECK CONSTRAINT FK_dt_ms_item_list_sta_tbl_bc_in_dtl
GO

dbo.dt_ms_item_list_sta