dbo.tbl_assy

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 (~)	77303
Created	1/15/2013 23:39:07
Last Modified	11/18/2016 23:30:50

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_assy_list	bigint	8	19	0	True	1 - 1	False	False
ASSY_CODE	varchar	50	0	0	False		False	False
ASSY_NO	varchar	50	0	0	False		False	False
LINE_NO	int	4	10	0	False		False	False
CUT_PCS	int	4	10	0	False		False	False
CRIMP_PCS	int	4	10	0	False		False	False
JOINT_PCS	int	4	10	0	False		False	False
CUT_SHLD	int	4	10	0	False		False	False
CRIMP_SHLD	int	4	10	0	False		False	False
JOINT_SHLD	int	4	10	0	False		False	False
ASSY_UMH	float	8	53	0	False		False	False
ASSY_UMHN	float	8	53	0	False		False	False
ACTIVESTAT	varchar	50	0	0	False		False	False
L_MONTH_QTY	int	4	10	0	False		False	False
FLAG_VALIDATE_PLIST	datetime	8	23	3	False		False	False
DESC_CARLINE	varchar	50	0	0	False		False	False
CONV_DATE	datetime	8	23	3	False		False	False
CCT	int	4	10	0	False		False	False
CRIMP_ACCS	int	4	10	0	False		False	False
CRIMP_DBL	int	4	10	0	False		False	False
CUT_TUBE	int	4	10	0	False		False	False
JOINT_BCHL	int	4	10	0	False		False	False
MOULDING	int	4	10	0	False		False	False
WOS	varchar	50	0	0	False		False	False
LOADING_LINE	varchar	50	0	0	False		False	False
HISTORY_CLINE1	varchar	50	0	0	False		False	False
HISTORY_CLINE2	varchar	50	0	0	False		False	False
HISTORY_CLINE3	varchar	50	0	0	False		False	False
PREV_CODE	varchar	50	0	0	False		False	False
CUST_KEY	varchar	50	0	0	False		False	False
PREVSTAT	varchar	50	0	0	False		False	False
ASSY_NO1	varchar	50	0	0	False		False	False
QTY_BOX	int	4	10	0	False		False	False
QTY_SET	int	4	10	0	False		False	False
IF_ORDER_QTY	int	4	10	0	False		False	False
STOCK_MIN_P	int	4	10	0	False		False	False
STOCK_MINQTY	int	4	10	0	False		False	False
NON_GSP	varchar	50	0	0	False		False	False
AIR_BAG	varchar	50	0	0	False		False	False
GROUPCODE	varchar	50	0	0	False		False	False
PACKSTD_SF	varchar	50	0	0	False		False	False
PACKSTD_AF	varchar	50	0	0	False		False	False
CTN_TYPE	varchar	50	0	0	False		False	False
QTYBOX_SF	int	4	10	0	False		False	False
QTYBOX_AF	int	4	10	0	False		False	False
PRICE	float	8	53	0	False		False	False
NET_KGS	float	8	53	0	False		False	False
GROSS_KGS	float	8	53	0	False		False	False
VOL	float	8	53	0	False		False	False
CUMM	float	8	53	0	False		False	False
CTN_TYPE_ME	varchar	50	0	0	False		False	False
CTN_KGS_SF	float	8	53	0	False		False	False
CTN_KGS_AF	float	8	53	0	False		False	False
CTN_VOL_SF	float	8	53	0	False		False	False
CTN_VOL_AF	float	8	53	0	False		False	False
PALET_KGS	float	8	53	0	False		False	False
PALET_VOL	float	8	53	0	False		False	False
CTN_URUT	varchar	50	0	0	False		False	False
GSP	varchar	50	0	0	False		False	False
QTY_BOX_AF	int	4	10	0	False		False	False
CTN_NO	int	4	10	0	False		False	False
L_MONTH_ACT	int	4	10	0	False		False	False
CUST_CODE	varchar	50	0	0	False		False	False
BOTTOM	int	4	10	0	False		False	False
TOP	int	4	10	0	False		False	False
LSEGI3	int	4	10	0	False		False	False
LSEGI4	int	4	10	0	False		False	False
LSEGI7	int	4	10	0	False		False	False
LSEGI8	int	4	10	0	False		False	False
LKERTAS	int	4	10	0	False		False	False
LINNING	int	4	10	0	False		False	False
GRP	int	4	10	0	False		False	False
GR3000	int	4	10	0	False		False	False
LDCUT	int	4	10	0	False		False	False
TOPDALAM	int	4	10	0	False		False	False
LINNINGSPCA	int	4	10	0	False		False	False
LINNINGSPCB	int	4	10	0	False		False	False
TYPE	varchar	50	0	0	False		False	False
DESIGN_CHANGE	varchar	50	0	0	False		False	False
DESC_ASSY	varchar	100	0	0	False		False	False
GENDATE_PLIST	datetime	8	23	3	False		False	False
PRICE_LSEGI3	float	8	53	0	False		False	False
PRICE_LSEGI4	float	8	53	0	False		False	False
PRICE_LSEGI7	float	8	53	0	False		False	False
PRICE_LSEGI8	float	8	53	0	False		False	False
PRICE_LABEL	float	8	53	0	False		False	False
PRICE_STICKER	float	8	53	0	False		False	False
PRICE_LINNING	float	8	53	0	False		False	False
LABEL	varchar	50	0	0	False		False	False
STICKER	int	4	10	0	False		False	False
PRICE2	float	8	53	0	False		False	False
FBP	int	4	10	0	False		False	False
PRICE_TOP	float	8	53	0	False		False	False
PRICE_BOTTOM	float	8	53	0	False		False	False
PRICE_GRP	float	8	53	0	False		False	False
PRICE_TOPDALAM	float	8	53	0	False		False	False
PRICE_LINNINGSPCA	float	8	53	0	False		False	False
PRICE_LINNINGSPCB	float	8	53	0	False		False	False
PRICE_FBP	float	8	53	0	False		False	False
CTN_BOX	int	4	10	0	False		False	False
PRICE_CTN_BOX	float	8	53	0	False		False	False
FLAG_PACKING	varchar	50	0	0	False		False	False
FOB	float	8	53	0	False		False	False
FOBN	float	8	53	0	False		False	False
COSTING	float	8	53	0	False		False	False
COSTINGN	varchar	50	0	0	False		False	False
BOTTOM_AF	int	4	10	0	False		False	False
TOP_AF	int	4	10	0	False		False	False
LSEGI3_AF	int	4	10	0	False		False	False
LSEGI4_AF	int	4	10	0	False		False	False
LSEGI7_AF	varchar	50	0	0	False		False	False
LSEGI8_AF	int	4	10	0	False		False	False
LINNING_AF	int	4	10	0	False		False	False
GRP_AF	int	4	10	0	False		False	False
FBP_AF	int	4	10	0	False		False	False
TOPDALAM_AF	int	4	10	0	False		False	False
LINNINGSPCA_AF	int	4	10	0	False		False	False
LINNINGSPCB_AF	int	4	10	0	False		False	False
CTN_TYPE_AF	varchar	50	0	0	False		False	False
LABEL_AF	int	4	10	0	False		False	False
STICKER_AF	int	4	10	0	False		False	False
CTN_BOX_AF	int	4	10	0	False		False	False
STATUS	varchar	50	0	0	False		False	False
PRICE_LSEGI3_2	float	8	53	0	False		False	False
PRICE_LSEGI4_2	float	8	53	0	False		False	False
PRICE_LSEGI7_2	float	8	53	0	False		False	False
PRICE_LSEGI8_2	float	8	53	0	False		False	False
PRICE_LABEL_2	float	8	53	0	False		False	False
PRICE_STICKER_2	float	8	53	0	False		False	False
PRICE_LINNING_2	float	8	53	0	False		False	False
PRICE_TOP_2	float	8	53	0	False		False	False
PRICE_BOTTOM_2	float	8	53	0	False		False	False
PRICE_GRP_2	float	8	53	0	False		False	False
PRICE_TOPDALAM_2	float	8	53	0	False		False	False
PRICE_LINNINGSPCA_2	float	8	53	0	False		False	False
PRICE_LINNINGSPCB_2	float	8	53	0	False		False	False
PRICE_FBP_2	float	8	53	0	False		False	False
PRICE_CTN_BOX_2	float	8	53	0	False		False	False
CELL_DEVIDERA	int	4	10	0	False		False	False
CELL_DEVIDERB	int	4	10	0	False		False	False
LSEGI3A	int	4	10	0	False		False	False
LSEGI3B	int	4	10	0	False		False	False
CELL_DEVIDERA_AF	int	4	10	0	False		False	False
CELL_DEVIDERB_AF	int	4	10	0	False		False	False
LSEGI3A_AF	int	4	10	0	False		False	False
LSEGI3B_AF	int	4	10	0	False		False	False
PRICE_LSEGI3A	float	8	53	0	False		False	False
PRICE_LSEGI3B	float	8	53	0	False		False	False
PRICE_CELL_DEVIDERA	float	8	53	0	False		False	False
PRICE_CELL_DEVIDERB	float	8	53	0	False		False	False
PRICE_LSEGI3A_2	float	8	53	0	False		False	False
PRICE_LSEGI3B_2	float	8	53	0	False		False	False
PRICE_CELL_DEVIDERA_2	float	8	53	0	False		False	False
PRICE_CELL_DEVIDERB_2	float	8	53	0	False		False	False
TYPE_PALLET	varchar	50	0	0	False		False	False
DATE_UMH	datetime	8	23	3	False		False	False
DATE_UMHN	datetime	8	23	3	False		False	False
DATE_PART	datetime	8	23	3	False		False	False
CUST_PNO1	varchar	50	0	0	False		False	False
filename	varchar	500	0	0	False		False	False
dateexec	datetime	8	23	3	False		False	False
status_aktif	varchar	50	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	ix_auto_tbl_assy_list_20161019_0001	ASSY_NO	False
	ix_auto_tbl_assy_list_20161019_0002	status_aktif	False

