销售订单预收业务后台数据表数据结构记录

业务流程形式：销售订单-收款单-收款退款单

销售订单预售业务算比较特殊的业务，我们在系统销售订单界面根据下查，是没法看到下游的关联收款单，

只有通过全流程跟踪才可以联查到

这时我们后台的_lk关联关系表就不能够直接使用。

需要关联的话我们要用到上下游的关联单据体来查。

关联语句如下：

select SAL_ORDER.FBILLNO,SAL_ORDERENTRY.FENTRYID, AR_RECEIVEBILLENTRY18.FREALRECAMOUNTFOR, AR_RECEIVEBILLENTRY18.* 

from T_SAL_ORDER as SAL_ORDER --销售订单

inner join T_SAL_ORDERENTRY as SAL_ORDERENTRY on SAL_ORDERENTRY.FID=SAL_ORDER.FID

left join T_SAL_ORDERPLAN as SAL_ORDERPLAN on SAL_ORDERPLAN.fid =SAL_ORDER.FID 

left join T_AR_RECEIVEBILL as AR_RECEIVEBILL18 on AR_RECEIVEBILL18.FBILLNO=SAL_ORDERPLAN.FRELBILLNO

left join T_AR_RECEIVEBILLENTRY as AR_RECEIVEBILLENTRY18 on AR_RECEIVEBILLENTRY18.FID=AR_RECEIVEBILL18.FID

left join T_AR_REFUNDBILLSRCENTRY_LK as AR_REFUNDBILLSRCENTRY_LK18 on AR_REFUNDBILLSRCENTRY_LK18.FSBILLID =AR_RECEIVEBILLENTRY18.FID and AR_REFUNDBILLSRCENTRY_LK18.FSID= AR_RECEIVEBILLENTRY18.FENTRYID--收款退款单

left join T_AR_REFUNDBILLSRCENTRY as AR_REFUNDBILLSRCENTRY18 on AR_REFUNDBILLSRCENTRY18.FENTRYID = AR_REFUNDBILLSRCENTRY_LK18.FENTRYID

left join T_AR_REFUNDBILL as AR_REFUNDBILL18 on AR_REFUNDBILL18.FID=AR_REFUNDBILLSRCENTRY18.FID

left join T_AR_REFUNDBILLENTRY as AR_REFUNDBILLENTRY18 on AR_REFUNDBILLENTRY18.FID = AR_REFUNDBILL18.FID

where SAL_ORDER.FBILLNO='XSDD002912'

关联时要注意，预收单和原单不是一一对应的关系，可能会出现多行重复，需要的话可以去重操作