Unearned Revenue

The following data elements can be used with the "UnearnedRev" usage.

Data Element
Description

DeliveryMethod

The delivery method for the subscription.

SubscriptionID

The unique identifier for the subscription.

OccupantName

The name of the occupant associated with the subscription.

ProductID

The unique identifier for the product associated with the subscription.

PriorUR

The prior unearned revenue balance.

EarnedRev

The earned revenue amount.

OtherEarnedRev

The other earned revenue amount.

Payments

The payment amount applied to the subscription.

ExpChg

The expire change amount.

Transfers

The transfer amount applied to the subscription.

GracePaid

The grace amount paid.

Refunds

The refund amount applied to the subscription.

UnearnedRev

The unearned revenue balance.

PriorURDisc

The prior unearned revenue discount amount.

EarnedRevDisc

The earned revenue discount amount.

OtherEarnedRevDisc

The other earned revenue discount amount.

PaymentDiscounts

The discount amount applied to payments.

ExpChgDiscount

The discount amount applied to expire changes.

TransferDonation

The transfer donation amount.

NewGrace

The new grace amount.

Writeoff

The write-off amount.

UnearnedRevDisc

The unearned revenue discount amount.

PriorDelivURFee

The prior unearned delivery fee balance.

EarnedDelivFee

The earned delivery fee amount.

OtherEarnedDelivFee

The other earned delivery fee amount.

PaymentDeliveryFee

The delivery fee amount applied to payments.

ExpChgDelivFee

The delivery fee amount applied to expire changes.

TransfersDelivFee

The delivery fee amount applied to transfers.

GraceDelivFee

The delivery fee amount applied to grace.

RefundsDelivFee

The delivery fee amount applied to refunds.

UnearnedDelivFee

The unearned delivery fee balance.

DonationDelivFee

The delivery fee amount applied to donations.

NewGraceDelivFee

The delivery fee amount applied to new grace.

WriteoffDelivFee

The delivery fee amount applied to write-offs.

Resolved

The resolved amount.

ResolvedDisc

The resolved discount amount.

RefundOR

The original refund amount.

TotalZone

The total amount for the zone.

TotalPriorUR

The total prior unearned revenue balance.

TotalEarnedRev

The total earned revenue amount.

TotalOtherEarnedRev

The total other earned revenue amount.

TotalPayments

The total payment amount.

TotalExpChg

The total expire change amount.

TotalTransfers

The total transfer amount.

TotalGracePaid

The total grace amount paid.

TotalRefunds

The total refund amount.

TotalUnearnedRev

The total unearned revenue balance.

TotalPriorURDisc

The total prior unearned revenue discount amount.

TotalEarnedRevDisc

The total earned revenue discount amount.

TotalOtherEarnedRevDisc

The total other earned revenue discount amount.

TotalPaymentDiscounts

The total discount amount applied to payments.

TotalExpChgDiscount

The total discount amount applied to expire changes.

TotalTransferDonation

The total transfer donation amount.

TotalNewGrace

The total new grace amount.

TotalWriteoff

The total write-off amount.

TotalUnearnedRevDisc

The total unearned revenue discount amount.

TotalPriorDelivURFee

The total prior unearned delivery fee balance.

TotalEarnedDelivFee

The total earned delivery fee amount.

TotalOtherEarnedDelivFee

The total other earned delivery fee amount.

TotalPaymentDeliveryFee

The total delivery fee amount applied to payments.

TotalExpChgDelivFee

The total delivery fee amount applied to expire changes.

TotalTransfersDelivFee

The total delivery fee amount applied to transfers.

TotalGraceDelivFee

The total delivery fee amount applied to grace.

TotalRefundsDelivFee

The total delivery fee amount applied to refunds.

TotalUnearnedDelivFee

The total unearned delivery fee balance.

TotalDonationDelivFee

The total delivery fee amount applied to donations.

TotalNewGraceDelivFee

The total delivery fee amount applied to new grace.

TotalWriteoffDelivFee

The total delivery fee amount applied to write-offs.

TotalResolved

The total resolved amount.

TotalResolvedDisc

The total resolved discount amount.

TotalRefundOR

The total original refund amount.

TotalProductID

The total amount for the product ID.

GrandTotalZone

The grand total amount for all zones.

GrandTotalPriorUR

The grand total prior unearned revenue balance.

GrandTotalEarnedRev

The grand total earned revenue amount.

GrandTotalOtherEarnedRev

The grand total other earned revenue amount.

GrandTotalPayments

The grand total payment amount.

GrandTotalExpChg

The grand total expire change amount.

GrandTotalTransfers

The grand total transfer amount.

GrandTotalGracePaid

The grand total grace amount paid.

GrandTotalRefunds

The grand total refund amount.

GrandTotalUnearnedRev

The grand total unearned revenue balance.

GrandTotalPriorURDisc

The grand total prior unearned revenue discount amount.

GrandTotalEarnedRevDisc

The grand total earned revenue discount amount.

GrandTotalOtherEarnedRevDisc

The grand total other earned revenue discount amount.

GrandTotalPaymentDiscounts

The grand total discount amount applied to payments.

GrandTotalExpChgDiscount

The grand total discount amount applied to expire changes.

GrandTotalTransferDonation

The grand total transfer donation amount.

GrandTotalNewGrace

The grand total new grace amount.

GrandTotalWriteoff

The grand total write-off amount.

GrandTotalUnearnedRevDisc

The grand total unearned revenue discount amount.

GrandTotalPriorDelivURFee

The grand total prior unearned delivery fee balance.

GrandTotalEarnedDelivFee

The grand total earned delivery fee amount.

GrandTotalOtherEarnedDelivFee

The grand total other earned delivery fee amount.

GrandTotalPaymentDeliveryFee

The grand total delivery fee amount applied to payments.

GrandTotalExpChgDelivFee

The grand total delivery fee amount applied to expire changes.

GrandTotalTransfersDelivFee

The grand total delivery fee amount applied to transfers.

GrandTotalGraceDelivFee

The grand total delivery fee amount applied to grace.

GrandTotalRefundsDelivFee

The grand total delivery fee amount applied to refunds.

GrandTotalUnearnedDelivFee

The grand total unearned delivery fee balance.

GrandTotalDonationDelivFee

The grand total delivery fee amount applied to donations.

GrandTotalNewGraceDelivFee

The grand total delivery fee amount applied to new grace.

GrandTotalWriteoffDelivFee

The grand total delivery fee amount applied to write-offs.

GrandTotalResolved

The grand total resolved amount.

GrandTotalResolvedDisc

The grand total resolved discount amount.

GrandTotalRefundOR

The grand total original refund amount.

GrandTotalProductID

The grand total amount for the product ID.

Last updated