【概述】说明下合并下推的常见问题
【常见问题】
<1>在不修改数据包时，字段的目标值、关联关系仅依赖于转换时的源单
常见的如源单编号
业务流上查
<2>修改控制字段的值，不会改变关联关系（link行没有减少），仅改变源单分配关系
当我手工分配采购数量的来源时（参考：[合并下推分配](https://wenku.my7c.com/article/272008385389184512?productLineId=1)），源单编号不会刷新，还是来源多个上游，源单编号不会重新计算，关联关系也不会
业务流上查
<3>上游单据全流程跟踪、下查时，看到的是存在关系的分录，而非有分配数值的分录
采购订单与采购申请单132没有数额分配，但是通过采购申请单132，下查依然能够看到采购订单
<4>在合并下推时，不能直接通过下查列表和单据数量比对比较
由于存在下推了没有分配数额的逻辑，因此下查的汇总值>=单据的数量，当且仅当该单据为直接下推时取等号。
如下图所示，采购申请单132重新再下推一个采购订单，发现总额为110超额了，但实际上并非超额
```sql
--<0>关联关系查询
select sbill.fbillno,sEntry.fseq,node.*,tbill.fbillno from T_PUR_Requisition sbill
left join T_PUR_ReqEntry sEntry on sbill.fid = sEntry.fid
left join t_bf_instanceentry node on sEntry.fentryid = node.fsid and node.fstablename = 'T_PUR_ReqEntry' and node.fttablename = 't_PUR_POOrderEntry'
left join t_PUR_POOrderEntry tEntry on tEntry.fentryid = node.ftid
left join t_PUR_POOrder tBill on tBill.fid = tEntry.fid
where sbill.fbillno = 'CGSQ000132'
```
```sql
--<1>关联关系 结合分配额查询
select sbill.fbillno,sEntry.fseq,node.*,tbill.fbillno,tlk.fbaseunitqty as '分配值',tlk.fbaseunitqtyold as '分配上限' from T_PUR_Requisition sbill
left join T_PUR_ReqEntry sEntry on sbill.fid = sEntry.fid
left join t_bf_instanceentry node on sEntry.fentryid = node.fsid and node.fstablename = 'T_PUR_ReqEntry' and node.fttablename = 't_PUR_POOrderEntry'
left join t_PUR_POOrderEntry tEntry on tEntry.fentryid = node.ftid
left join t_PUR_POOrder tBill on tBill.fid = tEntry.fid
left join t_PUR_POOrderEntry_lk tlk on tEntry.fentryid = tlk.fentryid and tlk.fsid = sEntry.fentryid
where sbill.fbillno = 'CGSQ000132'
```
```sql
--<2>关联关系 结合分配额查询
select sbill.fbillno,sEntry.fseq,node.*,tbill.fbillno,tlk.fbaseunitqty as '分配值',tlk.fbaseunitqtyold as '分配上限' from T_PUR_Requisition sbill
left join T_PUR_ReqEntry sEntry on sbill.fid = sEntry.fid
left join t_bf_instanceentry node on sEntry.fentryid = node.fsid and node.fstablename = 'T_PUR_ReqEntry' and node.fttablename = 't_PUR_POOrderEntry'
left join t_PUR_POOrderEntry tEntry on tEntry.fentryid = node.ftid
left join t_PUR_POOrder tBill on tBill.fid = tEntry.fid
left join t_PUR_POOrderEntry_lk tlk on tEntry.fentryid = tlk.fentryid and tlk.fsid = sEntry.fentryid
where sbill.fbillno = 'CGSQ000132' and tlk.fbaseunitqty>0
```
