CREATE TABLE [bi].[Fact_LocationProductDailyStockStatsPart-III_January10]
(
	[Product_Skey] [int] NULL,
	[Location_Skey] [int] NULL,
	[LocationCode] [nvarchar](4) NOT NULL,
	[DateId] [int] NOT NULL,
	[GenericCode] [nvarchar](18) NOT NULL,
	[MaterialCode] [nvarchar](18) NOT NULL,
	[StockQuantity] [decimal](18, 2) NULL,
	[StockAmount] [decimal](18, 2) NULL,
	[ActualStockQuantity] [decimal](18, 2) NULL,
	[ActualStockAmount] [decimal](18, 2) NULL,
	[StockAmountTR] [decimal](18, 2) NULL,
	[ActualStockAmountTR] [decimal](18, 2) NULL,
	[LocationCurrency] [nvarchar](5) NULL,
	[IsOutlet] [smallint] NULL,
	[SeasonGroupId] [smallint] NULL
)
WITH
(
	DISTRIBUTION = HASH ( [Product_Skey] ),
	CLUSTERED COLUMNSTORE INDEX,
	PARTITION ( DateId  RANGE LEFT FOR VALUES
    (  
    20200101
    ,20200113
,20200127
,20200210
,20200224
,20200309
,20200323
,20200406
,20200420
,20200504
,20200518
,20200601
,20200615
,20200629
,20200713
,20200727
,20200810
,20200824
,20200907
,20200921
,20201005
,20201019
,20201102
,20201116
,20201130
,20201214
,20201228
,20210111
,20210125
,20210208
,20210222
,20210308
,20210322
,20210405
,20210419
,20210503
,20210517
,20210531
,20210614
,20210628
,20210712
,20210726
,20210809
,20210823
,20210906
,20210920
,20211004
,20211018
,20211101
,20211115
,20211129
,20211213
,20211227
,20220110
,20220124
,20220207
,20220221
,20220307
,20220321
,20220404
,20220418
,20220502
,20220516
,20220530
,20220613
,20220627
,20220711
,20220725
,20220808
,20220822
,20220905
,20220919
,20221003
,20221017
,20221031
,20221114
,20221128
,20221212
,20221226
,20230109
    ))
)