The Revenue Waterfall dataset stores fields associated with the Revenue Schedule object in Revenue Management, the Contract Line Item object in Billing Central, and their related records as well as other associated objects. The fields are:
|
Field Type |
Field |
Description |
|---|---|---|
| Measures |
Scheduled Billing |
The billing amount scheduled for recognition. |
|
Scheduled Revenue |
The revenue to be recognized for the source record in this financial period. This field is extracted from the Revenue Schedule Line object in Revenue Management. | |
| Total Billed | The total amount billed for the contract line item. | |
| Total Contract Line Value | The total value of the contract line item over its lifetime including discounts. | |
| Dates | Contract Line Item End Date | The end date of the contract. The end date of new contract line items are initially set to this date. |
| Contract Line Item Start Date | The first date from which billing can commence for this contract line item. | |
| Period End Date | The end date of the period. This field is extracted from the Revenue Schedule Line object in Revenue Management. | |
| Period Start Date | The start date of the period. This field is extracted from the Revenue Schedule Line object in Revenue Management. | |
| Dimensions | Account Billing Country | The country portion of the account billing address. |
| Account ID | The identification number of the account. | |
| Account Industry | The industry sector to which the account belongs. | |
| Account Name | The name of the account. | |
| Company ID | The identification number of the company. | |
| Company Name | The name of the company. | |
| Contract Line Item ID | The identification number of the contract line item. | |
| Contract Line Item Name | The name of the contract line item. | |
| Contract Name | The name of the contract. | |
| Contract ID | The identification number of the contract. | |
| Currency ISO Code |
Currency of the contract in Billing Central. For more information, see Billing Contract Fields in Billing Central. |
|
| Period Name | The name of the recognition period. This field is extracted from the Recognition Period object in Revenue Management. | |
| Product Family | The category specified for the product. | |
| Product ID | The identification number of the product. | |
| Product Name | The name of the product. | |
| Revenue Schedule ID | The identification number of the revenue schedule. | |
| Revenue Schedule Recognition Method |
The method used to calculate the revenue to recognize for each period. For example, Equal Split where equal amounts are recognized each period. For more information, see Revenue Schedules in Revenue Management. |