Column Error in PROCEDURE [Integration].[GetStockItemUpdates]

[StefanGrigat]

Hi,
there is a column mapping error in the PROCEDURE [Integration].[GetStockItemUpdates].
In Lines 70 and 74.
The Insert Statement uses this column order:
[Is Chiller Stock], Barcode, [Tax Rate], [Unit Price], [Recommended Retail Price],
and the select statement has
si.IsChillerStock, si.Barcode, si.LeadTimeDays, si.UnitPrice, si.RecommendedRetailPrice,
So the Column "Tax Rate" ist filled with content of si.LeadTimeDays.
It should be:
si.IsChillerStock, si.Barcode, si.TaxRate, si.UnitPrice, si.RecommendedRetailPrice,

[StefanGrigat]

This should be the correct code in my opinion.
ALTER PROCEDURE [Integration].[GetStockItemUpdates].txt

[jodebrui]

Thanks for catching this issue. I updated the stored procedure accordingly.