AssetTransactionBetweenAssetsHistory

A transaction between assets history contains information about interasset transactions, in which two or more dependent transactions are performed at one time.

Expand all

Collapse all

Business Views

** Available for extracting data

• assetTransactionBetweenAssetsHistoriesExtract**

  A transaction between assets history contains information about interasset transactions, in which two or more dependent transactions are performed at one time.

  Label

  Asset Transaction Between Assets Histories

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • amortizationStartDateOfTheDestinationAsset (date)

    The amortization start date for the destination asset transaction.

    Label

    Amortization Start Date of the Destination Asset

    Properties

    • searchable
    • sortable
  • amortizationStartDateOfTheSourceAsset (date)

    The amortization start date for the source asset transaction.

    Label

    Amortization Start Date of the Source Asset

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

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

    The amount entered for catch-up depreciation expense on the destination asset transaction.

    Label

    Depreciation Expense Amount of the Destination Asset

    Properties

    • searchable
    • sortable
  • depreciationExpenseAmountOfTheSourceAsset (big-decimal)

    The amount entered for catch-up depreciation expense on the source asset transaction.

    Label

    Depreciation Expense Amount of the Source Asset

    Properties

    • searchable
    • sortable
  • destinationBookName (string)

    The name of the asset book.

    Label

    Destination Book

    Properties

    • searchable
    • sortable
  • destinationTransactionSubtype (string)

    More details about the type of transaction for the destination asset.

    Label

    Destination Transaction Subtype

    Properties

    • searchable
    • sortable
  • endOfFiscalYearReserveOfTheDestinationAsset (big-decimal)

    The depreciation reserve of the destination asset at the end of the previous fiscal year.

    Label

    End of Fiscal Year Reserve of the Destination Asset

    Properties

    • searchable
    • sortable
  • endOfFiscalYearReserveOfTheSourceAsset (big-decimal)

    The amount entered for the reserve of the prior fiscal year for the source asset.

    Label

    End of Fiscal Year Reserve of the Source Asset

    Properties

    • searchable
    • sortable
  • reserveTransferAmount (big-decimal)

    The reserve amount transferred between assets.

    Label

    Reserve Transfer Amount

    Properties

    • searchable
    • sortable
  • sourceTransactionSubtype (string)

    More details about the type of transaction for the destination asset.

    Label

    Source Transaction Subtype

    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
  • transactionReferenceId (int64)

    Transaction reference identifier, which links transactions with multiple assets.

    Label

    Transaction Reference ID

    Properties

    • searchable
    • sortable
    • not nullable
  • transactionTypeCode (enumeration: TransactionType)

    A classification of events that can occur during an asset's life. For example, additions, adjustments, or retirements.

    Label

    Transaction Type

    Type

    • Module: oraErpCoreFixedAssets

    • Enumeration Type: TransactionType

    Properties

    • searchable
    • sortable

    Valid Values

    • ADDITION
    • ADDITION/VOID
    • ADJUSTMENT
    • CIP ADDITION
    • CIP ADJUSTMENT
    • CIP REVERSE
    • FULL RETIREMENT
    • GROUP ADDITION
    • GROUP ADJUSTMENT
    • PARTIAL RETIREMENT

    For a complete list of valid values, see the TransactionType enumeration type.

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • searchable
    • sortable
    • not nullable

  Expand all

  Collapse all

  Reference Object

  • assetBook (AssetBook)

    A book represents the grouping in which fixed assets of the entity are recorded, tracked, depreciated, reported, and accounted for in the primary ledger.

    Business Object

    AssetBook

    Expand all

    Collapse all

    Fields

    • name (string)

      The name of the asset book.

      Label

      Book

      Properties

      • searchable
      • sortable
      • not nullable

  • destinationAsset (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

  • destinationTransaction (AssetTransaction)

    A transaction stores addition, adjustment, transfer, retirement, CIP capitalization, and mass copy information for an asset in the asset book.

    Business Object

    AssetTransaction

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

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

      Unique identifier of the asset transaction.

      Label

      Transaction Header ID

      Properties

      • searchable
      • sortable
      • not nullable

  • invoiceTransaction (AssetSourceLineTransaction)

    A source line transaction contains asset acquisition invoice line information, including the transaction type from source applications such as Oracle Payables.

    Business Object

    AssetSourceLineTransaction

    Expand all

    Collapse all

    Fields

    • invoiceTransactionId (int64)

      Unique identifier of the invoice transaction.

      Label

      Invoice Transaction ID

      Properties

      • searchable
      • sortable
      • not nullable

  • memberAsset (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

  • memberTransaction (AssetTransaction)

    A transaction stores addition, adjustment, transfer, retirement, CIP capitalization, and mass copy information for an asset in the asset book.

    Business Object

    AssetTransaction

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

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

      Unique identifier of the asset transaction.

      Label

      Transaction Header ID

      Properties

      • searchable
      • sortable
      • not nullable

  • sourceAsset (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

  • sourceTransaction (AssetTransaction)

    A transaction stores addition, adjustment, transfer, retirement, CIP capitalization, and mass copy information for an asset in the asset book.

    Business Object

    AssetTransaction

    Expand all

    Collapse all

    Fields

    • bookName (string)

      The name of the asset book.

      Label

      Book

      Properties

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

      Unique identifier of the asset transaction.

      Label

      Transaction Header ID

      Properties

      • searchable
      • sortable
      • not nullable

  • subledgerAccountingEvent (SubledgerAccountingEvent)

    A Subledger Accounting event is an event raised to account for the Subledger Accounting transaction.

    Business Object

    SubledgerAccountingEvent

    Expand all

    Collapse all

    Fields

    • eventId (int64)

      The unique identifier of the accounting event within an application and event class.

      Label

      Event Identifier

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top