Index: DB_PROJ_PDW_INVENTORY.sqlproj =================================================================== diff -u -ra8c24e14297a008474719dcb2bcbb8410e8c48a9 -r30ce2eac2f83325d1544d4d80653dd958efc7674 --- DB_PROJ_PDW_INVENTORY.sqlproj (.../DB_PROJ_PDW_INVENTORY.sqlproj) (revision a8c24e14297a008474719dcb2bcbb8410e8c48a9) +++ DB_PROJ_PDW_INVENTORY.sqlproj (.../DB_PROJ_PDW_INVENTORY.sqlproj) (revision 30ce2eac2f83325d1544d4d80653dd958efc7674) @@ -85,18 +85,22 @@ - - DB_PROJ_Master - {6f85db52-d291-4de7-969e-1c03ebfd37fd} - True - False - DB_PROJ_Master - - - + + master + $(SqlCmdVar__2) + DB_PROJ_Master $(SqlCmdVar__1) + + + DB_PROJ_DWH_MASTER + {6f85db52-d291-4de7-969e-1c03ebfd37fd} + True + True + DB_PROJ_DWH_MASTER + + \ No newline at end of file Index: dbo/Tables/factInventoryMonthly.sql =================================================================== diff -u -ra8c24e14297a008474719dcb2bcbb8410e8c48a9 -r30ce2eac2f83325d1544d4d80653dd958efc7674 --- dbo/Tables/factInventoryMonthly.sql (.../factInventoryMonthly.sql) (revision a8c24e14297a008474719dcb2bcbb8410e8c48a9) +++ dbo/Tables/factInventoryMonthly.sql (.../factInventoryMonthly.sql) (revision 30ce2eac2f83325d1544d4d80653dd958efc7674) @@ -12,8 +12,6 @@ [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) );