Oracle Fusion · Data dictionary
ZX_LINES_V
TaxUsed in 1 subject areas12 reporting columns
Transaction Tax (ZX), denormalized view.
Primary key: TAX_LINE_ID
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| TAX | ● | Tax. | |
| TAX_JURISDICTION_CODE | ● | Code identifying the tax jurisdiction. | |
| TAX_JURISDICTION_NAME | ● | Name of the tax jurisdiction. | |
| TAX_LINE_ID | PK | ○ | Identifier for the tax line. |
| TAX_LINE_NUMBER | ● | Tax line number. | |
| TAX_RATE | ● | Tax rate. | |
| TAX_RATE_CODE | ● | Code identifying the tax rate. | |
| TAX_RATE_NAME | ● | Name of the tax rate. | |
| TAX_REGIME_CODE | ● | Code identifying the tax regime. | |
| TAX_REGIME_NAME | ● | Name of the tax regime. | |
| TAX_STATUS_CODE | ● | Code identifying the tax status. | |
| TAX_STATUS_NAME | ● | Name of the tax status. | |
| UNROUNDED_TAX_AMT | ● | Unrounded tax amount. |
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_LINES_V.
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.
Need the extract + dbt staging for ZX_LINES_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table