ADO.NET Provider for Sage Intacct

Build 26.0.9655

JournalEntryLine

Represents individual line items on a journal entry, capturing GL account allocations, transaction amounts, currency details, and reconciliation information.

Columns

Name Type ReadOnly Description
accountingPeriod Int True

The accounting period to which this journal entry line is posted.

allocation_Href String True

The URL of the allocation associated with this journal entry line.

allocation_Id String False

The Id of the allocation associated with this journal entry line.

allocation_Key String False

The system-assigned key of the allocation associated with this journal entry line.

auditCreatedBy String True

The user who created the journal entry line.

auditCreatedDateTime Datetime True

The date and time when the journal entry line was created.

auditModifiedBy String True

The user who last modified the journal entry line.

auditModifiedDateTime Datetime True

The date and time when the journal entry line was last modified.

baseAmount Decimal True

The amount of this journal entry line in the base currency.

currencyBaseCurrency String False

The base currency used for this journal entry line.

currencyExchangeRate Decimal False

The exchange rate used to convert the transaction currency to the base currency for this line.

currencyExchangeRateDate Date False

The date used to determine the exchange rate for this journal entry line.

currencyExchangeRateTypeId String False

The Id of the exchange rate type used for currency conversion on this journal entry line.

currencyTxnCurrency String False

The transaction currency used for this journal entry line.

description String False

The description or memo for this journal entry line.

documentId String False

The document Id associated with this journal entry line.

entryDate Date True

The date on which this journal entry line was entered.

glAccount_Href String True

The URL of the GL account associated with this journal entry line.

glAccount_Id String False

The Id of the GL account associated with this journal entry line.

glAccount_Key String False

The system-assigned key of the GL account associated with this journal entry line.

glAccount_Name String True

The name of the GL account associated with this journal entry line.

href String True

The URL of the journal entry line resource.

id String True

The unique identifier of the journal entry line record.

interEntityTxnType String True

The inter-entity transaction type for this journal entry line, indicating how it is handled across entities.

isBillable Bool False

Indicates whether this journal entry line is billable to a customer or project.

isBilled Bool True

Indicates whether this journal entry line has been billed.

journalEntry_Href String True

The URL of the journal entry associated with this line.

journalEntry_Id String False

The Id of the journal entry associated with this line.

journalEntry_Key String False

The system-assigned key of the journal entry associated with this line.

key [KEY] String True

The system-assigned key that uniquely identifies the journal entry line record.

lineNumber Int True

The sequential line number of this entry within the journal entry.

numberOfUnits Int True

The number of units associated with this journal entry line.

parent_Href String True

The URL of the parent line associated with this journal entry line.

parent_Id String True

The Id of the parent line associated with this journal entry line.

parent_Key String True

The system-assigned key of the parent line associated with this journal entry line.

reconciliationGroupCleared String True

The cleared status of the reconciliation group associated with this journal entry line.

reconciliationGroupClearingDate Date True

The date on which the reconciliation group associated with this line was cleared.

reconciliationGroupReconciliationDate Date True

The date on which the reconciliation group associated with this line was reconciled.

state String False

The current state of this journal entry line, such as draft, submitted, or posted.

txnAmount Decimal False

The amount of this journal entry line in the transaction currency.

txnType String False

The transaction type for this journal entry line, such as debit or credit.

ListAggregate_TaxEntries String False

The aggregate list of tax entries associated with this journal entry line.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655