专业版12.3账套升级迁移到旗舰版2.0报错
624次浏览
编辑于2017年09月24日 16:25:03
语句已终止。
违反了 PRIMARY KEY 约束 'PRKEY_ICSTJGBill'。不能在对象 'dbo.ICSTJGBill' 中插入重复键。--根据系统参数更新投料单已领数量,基本单位已领数量-end-
--领料单上仓库为虚仓,领料单生成受托加工领料单
insert into ICSTJGBill(
FBrNo,
FInterID,
FTranType,
FROB,
FDate,
FBillNo,
FStatus,
FDeptID,
FUse,
FSManagerID,
FFManagerID,
FCheckerID,
FBillerID,
FMultiCheckLevel1,
FMultiCheckLevel2,
FMultiCheckLevel3,
FMultiCheckLevel4,
FMultiCheckLevel5,
FMultiCheckLevel6,
FMultiCheckDate1,
FMultiCheckDate2,
FMultiCheckDate3,
FMultiCheckDate4,
FMultiCheckDate5,
FMultiCheckDate6,
FCurCheckLevel,
FUpStockWhenSave,
FBackFlushed,
FWBInterID,
FCancellation,
FCheckDate,
FSelTranType,
FChildren,
FRelateBrID,
FBrID)
select t1.FBrNo,
t1.FInterID,
t1.FTranType,
t1.FROB,
t1.FDate,
t1.FBillNo,
t1.FStatus,
t1.FDeptID,
t1.FUse,
t1.FSManagerID,
t1.FFManagerID,
t1.FCheckerID,
t1.FBillerID,
t1.FMultiCheckLevel1,
t1.FMultiCheckLevel2,
t1.FMultiCheckLevel3,
t1.FMultiCheckLevel4,
t1.FMultiCheckLevel5,
t1.FMultiCheckLevel6,
t1.FMultiCheckDate1,
t1.FMultiCheckDate2,
t1.FMultiCheckDate3,
t1.FMultiCheckDate4,
t1.FMultiCheckDate5,
t1.FMultiCheckDate6,
t1.FCurCheckLevel,
t1.FUpStockWhenSave,
t1.FBackFlushed,
t1.FWBInterID,
t1.FCancellation,
t1.FCheckDate,
t1.FSelTranType,
t1.FChildren,
ISNULL(t1.FRelateBrID,''),
ISNULL(t1.FBrID,'')
from KIS_ICStockBill t1 inner join KIS_ICStockBillEntry t2 on t1.FInterID=t2.FInterID
inner join KIS_t_Stock t3 on t2.FSCStockID=t3.FItemID and t3.FTypeID=502 and t1.FTranType=24
求大神指导下, QQ 476574914,谢谢,
违反了 PRIMARY KEY 约束 'PRKEY_ICSTJGBill'。不能在对象 'dbo.ICSTJGBill' 中插入重复键。--根据系统参数更新投料单已领数量,基本单位已领数量-end-
--领料单上仓库为虚仓,领料单生成受托加工领料单
insert into ICSTJGBill(
FBrNo,
FInterID,
FTranType,
FROB,
FDate,
FBillNo,
FStatus,
FDeptID,
FUse,
FSManagerID,
FFManagerID,
FCheckerID,
FBillerID,
FMultiCheckLevel1,
FMultiCheckLevel2,
FMultiCheckLevel3,
FMultiCheckLevel4,
FMultiCheckLevel5,
FMultiCheckLevel6,
FMultiCheckDate1,
FMultiCheckDate2,
FMultiCheckDate3,
FMultiCheckDate4,
FMultiCheckDate5,
FMultiCheckDate6,
FCurCheckLevel,
FUpStockWhenSave,
FBackFlushed,
FWBInterID,
FCancellation,
FCheckDate,
FSelTranType,
FChildren,
FRelateBrID,
FBrID)
select t1.FBrNo,
t1.FInterID,
t1.FTranType,
t1.FROB,
t1.FDate,
t1.FBillNo,
t1.FStatus,
t1.FDeptID,
t1.FUse,
t1.FSManagerID,
t1.FFManagerID,
t1.FCheckerID,
t1.FBillerID,
t1.FMultiCheckLevel1,
t1.FMultiCheckLevel2,
t1.FMultiCheckLevel3,
t1.FMultiCheckLevel4,
t1.FMultiCheckLevel5,
t1.FMultiCheckLevel6,
t1.FMultiCheckDate1,
t1.FMultiCheckDate2,
t1.FMultiCheckDate3,
t1.FMultiCheckDate4,
t1.FMultiCheckDate5,
t1.FMultiCheckDate6,
t1.FCurCheckLevel,
t1.FUpStockWhenSave,
t1.FBackFlushed,
t1.FWBInterID,
t1.FCancellation,
t1.FCheckDate,
t1.FSelTranType,
t1.FChildren,
ISNULL(t1.FRelateBrID,''),
ISNULL(t1.FBrID,'')
from KIS_ICStockBill t1 inner join KIS_ICStockBillEntry t2 on t1.FInterID=t2.FInterID
inner join KIS_t_Stock t3 on t2.FSCStockID=t3.FItemID and t3.FTypeID=502 and t1.FTranType=24
求大神指导下, QQ 476574914,谢谢,
推荐阅读