ReportingBookAssetSourceLine

A reporting book 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 reporting 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

• reportingBookAssetSourceLinesExtract**

  A reporting book 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 reporting asset book. A source line contains all costs imported from source applications, including, items, freight, taxes, project labor, and expenses.

  Label

  Reporting Book Asset Source Lines

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • activeFlag (boolean)

    Latest asset invoice.

    Label

    Active Indicator

    Properties

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

    Cost of the asset for the lines.

    Label

    Asset Cost from Invoice

    Properties

    • searchable
    • sortable
  • conversionRate (big-decimal)

    Rate used to convert amounts in the primary ledger currency to amounts in the reporting currency.

    Label

    Conversion Rate

    Properties

    • searchable
    • sortable
  • 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 to include the row in the current total asset cost.

    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)

    Date when the invoice became effective.

    Label

    Effective Date

    Properties

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

    Cost without regard to any revaluations.

    Label

    Historical Cost

    Properties

    • searchable
    • sortable
  • ineffectiveDate (date)

    Date on which the book becomes inactive.

    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

    Asset Additions 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
  • ledgerId (int64)

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

    Label

    Ledger ID

    Properties

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

  • assetReportingBook (AssetReportingBook)

    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.

    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

  • 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