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.

Expand all

Collapse all

Business Views

** Available for extracting data

• assetSourceLinesExtract**

  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.

  Label

  Asset Source Lines

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • createMassAdditionsRunDate (date)

    Date and time of the creation of the mass additions batch.

    Label

    Create Mass Additions Run Date

    Properties

    • searchable
    • sortable
  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

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

    Indicates whether the invoice line is deleted.

    Label

    Deleted Indicator

    Properties

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

    Indicates whether the invoice line amount is included in the group asset cost.

    Label

    Depreciate in Group Asset Indicator

    Properties

    • searchable
    • sortable
  • description (string)

    Description of the asset invoice.

    Label

    Description

    Properties

    • searchable
    • sortable
  • effectiveDate (date)

    The date that the invoice is effective.

    Label

    Effective Date

    Properties

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

    Cost of the asset for the lines.

    Label

    Cost

    Properties

    • searchable
    • sortable
  • historicalCost (big-decimal)

    Cost without regard to any revaluations.

    Label

    Historical Cost

    Properties

    • searchable
    • sortable
  • ineffectiveDate (date)

    The date that the invoice is ineffective.

    Label

    Ineffective Date

    Properties

    • searchable
    • sortable
  • invoiceAmount (big-decimal)

    Invoice cost from Oracle Payables.

    Label

    Invoice Amount

    Properties

    • searchable
    • sortable
  • invoiceDate (date)

    Invoice date for asset invoices received from Oracle Payables.

    Label

    Invoice Date

    Properties

    • searchable
    • sortable
  • invoiceDistributionLineNumber (int64)

    Identifier of the distribution line for the Oracle Fusion Payables invoice.

    Label

    Invoice Distribution Line Number

    Properties

    • searchable
    • sortable
  • invoiceLineDescription (string)

    Description of the invoice line.

    Label

    Invoice Line Description

    Properties

    • searchable
    • sortable
  • invoiceLineNumber (big-decimal)

    Identifier for the line of the Oracle Fusion Payables invoice.

    Label

    Invoice Line Number

    Properties

    • searchable
    • sortable
  • invoiceNumber (string)

    Invoice number from Oracle Fusion Payables.

    Label

    Invoice Number

    Properties

    • searchable
    • sortable
  • invoiceVoucherNumber (string)

    Invoice voucher number from Oracle Fusion Payables.

    Label

    Invoice Voucher Number

    Properties

    • searchable
    • sortable
  • materialIndicatorFlag (boolean)

    Option indicating whether the invoice line is material or nonmaterial in nature.

    Label

    Material Indicator

    Properties

    • searchable
    • sortable
  • payablesUnits (big-decimal)

    Units from Payables invoice distribution.

    Label

    Payables Units

    Properties

    • searchable
    • sortable
  • projectNumber (string)

    Number of the project from which the costs are collected, summarized, and transferred from Oracle Fusion Projects.

    Label

    Project Number

    Properties

    • searchable
    • sortable
  • purchaseOrderNumber (string)

    The identifier of the purchase order.

    Label

    Purchase Order Number

    Properties

    • searchable
    • sortable
  • sourceBatch (string)

    Payables batch name in the mass addition lines.

    Label

    Source Batch

    Properties

    • searchable
    • sortable
  • sourceLineId (int64)

    Identifier of the asset source line.

    Label

    Source Line ID

    Properties

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

    The name of the purchase order supplier.

    Label

    Supplier Name

    Properties

    • searchable
    • sortable
  • supplierNumber (string)

    The supplier number of the purchase order supplier.

    Label

    Supplier Number

    Properties

    • searchable
    • sortable
  • taskNumber (string)

    User-defined number of the task from which costs are collected, summarized, and transferred from Oracle Fusion Project Costing. This column is populated only if the costs were summarized by task.

    Label

    Task Number

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

  • 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

  • feederSystemLookup (StandardLookupCode)

    Identifies the application that originated the mass addition.

    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

  • invoiceDistributionTypeLookup (LookupCode)

    The type of invoice distribution. It's based on Invoice Distribution Type lookup codes, such as ITEM, ERV, FREIGHT, or TAX.

    Business Object

    LookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • searchable
      • sortable
      • not nullable

  • invoiceLineTypeLookup (LookupCode)

    Indicates whether the invoice line corresponds to an item, tax, freight, or a miscellaneous line.

    Business Object

    LookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • searchable
      • sortable
      • not nullable

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

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

Back to Top