We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query to get tax registration from supplier address level

Accepted answer
12
Views
3
Comments
edited May 28, 2021 5:03PM in Payables, Payments & Cash Management 3 comments

Summary

Tax Registration from Supplier Address

Content

Hello 

I was wondering if you can share with me any SQL to get the Tax Registration at the address Level.

I have the following at Supplier Level

Thanks

SELECT HP.party_name supplier_name
,SUP.segment1 supplier_number
,ZR.TAX_REGIME_CODE
,ZR.REGISTRATION_NUMBER tax_registration_number
,ZR.EFFECTIVE_FROM
FROM zx_party_tax_profile tax
,zx_registrations ZR
,hz_parties HP
,poz_suppliers SUP
WHERE TAX.party_id = HP.party_id
AND tax.party_type_code = ‘THIRD_PARTY’
AND ZR.PARTY_TAX_PROFILE_ID = TAX.PARTY_TAX_PROFILE_ID
AND HP.party_id = SUP.party_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!