D365 Reference

InventJournalTable

worksheet header

Inventory journal header — one row per movement, adjustment, transfer, BOM, or counting journal, with its type, posting status, and line count

Module: InventoryCompany-partitioned (DataAreaId)

Notes

JournalType is an integer enum (movement / inventory adjustment / transfer / BOM / item counting / tag counting …) — integer order not yet primary-source verified, so it renders undecoded.

What the badges mean

main: Table group: how F&O categorizes the table's role — main entity, group/header, transaction, worksheet header, worksheet line, reference, parameter, or framework.
Shared across companies: The table carries no DataAreaId— rows aren’t partitioned per company, so a query never needs (and can’t use) a company filter here (see the quirks guide).
Date-effective: The table carries a ValidFrom/ValidTo effectivity window — a join without a date filter multiplies every key by its history (see the quirks guide).

Header & line

InventJournalTable is the header for its lines in InventJournalTrans.

Fields

16 fields · 1 key

16 fields.

Table fields: key flag, field name, extended data type, description, data type, length, and quirk flags. 16 fields.
Key	Field	EDT	Description	Type	Flags
Key	JournalId	InventJournalId	The journal number — the key its lines join back on	string
	JournalNameId		Journal name (setup record) the journal was created from, carrying its defaults	string
	JournalType		Kind of inventory journal — movement, adjustment, transfer, BOM, or counting	enum	Enum
	Description		Free-text description of the journal	string
	Posted		Whether the journal has been posted — unposted journals have no inventory impact yet	enum	Enum
	PostedDateTime		When the journal was posted, stored in UTC	datetime	UTC
	PostedUserId		User who posted the journal	string
	NumOfLines		Number of lines in the journal	int
	InventSiteId	InventSiteId	Default site for the journal's lines	string
	InventLocationId	InventLocationId	Default warehouse for the journal's lines	string
	LedgerDimension	RecId	RecId of the offset ledger account (dimension combination) the journal posts against	int64	RecId
	VoucherDraw		Whether vouchers are drawn at journal entry or at posting	enum	Enum
	DeletePostedLines		Whether lines are deleted after posting	enum	Enum
	SystemBlocked		Whether the system has locked the journal (for example while posting)	enum	Enum
	JournalIdOrignal	InventJournalId	Journal this one was created from, when split or copied (the misspelling is the genuine column name)	string
	Worker	RecId	RecId of the worker responsible for the journal	int64	RecId

Field provenance: hand-curated.

Boilerplate SQL

Starting point for reading InventJournalTable on Databricks — enums are decoded, 1900-01-01 dates are wrapped to NULL, and the DataAreaId anchor is in place. Set your Unity Catalog location, company, and filter values below; they’re substituted into the SQL and the copy button.

Query parameters

CatalogSchemaCompany (DataAreaId)

3 parameters not filled: <catalog>, <schema>, <company>

-- ============================================================
-- Table  : InventJournalTable Inventory journal header — one row per movement, adjustment, transfer, BOM, or counting journal, with its type, posting status, and line count
-- Purpose: Column-selected read of InventJournalTable — auto-generated from field metadata
-- Grain  : One row per company (dataareaid) + JournalId
-- Notes  : Auto-generated skeleton for Synapse Link / Fabric Link-landed F&O data (lowercase column names). Enums decoded inline where verified; datetimes stored in UTC; 1900-01-01 dates are sentinels mapped to NULL. System/audit columns omitted — see the quirks guide.
-- ============================================================
SELECT
  i.journalid AS "The journal number — the key its lines join back on",
  i.journalnameid AS "Journal name (setup record) the journal was created from, carrying its defaults",
  i.journaltype AS "Kind of inventory journal — movement, adjustment, transfer, BOM, or counting",  -- enum: decode i.journaltype via GlobalOptionsetMetadata join — see quirks guide #enums
  i.description AS "Free-text description of the journal",
  i.posted AS "Whether the journal has been posted — unposted journals have no inventory impact yet",  -- enum: decode i.posted via GlobalOptionsetMetadata join — see quirks guide #enums
  i.posteddatetime AS "When the journal was posted, stored in UTC",  -- stored in UTC
  i.posteduserid AS "User who posted the journal",
  i.numoflines AS "Number of lines in the journal",
  i.inventsiteid AS "Default site for the journal's lines",
  i.inventlocationid AS "Default warehouse for the journal's lines",
  i.ledgerdimension AS "RecId of the offset ledger account (dimension combination) the journal posts against",
  i.voucherdraw AS "Whether vouchers are drawn at journal entry or at posting",  -- enum: decode i.voucherdraw via GlobalOptionsetMetadata join — see quirks guide #enums
  i.deletepostedlines AS "Whether lines are deleted after posting",  -- enum: decode i.deletepostedlines via GlobalOptionsetMetadata join — see quirks guide #enums
  i.systemblocked AS "Whether the system has locked the journal (for example while posting)",  -- enum: decode i.systemblocked via GlobalOptionsetMetadata join — see quirks guide #enums
  i.journalidorignal AS "Journal this one was created from, when split or copied (the misspelling is the genuine column name)",
  i.worker AS "RecId of the worker responsible for the journal"
FROM <catalog>.<schema>.inventjournaltable i
WHERE
  i.dataareaid = '<company>'
ORDER BY i.journalid;

Verified September 2026

Relationships

Diagram of 1-hop neighbors — join details below. RecId and InventDim edges are highlighted; they’re the joins newcomers most often get wrong.

Join details

InventJournalTableInventJournalTransheader line · 1:N
ON inventjournaltable.journalid = inventjournaltrans.journalid AND inventjournaltable.dataareaid = inventjournaltrans.dataareaid

Data Entities That Expose This Table

No data-entity mappings populated for this table yet.

Browse more inventory tables