K3 wise 老单增加自定义项为下推或上拉【选单条件】
-- 老单增加自定义项选单条件，就是在下推时显示【没有符合条件的记录】，或在下游单据选单时在序时薄界面默认过滤条件单自据，这里以销售订单下推生成发货通知为例
-- 步骤如下：
-- 1、要用到的数据表有
-- ICTransactionType 该表反映了供需链所有单据的总体情况
-- ICClassLink 单据转换流程整体信息
-- 2、在【ICTransactionType 】表中查询两个单据的【Fid】
select * from ICTransactionType where fname in ('销售订单','发货通知')
-- 3、在【ICClassLink 】表中查询销售订单下推、选单获取记录的条件以第二步查到的【FID】加上-号为条件
select * from ICClassLink where fsourclasstypeid=-81
-- 4、在【ICClassLink 】表中找到相对应下游据的【FCondition】字段，先备份一下原内容，再把自定义字段的条件加上，然后更新到该字段中
-- 原内容
IsNull(v1.FclassTypeID,0)<>1007100 AND v1.FStatus IN (1, 2) AND u1.FMrpClosed = 0 AND u1.FIsAltered = 0 AND u1.FQty>u1.FCommitQty AND v1.FSaleStyle<>20296 AND NOT (v1.FRelateBrID<>0 AND v1.FOrderAffirm<>1 AND ((v1.FPOOrdBillNo='' AND v1.FBrID=(SELECT CASE WHEN LTRIM(RTRIM(FValue))='' THEN 0 ELSE FValue END FROM t_SystemProfile WHERE FKey='BrID')) OR (v1.FPOOrdBillNo<>'' AND v1.FBrID<>(SELECT CASE WHEN LTRIM(RTRIM(FValue))='' THEN 0 ELSE FValue END FROM t_SystemProfile WHERE FKey='BrID'))))
-- 新增自定义字段后内容
IsNull(v1.FHeadSelfS0166,0)=0 AND IsNull(v1.FclassTypeID,0)<>1007100 AND v1.FStatus IN (1, 2) AND u1.FMrpClosed = 0 AND u1.FIsAltered = 0 AND u1.FQty>u1.FCommitQty AND v1.FSaleStyle<>20296 AND NOT (v1.FRelateBrID<>0 AND v1.FOrderAffirm<>1 AND ((v1.FPOOrdBillNo='' AND v1.FBrID=(SELECT CASE WHEN LTRIM(RTRIM(FValue))='' THEN 0 ELSE FValue END FROM t_SystemProfile WHERE FKey='BrID')) OR (v1.FPOOrdBillNo<>'' AND v1.FBrID<>(SELECT CASE WHEN LTRIM(RTRIM(FValue))='' THEN 0 ELSE FValue END FROM t_SystemProfile WHERE FKey='BrID'))))
