Oracle Fusion · Data dictionary
ZX_EXEMPTIONS
TaxUsed in 2 subject areas10 reporting columns
Transaction Tax (ZX).
Primary key: not yet catalogued for ZX_EXEMPTIONS, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| EFFECTIVE_FROM | ● | Effective from. | |
| EFFECTIVE_TO | ● | Effective to. | |
| EXEMPTION_TYPE_CODE | ● | Code identifying the exemption type. | |
| EXEMPT_CERTIFICATE_NUMBER | ● | Exempt certificate number. | |
| EXEMPT_REASON_CODE | ● | Code identifying the exempt reason. | |
| RATE_MODIFIER | ● | Rate modifier. | |
| TAX | ● | Tax. | |
| TAX_RATE_CODE | ● | Code identifying the tax rate. | |
| TAX_REGIME_CODE | ● | Code identifying the tax regime. | |
| TAX_STATUS_CODE | ● | Code identifying the tax status. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Receivables - Customer Account Site Tax Profile Real Time
- Receivables - Customer Tax Profile Real Time
Need the extract + dbt staging for ZX_EXEMPTIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table