Hello,
There is no index on column, "last_update_date" in table FUSION."zx_lines" table. - as a result, the data takes a very long time to download - or the query ends with an error
What other table can we use to retrieve data for reports?
So far, we have downloaded data from ZX_lines:APPLIED_FROM_EVENT_CLASS_CODE
TAX_JURISDICTION_CODE
PLACE_OF_SUPPLY_TYPE_CODE
TAX_DATE
TAX_POINT_DATE
TAX_AMT_TAX_CURR
TAX_AMT_FUNCL_CURR
TAXABLE_AMT_TAX_CURR
TAXABLE_AMT_FUNCL_CURR
EXEMPT_CERTIFICATE_NUMBER
CANCEL_FLAG
TAX_AMT_INCLUDED_FLAG
SETTLEMENT_FLAG
TAX_ONLY_LINE_FLAG
TAX_POINT_BASIS
WHT_GROUP_ID