专业版产品，用KIS迁移工具升级到RISE产品时，应用的仓库管理模块中，仓库有属性为虚仓的，升级过程中，
语句已终止。
违反了 PRIMARY KEY 约束 'PRKEY_ICSTJGBill'。不能在对象 '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
推荐阅读