RevenueSourceDocument

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

Expand all

Collapse all

Business Views

** Available for extracting data

• revenueSourceDocumentsExtract**

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

  Label

  Revenue Source Documents

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • applicationID (int64)

    The identifier of the source application.

    Label

    Application ID

    Properties

    • not nullable
  • billToCustomerClassification (string)

    The customer classification of bill-to customer on source document. Values are from the CUSTOMER_CLASS lookup. Value at the source document line level takes precedence over value at the source document level.

    Label

    Bill-to Customer Classification

  • conversionDate (date)

    The date when the conversion rate is used to convert amounts in entered currency to the ledger currency for source document.

    Label

    Conversion Date

  • conversionRate (big-decimal)

    The conversion rate to convert amounts in entered currency to the ledger currency for source document.

    Label

    Conversion Rate

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • customerContractNumber (string)

    The numeric value assigned by the application used to identify the contract.

    Label

    Contract Number

  • customerPurchaseOrderNumber (string)

    The customer purchase order number of the source document.

    Label

    Customer purchase order number.

  • 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
  • documentIdentifierCharacter1 (string)

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

    Label

    Document Identifier Character 1

    Properties

    • not nullable
  • documentIdentifierCharacter2 (string)

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

    Label

    Document Identifier Character 2

    Properties

    • not nullable
  • documentIdentifierCharacter3 (string)

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

    Label

    Document Identifier Character 3

    Properties

    • not nullable
  • documentIdentifierCharacter4 (string)

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

    Label

    Document Identifier Character 4

    Properties

    • not nullable
  • documentIdentifierCharacter5 (string)

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

    Label

    Document Identifier Character 5

    Properties

    • not nullable
  • documentIdentifierInteger1 (int64)

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

    Label

    Document Identifier Integer 1

    Properties

    • not nullable
  • documentIdentifierInteger2 (int64)

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

    Label

    Document Identifier Integer 2

    Properties

    • not nullable
  • documentIdentifierInteger3 (int64)

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

    Label

    Document Identifier Integer 3

    Properties

    • not nullable
  • documentIdentifierInteger4 (int64)

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

    Label

    Document Identifier Integer 4

    Properties

    • not nullable
  • documentIdentifierInteger5 (int64)

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

    Label

    Document Identifier Integer 5

    Properties

    • not nullable
  • documentType (string)

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

    Label

    Source Document Type

    Properties

    • not nullable
  • headerStatus (enumeration: DocumentLineStatus)

    Identifies the processing status of the header record.

    Label

    Header 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.

  • 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

  • originalDocumentID (int64)

    Original source document identifier used to create the recurring source document.

    Label

    Original Document ID

  • quoteNumber (string)

    The quote number of the source document

    Label

    Quote Number

  • recurringHeaderNumber (int64)

    The identifier of the original source document used to create the recurring source document.

    Label

    Recurring Header Number

  • recurringHeaderStatusFlag (boolean)

    Indicates whether the source document's recurring lines were processed. Valid values are Yes and No.

    Label

    Recurring Header Status

  • referenceConversionRateDate (date)

    The date when the source document entered currency amounts are converted to reference currency.

    Label

    Reference Conversion Rate Date

  • salesAgreementNumber (string)

    The customer sales agreement document number.

    Label

    Sales Agreement Number

  • sourceBillToCustomerSiteReference (string)

    The original application bill-to customer site reference on source document.

    Label

    Source Bill-to Customer Site Reference

  • sourceDocumentCreationDate (date-time)

    The date and time when the source document was created.

    Label

    Source Document Creation Date

    Properties

    • not nullable
  • sourceDocumentDate (date)

    The date of the source document.

    Label

    Source Document Date

    Properties

    • not nullable
  • sourceDocumentNumber (string)

    The source document number. For example, a sales order number or receivables invoice number.

    Label

    Document Number

    Properties

    • not nullable
  • sourceDocumentUpdateDate (date-time)

    The date and time when the source document was last updated.

    Label

    Source Document Update Date

    Properties

    • not nullable
  • sourceShipToCustomerSiteReference (string)

    The original application ship-to customer site reference on source document.

    Label

    Source Ship-to Customer Site Reference

  • sourceSystem (string)

    The source application of document data used to identify the source document.

    Label

    Source System

  • sourceSystemBillToCustomerReference (string)

    The original application bill-to customer reference on source document.

    Label

    Source Bill-to Customer Reference

  • sourceSystemShipToCustomerReference (string)

    The original application ship-to customer reference on source document.

    Label

    Source Ship-to Customer Reference

  • 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

  • billToCustomer (Customer)

    Customer includes information about a Sales or Financial Account such as the total number of employees in a company, historical data, contact information, primary addresses, and so on.

    Business Object

    Customer

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the party.

      Label

      Party ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • billToCustomerAccount (CustomerAccount)

    The Customer Account business object provides the details of the specific business activities that the deploying company engages in with a customer party of type Organization or Person.

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • customerAccountId (int64)

      Identifier of the customer account.

      Label

      Customer Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • billToCustomerSite (CustomerAccountSite)

    The Customer Account Site business object provides the details of all customer account sites across all business units. A customer account site is one specific location belonging to a customer account. A single customer account can have multiple sites.

    Business Object

    CustomerAccountSite

    Expand all

    Collapse all

    Fields

    • customerAccountSiteId (int64)

      Identifier of the customer account site.

      Label

      Customer Account Site ID

      Properties

      • searchable
      • sortable
      • not nullable

  • 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

  • conversionRateType (CurrencyConversionRateType)

    A currency conversion rate type defines conversion rate types such as Corporate, Daily, Period End, and Period Average. These conversion rate types are used to convert foreign currency journal amounts to ledger currency equivalents or translate and remeasure account balances to a reporting currency.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

  • currency (Currency)

    A currency is a standardization of money used for displaying monetary amounts, assigning to ledgers, entering transactions, recording balances, and reporting. All currencies listed in the International Organization for Standardization 4217 standard are supported. The statistical unit currency is used for financial statistics in financial reports, allocation formulas, and other calculations.

    Business Object

    Currency

    Expand all

    Collapse all

    Fields

    • currencyCode (string)

      The currency in which an amount or a conversion rate is denominated.

      Label

      Currency Code

      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

  • legalEntity (LegalEntity)

    A legal entity represents an entity created under a commercial law which can own property, create obligation, recruit people, trade, account for themselves to regulators, taxation authorities, and owners. It identifies the legal owner or custodian for each business transaction for legal compliance and reporting.

    Business Object

    LegalEntity

    Expand all

    Collapse all

    Fields

    • legalEntityId (int64)

      The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.

      Label

      Legal Entity ID

      Properties

      • searchable
      • sortable
      • not nullable

  • salespersonID (ResourceCreditProfile)

    Represents a resource who can be assigned to customers, leads, opportunities, orders, and other sales-related transactions.

    Business Object

    ResourceCreditProfile

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of a resource credit profile record.

      Label

      Credit Profile ID

      Properties

      • searchable
      • sortable
      • not nullable

  • shipToCustomerAccount (CustomerAccount)

    The Customer Account business object provides the details of the specific business activities that the deploying company engages in with a customer party of type Organization or Person.

    Business Object

    CustomerAccount

    Expand all

    Collapse all

    Fields

    • customerAccountId (int64)

      Identifier of the customer account.

      Label

      Customer Account ID

      Properties

      • searchable
      • sortable
      • not nullable

  • shipToCustomerSite (CustomerAccountSite)

    The Customer Account Site business object provides the details of all customer account sites across all business units. A customer account site is one specific location belonging to a customer account. A single customer account can have multiple sites.

    Business Object

    CustomerAccountSite

    Expand all

    Collapse all

    Fields

    • customerAccountSiteId (int64)

      Identifier of the customer account site.

      Label

      Customer Account Site ID

      Properties

      • searchable
      • sortable
      • not nullable

  • sourceConversionRateType (CurrencyConversionRateType)

    The rate type of source application used to convert amounts between the entered currency and the ledger currency.

    Business Object

    CurrencyConversionRateType

    Expand all

    Collapse all

    Fields

    • conversionRateType (string)

      The rate type of the conversion rate used for the currency conversion, such as Corporate, Daily, Period End, and Period Average.

      Label

      Conversion Rate Type

      Properties

      • searchable
      • sortable
      • not nullable

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

Back to Top