JournalHeader

A journal header consists of journal entries with a one-to-many relationship between journal entry batches and journal entries. It stores these entries, containing the associated batch identifier, entry name, description, status, and other information about the journal entry.

Expand all

Collapse all

Business Views

** Available for extracting data

• journalHeadersExtract**

  A journal header consists of journal entries with a one-to-many relationship between journal entry batches and journal entries. It stores these entries, containing the associated batch identifier, entry name, description, status, and other information about the journal entry.

  Label

  Journal Headers

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • accountedCredit (big-decimal)

    Accumulated total accounted credit amounts at the journal level.

    Label

    Accounted Credit

    Properties

    • searchable
    • sortable
  • accountedDebit (big-decimal)

    Accumulated total accounted debit amounts at the journal level.

    Label

    Accounted Debit

    Properties

    • searchable
    • sortable
  • accountingDate (date)

    Default accounting date used in journal headers.

    Label

    Default Accounting Date

    Properties

    • searchable
    • sortable
    • not nullable
  • accountingSequenceNumber (big-decimal)

    Accounting sequence number associated with the journal header.

    Label

    Accounting Sequence Number

    Properties

    • searchable
    • sortable
  • accrualReversalEffectiveDate (date)

    Effective date of the accrual reversal journal.

    Label

    Accrual Reversal Effective Date

    Properties

    • searchable
    • sortable
  • accrualReversalFlag (boolean)

    Indicates whether the subledger accounting entry is an accrual reversal entry.

    Label

    Accrual Reversal

    Properties

    • creatable
    • searchable
    • sortable
    • not nullable
    • updatable
  • accrualReversalPeriodName (string)

    The type of journal reversal. A list of accepted values is defined in the lookup type YES_NO. The value is passed as a parameter to attribute GlJeHeadersAccrualRevChangeSignFlagTransient.

    Label

    Reversal Period Name

    Properties

    • searchable
    • sortable
  • balancedJournalEntryFlag (boolean)

    Indicates whether the journal is balanced. Possible values include Y, for the journal is balanced and N, for the journal isn't balanced.

    Label

    Balanced Journal

    Properties

    • searchable
    • sortable
  • controlTotal (big-decimal)

    Control total entered for a journal header to validate that the journal is complete.

    Label

    Control Total

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • crossCurrencyPostingFlag (boolean)

    Indicates whether the posted journal has multiple currencies. If Y, then the journal has multiple currencies. If N, then the journal doesn't have multiple currencies.

    Label

    Cross-currency Journal Posting Indicator

    Properties

    • searchable
    • sortable
  • currencyConversionDate (date)

    Currency conversion date of the journal.

    Label

    Conversion Date

    Properties

    • searchable
    • sortable
  • currencyConversionRate (big-decimal)

    Currency conversion rate of the journal.

    Label

    Conversion Rate

    Properties

    • searchable
    • sortable
  • dateCreated (date)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • description (string)

    Description of the journal entered by the user.

    Label

    Description

    Properties

    • searchable
    • sortable
  • enteredCredit (big-decimal)

    Accumulated total entered credit amounts at the journal level.

    Label

    Entered Credit

    Properties

    • searchable
    • sortable
  • enteredDebit (big-decimal)

    Accumulated total entered debit amounts at the journal level.

    Label

    Entered Debit

    Properties

    • searchable
    • sortable
  • journalHeaderId (int64)

    Identifier of the journal header.

    Label

    Header ID

    Properties

    • searchable
    • sortable
    • not nullable
  • multiCurrencyFlag (boolean)

    Indicates whether the journal contains multiple currencies. If Y, then the journal contains multiple currencies. If N, then the journal contains one currency.

    Label

    Multicurrency

    Properties

    • searchable
    • sortable
    • not nullable
  • name (string)

    Name of the journal entered by the user.

    Label

    General Ledger Journal

    Properties

    • searchable
    • sortable
    • not nullable
  • originatingBalSegValue (string)

    Intercompany clearing entity used to balance the journal.

    Label

    Clearing Company

    Properties

    • searchable
    • sortable
  • partitionGroupCode (string)

    Partition grouping information, which when combined with the period, determines the database partition in which the journal will be stored

    Label

    Partition Group Code

    Properties

    • searchable
    • sortable
  • periodName (string)

    Name of the calendar period.

    Label

    Period Name

    Properties

    • searchable
    • sortable
    • not nullable
  • postedDate (date)

    Date when the journal entry is posted to the general ledger.

    Label

    Journal header posted date.

    Properties

    • searchable
    • sortable
  • referenceDate (date)

    Additional date information entered by the user.

    Label

    Reference Date

    Properties

    • searchable
    • sortable
  • reportingSequenceNumber (big-decimal)

    Reporting sequence number associated with the journal header.

    Label

    Reporting Sequence Number

    Properties

    • searchable
    • sortable
  • status (string)

    Status of the journal header. A list of accepted values is defined in the lookup type MJE_BATCH_STATUS.

    Label

    Status

    Properties

    • searchable
    • sortable
    • not nullable
  • subledgerJournalCode (string)

    Subledger journal associated with the journal header.

    Label

    Subledger Journal

    Properties

    • searchable
    • sortable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not readable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • accountingSequence (SequenceVersion)

    The accounting sequence value for the journal.

    Business Object

    SequenceVersion

    Expand all

    Collapse all

    Fields

    • seqVersionId (int64)

      Identifier of the sequence version.

      Label

      Sequence Version ID

      Properties

      • searchable
      • sortable
      • not nullable

  • accrualReversalJournal (JournalHeader)

    Indicates whether the journal entry is an accrual reversal entry. Possible values include Y, for the journal is an accrual reversal journal and N, for the journal isn't an accrual reversal journal.

    Business Object

    JournalHeader

    Expand all

    Collapse all

    Fields

    • journalHeaderId (int64)

      Identifier of the journal header.

      Label

      Header ID

      Properties

      • searchable
      • sortable
      • not nullable

  • batch (JournalBatch)

    A journal batch contains information such as batch name and description, status, and running total debits and credits. The batch status indicates whether it has been posted, selected for posting, or in the process of being posted.

    Business Object

    JournalBatch

    Expand all

    Collapse all

    Fields

    • description (string)

      User-defined description of the journal batch.

      Label

      Description

      Properties

      • searchable
      • sortable
    • journalBatchId (int64)

      Unique identifier of the journal batch.

      Label

      Batch ID

      Properties

      • searchable
      • sortable
      • not nullable
    • name (string)

      Name of the journal batch.

      Label

      Journal Batch

      Properties

      • searchable
      • sortable
      • not nullable

  • conversionRateType (CurrencyConversionRateType)

    A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting currency.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

  • currency (Currency)

    A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      Properties

      • searchable
      • sortable
      • not nullable

  • encumbranceType (EncumbranceType)

    An encumbrance type stores information about encumbrance types, including their identifiers and descriptions. It serves as a comprehensive source for encumbrance type information.

    Business Object

    EncumbranceType

    Expand all

    Collapse all

    Fields

    • description (string)

      Description of the encumbrance type.

      Label

      Description

      Properties

      • translatable
    • encumbranceType (string)

      Encumbrance Type name such as Commitment or Obligation.

      Label

      Encumbrance Type Name

      Properties

      • translatable
      • not nullable
    • encumbranceTypeId (int64)

      Identifier of the encumbrance type.

      Label

      Encumbrance Type ID

      Properties

      • searchable
      • sortable
      • not nullable
    • $language (string)

      The language of the record.

      Label

      Language

      Properties

      • creatable
      • translatable
      • not nullable

  • journalCategory (JournalCategory)

    A journal category contains the category information that identifies the purpose of a journal, such as Adjustments or Invoices.

    Business Object

    JournalCategory

    Expand all

    Collapse all

    Fields

    • jeCategoryName (string)

      Name of the journal category.

      Label

      Category Name

      Properties

      • searchable
      • sortable
      • not nullable

  • journalSource (JournalSource)

    A journal source is defined to identify the origin of journals, such as Receivables or Payables. General Ledger supplies a number of predefined journal sources but users can create their own journal sources as well. A journal source contains details about the source name assigned to each journal entry in the general ledger during journal header creation.

    Business Object

    JournalSource

    Expand all

    Collapse all

    Fields

    • jeSourceName (string)

      Name of the journal source.

      Label

      Journal Source

      Properties

      • searchable
      • sortable
      • not nullable

  • ledger (Ledger)

    A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.

    Business Object

    Ledger

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      The unique identifier of the ledger for which the accounting entry is created.

      Label

      Ledger ID

      Properties

      • searchable
      • sortable
      • not nullable

  • legalEntity (LegalEntity)

    A legal entity represents an entity created under a commercial law which can own property, create obligation, recruit people, trade, account for themselves to regulators, taxation authorities, and owners. It identifies the legal owner or custodian for each business transaction for legal compliance and reporting.

    Business Object

    LegalEntity

    Expand all

    Collapse all

    Fields

    • legalEntityId (int64)

      The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.

      Label

      Legal Entity ID

      Properties

      • searchable
      • sortable
      • not nullable

  • lookupAccrualReversalChangeSign (ERPLookupCode)

    The status of the reversed journal entry. A list of accepted values is defined in the lookup type JE_REVERSAL_STATUS.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • lookupAccrualReversalStatus (ERPLookupCode)

    The type of reversal. A list of accepted values is defined in the lookup type REVERSAL_OPTION_CODE.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • lookupBalanceType (ERPLookupCode)

    The type of journal balance. Valid values are Actual, Budget, and Encumbrance.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • parentJournal (JournalHeader)

    Name of the originating journal of the accrual reversal journal.

    Business Object

    JournalHeader

    Expand all

    Collapse all

    Fields

    • journalHeaderId (int64)

      Identifier of the journal header.

      Label

      Header ID

      Properties

      • searchable
      • sortable
      • not nullable

  • reportingSequence (SequenceVersion)

    The reporting sequence value for the journal.

    Business Object

    SequenceVersion

    Expand all

    Collapse all

    Fields

    • seqVersionId (int64)

      Identifier of the sequence version.

      Label

      Sequence Version ID

      Properties

      • searchable
      • sortable
      • not nullable

  • reversedJournal (JournalHeader)

    The name of the journal that was reversed.

    Business Object

    JournalHeader

    Expand all

    Collapse all

    Fields

    • journalHeaderId (int64)

      Identifier of the journal header.

      Label

      Header ID

      Properties

      • searchable
      • sortable
      • not nullable
    • name (string)

      Name of the journal entered by the user.

      Label

      General Ledger Journal

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top