Index: dbo/Tables/factInventoryMonthly.sql =================================================================== diff -u -r30ce2eac2f83325d1544d4d80653dd958efc7674 -r317a98961af5de4c35affa7ca07eab67e4dc0265 --- dbo/Tables/factInventoryMonthly.sql (.../factInventoryMonthly.sql) (revision 30ce2eac2f83325d1544d4d80653dd958efc7674) +++ dbo/Tables/factInventoryMonthly.sql (.../factInventoryMonthly.sql) (revision 317a98961af5de4c35affa7ca07eab67e4dc0265) @@ -12,6 +12,8 @@ [OnOrderCost] DECIMAL (11, 2) NOT NULL, [ReservedQty] INT NOT NULL, [ReservedCost] DECIMAL (11, 2) NOT NULL, + [TransitQty] INT NULL, + [TransitCost] DECIMAL (11, 2) NULL, CONSTRAINT [factInventoryMonthly_PK] PRIMARY KEY NONCLUSTERED ([InventoryID] ASC), CONSTRAINT [factInventoryMonthly_UNIQ] UNIQUE CLUSTERED ([InventoryDateID] ASC, [ItemID] ASC, [WarehouseCode] ASC) );