销售退货原因直接在字典中维护


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


采购退货原因采购资料检索方案


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 '电子监管问题' 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 '质量问题' 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 '近效期' 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 '订单问题' as thyy,:mx.dj as dj

union all

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


物流中要将退货原因维护才能正常


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