dbo.tbl_item

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 (~)	27023
Created	1/12/2013 20:13:43
Last Modified	1/12/2013 20:39:02

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_item_list	bigint	8	19	0	True	1 - 1	False	False
PART_NO	varchar	100	0	0	False		False	False
PART_NAME	varchar	100	0	0	False		False	False
CUST_PNO	varchar	100	0	0	False		False	False
CUST_NAME	varchar	100	0	0	False		False	False
SUPP_PNO	varchar	100	0	0	False		False	False
SUPP_CODE	bigint	8	19	0	False		False	False
PCT_SUP	bigint	8	19	0	False		False	False
BAL_FAC	float	8	53	0	False		False	False
WEIGTH	float	8	53	0	False		False	False
ASS_STAGE	varchar	10	0	0	False		False	False
MIN_PACK	float	8	53	0	False		False	False
UNIT	varchar	10	0	0	False		False	False
CURRENCY	varchar	10	0	0	False		False	False
WASTE	float	8	53	0	False		False	False
ORG_CTRY	varchar	50	0	0	False		False	False
SUPP_STAT	varchar	5	0	0	False		False	False
CLASS	varchar	55	0	0	False		False	False
LOCATION	varchar	50	0	0	False		False	False
MIN_ORDQTY	float	8	53	0	False		False	False
BEG_BAL	float	8	53	0	False		False	False
TOTAL_IN	float	8	53	0	False		False	False
TOTAL_OUT	float	8	53	0	False		False	False
CUMM_REQ	float	8	53	0	False		False	False
CUMM_IN	float	8	53	0	False		False	False
PART_CODE	varchar	50	0	0	False		False	False
QTY1BOXROL	float	8	53	0	False		False	False
QTY1PALLET	float	8	53	0	False		False	False
FOB	float	8	53	0	False		False	False
CIF	float	8	53	0	False		False	False
FOBNI	float	8	53	0	False		False	False
CIFNI	float	8	53	0	False		False	False
QUOTEFOB	float	8	53	0	False		False	False
QUOTECIF	float	8	53	0	False		False	False
QUOTEFOBNI	float	8	53	0	False		False	False
QUOTECIFNI	float	8	53	0	False		False	False
QUOTE_CURR	float	8	53	0	False		False	False
NFOB	float	8	53	0	False		False	False
NCIF	float	8	53	0	False		False	False
NFOBNI	float	8	53	0	False		False	False
NCIFNI	float	8	53	0	False		False	False
NQUOTEFOB	float	8	53	0	False		False	False
NQUOTECIF	float	8	53	0	False		False	False
NQUOTEFOBNI	float	8	53	0	False		False	False
NQUOTECIFNI	float	8	53	0	False		False	False
FINAL_PRE	varchar	50	0	0	False		False	False
PARTNO2	varchar	50	0	0	False		False	False
PERIODE	varchar	50	0	0	False		False	False
PERIODE1	varchar	50	0	0	False		False	False
PRICE	float	8	53	0	False		False	False
SUPP_NAME	varchar	100	0	0	False		False	False
AMOUNT	float	8	53	0	False		False	False
COST	float	8	53	0	False		False	False
FREIGHT	float	8	53	0	False		False	False
INVOICE	float	8	53	0	False		False	False
FLAG	varchar	50	0	0	False		False	False
NFLAG	varchar	50	0	0	False		False	False
MAKER_CODE	varchar	50	0	0	False		False	False
RACK_LOC	varchar	50	0	0	False		False	False
CREATED_BY	varchar	50	0	0	False		False	False
CREATED_DATE	datetime	8	23	3	False		False	False
MODIFIED_BY	varchar	50	0	0	False		False	False
MODIFIED_DATE	datetime	8	23	3	False		False	False
NON_GSP_STATUS	varchar	50	0	0	False		False	False
COMODITY_CODE	varchar	50	0	0	False		False	False
PARTNO3	varchar	50	0	0	False		False	False
filename	varchar	255	0	0	False		False	False
execdate	datetime	8	23	3	False		False	False

SQL Script

CREATE TABLE dbo.tbl_item_list (
  id_item_list bigint IDENTITY,
  PART_NO varchar(100) NULL,
  PART_NAME varchar(100) NULL,
  CUST_PNO varchar(100) NULL,
  CUST_NAME varchar(100) NULL,
  SUPP_PNO varchar(100) NULL,
  SUPP_CODE bigint NULL,
  PCT_SUP bigint NULL,
  BAL_FAC float NULL,
  WEIGTH float NULL,
  ASS_STAGE varchar(10) NULL,
  MIN_PACK float NULL,
  UNIT varchar(10) NULL,
  CURRENCY varchar(10) NULL,
  WASTE float NULL,
  ORG_CTRY varchar(50) NULL,
  SUPP_STAT varchar(5) NULL,
  CLASS varchar(55) NULL,
  LOCATION varchar(50) NULL,
  MIN_ORDQTY float NULL,
  BEG_BAL float NULL,
  TOTAL_IN float NULL,
  TOTAL_OUT float NULL,
  CUMM_REQ float NULL,
  CUMM_IN float NULL,
  PART_CODE varchar(50) NULL,
  QTY1BOXROL float NULL,
  QTY1PALLET float NULL,
  FOB float NULL,
  CIF float NULL,
  FOBNI float NULL,
  CIFNI float NULL,
  QUOTEFOB float NULL,
  QUOTECIF float NULL,
  QUOTEFOBNI float NULL,
  QUOTECIFNI float NULL,
  QUOTE_CURR float NULL,
  NFOB float NULL,
  NCIF float NULL,
  NFOBNI float NULL,
  NCIFNI float NULL,
  NQUOTEFOB float NULL,
  NQUOTECIF float NULL,
  NQUOTEFOBNI float NULL,
  NQUOTECIFNI float NULL,
  FINAL_PRE varchar(50) NULL,
  PARTNO2 varchar(50) NULL,
  PERIODE varchar(50) NULL,
  PERIODE1 varchar(50) NULL,
  PRICE float NULL,
  SUPP_NAME varchar(100) NULL,
  AMOUNT float NULL,
  COST float NULL,
  FREIGHT float NULL,
  INVOICE float NULL,
  FLAG varchar(50) NULL,
  NFLAG varchar(50) NULL,
  MAKER_CODE varchar(50) NULL,
  RACK_LOC varchar(50) NULL,
  CREATED_BY varchar(50) NULL,
  CREATED_DATE datetime NULL,
  MODIFIED_BY varchar(50) NULL,
  MODIFIED_DATE datetime NULL,
  NON_GSP_STATUS varchar(50) NULL,
  COMODITY_CODE varchar(50) NULL,
  PARTNO3 varchar(50) NULL,
  filename varchar(255) NULL,
  execdate datetime NULL
)
ON [PRIMARY]
GO

Depends On

No items found

dbo.tbl_item_list

Description

Properties

Columns

SQL Script

Depends On

Used By