如何将委外订单上的自定义字段携带到委外加工出库单上

栏目:k3wise知识作者:金蝶来源:金蝶云社区发布:2024-09-22浏览:1

如何将委外订单上的自定义字段携带到委外加工出库单上

问题描述:

经常有客户有这样的需求,希望将委外订单上的自定义字段携带到委外加工出库单或其他下游单据上,而现在系统中委外订单是BOS新单,委外加工出库单、入库单、投料单等都是工业老单据,在前台无法进行自定义关联设置,需要在后台修改模板表或通过SQL进行处理,现在就将一个委外订单到委外加工出库单的自定义字段关联设置例子分享个大家:

解决方案:

--1.插入关联表
if not exists(select 1 from  ICTableRelation where FTypeID=0 and FInterID=26 and FTableName='ICSubContractEntry' and FBillID ='B08' and FFieldID ='1007105' and FTableName11='t_item')
begin
        insert into ICTableRelation(FTypeID ,FInterID ,FTableName ,FTableNameAlias ,FFieldName ,FTableName11 ,FTableNameAlias11 ,FFieldName11 ,FLogic ,FBillID,
        FFieldID ,FMode,FIndex,FLogicOperator,FISConst,FConstType )
        VALUES(0,26,'ICSubContractEntry','u1','FBase1','t_item','t999','Fitemid','=','B08','1007105',0,0,'=',0,0)
end
if not exists(select 1 from  ICTableRelation where FTypeID=0 and FInterID=27 and FTableName='ICSubContractEntry' and FBillID ='B08' and FFieldID ='1007105' and FTableName11='t_Base_SpecialProject')
begin
        insert into ICTableRelation(FTypeID ,FInterID ,FTableName ,FTableNameAlias ,FFieldName ,FTableName11 ,FTableNameAlias11 ,FFieldName11 ,FLogic ,FBillID,
        FFieldID ,FMode,FIndex,FLogicOperator,FISConst,FConstType )
        VALUES(0,27,'ICSubContractEntry','u1','FBase2','t_Base_SpecialProject','T888','Fitemid','=','B08','1007105',0,0,'=',0,0)
end
--FEntrySelfB0856 任务单号
--FEntrySelfB0857 委外形式/FBase1
--FEntrySelfB0858 项目名称/FBase2
--FEntrySelfB0859 建议发料日期/FDate3
--FEntrySelfB0860 要求交货日期/FDate2
--2执行下面的所有insert下推字段对应
if not exists (select 1 from ICSelbills where FID='b08' and FFieldName  ='1007105' AND FDstCtlField IN('FEntrySelfB0857','FEntrySelfB0858','FEntrySelfB0856','FEntrySelfB0859','FEntrySelfB0860'))
BEGIN
        insert into icselbills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited) 
        values('B08','1007105','FEntrySelfB0857',0,0,'Fbase1','FitemID','t_item','t999','',0,0) 
        insert into icselbills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited) 
        values('B08','1007105','FEntrySelfB0857',0,1,'Fbase1Name','Fname','t_item','t999','',0,0) 
        insert into icselbills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited) 
        values('B08','1007105','FEntrySelfB0857',0,2,'Fbase1number','Fnumber','t_item','t999','',0,0) 
        insert into icselbills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited) 
        values('B08','1007105','FEntrySelfB0858',0,0,'Fbase2','FitemID','t_Base_SpecialProject','t888','',0,0) 
        insert into icselbills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited) 
        values('B08','1007105','FEntrySelfB0858',0,1,'Fbase2Name','Fname','t_Base_SpecialProject','t888','',0,0) 
        insert into icselbills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited) 
        values('B08','1007105','FEntrySelfB0858',0,2,'Fbase2Number','Fnumber','t_Base_SpecialProject','t888','',0,0) 
        insert into icselbills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited) 
        values('B08','1007105','FEntrySelfB0856',0,0,'FText1','FText1','ICSubContractEntry','u1','',0,0) 
        insert into icselbills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited) 
        values('B08','1007105','FEntrySelfB0859',0,0,'FDate3','FDate3','ICSubContractEntry','u1','',0,0) 
        insert into icselbills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias,FAction,FROB,FAllowEdited) 
        values('B08','1007105','FEntrySelfB0860',0,0,'FDate2','FDate2','ICSubContractEntry','u1','',0,0) 
        update icclasstype set fid=fid
END
通过此,即可完成自定义字段的携带。

如何将委外订单上的自定义字段携带到委外加工出库单上

问题描述:经常有客户有这样的需求,希望将委外订单上的自定义字段携带到委外加工出库单或其他下游单据上,而现在系统中委外订单是BOS新单...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息