专业版12.3账套升级迁移到旗舰版2.0报错
金蝶云社区-云社区用户11z44977
云社区用户11z44977
0人赞赏了该文章 573次浏览 未经作者许可,禁止转载编辑于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,谢谢,