星空-星瀚对接记录

-- 星瀚暂估应收单 fl库 select * from t_ar_busbill where fbillno='ARUB-000139' -- 暂估应收单分录 select * from t_ar_busbillentry where fid =(select fid from t_ar_busbill where fbillno='ARUB-000139') --财务应收单 select * from t_ar_finarbill where fbillno='AR-260609-000008' select * from t_ar_finarbillentry --财务应收单分录 ---------------------星空------------------------ --- 应收单表头 select * from t_AR_receivable where FBILLNO='AR00000043' 100066 --应收单明细关联表 select * from T_AR_RECEIVABLEENTRY_LK where FSBILLID='100067' --销售出库单 select * from T_SAL_OUTSTOCK where FBILLNO='XSCKD000047' -- 出库单分录财务表 select * from T_SAL_OUTSTOCKENTRY_F where fid ='100067' -- 销售出库单明细关联表 --select * from T_SAL_OUTSTOCKENTRY_LK where fsid=( select fid from T_SAL_OUTSTOCK where FBILLNO='XSCKD000047' )