Query to fetch Withholding tax details for business partners.

[former_member224264]

Dear Experts,

We tried to fetch the withholding tax details by joining OCRD and OWHT tables for individual business partners and returning with no data.

Can anyone be of any help as to how can we retrieve or fetch the data?

Regards.

[g_richnafsky]

Business Partner's 'withholding tax %' is a column of the OCRD table. Try :

SELECT

Cardcode,

CardName,

DdctPrcnt

FROM OCRD

If you need 'Withholding Tax Deduction Group', that is DdgKey which is link to ODDG