dbo.tbl_scrap_memo

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 (~)	1273
Created	6/17/2020 07:01:13
Last Modified	6/17/2020 07:01:13

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_scrap_memo_dtl	bigint	8	19	0	True	1 - 1	False	False
id_memo_scrap_hdr	bigint	8	19	0	False		False	False
part_no	varchar	50	0	0	False		False	False
qty	decimal	13	24	4	False		False	False
unit	varchar	50	0	0	False		False	False
weight	decimal	13	24	4	False		False	False
no_ex_bc	varchar	50	0	0	False		False	False
tgl_ex_bc	date	3	10	0	False		False	False
no_urut	int	4	10	0	False		False	False
issue_no	varchar	50	0	0	False		False	False
vgi_date	datetime	8	23	3	False		False	False
vgi_qty	decimal	13	24	4	False		False	False
id_data_in_dtl	bigint	8	19	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_scrap_memo_dtl	id_scrap_memo_dtl	True

SQL Script

CREATE TABLE dbo.tbl_scrap_memo_dtl (
  id_scrap_memo_dtl bigint IDENTITY,
  id_memo_scrap_hdr bigint NULL,
  part_no varchar(50) NULL,
  qty decimal(24, 4) NULL,
  unit varchar(50) NULL,
  weight decimal(24, 4) NULL,
  no_ex_bc varchar(50) NULL,
  tgl_ex_bc date NULL,
  no_urut int NULL,
  issue_no varchar(50) NULL,
  vgi_date datetime NULL,
  vgi_qty decimal(24, 4) NULL,
  id_data_in_dtl bigint NULL,
  CONSTRAINT PK_tbl_scrap_memo_dtl PRIMARY KEY CLUSTERED (id_scrap_memo_dtl)
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_scrap_memo_dtl