如何通过ODBC将NetSuite TRANSACTION_LINES与REVENUE_RECOGNITION_SCHEDULES联系起来？

Question

如何通过ODBC将NetSuite TRANSACTION_LINES与REVENUE_RECOGNITION_SCHEDULES联系起来？

我研究过连接模式。虽然它说加入REVENUE_RECOGNITION_SCHEDULES.JOURNAL_ID到TRANSACTIONS.TRANSACTION_ID应该是可能的，但是如果我试图查找个别的发票，它就会崩溃。

Answer 1

TRANSACTION_LINES视图有一个名为SCHEDULE_ID的列，它匹配REVRECSCHEDULES视图中对应的SCHEDULE_ID。

SELECT 
    T.TRANID
    ,R.SCHEDULE_ID
FROM TRANSACTIONS AS T
INNER JOIN 
    TRANSACTION_LINES AS TL
    ON T.TRANSACTION_ID = TL.TRANSACTION_ID
INNER JOIN 
    REVRECSCHEDULES AS R
    ON TL.SCHEDULE_ID = R.SCHEDULE_ID
WHERE
    T.TRANSACTION_TYPE = 'Invoice'
    AND T.TRANID = 'R0356788'