5.2.10 SY10.01 – Summary Record Type for Financial Reporting to Record Companies
This is the Record that communicates basic summary information about Usages, Revenues or Sales being reported to Record Companies and companies that hold rights in Sound Recordings or Releases.
Cell Name | Field Definition | Data Type | M/O/C | Example | |
|---|---|---|---|---|---|
1 |
| The Type of the Record, always to contain “SY10.01” | Fixed String | M | SY10.01 |
2 |
| The Identifier (specific to the Message) of the Summary Record. This Identifier shall be referenced in Usage/Revenue/Sales Records to indicate to which Summary Record they provide details. | String | M | 123 |
3 |
| The Party that generated the sales/usages reported in this Sales/Usage Report. DistributionChannelName needs to be provided if the Message Sender offers multiple distribution channels that need to be differentiated in this Sales/Usage Report. | String | C | MyCo |
4 |
| The DDEX Party ID of the DistributionChannel. DistributionChannelDPID needs to be provided if the Message Sender offers multiple distribution channels that need to be differentiated in this Sales/Usage Report. Note: this terms differs from DistributionChannel as used in the Electronic Release Notification where a Distribution Channel is the specific DSP through which a Release may be made available. This may, or may not, map to a DistributionChannel as used in a sales/usage report. | DPID | C | DPIDA12345SDF |
5 |
| The Type of CommercialModel of the SalesTransaction. The CommercialModel defines how a Consumer has paid for access to a Service or Release/Resource. | AVS | M | SubscriptionModel |
6a |
| The StartDate of the reporting Period covered by the Summary Record (in ISO 8601 format) to allow reporting per-subscriber minima in a more granular form than for the overall reporting period. This is a string with the syntax YYYY[-MM[-DD]]. The ReportingPeriodStartDate must not be earlier than than the UsageEndDate provided in the header record. | Date | M | 2017-06-01 |
6b |
| The EndDate of the reporting Period covered by the Summary Record (in ISO 8601 format) to allow reporting per-subscriber minima in a more granular form than for the overall reporting period. This is a string with the syntax YYYY[-MM[-DD]]. The ReportingPeriodEndDate must not be later than than the UsageEndDate provided in the header record and must not be earlier than the ReportingPeriodStartDate. | Date | M | 2017-06-01 |
7 |
| The type of Subscriber. Sender and Recipient will need to agree values for this field. SubscriberType needs to be provided if the sales report covers subscriptions. | String | C | Student |
8 |
| The number of subscribers to a Service for each SubscriberType. Sender and Recipient will need to agree values for this field. Subscribers needs to be provided if the sales report covers subscriptions. | Decimal | C | 12245.4 |
9 |
| The number of active subscribers to a Service for each SubscriberType. What constitutes an ActiveSubscriber will depend on the agreement between Sender or Receiver. ActiveSubscribers needs to be provided if the sales report covers subscriptions. | Decimal | C | 12245.4 |
10 |
| A Description of a promotional activity. Sender and Recipient will need to agree values for this field. PromotionalActivity needs to be provided if a specific promotional activity was active at the time of the sale/use and which may have impacted on the sale/use. | String | C | HalloweenSpecial |
11 |
| The Territory for which the Sale/Usage is reported. | AVS | M | US |
12 |
| The service name (e.g. a service tier) under which the SalesTransaction took place. The ServiceDescription may not contain space characters or underscores. ServiceDescription needs to be provided if the Message Sender offers multiple services that need to be differentiated in this sales/usage report. | String | C | YTRed |
13 |
| Information on the type of offer involved in the consumer transaction. Sender and Recipient will need to agree values for this field. | String | O | CompleteMyAlbum |
14 |
| Information on the quality of the Resources/Releases involved in the consumer transaction. | String | O | UpgradeToHiResMusic |
15 |
| The number of Usages of the Release or Resource provided to Consumers, including any sales adjustments. Sales adjustments include e.g. file failures. Releases or Resources to be reported here include all Releases or Resources provided across the service, not just the ones that are are controlled by the MessageRecipient/RightsController, according to the knowledge of the MessageSender at the time of sending the message. This allows the MessageRecipient/RightsController to calculate its market share of uses. | Decimal | M | 12337.91826 |
16 |
| The number of Usages of the Release or Resource provided to Consumers, including any sales adjustments. Sales adjustments include e.g. file failures. The Releases or Resources to be reported here are those controlled by the MessageRecipient/RightsController, according to the knowledge of the MessageSender at the time of sending the message. | Decimal | M | 12334.78766 |
17 |
| The number of Usages of a Release or Resource returned (with refund) by Consumers as a result of a reversal of a SalesTransaction or because of an earlier error in sales reporting. If no returns are to be reported the value should be 0. | Integer
| M | 12 |
18 |
| Percentage of music usage on a service. | Decimal | M | 66.66 |
19 |
| The Currency in which the SalesTransactions have occurred (represented by an ISO 4217 CurrencyCode). This may be the same as the CurrencyOfAccounting. | AVS | M | USD |
20 |
| The Currency in which the SalesTransactions are accounted (represented by an ISO 4217 CurrencyCode). | AVS | M | EUR |
21 |
| The rate used to convert from the CurrencyOfTransaction to the CurrencyOfAccounting | Decimal | M |
|
22 |
| The source of the ExchangeRate. | String | C | |
23 |
| The date and time on which the ExchangeRate was determined. The only allowed format is ISO 8601 YYYY-MM-DDThh:mm:ssTZD). The DateOfCurrencyExchange shall be provided if an ExchangeRate is provided. | ISO datetime | C | 2014-12-14T10:05:00Z |
24 |
| Gross Revenue of the DSP generated from the distribution of Releases or Resources in the CurrencyOfTransaction. This Cell needs to be provided if applicable to the deal. When provided, the next cell needs to be provided as well. | Decimal | C | 1176153.10 |
25 |
| Gross Revenue of the DSP generated from the distribution of Releases or Resources in the CurrencyOfAccounting. This Cell needs to be provided if applicable to the deal. When provided, the previous cell needs to be provided as well. | Decimal | C | 1176153.10 |
26 |
| The type of the calculation made to the amounts reported in this Record. Types might include minimum amount or rate payable. Sender and Recipient will need to agree values for this field. | Multiple String | O | MinimumAmount|MaximumAmount |
27 |
| The value of the minimum amount or rate payable indicated by the corresponding value in CalculationType. One CalculationValues needs to be provided for each CalculationType. | Multiple Decimals | O | 52.24|72.66
|
28 |
| Different types of deductions that the DSP applies before allocating revenue to the DSP/MessageSender. DeductionType needs to be provided if applicable to the deal. When provided, the next two need to be provided as well. | Multiple String | C
|
|
29 |
| Deductions that the DSP applies before allocating revenue to the MessageRecipient/RightsController in the CurrencyOfTransaction. One Deduction amount has to be provided for each DeductionType. | Multiple Decimals | C | 1452.24|12372.66 |
30 |
| Deductions that the DSP applies before allocating revenue to the MessageRecipient/RightsController in the CurrencyOfAccounting. One Deduction amount has to be provided for each DeductionType. | Multiple Decimals | C
| 1452.24|12372.66 |
31 |
| Net Revenue of the DSP generated from the distribution of Releases or Resources, as well as sales of products based on Releases or Resources in the CurrencyOfTransaction. | Decimal | M | 1176153.65 |
32 |
| Net Revenue of the DSP generated from the distribution of Relea ses or Resources , as well as sales of products based on Releases or Resources in the CurrencyOfAccounting. | Decimal | M | 1176153.65 |
33 |
| The amount allocated to the MessageRecipient/RightsController for the Usages reported in the CurrencyOfTransaction. | Decimal | M | 76153.65 |
34 |
| The amount allocated to the MessageRecipient/RightsController for the Usages reported in the CurrencyOfAccounting. | Decimal | M | 76153.65 |
35 |
| Net Revenue generated that is to be allocated to the MessageRecipient/RightsController in the CurrencyOfTransaction.
| Decimal | M | 153.65 |
36 |
| Net Revenue generated that is to be allocated to the MessageRecipient/RightsController in the CurrencyOfAccounting. | Decimal | M | 153.65 |
37 |
| Market share as defined by the contract between sender and recipient. RightsControllerMarketShare needs to be provided if required in the agreement between Message Sender and Message Recipient.
| Decimal | C | 22.32 |
38 |
| Price for one subscription generated by the DSP in the CurrencyOfTransaction. SubscriptionFeeInCurrencyOfTransaction needs to be provided if required in the agreement between Message Sender and Message Recipient. | Decimal | C | 10.0 |
39 |
| Price for one subscription generated by the DSP in the CurrencyOfAccounting. | Decimal | M | 7.35 |
40 |
| The type of a fee payable payable to the RightsController independent from any usage generated based on RightsController's content. UsageIndependentFeeType must be provided when fees are applicable; Sender and Recipient will need to agree values for this field. | Multiple String | C | GuaranteedMinimum| GuaranteedMaximum |
41 |
| Fee payable to the RightsController independent from any usage generated based on RightsController's content in the CurrencyOfTransaction. One UsageIndependentFeeInCurrencyOfTransaction needs to be provided for each UsageIndependentFeeType. | Multiple Decimal | C | 10089.92 |
42 |
| Fee payable to the RightsController independent from any usage generated based on RightsController's content in the CurrencyOfAccounting. One UsageIndependentFeeInCurrencyOfAccounting needs to be provided for each UsageIndependentFeeType. | Multiple Decimal | C | 10089.92 |
43 |
| The total amount of all allocated amounts in the CurrencyOfTransaction, including the UsageIndependentFeeInCurrencyOfTransaction, reported in this Record. | Decimal | M | 555.654 |
44 |
| The total amount of all allocated amounts in the CurrencyOfAccounting, including the UsageIndependentFeeInCurrencyOfAccounting, reported in this Record. | Decimal | M | 555.654 |