===========================================================
===========================================================
订单 carrier_name 预付
作者: moonsoft(http://moonsoft.itpub.net)发表于: 2007.04.18 17:23
分类: 分销
出处: http://moonsoft.itpub.net/post/15182/281649
---------------------------------------------------------------
货运方式预付
订单 carrier_name 预付
--订单PICK RELEASE 后是可以修改货运方法的
select oh.order_number, oh.PAYMENT_TYPE_CODE, oh.PAYMENT_TERM_ID, rt.name, rt.PREPAYMENT_FLAG
from oe_order_headers_all oh , RA_TERMS_VL rt
where oh.order_number like '10000323%'
and oh.PAYMENT_TERM_ID=rt.TERM_ID
