JG_FSCL_TAX_LINES_ALL

Regional / FiscalUsed in 3 subject areas23 reporting columns

Regional / Global Accounting (JG) — line table — one row per line item under the header.

Likely primary key: FSCL_TAX_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions — verify against Tables & Views)

Columns

Column	Key	In reports	Description (inferred)
CAL_TAX_AMT		●	Cal tax amount.
CAL_TAX_AMT_TAX_CURR		●	Cal tax amount tax currency.
CREATION_DATE		●	Date and time the row was created.
FSCL_TAX_HEADER_ID	PK?	○	Identifier for the fscl tax header.
LAST_UPDATE_DATE		●	Date and time the row was last updated (the incremental-extract key).
LINE_NUMBER	PK?	○	Line number.
QUANTITY		●	Quantity.
REPORTING_TYPE_CODE		●	Code identifying the reporting type.
SELF_ASSESSED_FLAG		●	Indicator (Y/N) for the self assessed.
TAX		●	Tax.
TAXABLE_AMT		●	Taxable amount.
TAX_AMT		●	Tax amount.
TAX_AMT_INCLUDED_FLAG		●	Indicator (Y/N) for the tax amount included.
TAX_AMT_TAX_CURR		●	Tax amount tax currency.
TAX_HOLD_CODE		●	Code identifying the tax hold.
TAX_JURISDICTION_CODE		●	Code identifying the tax jurisdiction.
TAX_LINE_NUMBER		●	Tax line number.
TAX_RATE		●	Tax rate.
TAX_RATE_CODE		●	Code identifying the tax rate.
TAX_REGIME_CODE		●	Code identifying the tax regime.
TAX_SITUATION_CODE		●	Code identifying the tax situation.
TAX_STATUS_CODE		●	Code identifying the tax status.
UOM_CODE		●	Code identifying the unit of measure.
USER_ENTERED_TAX_AMT		●	User entered tax amount.
USER_ENTERED_TAX_AMT_TAX_CURR		●	User entered tax amount tax currency.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

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 JG_FSCL_TAX_LINES_ALL?

We ship parameterized SQL, BICC config, and dbt models you own.