RevenueContractPerformanceObligation
The customer contract performance obligation provides the details of the performance obligations of customer contract.
Business Views
** Available for extracting data- revenueContractPerformanceObligationsExtract**
The customer contract performance obligation provides the details of the performance obligations of customer contract.
Label
Revenue Contract Performance Obligations
Data Source
Read-optimized data store
Fields
- additionalSatisfactionEventExistsCode (enumeration: AdditionalSatisfactionEventExistence)
Indicates whether one or more promised details of the performance obligation has any additional satisfaction events associated with it. Values are derived from the ORA_VRM_LINE_ASE_EXISTANCE lookup type.
Label
Additional Satisfaction Event Exists
Type
-
Module: oraErpCoreRevenueManagement
-
Enumeration Type: AdditionalSatisfactionEventExistence
Valid Values
- ORA_EVALUATED_AND_HAS_ASE_RULE
- ORA_EVALUATED_AND_NO_ASE_RULE
- ORA_NOT_EVALUATED
-
- additionalSatisfactionEventLineStatusCode (enumeration: LineSatisfactionStatus)
The overall fulfillment status of all the additional satisfaction events of all the promised detail lines related to the performance obligation. Values are derived from the ORA_VRM_LINE_SATISFACTION_STATUS lookup type.
Label
Additional Satisfaction Event Line Status
Type
-
Module: oraErpCoreRevenueManagement
-
Enumeration Type: LineSatisfactionStatus
Valid Values
- ORA_FULLY_SATISFIED
- ORA_NOT_REQUIRED
- ORA_NOT_SATISFIED
- ORA_PARTIALLY_SATISFIED
-
- allocatedAmount (big-decimal)
The total allocated transaction price in the accounted currency.
Label
Allocated Amount
- allocationBasisCode (enumeration: AllocationBasisType)
The basis used to calculate the ratio of the allocated revenue for performance obligation distributions to their underlying promise detail lines. Valid values are from the ORA_VRM_ALLOC_BASIS lookup type.
Label
Allocation Basis
Type
-
Module: oraErpCoreRevenueManagement
-
Enumeration Type: AllocationBasisType
Valid Values
- ORA_EXTENDED_SSP_AMT
- ORA_SELLING_AMT
-
- allocationExemptionStatusFlag (boolean)
Indicates whether this performance obligation is exempted from allocation.
Label
Allocation Exemption Status
- basePrice (big-decimal)
The base price of an item.
Label
Base Price
- basePricePercentage (big-decimal)
The base price percentage of an item.
Label
Base Price Percentage
- billedAmount (big-decimal)
The total billed amount of all performance obligation lines in the accounted currency.
Label
Billed Amount
- comments (string)
The user-entered comments on the performance obligation.
Label
Comments
- contractAssetBalanceinAccountedCurrency (big-decimal)
Total debit contract asset amount on the performance obligation.
Label
Contract Asset Balance in Accounted Currency
- contractDiscountAccountBalanceinAccountedCurrency (big-decimal)
Total debit discount amount on the performance obligation.
Label
Contract Discount Account Balance in Accounted Currency
- contractLiabilityBalanceinAccountedCurrency (big-decimal)
Total credit contract liability amount on the performance obligation.
Label
Contract Liability Balance in Accounted Currency
- conversionRate (big-decimal)
The rate used to convert amounts from the entered currency to the ledger currency.
Label
Conversion Rate
- conversionRateDate (date)
The date from when the conversion rate is used to convert amounts from the entered currency to the ledger currency.
Label
Conversion Rate Date
- costAmount (big-decimal)
The cost price of an item.
Label
Cost Amount
- 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
- devolvePerformanceObligationStatusFlag (boolean)
Indicates whether this performance obligation is devolved. A performance obligation is devolved if the Devolve performance obligation option is set to Yes in either the performance obligation identification rule or the implied obligation template that was used to identify performance obligations.
Label
Devolve Performance Obligation Status
- discardStatusFlag (boolean)
Indicates whether the performance obligation is discarded.
Label
Discard Status
- discountAmount (big-decimal)
The total discount amount in all the performance obligation lines in the accounted currency.
Label
Discount Amount
- discountPercentage (big-decimal)
The discount percentage of an item.
Label
Discount Percentage
- distributedRevenueAmount (big-decimal)
The total revenue recognized for all performance obligation lines in the accounted currency.
Label
Distributed Revenue Amount
- enteredAllocatedAmount (big-decimal)
The allocated transaction price in the entered currency.
Label
Entered Allocated Amount
- enteredBilledAmount (big-decimal)
The total billed amount of all performance obligation lines in the entered currency.
Label
Entered Billed Amount
- enteredDiscountAmount (big-decimal)
The total discount amount of all performance obligation lines in the entered currency.
Label
Entered Discount Amount
- enteredDistributedRevenueAmount (big-decimal)
The total revenue recognized for all performance obligation lines in the entered currency.
Label
Entered Distributed Revenue Amount
- enteredExtendedStandaloneSellingPriceAmount (big-decimal)
The extended standalone selling price amount of the performance obligation in entered currency.
Label
Entered Extended Standalone Selling Price Amount
- enteredNetConsiderationAmount (big-decimal)
The total net consideration amount of all the performance obligation lines in the entered currency.
Label
Entered Net Consideration Amount
Properties
- not nullable
- enteredResidualSSPAmount (big-decimal)
The calculated residual estimated extended standalone selling price of the performance obligation in the entered currency.
Label
Entered Residual SSP Amount
- enteredSellingAmount (big-decimal)
The total line amount of all the performance obligation lines in the entered currency.
Label
Entered Selling Amount
Properties
- not nullable
- enteredUnitSSP (big-decimal)
The unit standalone selling price in entered currency.
Label
Entered Unit SSP
- enteredUnitSSPAmount (big-decimal)
The absolute value of the unit standalone selling price for an item or service.
Label
Entered Unit SSP Amount
- enteredVariableConsiderationAmount (big-decimal)
The variable consideration amount of all performance obligation lines in the entered currency.
Label
Entered Variable Consideration Amount
Properties
- not nullable
- extendedStandaloneSellingPriceAmount (big-decimal)
The extended standalone selling price amount of the performance obligation in accounted currency.
Label
Extended Standalone Selling Price Amount
- firstSatisfactionEventDate (date)
The date when the first satisfaction event is created for a promised detail line under an obligation.
Label
First Satisfaction Event Date
- grossMarginPercentage (big-decimal)
The gross margin percentage of an item.
Label
Gross Margin Percentage
- initialPerformanceEventCreatedCode (enumeration: ProcessStatus)
Indicates whether the initial performance accounting event was created.
Label
Initial Performance Accounting Event Creation Status
Type
-
Module: oraErpCoreRevenueManagement
-
Enumeration Type: ProcessStatus
Valid Values
- I
- N
- Y
-
- initialPerformanceEventExpectedDate (date)
The date on which the initial performance event is expected to be created.
Label
Initial Performance Event Expected Date
- initialPerformanceEventRecordedStatusFlag (boolean)
Indicates whether the initial performance accounting event was recorded.
Label
Initial Performance Event Recorded Status
- latestRevisionIntentCode (enumeration: RevisionIntentType)
The revision intent of the last promised detail revision of the performance obligation. Values are from the ORA_VRM_REVISION_INTENT_TYPE lookup type.
Label
Latest Revision Intent
Type
-
Module: oraErpCoreRevenueManagementSetup
-
Enumeration Type: RevisionIntentType
Valid Values
- ORA_CM
- ORA_EC
- ORA_UA
-
- latestVersionDate (date)
The date when the performance obligation's underlying promised detail was last updated.
Label
Latest Version Date
- listPriceAmount (big-decimal)
The list price amount of an item.
Label
List Price Amount
- netConsiderationAmount (big-decimal)
The total net consideration amount of all the performance obligation lines in the accounted currency.
Label
Net Consideration Amount
- performanceObligationId (int64)
The unique identifier of the performance obligation.
Label
Performance Obligation Identifier
Properties
- searchable
- sortable
- not nullable
- performanceObligationNumber (int64)
The numeric identifier of the performance obligation.
Label
Performance Obligation Number
Properties
- not nullable
- performanceObligationSatisfactionDate (date)
The date when a performance obligation was satisfied.
Label
Performance Obligation Satisfaction Date
- performanceObligationSatisfactionMethod (enumeration: SatisfactionMethod)
Specifies whether the obligation is satisfied at a point in time or over time. Valid values are derived from the ORA_VRM_SATISFACTION_METHOD lookup type.
Label
Performance Obligation Satisfaction Method
Type
-
Module: oraErpCoreRevenueManagement
-
Enumeration Type: SatisfactionMethod
Properties
- not nullable
Valid Values
- ORA_OVER_PERIOD_OF_TIME
- ORA_POINT_IN_TIME
-
- performanceObligationSatisfactionStatus (enumeration: LineSatisfactionStatus)
The status of the performance obligation line satisfaction. Values are derived from the lookup type ORA_VRM_LINE_SATISFACTN_STATUS.
Label
Performance Obligation Satisfaction Status
Type
-
Module: oraErpCoreRevenueManagement
-
Enumeration Type: LineSatisfactionStatus
Properties
- not nullable
Valid Values
- ORA_FULLY_SATISFIED
- ORA_NOT_REQUIRED
- ORA_NOT_SATISFIED
- ORA_PARTIALLY_SATISFIED
-
- performanceObligationType (enumeration: PerformanceObligationType)
Indicates the code for the performance obligation type. Valid values are Implied Performance Obligation and Explicit Performance Obligation.
Label
Performance Obligation Type
Type
-
Module: oraErpCoreRevenueManagement
-
Enumeration Type: PerformanceObligationType
Valid Values
- ORA_AUTOMATIC
- ORA_IMPLIED
- ORA_MANUAL
- ORA_NONIMPLIED
-
- reference (string)
User entered performance obligation reference or grouping attribute values used to identify the performance obligation as derived by enabling the Copy to Reference option in the Performance Obligation Identification rule.
Label
Reference
- referenceConversionRate (big-decimal)
The conversion rate used to convert the amount from entered currency into reference currency.
Label
Reference Conversion Rate
- referenceConversionRateDate (date)
The date as of which a conversion rate is used to convert the amount from entered currency into reference currency.
Label
Reference Conversion Rate Date
- residualApproachFlag (boolean)
Indicates the pricing for the goods or services is variable or missing and the standalone selling price for the performance obligation is estimated using the residual approach. Valid values are Yes and No.
Label
Residual Approach
- residualSSPAmount (big-decimal)
The calculated residual estimated extended standalone selling price of the performance obligation in the contract currency.
Label
Residual SSP Amount
- sellingAmount (big-decimal)
The total line amount of all performance obligation lines in the contract currency.
Label
Selling Amount
- sspHigh (big-decimal)
The high point of the acceptable standalone selling price ranges. This value is used to determine the unit standalone selling price in accordance with the Standalone Selling Price policy for ranges.
Label
SSP High
- sspLow (big-decimal)
The low point of the acceptable standalone selling price ranges. This value is used to determine the unit standalone selling price in accordance with the Standalone Selling Price policy for ranges.
Label
SSP Low
- sspRangeTestResult (enumeration: StandaloneSellingPriceRange)
The result of the comparison of the actual selling price with the SSP low and high points. This result shows whether the actual value is below the low point, in range, or above the high point.
Label
SSP Range Test Result
Type
-
Module: oraErpCoreRevenueManagement
-
Enumeration Type: StandaloneSellingPriceRange
Valid Values
- ORA_COMMON_PRICE
- ORA_SSP_HIGH
- ORA_SSP_LOW
- ORA_SSP_MID
- ORA_SSP_PUB_SALE
-
- sspRangeValueApplied (enumeration: StandaloneSellingPriceRangeRule)
The rule used to derive the unit standalone selling price based on the SSP range test result.
Label
SSP Range Value Applied
Type
-
Module: oraErpCoreRevenueManagement
-
Enumeration Type: StandaloneSellingPriceRangeRule
Valid Values
- ORA_ABOVE_RANGE
- ORA_BELOW_RANGE
- ORA_WITHIN_RANGE
-
- 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
- unitSellingPrice (big-decimal)
The selling price per unit of measure of the inventory item or memo line.
Label
Unit Selling Price
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
- variableConsiderationAmount (big-decimal)
The variable consideration amount of all performance obligation lines in the contract currency.
Label
Variable Consideration Amount
Reference Object
- contract (RevenueContract)
The customer contract provides the details of the customer contract. This includes performance obligations and promised detail lines.
Business Object
RevenueContractFields
- customerContractHeaderId (int64)
The unique identifier of the customer contract header.
Label
Customer Contract Header ID
Properties
- searchable
- sortable
- not nullable
- customerContractHeaderId (int64)
- 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
CurrencyConversionRateTypeFields
- 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
- conversionRateType (string)
- 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
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- impliedPerformanceObligationTemplate (ImpliedPerformanceObligationTemplate)
The performance obligation template is a structured document used to outline and manage the performance obligations within a contract. It explains the rules for creating performance obligations.
Business Object
ImpliedPerformanceObligationTemplateFields
- impliedPerformanceObligationTemplateId (int64)
The unique identifier of the implied performance obligation template.
Label
Implied Performance Obligation Template ID
Properties
- searchable
- sortable
- not nullable
- impliedPerformanceObligationTemplateId (int64)
- 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
LegalEntityFields
- 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
- legalEntityId (int64)
- performanceObligationClassification (ERPLookupCode)
The classification used to categorize the performance obligations, such as hardware, subscription, and promotion discount. The performance obligation classification is user-defined and can be used in reporting, and in subledger accounting rules.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupCode (string)
- performanceObligationIdentificationRule (PerformanceObligationIdentificationRule)
The performance obligation identification rule explains the rules for identifying separate performance obligations in a customer contract.
Business Object
PerformanceObligationIdentificationRuleFields
- performanceObligationIdentificationRuleId (int64)
The identifier of the performance obligation group rule.
Label
Performance Obligation Identification Rule ID
Properties
- searchable
- sortable
- not nullable
- performanceObligationIdentificationRuleId (int64)
- performanceObligationTemplate (PerformanceObligationTemplate)
The performance obligation template is a structured document used to outline and manage the performance obligations within a contract. It explains the rules for creating performance obligations.
Business Object
PerformanceObligationTemplateFields
- performanceObligationTemplateId (int64)
The identifier of the performance obligation template.
Label
Performance Obligation Template ID
Properties
- searchable
- sortable
- not nullable
- performanceObligationTemplateId (int64)
- pricingDimensionCombination (RevenueContractPricingDimensionCombination)
The pricing dimension combination provides pricing dimension details for establishing the standalone selling price of a product or price.
Business Object
RevenueContractPricingDimensionCombinationFields
- pricingDimensionCombinationId (int64)
The unique identifier of the pricing dimension combination.
Label
Pricing Dimension Combination ID
Properties
- searchable
- sortable
- not nullable
- pricingDimensionCombinationId (int64)
- referenceConversionRateType (CurrencyConversionRateType)
The rate type used to convert entered currency amounts to the reference currency. Valid values are from the ORA_REF_CONVERSION_RATE_DATE lookup type.
Business Object
CurrencyConversionRateTypeFields
- 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
- conversionRateType (string)
- referenceCurrency (Currency)
The currency used as the reference currency for converting entered currency amounts to the reference currency.
Business Object
CurrencyFields
- currencyCode (string)
The currency in which an amount or a conversion rate is denominated.
Label
Currency Code
Properties
- searchable
- sortable
- not nullable
- currencyCode (string)
- standaloneSellingPrice (RevenueContractStandaloneSellingPrice)
The standalone selling price provides the details of unit standalone selling prices
Business Object
RevenueContractStandaloneSellingPriceFields
- standaloneSellingPriceLineId (int64)
The identifier for a Standalone Selling Price line.
Label
Standalone Selling Price Line ID
Properties
- searchable
- sortable
- not nullable
- standaloneSellingPriceLineId (int64)
- standaloneSellingPriceProfile (StandaloneSellingPriceProfile)
The standalone selling price profile provides the details of the standalone selling price profiles, items assigned to the profile, and pricing dimension band assignments.
Business Object
StandaloneSellingPriceProfileFields
- standaloneSellingPriceProfileId (int64)
The identifier of the standalone selling price profile.
Label
Standalone Selling Price Profile ID
Properties
- searchable
- sortable
- not nullable
- standaloneSellingPriceProfileId (int64)
- additionalSatisfactionEventExistsCode (enumeration: AdditionalSatisfactionEventExistence)