更改外购入库单的不一致辞价格

来源:互联网 发布:lumia 813刷linux 编辑:程序博客网 时间:2024/04/29 19:52

select * from t_tabledescription where fdescription like '%外购入库%'

select * from vwicbill_1
--update vwicbill_1 set fauxplanprice='24'
where fentryid=1
and FSourceBillNo='VLMOV000118'
and funhookqty=42

select * from ICStockBillEntry
--update ICStockBillEntry fauxprice=24,famount=1008.00
where fentryid=1
and finterid='23580'

原创粉丝点击