Pilot_KD_Parino_yuyubo/修改合同号一些列订单.txt

select F_CONTRACTNUMBER, * from T_SAL_ORDER
where fbillno='PL-XSDD20251200583'

--update  T_SAL_ORDER set F_CONTRACTNUMBER='P202512090017-HH01'
--where fbillno='PL-XSDD20251200583'


select F_Papercontract, * from T_SAL_DELIVERYNOTICE
where FBillNo='SEOUT25121086'

--update  T_SAL_DELIVERYNOTICE set F_Papercontract='P202512090017-HH01'
--where  FBillNo='SEOUT25121086'

select F_contractnumber,* from T_SAL_OUTSTOCK
where FBillNo='PL-XSCKD20251200647'

--update  T_SAL_OUTSTOCK set F_contractnumber='P202512090017-HH01'
--where  FBillNo='PL-XSCKD20251200647'


select F_Paperpro,* from T_AR_RECEIVABLE
where FBillNo='PL-XSCKD20251200647'


--update  T_AR_RECEIVABLE set F_Paperpro='P202512090017-HH01'
--where FBillNo='PL-XSCKD20251200647'

select F_Paper,* from T_AR_RECEIVABLEENTRY
where fid=129824

--update  T_AR_RECEIVABLEENTRY set F_Paper='P202512090017-HH01'
--where fid=129824

select * from T_PRD_MO a
where  FBillNo='PL-MO20251201392'


select F_ZZHTH,* from T_PRD_MOENTRY b
where fid=129745

--update  T_PRD_MOENTRY set F_ZZHTH='P202512090017-HH01'
--where fid=129745