Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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