Query to find the tax Reporting code using the tax rate from zx_lines?

User_1ZWDZ

The tax Reporting Code is in the table - ZX_REPORTING_CODES_B

I need help on how to join this table with zx_lines,

or join tax rate with tax reporting code?

Mallikarjuna Kuppauru-Oracle

Hi @User_1ZWDZ

Tax reporting codes you can refer below table -

ZX_REPORTING_CODES_B (oracle.com)

ZX_REPORTING_CODES_B

This table stores the tax reporting codes, which are unique codes for tax reporting purposes.

Regards,

Arjun

User_1ZWDZ

Hello,

I need a join between zx_lines and ZX_REPORTING_CODES_B

Maalavica

hi i have the same requirement did you get the table?

Gianni Ceresa

Hi @Maalavica , what product are you asking about?

This category is mostly for technical questions on Publisher. If you are using OBIA or FDI, there are dedicated categories for those products where to ask questions about the data model.

If you are using a Fusion product, then you should consider asking your data question in the forum that cover the Fusion products: https://community.oracle.com/customerconnect