Deferred Revenue Adjustment Report - Data Fields

Owned by Chris McFarlane (Deactivated)
Last updated: Aug 24, 2023
4 min read


In Projector a data field represents the information that you are interested in. For Excel Pivot Tables this information can be cross-referenced by the row and column fields to compile the data. In this image you see project profit organized by project name and month. Project Profit is the data field. Project Name is the row field. Month is the column field. If this sounds confusing, read our introductory article on pivot tables.

Data Fields

FieldField CategoryDescription
Adjustment TypeAdjustment FieldsAction taken which resulted in a change to deferred revenue.
ExplanationAdjustment FieldsAdditional context supporting the adjustment.
New Primary Client NameClient FieldsPrimary Client Name for the destination contract line item that deferred revenue was transferred to.
New Primary Client NumberClient FieldsPrimary Client Number for the destination contract line item that deferred revenue was transferred to.
Original Primary Client NameClient FieldsPrimary Client Name for the original contract line item that deferred revenue was transferred from.
Original Primary Client NumberClient FieldsPrimary Client Number for the original contract line item that deferred revenue was transferred from.
New Contract Line Item CodeContract Line Item FieldsContract Line Item Code for the destination contract line item that deferred revenue was transferred to.
New Contract Line Item NameContract Line Item FieldsContract Line Item Name for the destination contract line item that deferred revenue was transferred to.
New Contract TypeContract Line Item FieldsContract Type for the destination contract line item that deferred revenue was transferred to.
New Cost Contract TermsContract Line Item FieldsCost Contract Terms for the destination contract line item that deferred revenue was transferred to.
New Time Contract TermsContract Line Item FieldsTime Contract Terms for the destination contract line item that deferred revenue was transferred to.
Original Contract Line Item CodeContract Line Item FieldsContract Line Item Code for the original contract line item that deferred revenue was transferred from.
Original Contract Line Item NameContract Line Item FieldsContract Line Item Name for the original contract line item that deferred revenue was transferred from.
Original Contract TypeContract Line Item FieldsContract Type for the original contract line item that deferred revenue was transferred from.
Original Cost Contract TermsContract Line Item FieldsCost Contract Terms for the original contract line item that deferred revenue was transferred from.
Original Time Contract TermsContract Line Item FieldsTime Contract Terms for the original contract line item that deferred revenue was transferred from.
Adjustment DateDate FieldsDate associated with the adjustment. Depending on the type of adjustment the adjustment date may reflect a variety of adjustment specific values.
Transaction TimestampDate FieldsDate and time the adjustment was executed. 
New EngagementEngagement FieldsEngagement for the destination contract line item that deferred revenue was transferred to.
New Engagement CompanyEngagement FieldsEngagement Company for the destination contract line item that deferred revenue was transferred to.
New Engagement CorporationEngagement FieldsEngagement Corporation for the destination contract line item that deferred revenue was transferred to.
New Engagement CurrencyEngagement FieldsEngagement Currency for the destination contract line item that deferred revenue was transferred to.
New Engagement DivisionEngagement FieldsEngagement Division for the destination contract line item that deferred revenue was transferred to.
New Engagement Level 2Engagement FieldsEngagement Level 2 for the destination contract line item that deferred revenue was transferred to.
New Engagement ManagerEngagement FieldsEngagement Manager for the destination contract line item that deferred revenue was transferred to.
New Engagement Manager Display NameEngagement FieldsEngagement Manager Display Name for the destination contract line item that deferred revenue was transferred to.
New Engagement Manager Email AddressEngagement FieldsEngagement Manager Email Address for the destination contract line item that deferred revenue was transferred to.
New Engagement Primary Cost Center NameEngagement FieldsEngagement Primary Cost Center Name for the destination contract line item that deferred revenue was transferred to.
New Engagement Primary Cost Center NumberEngagement FieldsEngagement Primary Cost Center Number for the destination contract line item that deferred revenue was transferred to.
New Engagement TypeEngagement FieldsEngagement Type for the destination contract line item that deferred revenue was transferred to.
Original EngagementEngagement FieldsEngagement for the original contract line item that deferred revenue was transferred from.
Original Engagement CompanyEngagement FieldsEngagement Company for the original contract line item that deferred revenue was transferred from.
Original Engagement CorporationEngagement FieldsEngagement Corporation for the original contract line item that deferred revenue was transferred from.
Original Engagement CurrencyEngagement FieldsEngagement Currency for the original contract line item that deferred revenue was transferred from.
Original Engagement DivisionEngagement FieldsEngagement Division for the original contract line item that deferred revenue was transferred from.
Original Engagement Level 2Engagement FieldsEngagement Level 2 for the original contract line item that deferred revenue was transferred from.
Original Engagement ManagerEngagement FieldsEngagement Manager for the original contract line item that deferred revenue was transferred from.
Original Engagement Manager Display NameEngagement FieldsEngagement Manager Display Name for the original contract line item that deferred revenue was transferred from.
Original Engagement Manager Email AddressEngagement FieldsEngagement Manager Email Address for the original contract line item that deferred revenue was transferred from.
Original Engagement Primary Cost Center NameEngagement FieldsEngagement Primary Cost Center Name for the original contract line item that deferred revenue was transferred from.
Original Engagement Primary Cost Center NumberEngagement FieldsEngagement Primary Cost Center Number for the original contract line item that deferred revenue was transferred from.
Original Engagement TypeEngagement FieldsEngagement Type for the original contract line item that deferred revenue was transferred from.
Deferred Revenue Change AmountRevenue FieldsThe diference between the deferred revenue amount before and after the adjustment.
New Deferred Revenue AmountRevenue FieldsDeferred Revenue Amount for the destination contract line item that deferred revenue was transferred to.
Original Deferred Revenue AmountRevenue FieldsDeferred Revenue Amount for the original contract line item that deferred revenue was transferred from.
Entered by UserUser FieldsUser who initiated the adjustment.