با توجه به اینکه قبض انبار با جداول زیادی در ارتباط است ، باید ابتدا دیتیل این جدول حذف شود

سپس جداول وابسته حذف شوند

و در نهایت هدر قبض ها حذف شود

خانومی
--حذف قبض ها و جداول وابسته
delete from wm.DeliveryDetails
delete from WM.InventoryFirstStockDetails
delete from WM.InventoryFirstStock
delete from Sale.OnLineSaleDetails
delete from Sale.OnLineSale
delete from WM.AdjustInventoryDetails
delete from WM.AdjustInventory
delete from WM.ASNDetails
delete from WM.ASNPDATemp
delete from WM.ASN
delete from WM.StockDraftDetails
delete from WM.StockDraftRecPDATemp
delete from WM.StockDraft
delete from wm.MojodiReview
delete from wm.MojodiReviewIdentification
delete from wm.MojodiReviewPDATemp
delete from wm.MojodiReviewSetting
delete from wm.MojodiReviewShelfs
delete from wm.MojodiReviewInfo
delete from wm.Delivery
exec wm.PrepareStock	--برای بازسازی موجودی


  • No labels