Skip to main content

Revenue Recognition Events Transaction object fields and Data Query

Zuora

Revenue Recognition Events Transaction object fields and Data Query

  1. Last updated
  2. Save as PDF

You can perform a query from the Revenue Recognition Events Transaction object through Data Query. For information about the basic usage of Data Query, see Construct SQL Queries in Data Query.

Revenue Recognition Events Transaction fields

The following table lists all the fields that are defined on the Revenue Recognition Events Transaction object. You can access the Revenue Recognition Events Transaction object and all its fields through Data Query.

Field name

Format

Description

AccountId

String

ID of the account.

ChargeNumber

String

The unique number that identifies the rate plan charge.

  • Delivery Schedule: the charge number
  • Daily Rated Usage: the committed charge number
  • Unbilled Usage: the usage charge number
  • Fund Expiry: the committed charge number

ChargeSegment

Integer

The identifying number of the charge segment.

  • Delivery Schedule: the charge number
  • Daily Rated Usage: the committed charge number
  • Unbilled Usage: the usage charge number
  • Fund Expiry: the committed charge number

CreatedById

String

The ID by when the event is created.

CreatedDate

Timestamp

The date by when the event is created.

DDAdjustmentRevGlAccNumber

String

The adjustment revenue general ledger account number of the drawdown charge.

This is used in Daily Rated Usage and Unbilled Usage, and the value comes from the daily consumption.

DDRecognizedRevGlAccNumber

String

The recognized revenue general ledger account number of the drawdown charge.

This is used in Daily Rated Usage and Unbilled Usage, and the value comes from the daily consumption.

DailyAmount

Decimal

The daily amount collected for the events. The amount can be one of the following:

  • the rated amount for DeliveryPricing
  • null for FundRollover
  • the daily accumulated drawdown amount per day per charge segment
  • the daily rated amount per day per charge segment

DailyQuantity

Decimal

The daily quantity collected for the events. The quantity can be one of the following:

  • 1 for DeliveryPricing
  • null for FundRollover
  • daily quantity of usage for Drawdown and UnbilledUsage

deleted

Boolean

Indicates whether this record has been removed.

DrawdownChargeSegment

Integer

The segment of the drawdown charge. This value is used only in Daily Rated Usage, and the value comes from the daily consumption.

DrawdownOriginalChargeId

String

 The orginalScId of the drawdown charge. This value is used only in Daily Rated Usage, and the value comes from daily consumption.

ExcludeItemBillingFromRevenueAccounting

Boolean

The billing item excluded from the revenue account.

ExcludeItemBookingFromRevenueAccounting

Boolean

The booking item excluded from the revenue account.

FundEndDate

Timestamp

The end date of the fund. This value is used only in Daily Rated Usage and Unbilled Usage, and the value comes from the Fund.

FundId

String

The ID of the fund. This value is used only in Daily Rated Usage and Unbilled Usage, and the value comes from daily consumption.

FundStartDate

Timestamp

The start date of the fund. This value is used only in Daily Rated Usage and Unbilled Usage, and the value comes from the Fund.

Id

String

The ID of the revenue recognition event transaction object.

OriginalRatePlanChargeId

String

The original ID to identify the rate plan charge.

  • Delivery Schedule: the original charge id
  • Daily Rated Usage: the original charge id of the committed charge
  • Unbilled Usage: the original charge id of usage charge
  • Fund Expiry: the original charge id of the committed charge

SalesOrderLineId

String

The line ID of the sales order.

  • DeliveryPricing: these values come from the charge segment
  • Daily Rated Usage & Unbilled Usage: these values come from daily consumption
  • FundExpiry: these values come from Kafka event payload

SubscriptionName

String

Name of the subscription

TransactionDate

Date

The date by when the transaction happened.

  • DeliveryPricing: delivery date calculated from the delivery schedule
  • Drawdown and UnbilledUsage: date from daily consumption
  • FundRollover: fund expiry date

Type

String

The type of the source transaction. The available values are:

  • Delivery Schedule
  • Daily Rated Usage (for Drawdown)
  • Unbilled Usage
  • Fund Expiry

UnitPrice

Decimal

Indicates the unit price of a revenue recognition event and is only used in DeliveryPricing.

The amount can be one of the following:

  • the rated amount for DeliveryPricing
  • null for FundRollover
  • the daily accumulated drawdown amount per day per charge segment
  • the daily rated amount per day per charge segment

UpdatedById

String

The ID of the Zuora user who updated the revenue recognition event transaction.

UpdatedDate

Timestamp

The date and time when the revenue recognition event transaction is updated.
UsageChargeName String The name that identifies the usage charge.
UsageChargeNumber String The unique number that identifies the usage charge.