SubledgerAccountingEntryLine
A subledger accounting entry line contains the accounting entry lines information for each subledger accounting entry. These lines contain the associated accounting entry header identifier, line number, and associated account information and related debits or credits.
Business Views
** Available for extracting data- subledgerAccountingEntryLinesExtract**
A subledger accounting entry line contains the accounting entry lines information for each subledger accounting entry. These lines contain the associated accounting entry header identifier, line number, and associated account information and related debits or credits.
Label
Subledger Accounting Entry Lines
Data Source
Read-optimized data store
Fields
- accountedCr (big-decimal)
The credit amount of the subledger accounting entry line in the accounting currency.
Label
Accounted Credit
Properties
- searchable
- sortable
- accountedDr (big-decimal)
The debit amount of the subledger accounting entry line in the accounting currency.
Label
Accounted Debit
Properties
- searchable
- sortable
- accountingDate (date)
The date that's used to determine the accounting period of the subledger accounting entry and when the entry appears in fiscal reports and queries.
Label
Accounting Date
Properties
- searchable
- sortable
- not nullable
- applicationId (int64)
The unique identifier of the source application that represents a functional area.
Label
Application
Properties
- searchable
- sortable
- not nullable
- businessClassCode (string)
Indicates the classification assigned to a business class that's used for reporting or in reference to an option. A list of accepted values is defined in the lookup type XLA_BUSINESS_FLOW_CLASS.
Label
Business Class Short Name
Properties
- searchable
- sortable
- controlBalance (string)
Indicates the status of third party control balance calculation.
Label
Control Balance Indicator
Properties
- searchable
- sortable
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- searchable
- sortable
- not nullable
- currencyConversionDate (date)
The date that's used to determine the effective rate and calculate accounted amounts when the entered currency isn't the same as the ledger currency.
Label
Conversion Date
Properties
- searchable
- sortable
- currencyConversionRate (big-decimal)
The exchange rate used in the subledger accounting entry line when the entered currency isn't the same as the ledger currency.
Label
Conversion Rate
Properties
- searchable
- sortable
- displayedLineNumber (string)
The line number associated with the subledger journal entry line.
Label
Journal Line Number
Properties
- searchable
- sortable
- enteredCr (big-decimal)
The credit amount of the subledger accounting entry line in the transaction currency.
Label
Entered Credit
Properties
- searchable
- sortable
- enteredDr (big-decimal)
The debit amount of the subledger accounting entry line in the transaction currency.
Label
Entered Debit
Properties
- searchable
- sortable
- fundsStatusCode (enumeration: FundsStatusEnum)
Indicates the status resulting from a fund check performed on a journal entry. A list of accepted values is defined in the lookup type XLA_FUNDS_STATUS.
Label
Funds Status
Type
-
Module: oraErpCoreSubledgerAccountingEntries
-
Enumeration Type: FundsStatusEnum
Properties
- searchable
- sortable
Valid Values
- A
- F
- FAILED
- INPROCESS
- P
- PASSED
- R
- REQUIRED
- S
-
- gainOrLossFlag (boolean)
Indicates whether the subledger journal entry line is a gain or a loss line. A list of accepted values is defined in the lookup type YES_NO.
Label
Gain or Loss Indicator
Properties
- searchable
- sortable
- intercompanyReversalFlag (boolean)
Indicates whether the subledger journal entry line is an intercompany reversal line. A list of accepted values is defined in the lookup type YES_NO.
Label
Intercompany Reversal
Properties
- searchable
- sortable
- lineDescription (string)
The description of the subledger accounting entry line provided by the user or source application.
Label
Line Description
Properties
- searchable
- sortable
- mpaAccrualEntryFlag (boolean)
Indicates whether the subledger journal entry line is a multiperiod accounting entry or an accrual entry.
Label
Multiperiod Accrual Entry Indicator
Properties
- searchable
- sortable
- overrideReason (string)
The reason to override a subledger accounting entry line.
Label
Override Reason
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
- partyTypeCode (enumeration: PartyTypeEnum)
Indicates the type of third party.
Label
Third-Party Type
Type
-
Module: oraErpCoreSubledgerAccountingEntries
-
Enumeration Type: PartyTypeEnum
Properties
- searchable
- sortable
Valid Values
- C
- S
-
- periodName (string)
The accounting period associated with the subledger accounting entry.
Label
Period Name
Properties
- searchable
- sortable
- reconciliationReference (string)
The unique identifier assigned by the system for reconciliation matching.
Label
Reconciliation Reference
Properties
- searchable
- sortable
- statisticalAmount (big-decimal)
The statistical amount of a subledger accounting entry line.
Label
Statistical Amount
Properties
- searchable
- sortable
- subledgerJournalHeaderId (int64)
The unique identifier of the subledger accounting entry.
Label
Subledger Accounting Entry Header Identifier
Properties
- searchable
- sortable
- not nullable
- subledgerJournalLineNumber (int64)
The number associated with each subledger accounting entry line.
Label
Subledger Accounting Entry Line Number
Properties
- searchable
- sortable
- not nullable
- suppRefCombinationIdentifier (string)
The unique identifier of the combination that includes additional transactional information on a subledger accounting entry line.
Label
Supporting Reference Combination Identifier
Properties
- searchable
- sortable
- supportingReference1 (string)
The source value associated with Supporting Reference 1.
Label
Supporting Reference 1 Value
Properties
- searchable
- sortable
- supportingReference10 (string)
The source value associated with Supporting Reference 10.
Label
Supporting Reference 10 Value
Properties
- searchable
- sortable
- supportingReference11 (string)
The source value associated with Supporting Reference 11.
Label
Supporting Reference 11 Value
Properties
- searchable
- sortable
- supportingReference12 (string)
The source value associated with Supporting Reference 12.
Label
Supporting Reference 12 Value
Properties
- searchable
- sortable
- supportingReference13 (string)
The source value associated with Supporting Reference 13.
Label
Supporting Reference 13 Value
Properties
- searchable
- sortable
- supportingReference14 (string)
The source value associated with Supporting Reference 14.
Label
Supporting Reference 14 Value
Properties
- searchable
- sortable
- supportingReference15 (string)
The source value associated with Supporting Reference 15.
Label
Supporting Reference 15 Value
Properties
- searchable
- sortable
- supportingReference16 (string)
The source value associated with Supporting Reference 16.
Label
Supporting Reference 16 Value
Properties
- searchable
- sortable
- supportingReference17 (string)
The source value associated with Supporting Reference 17.
Label
Supporting Reference 17 Value
Properties
- searchable
- sortable
- supportingReference18 (string)
The source value associated with Supporting Reference 18.
Label
Supporting Reference 18 Value
Properties
- searchable
- sortable
- supportingReference19 (string)
The source value associated with Supporting Reference 19.
Label
Supporting Reference 19 Value
Properties
- searchable
- sortable
- supportingReference2 (string)
The source value associated with Supporting Reference 2.
Label
Supporting Reference 2 Value
Properties
- searchable
- sortable
- supportingReference20 (string)
The source value associated with Supporting Reference 20.
Label
Supporting Reference 20 Value
Properties
- searchable
- sortable
- supportingReference21 (string)
The source value associated with Supporting Reference 21.
Label
Supporting Reference 21 Value
Properties
- searchable
- sortable
- supportingReference22 (string)
The source value associated with Supporting Reference 22.
Label
Supporting Reference 22 Value
Properties
- searchable
- sortable
- supportingReference23 (string)
The source value associated with Supporting Reference 23.
Label
Supporting Reference 23 Value
Properties
- searchable
- sortable
- supportingReference24 (string)
The source value associated with Supporting Reference 24.
Label
Supporting Reference 24 Value
Properties
- searchable
- sortable
- supportingReference25 (string)
The source value associated with Supporting Reference 25.
Label
Supporting Reference 25 Value
Properties
- searchable
- sortable
- supportingReference26 (string)
The source value associated with Supporting Reference 26.
Label
Supporting Reference 26 Value
Properties
- searchable
- sortable
- supportingReference27 (string)
The source value associated with Supporting Reference 27.
Label
Supporting Reference 27 Value
Properties
- searchable
- sortable
- supportingReference28 (string)
The source value associated with Supporting Reference 28.
Label
Supporting Reference 28 Value
Properties
- searchable
- sortable
- supportingReference29 (string)
The source value associated with Supporting Reference 29.
Label
Supporting Reference 29 Value
Properties
- searchable
- sortable
- supportingReference3 (string)
The source value associated with Supporting Reference 3.
Label
Supporting Reference 3 Value
Properties
- searchable
- sortable
- supportingReference30 (string)
The source value associated with Supporting Reference 30.
Label
Supporting Reference 30 Value
Properties
- searchable
- sortable
- supportingReference31 (string)
The source value associated with Supporting Reference 31.
Label
Supporting Reference 31 Value
Properties
- searchable
- sortable
- supportingReference32 (string)
The source value associated with Supporting Reference 32.
Label
Supporting Reference 32 Value
Properties
- searchable
- sortable
- supportingReference33 (string)
The source value associated with Supporting Reference 33.
Label
Supporting Reference 33 Value
Properties
- searchable
- sortable
- supportingReference34 (string)
The source value associated with Supporting Reference 34.
Label
Supporting Reference 34 Value
Properties
- searchable
- sortable
- supportingReference35 (string)
The source value associated with Supporting Reference 35.
Label
Supporting Reference 35 Value
Properties
- searchable
- sortable
- supportingReference36 (string)
The source value associated with Supporting Reference 36.
Label
Supporting Reference 36 Value
Properties
- searchable
- sortable
- supportingReference37 (string)
The source value associated with Supporting Reference 37.
Label
Supporting Reference 37 Value
Properties
- searchable
- sortable
- supportingReference38 (string)
The source value associated with Supporting Reference 38.
Label
Supporting Reference 38 Value
Properties
- searchable
- sortable
- supportingReference39 (string)
The source value associated with Supporting Reference 39.
Label
Supporting Reference 39 Value
Properties
- searchable
- sortable
- supportingReference4 (string)
The source value associated with Supporting Reference 4.
Label
Supporting Reference 4 Value
Properties
- searchable
- sortable
- supportingReference40 (string)
The source value associated with Supporting Reference 40.
Label
Supporting Reference 40 Value
Properties
- searchable
- sortable
- supportingReference41 (string)
The source value associated with Supporting Reference 41.
Label
Supporting Reference 41 Value
Properties
- searchable
- sortable
- supportingReference42 (string)
The source value associated with Supporting Reference 42.
Label
Supporting Reference 42 Value
Properties
- searchable
- sortable
- supportingReference43 (string)
The source value associated with Supporting Reference 43.
Label
Supporting Reference 43 Value
Properties
- searchable
- sortable
- supportingReference44 (string)
The source value associated with Supporting Reference 44.
Label
Supporting Reference 44 Value
Properties
- searchable
- sortable
- supportingReference45 (string)
The source value associated with Supporting Reference 45.
Label
Supporting Reference 45 Value
Properties
- searchable
- sortable
- supportingReference46 (string)
The source value associated with Supporting Reference 46.
Label
Supporting Reference 46 Value
Properties
- searchable
- sortable
- supportingReference47 (string)
The source value associated with Supporting Reference 47.
Label
Supporting Reference 47 Value
Properties
- searchable
- sortable
- supportingReference48 (string)
The source value associated with Supporting Reference 48.
Label
Supporting Reference 48 Value
Properties
- searchable
- sortable
- supportingReference49 (string)
The source value associated with Supporting Reference 49.
Label
Supporting Reference 49 Value
Properties
- searchable
- sortable
- supportingReference5 (string)
The source value associated with Supporting Reference 5.
Label
Supporting Reference 5 Value
Properties
- searchable
- sortable
- supportingReference50 (string)
The source value associated with Supporting Reference 50.
Label
Supporting Reference 50 Value
Properties
- searchable
- sortable
- supportingReference51 (string)
The source value associated with Supporting Reference 51.
Label
Supporting Reference 51 Value
Properties
- searchable
- sortable
- supportingReference52 (string)
The source value associated with Supporting Reference 52.
Label
Supporting Reference 52 Value
Properties
- searchable
- sortable
- supportingReference53 (string)
The source value associated with Supporting Reference 53.
Label
Supporting Reference 53 Value
Properties
- searchable
- sortable
- supportingReference54 (string)
The source value associated with Supporting Reference 54.
Label
Supporting Reference 54 Value
Properties
- searchable
- sortable
- supportingReference55 (string)
The source value associated with Supporting Reference 55.
Label
Supporting Reference 55 Value
Properties
- searchable
- sortable
- supportingReference56 (string)
The source value associated with Supporting Reference 56.
Label
Supporting Reference 56 Value
Properties
- searchable
- sortable
- supportingReference57 (string)
The source value associated with Supporting Reference 57.
Label
Supporting Reference 57 Value
Properties
- searchable
- sortable
- supportingReference58 (string)
The source value associated with Supporting Reference 58.
Label
Supporting Reference 58 Value
Properties
- searchable
- sortable
- supportingReference59 (string)
The source value associated with Supporting Reference 59.
Label
Supporting Reference 59 Value
Properties
- searchable
- sortable
- supportingReference6 (string)
The source value associated with Supporting Reference 6.
Label
Supporting Reference 6 Value
Properties
- searchable
- sortable
- supportingReference60 (string)
The source value associated with Supporting Reference 60.
Label
Supporting Reference 60 Value
Properties
- searchable
- sortable
- supportingReference7 (string)
The source value associated with Supporting Reference 7.
Label
Supporting Reference 7 Value
Properties
- searchable
- sortable
- supportingReference8 (string)
The source value associated with Supporting Reference 8.
Label
Supporting Reference 8 Value
Properties
- searchable
- sortable
- supportingReference9 (string)
The source value associated with Supporting Reference 9.
Label
Supporting Reference 9 Value
Properties
- searchable
- sortable
- supportingReferenceBalanceFlag (boolean)
Indicates the status of supporting reference balance calculation.
Label
Supporting Reference Balance Indicator
Properties
- searchable
- sortable
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- sortable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not nullable
- unroundedAccountedCr (big-decimal)
The unrounded credit amount of the subledger accounting entry line in the ledger currency.
Label
Unrounded Accounted Amount Credit
Properties
- searchable
- sortable
- unroundedAccountedDr (big-decimal)
The unrounded debit amount of the subledger accounting entry line in the ledger currency.
Label
Unrounded Accounted Amount Debit
Properties
- searchable
- sortable
- unroundedEnteredCr (big-decimal)
The subledger accounting entry line unrounded credit amount in the entered currency.
Label
Unrounded Entered Amount Credit
Properties
- searchable
- sortable
- unroundedEnteredDr (big-decimal)
The unrounded debit amount of the subledger accounting entry line in the entered currency.
Label
Unrounded Entered Amount Debit
Properties
- searchable
- sortable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- searchable
- sortable
- not nullable
Reference Object
- account (GeneralLedgerAccount)
Identifier of the account combination.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- accountingClassLookup (ERPLookupCode)
The short name of a lookup type that's shared across applications to classify journal entry lines. A list of accepted values is defined in the lookup type XLA_ACCOUNTING_CLASS.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupType (string)
The unique identifier of the Lookup Type.
Label
Lookup Type ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- 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)
- customer (Customer)
The Customer party represents an entity (either an individual or an organization) that purchases goods or services and to whom invoices and payment requests are issued.
Business Object
CustomerFields
- id (int64)
The unique identifier of the party.
Label
Party ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- customerSite (CustomerAccountSite)
The Customer Account Site business object provides the details of all customer account sites across all business units. A customer account site is one specific location belonging to a customer account. A single customer account can have multiple sites.
Business Object
CustomerAccountSiteFields
- customerAccountSiteId (int64)
Identifier of the customer account site.
Label
Customer Account Site ID
Properties
- searchable
- sortable
- not nullable
- customerAccountSiteId (int64)
- 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
EncumbranceTypeFields
- encumbranceTypeId (int64)
Identifier of the encumbrance type.
Label
Encumbrance Type ID
Properties
- searchable
- sortable
- not nullable
- encumbranceTypeId (int64)
- enteredCurrency (Currency)
Currencies are defined and populated through seed data and used to create transactions within the application. This object encapsulates various properties and functionalities related to a specific currency.
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)
- lookupBatchStatus (ERPLookupCode)
Indicates the budgetary control completion status of the subledger accounting entry line.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- originalAccount (GeneralLedgerAccount)
The code combination identifier of the account that was substituted for this subledger journal entry line. This is a foreign key of the General Ledger Accounts view object.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- overridenAccount (GeneralLedgerAccount)
The code combination identifier of the account that this line overrides. This is a foreign key of the General Ledger Accounts view object.
Business Object
GeneralLedgerAccountFields
- codeCombinationId (int64)
The unique identifier of the account combination.
Label
Account ID
Properties
- inherited
- creatable
- searchable
- sortable
- not nullable
- codeCombinationId (int64)
- accountedCr (big-decimal)