Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 106 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Required Backend SQL table for Manage Taxes setup
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
lease provide us the right table where the above information stored table along with tax name.
Answers
-
Hi
Take a look at ZX_TAX_SETTLEMENT_AUTHS_F
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_IDHope it helps
Rodrigo
0