Required Backend SQL table for Manage Taxes setup

Opkey PA

Hi Team,

Could anyone please tell us the Table name where the columns("Collecting tax authority" and "Collecting Tax authority site" ) information stored for the task Manage taxes setup.

We have gone through all the ZX tables but we are unable to find above mentioned two columns.

Attached screenshot with highlighted fields for reference.

P

Manage Tax Code.PNG

lease provide us the right table where the above information stored table along with tax name.

Rodrigo Mello-Oracle

Hi

Take a look at ZX_TAX_SETTLEMENT_AUTHS_F

https://docs.oracle.com/en/cloud/saas/financials/25b/oedmf/zxtaxsettlementauthsf-22715.html#zxtaxsettlementauthsf-22715

Had similar need, and the below query helped a lot:

select a.tax, a.SUPPLIER_ID, a.TAX_REGIME_CODE, a.TAX_JURISDICTION_CODE, a.INTERNAL_ORGANIZATION_ID, b.BU_NAME, a.EFFECTIVE_START_DATE, a.EFFECTIVE_END_DATE
from ZX_TAX_SETTLEMENT_AUTHS_F a, FUN_ALL_BUSINESS_UNITS_V b
where a.tax = :P_TAX
AND b.BU_ID = a.INTERNAL_ORGANIZATION_ID

Hope it helps

Rodrigo