/*T_SAL_ORDER 销售订单
T_SAL_ORDERENTRY 销售订单明细
T_SAL_OUTSTOCK 销售出库单
T_SAL_OUTSTOCKENTRY 销售出库单明细
t_AR_receivable 应收单
t_AR_receivableEntry 应收单明细
T_IV_SALESIC 普票
T_IV_SALESICENTRY 普票明细
T_IV_SALESIC 专票
T_IV_SALESICENTRY 专票明细*/
update t4 set t4.F_TTQI_TEXT=t2.F_TTQI_TEXT,t4.FNOTE=t2.FNOTE from T_SAL_ORDER t1 inner join T_SAL_ORDERENTRY t2 on t1.FID=t2.FID
inner join T_SAL_OUTSTOCKENTRY_R t3 on t3.FSRCBILLNO=t1.FBILLNO
inner join T_SAL_OUTSTOCKENTRY t4 on t4.FENTRYID=t3.FENTRYID
inner join T_SAL_OUTSTOCK t5 on t5.FID=t4.FID
where t3.FSOENTRYID=t2.FENTRYID and t1.FDATE>='2024-05-21'
/*更新5月21号之前的销售订单明细行的电商订单号与备注到销售出库单*/
销售出库单明细里面有个销售订单"FentryID"字段可以与销售订单的子表"FentryID"对应起来,另外有些字段是放在子表的拆分表中的注意看下那个字段所属的拆分表.(比如这里的源单编号"FSRCBILLNO"就是放在拆分表里的)
您的鼓励与嘉奖将成为创作者们前进的动力,如果觉得本文还不错,可以给予作者创作打赏哦!
请选择打赏金币数 *