CREATE TABLE DIMEN_VEND(
	DUNS_NBR varchar(17) NOT NULL,
	COMM_VEND_NM varchar(70) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE REF_VEND_STAT(
	VEND_STAT_ID varchar(8) NOT NULL,
	VEND_NM varchar(70) NOT NULL,
	DUNS_NBR varchar(17) NOT NULL,
	COMPL_PROF_DT datetime NULL,
	UTC_COMPL_DT datetime NULL,
	PRD_LIAB_INS_DT datetime NULL,
	TRD_PMNT_DT datetime NULL,
	CDE_OF_BUS_DT datetime NULL,
	ENTRY_DT datetime NULL,
	BUYER_NM varchar(70) NULL,
	INTL_EMAIL_ID varchar(20) NULL,
	BUYER_EMAIL_ID varchar(20) NULL,
	CNTCT_NM varchar(70) NULL,
	CNTCT_EMAIL varchar(100) NULL,
	CNTCT_PHONE varchar(20) NULL,
	VEND_SUPP_NM varchar(70) NULL,
	VEND_SUPP_ID varchar(20) NULL,
	RQST_TYP_CD char(1) NULL,
	DVSN_DESC varchar(500) NULL,
	FLOW_PATH varchar(500) NULL,
	CMNT varchar(1000) NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE DIMEN_VP(
	VP_ID int NOT NULL,
	KSN_ID int NOT NULL,
	PROJ_FST_IN_STR_DT datetime NULL,
	DUNS_NBR varchar(17) NULL,
	VEND_NM varchar(35) NULL,
	VEND_ORD_DUNS varchar(17) NULL,
	VEND_STK_NBR varchar(17) NULL,
	OWNER_CD char(1) NULL,
	COST decimal(11, 4) NULL,
	SARM_ID int NULL,
	FLOW_TYPE varchar(4) NULL,
	IMPRT_CD char(1) NULL,
	SHIP_GTIN decimal(14, 0) NULL,
	CRTN_HT decimal(7, 2) NULL,
	CRTN_LGTH decimal(7, 2) NULL,
	CRTN_WDTH decimal(7, 2) NULL,
	CRTN_WT decimal(9, 2) NULL,
	CRTN_CBE decimal(10, 2) NULL,
	TOT_EACHES_QTY int NULL,
	EACH_PER_INNER_QTY int NULL,
	NBR_OF_INNERS int NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_SRS_HIER(
	IV_SRS_HIER_ID int  NOT NULL,
	SRS_DVSN int NULL,
	SRS_LN int NULL,
	SRS_SUB_LN int NULL,
	SRS_CLS int NULL,
	SRS_ITM_NBR int NULL,
	SRS_SKU_NBR int NULL,
	SRS_DIV_DESC varchar(25) NULL,
	SRS_SUB_LN_DESC varchar(25) NULL,
	SRS_LN_DESC varchar(25) NULL,
	SRS_CLS_DESC varchar(25) NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_KSN_ATTR_VALU(
	VALU_ID int  NOT NULL,
	ATTR_ID int NOT NULL,
	SUB_ATTR_ID int NOT NULL,
	VALU_NM varchar(25) NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_SHC_HIER(
	IV_SHC_HIER_ID int  NOT NULL,
	SHC_ITEM_ID int NULL,
	SHC_DVSN int NULL,
	SHC_CATG int NULL,
	SHC_SUB_CATG int NULL,
	SHC_DVSN_DESC varchar(100) NULL,
	SHC_CATG_DESC varchar(100) NULL,
	SHC_SUB_CATG_DESC varchar(100) NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_KSN_ATTR(
	ATTR_ID int NOT NULL,
	ATTR_NM varchar(30) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE REF_KSN_ATTR_VALU(
	KSN_ID int NOT NULL,
	ATTR_ID int NOT NULL,
	SUB_ATTR_ID int NOT NULL,
	VALU_ID int NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE FACT_VP_ST(
	VP_ID int NOT NULL,
	ST_ID int NOT NULL,
	START_DT datetime NOT NULL,
	END_DT datetime NULL,
	STAT_CD char(1) NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_PURCH_STAT(
	PURCH_STAT char(1) NOT NULL,
	PURCH_STAT_DESC varchar(50) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_SEAS(
	SEAS_CD smallint NOT NULL,
	SEAS_DESC varchar(40) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_NETWORK_DISTRB(
	NETWORK_DISTRB_CD varchar(4) NOT NULL,
	NETWORK_DISTRB_DESC varchar(50) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_OWNER(
	OWNER_CD char(1) NOT NULL,
	OWNER_DESC varchar(40) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_IMPRT(
	IMPRT_CD char(1) NOT NULL,
	IMPRT_DESC varchar(40) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_UOM(
	UOM_CD varchar(4) NOT NULL,
	UOM_DESC varchar(50) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE ETL_FEED_MSTR(
	ETL_RUN_NBR int  NOT NULL,
	RUN_DT datetime NULL,
	RUN_STAT varchar(25) NULL
) 
;
CREATE TABLE LU_MDL(
	MDL_ID int NOT NULL,
	MDL_DESC varchar(240) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_RETL_GTIN_FMT(
	RETL_GTIN_FMT_CD char(1) NOT NULL,
	RETL_GTIN_FMT_DESC varchar(50) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE DIMEN_KSN(
	KSN_ID int NOT NULL,
	IV_SRS_HIER_ID int NULL,
	IV_SHC_HIER_ID int NULL,
	PURCH_STAT char(1) NULL,
	CORE_DESC varchar(25) NULL,
	CAN_CARR_MDL_ID int NULL,
	NETWORK_DISTRB_CD varchar(4) NULL,
	DFLT_SELL_PRC int NULL,
	SEM_DESC varchar(40) NULL,
	LE_SKU_NBR varchar(8) NULL,
	SEAS_CD smallint NULL,
	SUB_SEAS_ID smallint NULL,
	SEAS_YR_NBR int NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE DIMEN_PKG(
	PKG_ID int NOT NULL,
	RETL_GTIN decimal(14, 0) NULL,
	VP_ID int NOT NULL,
	RETL_GTIN_FMT_CD char(1) NULL,
	BRND_DESC varchar(40) NULL,
	BRND_ABBR varchar(4) NULL,
	BRND_VALU varchar(40) NULL,
	PROD_HT decimal(7, 2) NULL,
	PROD_LGTH decimal(7, 2) NULL,
	PROD_WDTH decimal(7, 2) NULL,
	PROD_WT decimal(9, 2) NULL,
	PROD_CBE decimal(10, 2) NULL,
	UOM_CD varchar(4) NULL,
	UOM_QTY decimal(8, 4) NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE LU_KSN_SUB_ATTR(
	ATTR_ID int NOT NULL,
	SUB_ATTR_ID int NOT NULL,
	SUB_ATTR_NM varchar(30) NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE DIMEN_ROLE(
	ROLE_ID int NOT NULL,
	ROLE_NM varchar(50) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE DIMEN_ST(
	ST_ID int NOT NULL,
	ROLE_ID int NOT NULL  DEFAULT 0,
	ST_DESC varchar(80) NOT NULL,
	ETL_ISRT int NULL,
	ETL_CHG int NULL
) 
;
CREATE TABLE ETL_DIMEN_ROLE(
	ROLE_ID int NOT NULL,
	ROLE_SEQ int NULL,
	ROLE_NM varchar(50) NULL,
	ROLE_TYPE varchar(50) NULL
) 
;