```SQL
select T2H.FID AS [下游单据主表ID]
, T2E.FENTRYID AS [下游单据明细ID]
, lk.FENTRYID as [下游单据关联表FENTRYID对应下游单据明细ID]
, lk.FSBILLID AS [下游单据关联表FSBILLID对应上游单据主表ID]
, T1H.FID AS [上游单据主表ID]
, lk.FSID AS [下游单据关联表FSID对应上游单据明细ID]
, T1E.FENTRYID AS [上游单据明细ID]
, lk.FSTABLENAME [下游单据关联表FSTABLENAME]
from T_SAL_OUTSTOCK T2H -- 销售出库单
left join T_SAL_OUTSTOCKENTRY T2E -- 销售订单明细记录
on T2H.fid = T2E.fid
left join T_SAL_OUTSTOCKENTRY_LK lk -- 销售订单明细下推关系表
on T2E.FENTRYID = lk.FENTRYID
LEFT JOIN T_SAL_ORDERENTRY T1E -- 销售订单明细表
ON LK.FSID = T1E.FENTRYID
LEFT JOIN T_SAL_ORDER T1H -- 销售订单主表
on lk.FSBILLID = T1H.FID
where T2H.FDOCUMENTSTATUS = 'C'
and T2H.fbillno = 'XSCKD145137'
