INV_CYCLE_COUNT_HEADERS

InventoryUsed in 3 subject areas23 reporting columns

Inventory (INV) — header table — one row per transaction or event (with detail in the paired _LINES table).

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

Columns

Column	Key	In reports	Description (inferred)
ALLOW_SERIAL_ITEMS		●	Allow serial items.
APPROVAL_REQUIRED		●	Approval required.
APPROVAL_TOLERANCE_NEGATIVE		●	Approval tolerance negative.
APPROVAL_TOLERANCE_POSITIVE		●	Approval tolerance positive.
AUTOSCHEDULE_ENABLED_FLAG		●	Indicator (Y/N) for the autoschedule enabled.
COST_TOLERANCE_NEGATIVE		●	Cost tolerance negative.
COST_TOLERANCE_POSITIVE		●	Cost tolerance positive.
CYCLE_COUNT_HEADER_ID	PK?	○	Identifier for the cycle count header.
CYCLE_COUNT_HEADER_NAME		●	Name of the cycle count header.
DAYS_UNTIL_LATE		●	Days until late.
DESCRIPTION		●	Description.
HIT_MISS_TOLERANCE_NEGATIVE		●	Hit miss tolerance negative.
HIT_MISS_TOLERANCE_POSITIVE		●	Hit miss tolerance positive.
MAXIMUM_AUTO_RECOUNTS		●	Maximum auto recounts.
NEXT_USER_COUNT_SEQUENCE		●	Next user count sequence.
ONHAND_VISIBLE_FLAG		●	Indicator (Y/N) for the onhand visible.
SCHEDULE_INTERVAL_TIME		●	Schedule interval time.
SERIAL_ADJUSTMENT_OPTION		●	Serial adjustment option.
SERIAL_COUNT_OPTION		●	Serial count option.
SERIAL_DETAIL_OPTION		●	Serial detail option.
SERIAL_DISCREPANCY_OPTION		●	Serial discrepancy option.
START_MANUAL_COUNTS_PREFIX		●	Start manual counts prefix.
UNSCHEDULED_COUNT_ENTRY		●	Unscheduled count entry.
ZERO_COUNT_FLAG		●	Indicator (Y/N) for the zero count.

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

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