SQL Script

CREATE TABLE dbo.tbl_assy_list (
  id_assy_list bigint IDENTITY,
  ASSY_CODE varchar(50) NULL,
  ASSY_NO varchar(50) NULL,
  LINE_NO int NULL,
  CUT_PCS int NULL,
  CRIMP_PCS int NULL,
  JOINT_PCS int NULL,
  CUT_SHLD int NULL,
  CRIMP_SHLD int NULL,
  JOINT_SHLD int NULL,
  ASSY_UMH float NULL,
  ASSY_UMHN float NULL,
  ACTIVESTAT varchar(50) NULL,
  L_MONTH_QTY int NULL,
  FLAG_VALIDATE_PLIST datetime NULL,
  DESC_CARLINE varchar(50) NULL,
  CONV_DATE datetime NULL,
  CCT int NULL,
  CRIMP_ACCS int NULL,
  CRIMP_DBL int NULL,
  CUT_TUBE int NULL,
  JOINT_BCHL int NULL,
  MOULDING int NULL,
  WOS varchar(50) NULL,
  LOADING_LINE varchar(50) NULL,
  HISTORY_CLINE1 varchar(50) NULL,
  HISTORY_CLINE2 varchar(50) NULL,
  HISTORY_CLINE3 varchar(50) NULL,
  PREV_CODE varchar(50) NULL,
  CUST_KEY varchar(50) NULL,
  PREVSTAT varchar(50) NULL,
  ASSY_NO1 varchar(50) NULL,
  QTY_BOX int NULL,
  QTY_SET int NULL,
  IF_ORDER_QTY int NULL,
  STOCK_MIN_P int NULL,
  STOCK_MINQTY int NULL,
  NON_GSP varchar(50) NULL,
  AIR_BAG varchar(50) NULL,
  GROUPCODE varchar(50) NULL,
  PACKSTD_SF varchar(50) NULL,
  PACKSTD_AF varchar(50) NULL,
  CTN_TYPE varchar(50) NULL,
  QTYBOX_SF int NULL,
  QTYBOX_AF int NULL,
  PRICE float NULL,
  NET_KGS float NULL,
  GROSS_KGS float NULL,
  VOL float NULL,
  CUMM float NULL,
  CTN_TYPE_ME varchar(50) NULL,
  CTN_KGS_SF float NULL,
  CTN_KGS_AF float NULL,
  CTN_VOL_SF float NULL,
  CTN_VOL_AF float NULL,
  PALET_KGS float NULL,
  PALET_VOL float NULL,
  CTN_URUT varchar(50) NULL,
  GSP varchar(50) NULL,
  QTY_BOX_AF int NULL,
  CTN_NO int NULL,
  L_MONTH_ACT int NULL,
  CUST_CODE varchar(50) NULL,
  BOTTOM int NULL,
  [TOP] int NULL,
  LSEGI3 int NULL,
  LSEGI4 int NULL,
  LSEGI7 int NULL,
  LSEGI8 int NULL,
  LKERTAS int NULL,
  LINNING int NULL,
  GRP int NULL,
  GR3000 int NULL,
  LDCUT int NULL,
  TOPDALAM int NULL,
  LINNINGSPCA int NULL,
  LINNINGSPCB int NULL,
  TYPE varchar(50) NULL,
  DESIGN_CHANGE varchar(50) NULL,
  DESC_ASSY varchar(100) NULL,
  GENDATE_PLIST datetime NULL,
  PRICE_LSEGI3 float NULL,
  PRICE_LSEGI4 float NULL,
  PRICE_LSEGI7 float NULL,
  PRICE_LSEGI8 float NULL,
  PRICE_LABEL float NULL,
  PRICE_STICKER float NULL,
  PRICE_LINNING float NULL,
  LABEL varchar(50) NULL,
  STICKER int NULL,
  PRICE2 float NULL,
  FBP int NULL,
  PRICE_TOP float NULL,
  PRICE_BOTTOM float NULL,
  PRICE_GRP float NULL,
  PRICE_TOPDALAM float NULL,
  PRICE_LINNINGSPCA float NULL,
  PRICE_LINNINGSPCB float NULL,
  PRICE_FBP float NULL,
  CTN_BOX int NULL,
  PRICE_CTN_BOX float NULL,
  FLAG_PACKING varchar(50) NULL,
  FOB float NULL,
  FOBN float NULL,
  COSTING float NULL,
  COSTINGN varchar(50) NULL,
  BOTTOM_AF int NULL,
  TOP_AF int NULL,
  LSEGI3_AF int NULL,
  LSEGI4_AF int NULL,
  LSEGI7_AF varchar(50) NULL,
  LSEGI8_AF int NULL,
  LINNING_AF int NULL,
  GRP_AF int NULL,
  FBP_AF int NULL,
  TOPDALAM_AF int NULL,
  LINNINGSPCA_AF int NULL,
  LINNINGSPCB_AF int NULL,
  CTN_TYPE_AF varchar(50) NULL,
  LABEL_AF int NULL,
  STICKER_AF int NULL,
  CTN_BOX_AF int NULL,
  STATUS varchar(50) NULL,
  PRICE_LSEGI3_2 float NULL,
  PRICE_LSEGI4_2 float NULL,
  PRICE_LSEGI7_2 float NULL,
  PRICE_LSEGI8_2 float NULL,
  PRICE_LABEL_2 float NULL,
  PRICE_STICKER_2 float NULL,
  PRICE_LINNING_2 float NULL,
  PRICE_TOP_2 float NULL,
  PRICE_BOTTOM_2 float NULL,
  PRICE_GRP_2 float NULL,
  PRICE_TOPDALAM_2 float NULL,
  PRICE_LINNINGSPCA_2 float NULL,
  PRICE_LINNINGSPCB_2 float NULL,
  PRICE_FBP_2 float NULL,
  PRICE_CTN_BOX_2 float NULL,
  CELL_DEVIDERA int NULL,
  CELL_DEVIDERB int NULL,
  LSEGI3A int NULL,
  LSEGI3B int NULL,
  CELL_DEVIDERA_AF int NULL,
  CELL_DEVIDERB_AF int NULL,
  LSEGI3A_AF int NULL,
  LSEGI3B_AF int NULL,
  PRICE_LSEGI3A float NULL,
  PRICE_LSEGI3B float NULL,
  PRICE_CELL_DEVIDERA float NULL,
  PRICE_CELL_DEVIDERB float NULL,
  PRICE_LSEGI3A_2 float NULL,
  PRICE_LSEGI3B_2 float NULL,
  PRICE_CELL_DEVIDERA_2 float NULL,
  PRICE_CELL_DEVIDERB_2 float NULL,
  TYPE_PALLET varchar(50) NULL,
  DATE_UMH datetime NULL,
  DATE_UMHN datetime NULL,
  DATE_PART datetime NULL,
  CUST_PNO1 varchar(50) NULL,
  filename varchar(500) NULL,
  dateexec datetime NULL,
  status_aktif varchar(50) NULL
)
ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_assy_list_20161019_0001
  ON dbo.tbl_assy_list (ASSY_NO)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX ix_auto_tbl_assy_list_20161019_0002
  ON dbo.tbl_assy_list (status_aktif)
  INCLUDE (ASSY_CODE, ASSY_NO)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_assy_list