JournalLine
A journal line contains the journal entry lines information for the journal entry. Journal lines contain the associated journal entry header identifier, line number, and associated account information along with the debits or credits.
Business Views
** Available for extracting data- journalLinesExtract**
A journal line contains the journal entry lines information for the journal entry. Journal lines contain the associated journal entry header identifier, line number, and associated account information along with the debits or credits.
Label
Journal Lines
Data Source
Read-optimized data store
Fields
- accountedCr (big-decimal)
Credit amount in the ledger currency.
Label
Accounted Credit
Properties
- searchable
- sortable
- accountedDr (big-decimal)
Debit amount in the ledger currency.
Label
Accounted Debit
Properties
- searchable
- sortable
- accountingDate (date)
Date used to determine the accounting period.
Label
Accounting Date
Properties
- searchable
- sortable
- not nullable
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- searchable
- sortable
- not readable
- not nullable
- currencyConversionDate (date)
Journal line currency conversion date.
Label
Conversion Date
Properties
- searchable
- sortable
- not nullable
- currencyConversionRate (big-decimal)
Journal line currency conversion rate.
Label
Conversion Rate
Properties
- searchable
- sortable
- not nullable
- description (string)
User-defined description of the journal line.
Label
Description
Properties
- searchable
- sortable
- enteredCr (big-decimal)
Credit amount in the entered currency.
Label
Entered Credit
Properties
- searchable
- sortable
- enteredDr (big-decimal)
Debit amount in the entered currency.
Label
Entered Debit
Properties
- searchable
- sortable
- glSlLinkTable (string)
Name of the subledger journal table used to drill down from the general ledger to the subledger transaction.
Label
Subledger Table Name
Properties
- searchable
- sortable
- journalHeaderId (int64)
Identifier of the journal header.
Label
Header ID
Properties
- searchable
- sortable
- not nullable
- journalLineNumber (int64)
Number of the journal line.
Label
Line Number
Properties
- searchable
- sortable
- not nullable
- lineTypeCode (string)
Identifies the type of line such as suspense, rounding, and intercompany. Valid values are blank, INTRA, INTER, ENTERED_CURR_BALANCE, SUSPENSE, ROUNDING, and GAIN_LOSS.
Label
Line Type
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 accounting period.
Label
Period Name
Properties
- searchable
- sortable
- not nullable
- reference1 (string)
First reference value of a journal line used to store a specific value related to the source subledger transaction.
Label
Reference 1
Properties
- searchable
- sortable
- reference10 (string)
Tenth reference value of a journal line used to store a specific value related to the source subledger transaction.
Label
Reference 10
Properties
- searchable
- sortable
- reference2 (string)
Second reference value of a journal line used to store a specific value related to the source subledger transaction.
Label
Reference 2
Properties
- searchable
- sortable
- reference3 (string)
Third reference value of a journal line used to store a specific value related to the source subledger transaction.
Label
Reference 3
Properties
- searchable
- sortable
- reference4 (string)
Fourth reference value of a journal line used to store a specific value related to the source subledger transaction.
Label
Reference 4
Properties
- searchable
- sortable
- reference5 (string)
Fifth reference value of a journal line used to store a specific value related to the source subledger transaction.
Label
Reference 5
Properties
- searchable
- sortable
- reference6 (string)
Sixth reference value of a journal line used to store a specific value related to the source subledger transaction.
Label
Reference 6
Properties
- searchable
- sortable
- reference7 (string)
Seventh reference value of a journal line used to store a specific value related to the source subledger transaction.
Label
Reference 7
Properties
- searchable
- sortable
- reference8 (string)
Eighth reference value of a journal line used to store a specific value related to the source subledger transaction.
Label
Reference 8
Properties
- searchable
- sortable
- reference9 (string)
Ninth reference value of a journal line used to store a specific value related to the source subledger transaction.
Label
Reference 9
Properties
- searchable
- sortable
- statisticalAmount (big-decimal)
Amount entered in a journal that's based on the unit of measure.
Label
Statistical Amount
Properties
- searchable
- sortable
- status (string)
Status of the journal line. A list of accepted values is defined in the lookup type MJE_BATCH_STATUS.
Label
Status
Properties
- searchable
- sortable
- not nullable
- 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
Reference Object
- account (GeneralLedgerAccount)
A general ledger account contains information about account combinations for each accounting flexfield structure that are used for accounting transactions.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- 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
CurrencyConversionRateTypeFields
- 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
- conversionRateType (string)
- 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
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- 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
LedgerFields
- ledgerId (int64)
The unique identifier of the ledger for which the accounting entry is created.
Label
Ledger ID
Properties
- searchable
- sortable
- not nullable
- ledgerId (int64)
- accountedCr (big-decimal)