新增文章
文章标题
分类
C#
云星空
K3 BOS
K3 功能
用友
Oracle
python
SQL
MySql
PHP
HTML
script
windows
Access
影视后期
财务
服务
生活
内容
SELECT FTranType2,FInterID,FEntryID ,FDetailID,FSourceTranType,FSourceInterId,FSourceEntryID,FSourceBillNo,FOrderInterID,FOrderEntryID,FOrderBillNo ,FItemID,FAuxPropID,FDCStockID,FBatchNo,FUnitID,FQtyMust,FAuxQtyMust,FQty,FAuxQty,FQtyInvoice,FAuxQtyInvoice,FPrice,FAuxPrice,FAmount ,FEntrySelfB0139,FEntrySelfB0138,FConsignPrice,FConsignAmount,FDiscountRate,FDiscountAmount ,FNote,FPlanMode,FChkPassItem,FComplexQty FROM ICStockBillEntry WHERE FInterID = 352587 AND FEntryID = 1 EXCEPT -- 对比有差异的数据 SELECT FTranType2,FInterID,FEntryID ,FDetailID,FSourceTranType,FSourceInterId,FSourceEntryID,FSourceBillNo,FOrderInterID,FOrderEntryID,FOrderBillNo ,FItemID,FAuxPropID,FDCStockID,FBatchNo,FUnitID,FQtyMust,FAuxQtyMust,FQty,FAuxQty,FQtyInvoice,FAuxQtyInvoice,FPrice,FAuxPrice,FAmount ,FEntrySelfB0139,FEntrySelfB0138,FConsignPrice,FConsignAmount,FDiscountRate,FDiscountAmount ,FNote,FPlanMode,FChkPassItem,FComplexQty FROM ICStockBillEntry_bak WHERE FInterID = 352588 AND FEntryID = 1
返回
保存