A little difficult to currently (not in the office or on a PC!!) I'll give it a shot...forgive any syntax errors!

So DimOrder is snowflakes to DimProduct and this is a condensed amount fields:

Create table DimOrder

(DimOrderKey int identity(1,1),

DimProductKey int,

DimOrderDateKey int,

DimOrderProcessed int,

DimOrderDispatchedKey int,

OrderType varchar(10),

DateRowStart datetime,

DateRowEnd date time,

IsRowCurrent bit)

Create table FactAccumSnapshot

(DimOrderKey int,

DimOrderDateKey int

,DimOrderProcessedDateKey int,

OrderDateToProcessLag int,

AmountPaidToDate money,

LastPaymentAmount money,

DimLastPaymentDateKey int)

The date keys are all based on role playing view back to dim date