销售发票表明细修改
原创
©著作权归作者所有：来自51CTO博客作者freebook_z的原创作品，请联系作者获取转载授权，否则将追究法律责任
销售发票表 ICSale
销售发票明细表 ICSaleEntry
查询
select * from ICSale where FBillNo='ZSEFP079585'
select * from ICSaleEntry where FInterID=80658 and FSourceBillNo='S1680241230123635352-1'
select * from ICSaleEntry where FInterID in (select FInterID from ICSale where FBillNo='ZSEFP079585' ) and FSourceBillNo='S1680241230123635352-1'
修改
update ICSaleEntry set FPrice=118.805,FAmount=118.805,FTaxAmount=15.44,FAuxPrice=118.805,FStdAmount=118.805,FStdTaxAmount=15.44,FAllHookAmount=118.805,FCurrentHookAmount=118.805,FStdAllHookAmount=118.805,FStdCurrentHookAmount=118.805,FRemainAmount=134.25,FRemainAmountFor=134.25, FTaxPrice=134.25,FAuxTaxPrice=134.25,FAmountincludetax=134.25,FStdAmountincludetax=134.25,FPriceDiscount=134.25,FAuxPriceDiscount=134.25 where FInterID=80658 and FSourceBillNo='S1680241230123635352-1'
update ICSaleEntry set FAmountExceptDisCount=118.805,FStdAmountExceptDisCount=118.805,FAllAmountExceptDisCount=134.25,FStdAllAmountExceptDisCount=134.25 where FInterID=80658 and FSourceBillNo='S1680241230123635352-1'
