RevenueContract

The customer contract provides the details of the customer contract. This includes performance obligations and promised detail lines.

Expand all

Collapse all

Business Views

** Available for extracting data

• revenueContractsExtract**

  The customer contract provides the details of the customer contract. This includes performance obligations and promised detail lines.

  Label

  Revenue Contracts

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • allocatedAmountAsOfContractRevisionDate (big-decimal)

    The allocated amount in the contract currency as of the contract revision date.

    Label

    Allocated Amount as of Contract Revision Date

  • allocationCurrencyBasis (enumeration: AllocationMethod)

    The allocation currency basis used to allocate and recognize revenue for a contract. Valid values are from the ORA_VRM_ALLOCATION_METHOD lookup type.

    Label

    Allocation Currency Basis

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: AllocationMethod

    Valid Values

    • ORA_ACCTD_CURRENCY
    • ORA_TRX_CURRENCY
  • allocationPendingReason (string)

    A code indicating why there is no allocated revenue on the performance obligation. Valid values are Conversion Rate Not Available, Standalone Selling Price Not Available, Pricing Dimension Not Available, Awaiting Contract Freeze, and On Review Hold.

    Label

    Allocation Pending Reason

  • allocationRequestID (int64)

    The request identifier of the job that marked this row as allocated or removed.

    Label

    Allocation Request ID

  • allocationStatus (enumeration: ContractAllocationStatus)

    A code that indicates the revenue allocation status. Valid values are Allocated, Exempted, Pending Allocation, and Not Required.

    Label

    Allocation Status

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: ContractAllocationStatus

    Valid Values

    • ORA_ALLOCATED
    • ORA_EXEMPTED
    • ORA_NOT_REQUIRED
    • ORA_PENDING_ALLOCATION
  • billedAmount (big-decimal)

    The total amount of revenue invoiced in the contract currency.

    Label

    Billed Amount

  • comments (string)

    The user-entered comments for taking an action on a customer contract.

    Label

    Comments

  • contractFullSatisfactionDate (date)

    The latest satisfaction date for all of the performance obligations within a contract when all performance obligations in the contract are fully satisfied. This is used in conjunction with the contract satisfaction status attribute.

    Label

    Contract Full Satisfaction Date

  • contractGroupNumber (string)

    Indicates whether the matching group value is used as the contract group number.

    Label

    Contract Group Number

  • contractLastActivityDate (date)

    The date when the last activity was performed on the contract.

    Label

    Contract Last Activity Date

  • contractRevisionDate (date)

    Date when the revenue contract was revised.

    Label

    Contract Revision Date

  • conversionDate (date)

    Conversion date used for conversion.

    Label

    Conversion Date

  • conversionRate (big-decimal)

    The rate for converting amounts from entered currency to ledger currency.

    Label

    Conversion Rate

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • createdFrom (string)

    The process or user interface from which this row was created.

    Label

    Created From

    Properties

    • not nullable
  • currencyRevaluationOffsetAdjustmentStatus (enumeration: ResidualAdjustmentStatus)

    Indicates the eligibility of the contract for adjustment by the Residual Account Balance Write Off process. Values are from the ORA_CURR_REVAL_OFFSET_ADJ_STATUS lookup type.

    Label

    Currency Revaluation Offset Adjustment Status

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: ResidualAdjustmentStatus

    Valid Values

    • CURR_REVL_OFFSET_FINAL_ADJ
    • ELIGIBLE_FOR_CURR_OFF_ADJ
    • NOT_ELIGIBLE_FOR_CURR_OFF_ADJ
    • NO_CURR_REVL_OFFSET_BALANCE
  • customerContractHeaderId (int64)

    The unique identifier of the customer contract header.

    Label

    Customer Contract Header ID

    Properties

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

    The date the parties entered into the agreement.

    Label

    Date

    Properties

    • not nullable
  • discountAmountAsOfContractRevisionDate (big-decimal)

    The discounted amount in the contract currency as of the contract revision date.

    Label

    Discount Amount as of Contract Revision Date

  • distributedRevenueAmount (big-decimal)

    The total amount of revenue recognized in the contract currency.

    Label

    Distributed Revenue Amount

  • enteredAllocationAmountAsOfContractRevisionDate (big-decimal)

    The allocated amount in the entered currency as of the contract modification date.

    Label

    Entered Allocated Amount as of Contract Revision Date

  • enteredBilledAmount (big-decimal)

    The total billed amount for all the performance obligations in the entered currency.

    Label

    Entered Billed Amount

  • enteredDiscountAmountAsOfContractRevisionDate (big-decimal)

    The discounted amount in the entered currency as of the contract revision date.

    Label

    Entered Discount Amount as of Contract Revision Date

  • enteredDistributedRevenueAmount (big-decimal)

    The total revenue recognized for all performance obligations in the entered currency.

    Label

    Entered Distributed Revenue Amount

  • enteredTransactionPrice (big-decimal)

    The total contract amount in the entered currency, which is the sum of the net consideration amount of all obligations.

    Label

    Entered Transaction Price

  • excludeFromAutomaticWriteoffFlag (boolean)

    Indicates whether the Residual Account Balance Write Off process will exclude the contract from processing. Valid values are Yes and No.

    Label

    Exclude from Automatic Write-Off

  • freezeDate (date)

    The date when new lines can no longer be added automatically to the contract. The date is derived by adding the freeze period defined in the contract identification rule to the contract date.

    Label

    Freeze Date

  • latestImmaterialChangeCode (enumeration: ImmaterialChangeType)

    Indicates the latest immaterial change type processed on this customer contract. Valid values are Material and Immaterial.

    Label

    Latest Immaterial Change

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: ImmaterialChangeType

    Valid Values

    • IMMATERIAL
    • MATERIAL
  • latestRevisionIntentCode (enumeration: RevisionIntentType)

    The revision intent of the last source document line version of the promised detail. Valid values are Contract Modification, Estimate Correction, and Unassigned.

    Label

    Latest Revision Intent

    Type

    • Module: oraErpCoreRevenueManagementSetup

    • Enumeration Type: RevisionIntentType

    Valid Values

    • ORA_CM
    • ORA_EC
    • ORA_UA
  • latestVersionDate (date)

    The date of the most recent version of the underlying performance obligation.

    Label

    Latest Version Date

  • nonExemptTransactionPrice (big-decimal)

    The total nonexempt transaction price in the contract currency. This is derived from the transaction price after excluding the exempt performance obligation amounts.

    Label

    Nonexempt Transaction Price

  • number (int64)

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

    Label

    Number

    Properties

    • not nullable
  • reference (string)

    The user-entered contract reference or grouping attribute values that are used to identify the contract as derived by enabling the Copy to Reference option in the Contract Identification rule.

    Label

    Contract Reference

  • residualBalanceAdjustmentStatus (enumeration: AdjustmentStatus)

    Indicates the status of the residual balance adjustment whether the contract is eligible for final adjustment, not eligible for final adjustment, or final adjusted.

    Label

    Residual Balance Adjustment Status

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: AdjustmentStatus

    Valid Values

    • ELIGIBLE_FOR_ADJUSTMENT
    • FINAL_ADJUSTED
    • NOT_ELIGIBLE_FOR_ADJUSTMENT
    • NO_RESIDUAL_BALANCE
  • reviewRequiredReasonCode (enumeration: ReviewRequiredReason)

    Indicates the reason for which contract is pending for review. Valid values are Source Hold, Transaction Price Threshold, and Manual Hold.

    Label

    Review Required Reason

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: ReviewRequiredReason

    Valid Values

    • ORA_MANUAL_HOLD
    • ORA_SOURCE_HOLD
    • ORA_TRANS_PRICE_THRESHOLD
  • satisfactionStatus (string)

    The status of overall satisfaction of the contract. Valid values are Fully Satisfied and Not Satisfied. When all of the performance obligations in the contract are fully satisfied, the contract status is set to Fully Satisfied and the contract full satisfaction date is set to maximum satisfaction date of all the performance obligations of the contract. When at least one performance obligation in the contract isn't fully satisfied, then the status is set to Not Satisfied.

    Label

    Satisfaction Status

  • singleObligationFlag (boolean)

    Indicates whether the contract contains one or more performance obligations. Value valid are Yes, contract contains only one performance obligation and No, the contract contains more than one performance obligation.

    Label

    Single Obligation

  • standaloneSalesFlag (boolean)

    Indicates whether the contract is used for observed standalone selling price calculation.

    Label

    Standalone Sales

  • status (enumeration: ContractReviewStatus)

    Indicates the status of the manual review of the contract. Valid values are Discard, Pending Review, Reviewed, and Review Not Required.

    Label

    Status

    Type

    • Module: oraErpCoreRevenueManagement

    • Enumeration Type: ContractReviewStatus

    Valid Values

    • ORA_DISCARD
    • ORA_MUST_REVIEW
    • ORA_REVIEWED
    • ORA_REVIEW_NOT_REQ
  • 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
  • transactionPrice (big-decimal)

    The total contract amount in the contract currency. It's the sum of the consideration amount for the goods or services promised to the customers.

    Label

    Transaction Price

  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

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

  • contractClassification (ERPLookupCode)

    The classification used to categorize revenue contracts, such as consumer, subscription services, software license, and professional services. The contract classification is user-defined and can be used in reporting, and in subledger accounting rules.

    Business Object

    ERPLookupCode

    Expand all

    Collapse all

    Fields

    • lookupCode (string)

      The unique identifier of the Lookup Code.

      Label

      Lookup Code ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • contractEffectivePeriod (StandaloneSellingPriceEffectivePeriod)

    The standalone selling price effective period provides the details of the standalone selling price effective periods for which standalone sales can be calculated or imported.

    Business Object

    StandaloneSellingPriceEffectivePeriod

    Expand all

    Collapse all

    Fields

    • effectivityPeriodId (int64)

      The unique identifier of a standalone selling price effective period.

      Label

      Effectivity Period ID

      Properties

      • searchable
      • sortable
      • not nullable

  • contractIdentificationRule (RevenueContractIdentificationRule)

    The contract identification rule provides the details of the contract identification rules used to identify customer contracts.

    Business Object

    RevenueContractIdentificationRule

    Expand all

    Collapse all

    Fields

    • contractIdentificationRuleId (int64)

      The numeric identifier of the contract identification rule.

      Label

      Contract Identification Rule ID

      Properties

      • searchable
      • sortable
      • not nullable

  • 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

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

Back to Top