Deferred Revenue Adjustment Report - Data Fields

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

Field	Field Category	Description
Adjustment Type	Adjustment Fields	Action taken which resulted in a change to deferred revenue.
Explanation	Adjustment Fields	Additional context supporting the adjustment.
New Primary Client Name	Client Fields	Primary Client Name for the destination contract line item that deferred revenue was transferred to.
New Primary Client Number	Client Fields	Primary Client Number for the destination contract line item that deferred revenue was transferred to.
Original Primary Client Name	Client Fields	Primary Client Name for the original contract line item that deferred revenue was transferred from.
Original Primary Client Number	Client Fields	Primary Client Number for the original contract line item that deferred revenue was transferred from.
New Contract Line Item Code	Contract Line Item Fields	Contract Line Item Code for the destination contract line item that deferred revenue was transferred to.
New Contract Line Item Name	Contract Line Item Fields	Contract Line Item Name for the destination contract line item that deferred revenue was transferred to.
New Contract Type	Contract Line Item Fields	Contract Type for the destination contract line item that deferred revenue was transferred to.
New Cost Contract Terms	Contract Line Item Fields	Cost Contract Terms for the destination contract line item that deferred revenue was transferred to.
New Time Contract Terms	Contract Line Item Fields	Time Contract Terms for the destination contract line item that deferred revenue was transferred to.
Original Contract Line Item Code	Contract Line Item Fields	Contract Line Item Code for the original contract line item that deferred revenue was transferred from.
Original Contract Line Item Name	Contract Line Item Fields	Contract Line Item Name for the original contract line item that deferred revenue was transferred from.
Original Contract Type	Contract Line Item Fields	Contract Type for the original contract line item that deferred revenue was transferred from.
Original Cost Contract Terms	Contract Line Item Fields	Cost Contract Terms for the original contract line item that deferred revenue was transferred from.
Original Time Contract Terms	Contract Line Item Fields	Time Contract Terms for the original contract line item that deferred revenue was transferred from.
Adjustment Date	Date Fields	Date associated with the adjustment. Depending on the type of adjustment the adjustment date may reflect a variety of adjustment specific values.
Transaction Timestamp	Date Fields	Date and time the adjustment was executed.
New Engagement	Engagement Fields	Engagement for the destination contract line item that deferred revenue was transferred to.
New Engagement Company	Engagement Fields	Engagement Company for the destination contract line item that deferred revenue was transferred to.
New Engagement Corporation	Engagement Fields	Engagement Corporation for the destination contract line item that deferred revenue was transferred to.
New Engagement Currency	Engagement Fields	Engagement Currency for the destination contract line item that deferred revenue was transferred to.
New Engagement Division	Engagement Fields	Engagement Division for the destination contract line item that deferred revenue was transferred to.
New Engagement Level 2	Engagement Fields	Engagement Level 2 for the destination contract line item that deferred revenue was transferred to.
New Engagement Manager	Engagement Fields	Engagement Manager for the destination contract line item that deferred revenue was transferred to.
New Engagement Manager Display Name	Engagement Fields	Engagement Manager Display Name for the destination contract line item that deferred revenue was transferred to.
New Engagement Manager Email Address	Engagement Fields	Engagement Manager Email Address for the destination contract line item that deferred revenue was transferred to.
New Engagement Primary Cost Center Name	Engagement Fields	Engagement Primary Cost Center Name for the destination contract line item that deferred revenue was transferred to.
New Engagement Primary Cost Center Number	Engagement Fields	Engagement Primary Cost Center Number for the destination contract line item that deferred revenue was transferred to.
New Engagement Type	Engagement Fields	Engagement Type for the destination contract line item that deferred revenue was transferred to.
Original Engagement	Engagement Fields	Engagement for the original contract line item that deferred revenue was transferred from.
Original Engagement Company	Engagement Fields	Engagement Company for the original contract line item that deferred revenue was transferred from.
Original Engagement Corporation	Engagement Fields	Engagement Corporation for the original contract line item that deferred revenue was transferred from.
Original Engagement Currency	Engagement Fields	Engagement Currency for the original contract line item that deferred revenue was transferred from.
Original Engagement Division	Engagement Fields	Engagement Division for the original contract line item that deferred revenue was transferred from.
Original Engagement Level 2	Engagement Fields	Engagement Level 2 for the original contract line item that deferred revenue was transferred from.
Original Engagement Manager	Engagement Fields	Engagement Manager for the original contract line item that deferred revenue was transferred from.
Original Engagement Manager Display Name	Engagement Fields	Engagement Manager Display Name for the original contract line item that deferred revenue was transferred from.
Original Engagement Manager Email Address	Engagement Fields	Engagement Manager Email Address for the original contract line item that deferred revenue was transferred from.
Original Engagement Primary Cost Center Name	Engagement Fields	Engagement Primary Cost Center Name for the original contract line item that deferred revenue was transferred from.
Original Engagement Primary Cost Center Number	Engagement Fields	Engagement Primary Cost Center Number for the original contract line item that deferred revenue was transferred from.
Original Engagement Type	Engagement Fields	Engagement Type for the original contract line item that deferred revenue was transferred from.
Deferred Revenue Change Amount	Revenue Fields	The diference between the deferred revenue amount before and after the adjustment.
New Deferred Revenue Amount	Revenue Fields	Deferred Revenue Amount for the destination contract line item that deferred revenue was transferred to.
Original Deferred Revenue Amount	Revenue Fields	Deferred Revenue Amount for the original contract line item that deferred revenue was transferred from.
Entered by User	User Fields	User who initiated the adjustment.