AssetDistribution

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

Expand all

Collapse all

Business Views

** Available for extracting data

• assetDistributionsExtract**

  This view contains assigned units, employees, the depreciation expense account, or location information about the asset when the asset is added retired, transferred, reinstated, or reclassified.

  Label

  Asset Distributions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • bookName (string)

    The name of the asset book.

    Label

    Book

    Properties

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

    The user who created the record.

    Label

    Created By

    Properties

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

    The identifier of the distribution.

    Label

    Distribution ID

    Properties

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

    The date from when the distribution is in effect.

    Label

    Effective Date

    Properties

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

    The date from when the distribution is inactive.

    Label

    Ineffective Date

    Properties

    • searchable
    • sortable
  • inventoryTakenDate (date)

    The date on which the physical verification of the asset was done.

    Label

    Inventory Taken 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
  • transactionUnits (big-decimal)

    The number of transactional units.

    Label

    Transaction Units

    Properties

    • searchable
    • sortable
  • unitsAssigned (big-decimal)

    The number of units assigned to the distribution.

    Label

    Units Assigned

    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

  • 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

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

  • location (AssetLocation)

    A location stores the location information of a fixed asset, such as the country, state or province, county, city, and building.

    Business Object

    AssetLocation

    Expand all

    Collapse all

    Fields

    • locationId (int64)

      Code that identifies the asset location.

      Label

      Location ID

      Properties

      • inherited
      • 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

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

Back to Top