单据下推关系SQL整理及说明原创
2人赞赏了该文章
588次浏览
编辑于2022年05月06日 16:38:26
样例(仅供参考):
--关联关系表(FSBILLID为上游单据编号,FSID为上游单据单据体entryID)
select * from T_SAL_OUTSTOCKENTRY_LK where FSBILLID=100080
--发货通知
select * from T_SAL_DELIVERYNOTICE where FID = 100080
select * from T_SAL_DELIVERYNOTICEENTRY where FID = 100080--fentryid = 100087
--销售出库
select * from T_SAL_OUTSTOCK where FID=100056
select * from T_SAL_OUTSTOCKENTRY where FID=100056