銷售退貨原因直接在字典中維護(hù)

select dictlist as thyy,:mx.dj as dj ?from gldict where fdname='thyy'

采購?fù)素浽虿少徺Y料檢索方案

select '包裝問題' as thyy,:mx.dj as dj

union all

select '藥品信息不符' as thyy,:mx.dj as dj

union all

select '付款方式不符' as thyy,:mx.dj as dj

union all

select '電子監(jiān)管問題' as thyy,:mx.dj as dj

union all

select '藥品召回' as thyy,:mx.dj as dj

union all

select '抽檢' as thyy,:mx.dj as dj

union all

select '質(zhì)量問題' as thyy,:mx.dj as dj

union all

select '價(jià)格不適' as thyy,:mx.dj as dj

union all

select '入錯(cuò)單位' as thyy,:mx.dj as dj

union all

select '近效期' as thyy,:mx.dj as dj

union all

select '資質(zhì)問題' as thyy,:mx.dj as dj

union all

select '票據(jù)問題' as thyy,:mx.dj as dj

union all

select '訂單問題' as thyy,:mx.dj as dj

union all

select '多入' as thyy,:mx.dj as dj

物流中要將退貨原因維護(hù)才能正常

select * from openquery(lmis,'select * from jc_zdwh_mx') where english_name='tuih_reason'

轉(zhuǎn)載于:https://blog.51cto.com/bks2015/1701854

總結(jié)

以上是生活随笔為你收集整理的退货原因的修改的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。