AssetTransaction

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

Expand all

Collapse all

Business Views

** Available for extracting data

• assetTransactionsExtract**

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

  Label

  Asset Transactions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • amortizationStartDate (date)

    The date from which the amortization calculation begins for an asset transaction.

    Label

    Amortization Start Date

    Properties

    • searchable
    • sortable
  • bookName (string)

    The name of the asset book.

    Label

    Book

    Properties

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

    User-entered commentary for asset transactions.

    Label

    Comments

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

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

    Date on which the asset transaction becomes effective.

    Label

    Effective Date

    Properties

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

    Date used to calculate the annual depreciation for assets.

    Label

    Prorate Date

    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
  • transactionDate (date)

    The date on which the transaction is entered.

    Label

    Transaction Date

    Properties

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

    User-defined batch name used for processing mass transactions.

    Label

    Transaction Group

    Properties

    • searchable
    • sortable
  • transactionHeaderId (int64)

    Unique identifier of the asset transaction.

    Label

    Transaction Header ID

    Properties

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

    The source interface from which the transaction was created.

    Label

    Transaction Source

    Properties

    • searchable
    • sortable
  • transactionSubtype (string)

    A subclassification of events that an asset can face during its life.

    Label

    Transaction Subtype

    Properties

    • searchable
    • sortable
  • 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
    • not nullable

    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

  • 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

  • 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

  • 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

  • prorateConvention (AssetProrateConvention)

    A prorate convention contains the date that maps a date placed in service to a prorate date for depreciation calculation.

    Business Object

    AssetProrateConvention

    Expand all

    Collapse all

    Fields

    • conventionTypeId (int64)

      Unique identifier of the prorate convention.

      Label

      Prorate Convention 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

  • transactionBetweenAssetsHistory (AssetTransactionBetweenAssetsHistory)

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

    Business Object

    AssetTransactionBetweenAssetsHistory

    Expand all

    Collapse all

    Fields

    • transactionReferenceId (int64)

      Transaction reference identifier, which links transactions with multiple assets.

      Label

      Transaction Reference ID

      Properties

      • searchable
      • sortable
      • not nullable

  • transactionKeyLookup (StandardLookupCode)

    A subclassification of an asset transaction. For example, amortized, expensed, or impairment.

    Business Object

    StandardLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

Back to Top