43 lines
1.1 KiB
Plaintext
43 lines
1.1 KiB
Plaintext
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
|