-- 星瀚暂估应收单 fl库 select * from t_ar_busbill where fbillnoARUB-000139 -- 暂估应收单分录 select * from t_ar_busbillentry where fid (select fid from t_ar_busbill where fbillnoARUB-000139) --财务应收单 select * from t_ar_finarbill where fbillnoAR-260609-000008 select * from t_ar_finarbillentry --财务应收单分录 ---------------------星空------------------------ --- 应收单表头 select * from t_AR_receivable where FBILLNOAR00000043 100066 --应收单明细关联表 select * from T_AR_RECEIVABLEENTRY_LK where FSBILLID100067 --销售出库单 select * from T_SAL_OUTSTOCK where FBILLNOXSCKD000047 -- 出库单分录财务表 select * from T_SAL_OUTSTOCKENTRY_F where fid 100067 -- 销售出库单明细关联表 --select * from T_SAL_OUTSTOCKENTRY_LK where fsid( select fid from T_SAL_OUTSTOCK where FBILLNOXSCKD000047 )