dbo.tbl_incoming_fg

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 (~)	484769
Created	1/16/2013 02:46:00
Last Modified	11/18/2016 23:32:29

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_incoming_fg_dtl	bigint	8	19	0	True	1 - 1	False	False
id_incoming_fg	bigint	8	19	0	False		False	False
PROD_DATE	datetime	8	23	3	False		False	False
PERIODE	varchar	50	0	0	False		False	False
LINE_NO	varchar	50	0	0	False		False	False
LOADING_LINE	varchar	50	0	0	False		False	False
ASSY_NO	varchar	50	0	0	False		False	False
ASSY_CODE	varchar	50	0	0	False		False	False
QTY_BOX_SF	float	8	53	0	False		False	False
QTY_BOX_AF	float	8	53	0	False		False	False
ATOT_BOX_SF	float	8	53	0	False		False	False
ATOT_PCS_SF	float	8	53	0	False		False	False
ATOT_BOX_AF	float	8	53	0	False		False	False
ATOT_PCS_AF	float	8	53	0	False		False	False
BTOT_BOX_SF	float	8	53	0	False		False	False
BTOT_PCS_SF	float	8	53	0	False		False	False
BTOT_BOX_AF	float	8	53	0	False		False	False
BTOT_PCS_AF	float	8	53	0	False		False	False
CTOT_BOX_SF	float	8	53	0	False		False	False
CTOT_PCS_SF	float	8	53	0	False		False	False
CTOT_BOX_AF	float	8	53	0	False		False	False
CTOT_PCS_AF	float	8	53	0	False		False	False
GROUP_NO	varchar	50	0	0	False		False	False
LBJ_NO	varchar	50	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK_tbl_incoming_fg	id_incoming_fg_dtl	True

SQL Script

CREATE TABLE dbo.tbl_incoming_fg_dtl (
  id_incoming_fg_dtl bigint IDENTITY,
  id_incoming_fg bigint NULL,
  PROD_DATE datetime NULL,
  PERIODE varchar(50) NULL,
  LINE_NO varchar(50) NULL,
  LOADING_LINE varchar(50) NULL,
  ASSY_NO varchar(50) NULL,
  ASSY_CODE varchar(50) NULL,
  QTY_BOX_SF float NULL,
  QTY_BOX_AF float NULL,
  ATOT_BOX_SF float NULL,
  ATOT_PCS_SF float NULL,
  ATOT_BOX_AF float NULL,
  ATOT_PCS_AF float NULL,
  BTOT_BOX_SF float NULL,
  BTOT_PCS_SF float NULL,
  BTOT_BOX_AF float NULL,
  BTOT_PCS_AF float NULL,
  CTOT_BOX_SF float NULL,
  CTOT_PCS_SF float NULL,
  CTOT_BOX_AF float NULL,
  CTOT_PCS_AF float NULL,
  GROUP_NO varchar(50) NULL,
  LBJ_NO varchar(50) NULL,
  CONSTRAINT PK_tbl_incoming_fg PRIMARY KEY CLUSTERED (id_incoming_fg_dtl) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

dbo.spi_incoming_fg