销售订单明细行字段更新销售出库单明细行字段

栏目:云星空知识作者:金蝶来源:金蝶云社区发布:2024-09-16浏览:2

销售订单明细行字段更新销售出库单明细行字段

/*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"就是放在拆分表里的)

销售订单明细行字段更新销售出库单明细行字段

/*T_SAL_ORDER 销售订单T_SAL_ORDERENTRY 销售订单明细T_SAL_OUTSTOCK 销售出库单T_SAL_OUTSTOCKENTRY 销售出库单明细t_AR_receivable...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息