42 lines
1.3 KiB
MySQL
42 lines
1.3 KiB
MySQL
|
SELECT
|
|||
|
|
B.FSRCBILLNO AS FSRCBILLNO, --Դ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ݱ<EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
B.FREALRECAMOUNTFOR AS FREALRECAMOUNTFOR, --Դ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʵ<EFBFBD>ս<EFBFBD><EFBFBD><EFBFBD>(<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD>)
|
|||
|
|
B.F_YKQC_CheckBox_re5 AS F_YKQC_CheckBox_re5, --<EFBFBD>Ƿ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|||
|
|
B.F_YKQC_Amount_apv AS F_YKQC_Amount_apv, --<EFBFBD>ɺ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>(<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD>)
|
|||
|
|
B.FENTRYID AS FENTRYID --<EFBFBD><EFBFBD>ϸ<EFBFBD><EFBFBD>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'
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|