更新金碟云星空单据供应商和币别

--应付单
select FSUPPLIERID from  [dbo].[T_AP_PAYABLE] where FBILLNO='AP2024121670'
select FSUPPLIERID,FCURRENCYID,* from  [dbo].[T_AP_PAYABLE] where FBILLNO='AP2024121670'

-- update T_AP_PAYABLE set  FSUPPLIERID='100567' where FBILLNO='AP2024121670'
-- update T_AP_PAYABLE set  FCURRENCYID='3' where FBILLNO='AP2024121670'

--采购入库单列表 FLOCALCURRID  FSettleCurrId  FSupplierId
select * from  [dbo].[T_BD_SUPPLIER] where 
FNUMBER='NB00001'  and FMASTERID='100567'
-- fsupplierid='354106'

select * from [dbo].[T_STK_INSTOCK] where fbillno='CGRK2024121392'

select  * from  [dbo].[T_STK_INSTOCKFIN] where fid='153709'

-- update T_STK_INSTOCKFIN set  FSettleCurrId='3' where fid