Oracle Fusion · Data dictionary
ZX_WHT_LINES_SUMMARY
TaxUsed in 3 subject areas2 reporting columns
Transaction Tax (ZX) — summary / aggregate.
Primary key: SUMMARY_TAX_LINE_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| EXEMPT_CERTIFICATE_NUMBER | ● | Exempt certificate number. | |
| SUMMARY_TAX_LINE_ID | PK | ○ | Identifier for the summary tax line. |
| TAX_RATE | ● | Tax rate. |
1 report read from this table
Change a column here and these are the reports that move with it — the blast radius for any change to ZX_WHT_LINES_SUMMARY.
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.
- Payables Invoices - Holds Real Time
- Payables Invoices - Prepayment Applications Real Time
- Payables Invoices - Transactions Real Time
Need the extract + dbt staging for ZX_WHT_LINES_SUMMARY?
We ship parameterized SQL, BICC config, and dbt models you own.