--總賬分錄追溯發(fā)票 SELECT DISTINCT AIA.*FROM AP_AE_HEADERS_ALL AAH, --帳戶分錄頭表AP_AE_LINES_ALL AAL, --賬戶分錄行表，每一個(gè)會(huì)計(jì)事件都會(huì)在此表中產(chǎn)生會(huì)計(jì)分錄 GL_JE_BATCHES GJB,GL_JE_HEADERS GJH,GL_JE_LINES GJL,AP_INVOICES_ALL AIA,AP_ACCOUNTING_EVENTS_ALL AAE --會(huì)計(jì)帳戶事件表，一種能產(chǎn)生帳戶的事務(wù)處理活動(dòng), 如:發(fā)票調(diào)整, 預(yù)付款, 付款等. WHERE 1 = 1AND AAH.AE_HEADER_ID = AAL.AE_HEADER_IDAND GJB.JE_BATCH_ID = GJH.JE_BATCH_IDAND GJH.JE_HEADER_ID = GJL.JE_HEADER_IDAND GJL.GL_SL_LINK_ID = AAL.GL_SL_LINK_ID --關(guān)鍵點(diǎn)AND GJH.JE_SOURCE = 'Payables'AND AIA.INVOICE_ID = AAE.SOURCE_IDAND AAE.SOURCE_TABLE = 'AP_INVOICES'AND AAH.ACCOUNTING_EVENT_ID = AAE.ACCOUNTING_EVENT_ID --關(guān)鍵點(diǎn)AND GJB.NAME = '3292 應(yīng)付款 1047558: A 29786'

?

--應(yīng)付總賬分錄追溯到付款 SELECT DISTINCT ACA.*FROM AP_AE_HEADERS_ALL AAH --帳戶分錄頭表,AP_AE_LINES_ALL AAL --賬戶分錄行表，每一個(gè)會(huì)計(jì)事件都會(huì)在此表中產(chǎn)生會(huì)計(jì)分錄 ,GL_JE_BATCHES GJB,GL_JE_HEADERS GJH,GL_JE_LINES GJL,AP_CHECKS_ALL ACA --付款單據(jù)表，存儲(chǔ)支付給供應(yīng)商的付款,AP_ACCOUNTING_EVENTS_ALL AAE --會(huì)計(jì)帳戶事件表，一種能產(chǎn)生帳戶的事務(wù)處理活動(dòng), 如:發(fā)票調(diào)整, 預(yù)付款, 付款等.,AP_INVOICE_PAYMENTS_ALL AIP --發(fā)票付款記錄，此表連接付款(CHECK_ID)信息到其相對(duì)應(yīng)的發(fā)票.WHERE AAH.AE_HEADER_ID = AAL.AE_HEADER_IDAND GJB.JE_BATCH_ID = GJH.JE_BATCH_IDAND GJH.JE_HEADER_ID = GJL.JE_HEADER_IDAND GJL.GL_SL_LINK_ID = AAL.GL_SL_LINK_IDAND GJH.JE_SOURCE = 'Payables'AND ACA.CHECK_ID = AAE.SOURCE_IDAND AAE.SOURCE_TABLE = 'AP_CHECKS'AND AAE.ACCOUNTING_EVENT_ID = AAH.ACCOUNTING_EVENT_IDAND AIP.CHECK_ID = ACA.CHECK_IDAND GJH.NAME = '<5021AP040600002>付款 CNY'

?

轉(zhuǎn)載于:https://www.cnblogs.com/rigid/p/4047926.html

總結(jié)

以上是生活随笔為你收集整理的总账分录追溯发票或者付款的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。