ReportingBookAssetAccountingLine

A reporting book accounting line contains journal entry lines for every asset transaction that has a financial impact on the reporting asset book. These accounting lines are used to create journal entries in Oracle Subledger Accounting and transfer them to Oracle General Ledger.

Expand all

Collapse all

Business Views

** Available for extracting data

• reportingBookAssetAccountingLinesExtract**

  A reporting book accounting line contains journal entry lines for every asset transaction that has a financial impact on the reporting asset book. These accounting lines are used to create journal entries in Oracle Subledger Accounting and transfer them to Oracle General Ledger.

  Label

  Reporting Book Asset Accounting Lines

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • adjustmentLineId (int64)

    The amount used to adjust the asset.

    Label

    Adjustment Line ID

    Properties

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

    The adjustment amount for a period multiplied by the number of periods in the fiscal year for retroactive transactions.

    Label

    Annualized Adjustment

    Properties

    • searchable
    • sortable
  • assetAdjustmentAmount (big-decimal)

    Transaction amount broken down by the account type and asset distribution.

    Label

    Asset Adjustment Amount

    Properties

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

    Value that identifies the type of adjustment to the asset.

    Label

    Asset Adjustment Type

    Properties

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

    Indicates whether amounts have been converted to the reporting currency.

    Label

    Conversion Status

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • searchable
    • sortable
    • not nullable
  • debitOrCredit (enumeration: DebitOrCredit)

    Indicates whether the line is Credit or Debit in the accounting entry for the asset transaction.

    Label

    Debit or Credit Line Indicator

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: DebitOrCredit

    Properties

    • searchable
    • sortable
    • not nullable

    Valid Values

    • CR
    • DR
  • depreciationOverride (string)

    Indicates whether a depreciation override amount is allowed for assets in the book.

    Label

    Depreciation Override Indicator

    Properties

    • searchable
    • sortable
  • insertionOrder (int64)

    The insertion order of bonus reserve adjustment amount entered for previous period transfers.

    Label

    Insertion Order

    Properties

    • searchable
    • sortable
  • ledgerId (int64)

    Code that identifies the ledger the accounting entry is created for.

    Label

    Ledger ID

    Properties

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

    Indicates whether the account information is created at the member level when the Track Member Account option is set.

    Label

    Member Asset Tracking

    Properties

    • searchable
    • sortable
  • sourceOrDestination (enumeration: SourceOrDestination)

    Indicates whether this line is on the source or destination side of a transaction.

    Label

    Source or Destination

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: SourceOrDestination

    Properties

    • searchable
    • sortable

    Valid Values

    • DEST
    • SOURCE
  • sourceTypeCode (string)

    Asset transaction type of the accounting line.

    Label

    Source Type Code

    Properties

    • searchable
    • sortable
    • not nullable
  • 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
  • transactionHeaderId (int64)

    Identifier of the transaction that created the row.

    Label

    Transaction Header ID

    Properties

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

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • account (GeneralLedgerAccount)

    A general ledger account combination represents the specific grouping of segment values within the Oracle General Ledger. It provides details of all the valid account combinations for each accounting flexfield structure within the General Ledger.

    Business Object

    GeneralLedgerAccount

    Expand all

    Collapse all

    Fields

    • codeCombinationId (int64)

      The unique identifier of the account combination.

      Label

      Account ID

      Properties

      • inherited
      • creatable
      • searchable
      • sortable
      • not nullable

  • adjustedPeriod (AssetBookPeriod)

    A book period contains information about the depreciation period status, period open date, and period close date for each asset book.

    Business Object

    AssetBookPeriod

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

      • searchable
      • sortable
      • not nullable
    • periodId (int64)

      Identifier of the depreciation period.

      Label

      Period ID

      Properties

      • searchable
      • sortable
      • not nullable

  • asset (Asset)

    An asset contains the descriptive information such as units, asset type, tag number, manufacturer number, serial number, and model number added in the asset book.

    Business Object

    Asset

    Expand all

    Collapse all

    Fields

    • assetId (int64)

      The identifier of the asset number.

      Label

      Asset ID

      Properties

      • searchable
      • sortable
      • not nullable

  • assetReportingBook (AssetReportingBook)

    A reporting book represents the secondary grouping in which fixed assets of the entity are recorded, tracked, depreciated, reported, and accounted for in the reporting currencies or in a secondary ledger with different currency than its primary ledger.

    Business Object

    AssetReportingBook

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      Code that identifies the ledger the accounting entry is created for.

      Label

      Ledger ID

      Properties

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

      The name of the asset book.

      Label

      Book

      Properties

      • searchable
      • sortable
      • not nullable

  • createdPeriod (AssetBookPeriod)

    A book period contains information about the depreciation period status, period open date, and period close date for each asset book.

    Business Object

    AssetBookPeriod

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

      • searchable
      • sortable
      • not nullable
    • periodId (int64)

      Identifier of the depreciation period.

      Label

      Period ID

      Properties

      • searchable
      • sortable
      • not nullable

  • distribution (AssetDistribution)

    The distribution history contains employee information, location information, and Accounting flexfield values assigned to assets in the asset book.

    Business Object

    AssetDistribution

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

      • searchable
      • sortable
      • not nullable
    • distributionId (int64)

      The identifier of the distribution.

      Label

      Distribution ID

      Properties

      • searchable
      • sortable
      • not nullable

  • sourceLine (AssetSourceLine)

    A source line contains asset acquisition invoice information from source applications, such as Oracle Payables, Oracle Receiving, and Oracle Project Costing, for tracking and reporting purposes in the primary asset book. A source line contains all costs imported from source applications, including, items, freight, taxes, project labor, and expenses.

    Business Object

    AssetSourceLine

    Expand all

    Collapse all

    Fields

    • sourceLineId (int64)

      Identifier of the asset source line.

      Label

      Source Line ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top