eBTax tables

Setup tables

Tax Regimes: ZX_REGIMES_B
Taxes: ZX_TAXES_B
Tax Status: ZX_STATUS_B
Tax Rates: ZX_RATES_B
Tax Jurisdictions: ZX_JURISDICTIONS_B
Tax Rules: ZX_RULES_B

SQL References

SELECT *
FROM zx_regimes_b
WHERE tax_regime_code = :tax_regime_code;

SELECT *
FROM zx_taxes_b
WHERE DECODE(:tax_name,null,'xxx',tax) = nvl(:tax_name,'xxx')
AND tax_regime_code = :tax_regime_code;

SELECT *
FROM zx_status_b
WHERE tax = :tax_name
AND tax_regime_code = :tax_regime_code;

SELECT *
FROM zx_rates_b
WHERE tax = :tax_name
AND tax_regime_code = :tax_regime_code;

SELECT *
FROM zx_jurisdictions_b
WHERE DECODE(:tax_name,null,'xxx',tax) = nvl(:tax_name,'xxx')
AND tax_regime_code = :tax_regime_code;

SELECT *
FROM zx_rules_b
WHERE tax = :tax_name
AND tax_regime_code = :tax_regime_code;