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.

Change a column here and these are the reports that move with it — the blast radius for any change to ZX_LINES_V.

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.