8
4/11/2016 10:39:10 AM
0
4/13/2016 11:25:23 AM
0
[Integration].[City_Staging]
1252
false
3
false
false
CHECK_CONSTRAINTS
2147483647
0
EXEC Integration.GetCityUpdates ?, ?
WITH RESULT SETS
(
(
[WWI City ID] int,
City nvarchar(50),
[State Province] nvarchar(50),
Country nvarchar(50),
Continent nvarchar(30),
[Sales Territory] nvarchar(50),
Region nvarchar(30),
Subregion nvarchar(30),
[Location] geography,
[Latest Recorded Population] bigint,
[Valid From] datetime2(7),
[Valid To] datetime2(7)
)
);
1252
false
2
"@LastCutoff:Input",{60BD9010-4784-49A6-8FF2-340D7AB3B70D};"@NewCutoff:Input",{B96D08A3-EC4E-45C1-8E78-526920753C6B};
0
[Integration].[Customer_Staging]
1252
false
3
false
false
CHECK_CONSTRAINTS
2147483647
0
EXEC Integration.GetCustomerUpdates ?, ?
WITH RESULT SETS
(
(
[WWI Customer ID] int,
Customer nvarchar(100),
[Bill To Customer] nvarchar(100),
Category nvarchar(50),
[Buying Group] nvarchar(50),
[Primary Contact] nvarchar(50),
[Postal Code] nvarchar(10),
[Valid From] datetime2(7),
[Valid To] datetime2(7)
)
);
1252
false
2
"@LastCutoff:Input",{60BD9010-4784-49A6-8FF2-340D7AB3B70D};"@NewCutoff:Input",{B96D08A3-EC4E-45C1-8E78-526920753C6B};
0
[Integration].[Employee_Staging]
1252
false
3
false
false
CHECK_CONSTRAINTS
2147483647
0
EXEC Integration.GetEmployeeUpdates ?, ?
WITH RESULT SETS
(
(
[WWI Employee ID] int,
Employee nvarchar(50),
[Preferred Name] nvarchar(50),
[Is Salesperson] bit,
Photo varbinary(max),
[Valid From] datetime2(7),
[Valid To] datetime2(7)
)
);
1252
false
2
"@LastCutoff:Input",{60BD9010-4784-49A6-8FF2-340D7AB3B70D};"@NewCutoff:Input",{B96D08A3-EC4E-45C1-8E78-526920753C6B};
0
EXEC Integration.GetMovementUpdates ?, ?
WITH RESULT SETS
(
(
[Date Key] date,
[WWI Stock Item Transaction ID] int,
[WWI Invoice ID] int,
[WWI Purchase Order ID] int,
[Quantity] int,
[WWI Stock Item ID] int,
[WWI Customer ID] int,
[WWI Supplier ID] int,
[WWI Transaction Type ID] int,
[Last Modified When] datetime2(7)
)
);
1252
false
2
"@LastCutoff:Input",{60BD9010-4784-49A6-8FF2-340D7AB3B70D};"@NewCutoff:Input",{B96D08A3-EC4E-45C1-8E78-526920753C6B};
0
[Integration].[Movement_Staging]
1252
false
3
false
false
CHECK_CONSTRAINTS
2147483647
0
EXEC Integration.GetOrderUpdates ?, ?
WITH RESULT SETS
(
(
[Order Date Key] date,
[Picked Date Key] date,
[WWI Order ID] int,
[WWI Backorder ID] int,
[Description] nvarchar(100),
[Package] nvarchar(50),
Quantity int,
[Unit Price] decimal(18,2),
[Tax Rate] decimal(18,3),
[Total Excluding Tax] decimal(18,2),
[Tax Amount] decimal(18,2),
[Total Including Tax] decimal(18,2),
[WWI City ID] int,
[WWI Customer ID] int,
[WWI Stock Item ID] int,
[WWI Salesperson ID] int,
[WWI Picker ID] int,
[Last Modified When] datetime2(7)
)
);
1252
false
2
"@LastCutoff:Input",{60BD9010-4784-49A6-8FF2-340D7AB3B70D};"@NewCutoff:Input",{B96D08A3-EC4E-45C1-8E78-526920753C6B};
0
[Integration].[Order_Staging]
1252
false
3
false
false
CHECK_CONSTRAINTS
2147483647
0
EXEC Integration.GetPaymentMethodUpdates ?, ?
WITH RESULT SETS
(
(
[WWI Payment Method ID] int,
[Payment Method] nvarchar(50),
[Valid From] datetime2(7),
[Valid To] datetime2(7)
)
);
1252
false
2
"@LastCutoff:Input",{60BD9010-4784-49A6-8FF2-340D7AB3B70D};"@NewCutoff:Input",{B96D08A3-EC4E-45C1-8E78-526920753C6B};
0
[Integration].[PaymentMethod_Staging]
1252
false
3
false
false
CHECK_CONSTRAINTS
2147483647
0
EXEC Integration.GetPurchaseUpdates ?, ?
WITH RESULT SETS
(
(
[Date Key] date,
[WWI Purchase Order ID] int,
[Ordered Outers] int,
[Ordered Quantity] int,
[Received Outers] int,
[Package] nvarchar(50),
[Is Order Line Finalized] bit,
[WWI Supplier ID] int,
[WWI Stock Item ID] int,
[Last Modified When] datetime2(7)
)
);
1252
false
2
"@LastCutoff:Input",{60BD9010-4784-49A6-8FF2-340D7AB3B70D};"@NewCutoff:Input",{B96D08A3-EC4E-45C1-8E78-526920753C6B};
0
[Integration].[Purchase_Staging]
1252
false
3
false
false
CHECK_CONSTRAINTS
2147483647
0
EXEC Integration.GetSaleUpdates ?, ?
WITH RESULT SETS
(
(
[Invoice Date Key] date,
[Delivery Date Key] date,
[WWI Invoice ID] int,
[Description] nvarchar(100),
[Package] nvarchar(50),
[Quantity] int,
[Unit Price] decimal(18,2),
[Tax Rate] decimal(18,3),
[Total Excluding Tax] decimal(18,2),
[Tax Amount] decimal(18,2),
[Profit] decimal(18,2),
[Total Including Tax] decimal(18,2),
[Total Dry Items] int,
[Total Chiller Items] int,
[WWI City ID] int,
[WWI Customer ID] int,
[WWI Bill To Customer ID] int,
[WWI Stock Item ID] int,
[WWI Salesperson ID] int,
[Last Modified When] datetime2(7)
)
);
1252
false
2
"@LastCutoff:Input",{60BD9010-4784-49A6-8FF2-340D7AB3B70D};"@NewCutoff:Input",{B96D08A3-EC4E-45C1-8E78-526920753C6B};
0
[Integration].[Sale_Staging]
1252
false
3
false
false
CHECK_CONSTRAINTS
2147483647
0
EXEC Integration.GetStockHoldingUpdates
WITH RESULT SETS
(
(
[Quantity On Hand] int,
[Bin Location] nvarchar(20),
[Last Stocktake Quantity] int,
[Last Cost Price] int,
[Reorder Level] int,
[Target Stock Level] int,
[WWI Stock Item ID] int
)
);
1252
false
2
"@LastCutoff:Input",{60BD9010-4784-49A6-8FF2-340D7AB3B70D};"@NewCutoff:Input",{B96D08A3-EC4E-45C1-8E78-526920753C6B};
0
[Integration].[StockHolding_Staging]
1252
false
3
false
false
CHECK_CONSTRAINTS
2147483647
0
EXEC Integration.GetStockItemUpdates ?, ?
WITH RESULT SETS
(
(
[WWI Stock Item ID] int,