委外接收单税率输入错误，在数据库后台进行修改

--字段说明

/*FTaxRate  --税率

FTaxOfRate --税率

FTaxAmount -- 税额

FUNHookAmount --不含税金额

FAmountIncludeTax --含税金额

FInterID --单据内码*/

--先查询出来对应单据的单据内码

SELECT FInterID，* FROM ICShop_SubcIn where FBillNo='单据编号'

--依据单据内码查询需要修改税率、税额等字段

SELECT FTaxRate,FTaxOfRate,FTaxAmount,FUNHookAmount,FAmountIncludeTax,FAmount

FROM ICShop_SubcInEntry 

WHERE FInterID=1883

--更新委外接收单税率与含税金额

UPDATE ICShop_SubcInEntry 

SET FTaxRate='13.0000000000',

FTaxOfRate='13.0000000000',

FTaxAmount='44.2000000000',

FAmountIncludeTax='384.2000000000'

WHERE FInterID=1883