操作记录

数据库备份

表备份

导入的清单

下架操作
update [Udit.Mms].[dbo].[mms_reels] set [LOCATION]=’’,[STATUS]=0
where [MATERIAL_NO] in (SELECT [料号] FROM [Udit.LOG].[dbo].[盘点241229]) and ([WAREHOUSE]=’R01’ OR [WAREHOUSE] is null)