RevenueSourceDocumentSubline

The Revenue Source Document Subline business object provides the fulfillment details for each promised detail line from upstream application.

Expand all

Collapse all

Business Views

** Available for extracting data

• revenueSourceDocumentSublinesExtract**

  The Revenue Source Document Subline business object provides the fulfillment details for each promised detail line from upstream application.

  Label

  Revenue Source Document Sublines

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • applicationID (int64)

    The identifier of the source application.

    Label

    Application ID

  • comments (string)

    The user-entered comments on the source document subline.

    Label

    Comments

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • dataTransformationStatus (enumeration: DocumentLineStatus)

    Indicates the processing status of the source document subline. Valid values are Processed or Not Processed.

    Label

    Subline Status

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: DocumentLineStatus

    Valid Values

    • CREATE_ASE_PROCESSED
    • CREATE_SATIS_EVENTS_PROCESSED
    • FUSION_INIT
    • FUSION_NOT_PROCESSED
    • FUSION_PRE_INIT
    • INITIALIZED
    • NOT_PROCESSED
    • PROCESSED
    • PURGED
    • REJECTED

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

  • documentIdCharacter1 (string)

    First character column of the key that identifies a source document in the source application.

    Label

    Document Identifier Character 1

  • documentIdCharacter2 (string)

    Second character column of the key that identifies a source document in the source application.

    Label

    Document Identifier Character 2

  • documentIdCharacter3 (string)

    Third character column of the key that identifies a source document in the source application.

    Label

    Document Identifier Character 3

  • documentIdCharacter4 (string)

    Fourth character column of the key that identifies a source document in the source application.

    Label

    Document Identifier Character 4

  • documentIdCharacter5 (string)

    Fifth character column of the key that identifies a source document in the source application.

    Label

    Document Identifier Character 5

  • documentIdNumber1 (int64)

    First numeric column of the key that identifies a source document in the source application.

    Label

    Document Identifier Integer 1

  • documentIdNumber2 (int64)

    Second numeric column of the key that identifies a source document in the source application.

    Label

    Document Identifier Integer 2

  • documentIdNumber3 (int64)

    Third numeric column of the key that identifies a source document in the source application.

    Label

    Document Identifier Integer 3

  • documentIdNumber4 (int64)

    Fourth numeric column of the key that identifies a source document in the source application.

    Label

    Document Identifier Integer 4

  • documentIdNumber5 (int64)

    Fifth numeric column of the key that identifies a source document in the source application.

    Label

    Document Identifier Integer 5

  • documentLineIdCharacter1 (string)

    First character column of the key that identifies the source document line in the source application.

    Label

    Document Line Identifier Character 1

  • documentLineIdCharacter2 (string)

    Second character column of the key that identifies the source document line in the source application.

    Label

    Document Line Identifier Character 2

  • documentLineIdCharacter3 (string)

    Third character column of the key that identifies the source document line in the source application.

    Label

    Document Line Identifier Character 3

  • documentLineIdCharacter4 (string)

    Fourth character column of the key that identifies the source document line in the source application.

    Label

    Document Line Identifier Character 4

  • documentLineIdCharacter5 (string)

    Fifth character column of the key that identifies the source document line in the source application.

    Label

    Document Line Identifier Character 5

  • documentLineIdNumber1 (int64)

    First numeric column of the key that identifies a source document line in the source application.

    Label

    Document Line Identifier Integer 1

  • documentLineIdNumber2 (int64)

    Second numeric column of the key that identifies a source document line in the source application.

    Label

    Document Line Identifier Integer 2

  • documentLineIdNumber3 (int64)

    Third numeric column of the key that identifies a source document line in the source application.

    Label

    Document Line Identifier Integer 3

  • documentLineIdNumber4 (int64)

    Fourth numeric column of the key that identifies the source document line in the source application.

    Label

    Document Line Identifier Integer 4

  • documentLineIdNumber5 (int64)

    Fifth numeric column of the key that identifies the source document line in the source application.

    Label

    Document Line Identifier Integer 5

  • documentSubLineIdCharacter1 (string)

    The first character column of the key that identifies the source document subline in the source application.

    Label

    Document Subline Identifier Character 1

  • documentSubLineIdCharacter2 (string)

    The second character column of the key that identifies the source document subline in the source application.

    Label

    Document Subline Identifier Character 2

  • documentSubLineIdCharacter3 (string)

    The third character column of the key that identifies the source document subline in the source application.

    Label

    Document Subline Identifier Character 3

  • documentSubLineIdCharacter4 (string)

    The fourth character column of the key that identifies the source document subline in the source application.

    Label

    Document Subline Identifier Character 4

  • documentSubLineIdCharacter5 (string)

    The fifth character column of the key that identifies the source document subline in the source application.

    Label

    Document Subline Identifier Character 5

  • documentSubLineIdNumber1 (int64)

    The first numeric column of the key that identifies the source document subline in the source application.

    Label

    Document Subline Identifier Integer 1

  • documentSubLineIdNumber2 (int64)

    The second numeric column of the key that identifies the source document subline in the source application.

    Label

    Document Subline Identifier Integer 2

  • documentSubLineIdNumber3 (int64)

    The third numeric column of the key that identifies the source document subline in the source application.

    Label

    Document Subline Identifier Integer 3

  • documentSubLineIdNumber4 (int64)

    The fourth numeric column of the key that identifies the source document subline in the source application.

    Label

    Document Subline Identifier Integer 4

  • documentSubLineIdNumber5 (int64)

    The fifth numeric column of the key that identifies the source document subline in the source application.

    Label

    Document Subline Identifier Integer 5

  • documentSubLineType (string)

    The type of the subline. Valid values are distributions, sales credits, and additional satisfaction event.

    Label

    Document Subline Type

  • documentTypeCode (string)

    The code representing the source document type associated with the source document.

    Label

    Source Document Type

  • lineNumber (int64)

    The source document subline number, based on a running sequence.

    Label

    Line Number

  • loadRequestID (int64)

    Indicates the request identifier of the Enterprise Service Scheduler's interface load job that created or last updated the row.

    Label

    Load Request ID

  • periodActionCode (string)

    The type of action for period satisfaction events. This attribute is required if the subline type is Period. Valid values are from the ORA_VRM_PERIOD_SUBLINE_ACTION lookup type.

    Label

    Period Action

  • periodActionEventDate (date)

    The effective date for the period satisfaction event action.

    Label

    Period Action Event Date

  • satisfactionEventPercent (big-decimal)

    The value used to derive the percent of a satisfaction event, when the satisfaction measurement model is Measure Percentage Satisfied.

    Label

    Satisfaction Event Percent

  • satisfactionEventQuantity (big-decimal)

    The value used to derive the quantity of a satisfaction event, when the satisfaction measurement model is Measure Quantity Satisfied.

    Label

    Satisfaction Event Quantity

  • satisfactionMeasurementDate (date)

    The satisfaction measurement date on the source document subline.

    Label

    Satisfaction Measurement Date

  • sourceDocumentSubLineId (int64)

    The unique identifier of the source document subline.

    Label

    Source Document Subline ID

    Properties

    • searchable
    • sortable
    • not nullable
  • subLineTimeCreated (date-time)

    The date and time when the document subline was created in the source application.

    Label

    Subline Creation Date

    Properties

    • not nullable
  • subLineTimeUpdated (date-time)

    The date and time when the document subline was last updated in the source application before extraction to Revenue Management.

    Label

    Subline Last Update Date

    Properties

    • not nullable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • businessUnit (BusinessUnit)

    A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • document (RevenueSourceDocument)

    The contract source document provides the details of the documents from the upstream applications.

    Business Object

    RevenueSourceDocument

    Expand all

    Collapse all

    Fields

    • documentId (int64)

      The identifier of the source document for a sales order, invoice, project, or service contract.

      Label

      Document ID

      Properties

      • searchable
      • sortable
      • not nullable

  • documentLine (RevenueSourceDocumentLine)

    The source document line detail includes document lines from upstream applications, identified as contracts and performance obligations, and used in standalone selling price calculations.

    Business Object

    RevenueSourceDocumentLine

    Expand all

    Collapse all

    Fields

    • sourceDocumentLineId (int64)

      The internal identifier for source document line.

      Label

      Source Document Line ID

      Properties

      • searchable
      • sortable
      • not nullable

  • documentType (RevenueSourceDocumentType)

    The source document type provides the sources identified as types in Revenue Management.

    Business Object

    RevenueSourceDocumentType

    Expand all

    Collapse all

    Fields

    • sourceDocumentTypeId (int64)

      The unique identifier of a source document type.

      Label

      Source Document Type ID

      Properties

      • searchable
      • sortable
      • not nullable

  • ledger (Ledger)

    A ledger represents a record-keeping book used to track financial transactions. It serves as a central repository for all financial activities within an organization, providing a chronological and systematic account of debits, credits, and balances. Ledgers play a crucial role in financial management, budgeting, and maintaining accurate financial records, tracking expenses, revenues, assets, liabilities, and equity.

    Business Object

    Ledger

    Expand all

    Collapse all

    Fields

    • ledgerId (int64)

      The unique identifier of the ledger for which the accounting entry is created.

      Label

      Ledger ID

      Properties

      • searchable
      • sortable
      • not nullable

  • previousSourceDocumentSubline (RevenueSourceDocumentSubline)

    The source document subline of the earlier period type subline. When a reinstated subline is received after a reversed subline, this attribute is populated on the reinstated subline.

    Business Object

    RevenueSourceDocumentSubline

    Expand all

    Collapse all

    Fields

    • sourceDocumentSubLineId (int64)

      The unique identifier of the source document subline.

      Label

      Source Document Subline ID

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top