SELECT 
B.FSRCBILLNO AS FSRCBILLNO, --源单单据编号
B.FREALRECAMOUNTFOR AS FREALRECAMOUNTFOR, --源单本次实收金额(本位币)
B.F_YKQC_CheckBox_re5 AS F_YKQC_CheckBox_re5, --是否核销
B.F_YKQC_Amount_apv AS F_YKQC_Amount_apv, --旧核销金额(本位币)
B.FENTRYID AS FENTRYID --明细行ID
FROM T_AR_RECEIVEBILL A
INNER JOIN T_AR_RECEIVEBILLSRCENTRY B ON A.FID = B.FID
WHERE A.FID = '105186' AND A.FSETTLEORGID != '100302' AND A.FDOCUMENTSTATUS = 'C' AND B.FREALRECAMOUNTFOR > 0 
AND B.FSRCBILLTYPEID = 'SAL_SaleOrder'


SELECT C.FSRCBILLTYPEID,C.FSRCBILLNO,A.FID,B.*
FROM T_AR_RECEIVEBILL A
INNER JOIN T_AR_RECEIVEBILLSRCENTRY C ON A.FID = C.FID
INNER JOIN T_AR_RECEIVEBILLSRCENTRY_LK B ON C.FENTRYID = B.FENTRYID
WHERE A.FBILLNO = 'XN-SKD202501000009'

SELECT B.FSBILLID AS FSBILLID
,C.FSRCBILLNO AS FSRCBILLNO
,C.F_YKQC_Amount_apv AS F_YKQC_Amount_apv
,B.FREALRECAMOUNT AS FREALRECAMOUNT
,C.F_YKQC_CheckBox_re5 AS F_YKQC_CheckBox_re5
,C.FENTRYID AS FENTRYID
,C.FID AS FID
FROM T_AR_RECEIVEBILL A
INNER JOIN T_AR_RECEIVEBILLSRCENTRY C ON A.FID = C.FID
INNER JOIN T_AR_RECEIVEBILLSRCENTRY_LK B ON C.FENTRYID = B.FENTRYID
WHERE A.FID = '105186' AND B.FREALRECAMOUNT != 0 AND C.FSRCBILLTYPEID != 'SAL_SaleOrder' AND A.FSETTLEORGID != '100302'

SELECT FORDERNUMBER
FROM T_AR_RECEIVABLEENTRY
WHERE FID = '112350'AND FSOURCEBILLNO = 'XN-XSCKD20250200009'