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)
);