Base tables for Taxable transactions Created via Spreadsheet
Summary:
Dear Community,
I am looking for the base tables related to the Taxable transactions created via the Spreadsheet. I am looking to build a query to fetch all the taxable transactions, lines, and distributions. Something similar to the base tables for AP Transactions ( ap_invoices_all, ap_invoice_lines_all, ap_invoice_distributions_all)
My understanding is that the relevant base tables are ZX_TRANSACTION, ZX_TRANSACTION_LINES, and ZX_TRX_TAX_DISTRIBUTIONS. But when I query these tables, I can not find any transactions that we uploaded, and I only see a few hundred records, while we upload a few thousand taxable transactions (both Purchase and sales Journals) each month.