dbo.tbl_incoming_fg_temp3DEB0914C09945FB99554ACAC85F6E10

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	7/2/2021 15:46:31
Last Modified	7/2/2021 15:46:31

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
PROD_DATE	datetime	8	23	3	True	False	False
PERIODE	varchar	50	0	0	True	False	False
LINE_NO	varchar	50	0	0	True	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

SQL Script

CREATE TABLE dbo.tbl_incoming_fg_temp3DEB0914C09945FB99554ACAC85F6E10 (
  PROD_DATE datetime NOT NULL,
  PERIODE varchar(50) NOT NULL,
  LINE_NO varchar(50) NOT 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
)
ON [PRIMARY]
GO

Depends On

No items found

Used By

No items found