JournalLine

Object

_id

workspaceId

journalId

accountId

postingDate

debit

The ledger amount, in the workspace base currency — what every report sums.

credit

The ledger amount, in the workspace base currency — what every report sums.

transactionAmount

The line's amount in its account's own currency, on the same side as the base debit or credit. Set exactly when the account is kept in a currency other than the base; null on every line of a base-currency account. The base amount is this amount converted at exchangeRate.

exchangeRate

The rate that converted transactionAmount into the base amount, account currency to base, as authored.

exchangeRateAsOf

The day the exchange rate applies from.

exchangeRateSource

Where the exchange rate came from.

projectId

The Hive project this line is booked to.

projectName

The project's name, when this reader may see the project.

coding

The line's position on each reporting dimension: one member per dimension, empty when uncoded.

glCompanyId

The GL company whose books this line posts to — the boundary between sets of books. Distinct from entityId, which is the counterparty the line is about. Null on lines written before GL companies existed.

intercompanyCounterpartyGlCompanyId

The company on the other side of a due-to/due-from leg. A string here is exactly a line the posting engine generated from an intercompany mapping — every authored line carries null — so it is also what tells a derived leg apart from one a person wrote. Named rather than inferred from the account, because two rows on one account in one company can belong to different pairs once a mapping's accounts are shared.

entityId

The counterparty this line concerns — a client, vendor or employee, per entityType. Never a project or a dimension, and not a ledger scope.

sourceType

sourceId

sourceLineId

memo

createdAt

modifiedAt

createdBy

modifiedBy

dimensionId

dimensionMemberId

dimensionCode

dimensionName

dimensionMemberCode

dimensionMemberName