Cell Name | Definition | Data type | M/O/C | Example |
---|
1 | RecordType
| The type of the Record which shall always contain the value SY09.02 . | Fixed string | M | SY09.02 |
2 | SummaryRecordId
| The identifier of the summary Record which shall be specific to the Sale/Usage Report. This identifier shall be used in the sales and/or usage data Records to indicate to which summary Record they provide details. | String | M | 34 |
3 | CommercialModel
| A description of the type of business model or end user charging mechanism to which the sales and/or usage data in a DSR message relates. The value in the CommercialModel Cell defines how an end user has paid for or otherwise accessed the service offering the releases and/or resources. | AVS: CommercialModelType
| M | PayAsYouGoModel |
4 | UseType
| A description of the way in which an end user uses a service. The value in the UseType Cell also enables the communication of which type of device an end user has used to access the service. This is achieved by using the UseType value UseAsDevice . A value in the UseType Cell is mandatory if there is no UseType on the relevant sales and/or usage data Record(s). | AVS: UseType_DSR
| C | PermanentDownload |
5 | Territory
| The name of the territory in which the sales and/or usage being reported took place. | AVS: Current TerritoryCode
| M | DE |
6 | Service Description
| The service offering/tier under which the sales and/or usage data in the SY Record took place. Where the licensee is reporting sales and/or usage data for one service offering/tier in the DSR message the value in the ServiceDescription shall be the same as the value for ServiceDescription in the HEAD Record. A value in the ServiceDescription Cell is mandatory if the licensee is reporting sales and/or usage date for multiple service offerings/tiers in the DSR message or determined by the bilateral agreement between the licensee and the licensor. The identification of each such multiple services is essential to the processing of the DSR message by the licensor. The value in the ServiceDescription Cell may not contain space characters or underscores. | String | C | PremiumService |
7 | Deprecated Cell (SubscriberType ) | | | | |
8 | RightsController Name
| The name of the owner(s) or administrator(s) that is believed by the licensee to own or administer a RightShare in the musical work that is the subject of the Record. The order of the values in the RightsControllerName and the RightsControllerPartyId Cells shall be the same so that the licensor is able to link names and identifiers correctly. If an SY record references more than one rights controller, no RightsControllerPartyId shall be provided. If an SY Record references more than one rights controller, the licensee and the licensor shall agree a mutually acceptable keywords (e.g. "all" or "conflict") to convey the required data. Clearly, the licensee and the licensor must take care to use keywords that do not conflict with actual RightsControllerName (s). | String | O | SACEM |
9 | RightsController PartyID
| The identifier(s) of the party(ies) identified in the RightsControllerName Cell. The order of the values in the RightsControllerPartyId and RightsControllerName Cells shall be the same so that the licensor is able to link names and identifiers correctly. | Multiple Party Identifiers | O | ISNI::0000000081266409 |
10 | RightsType
| A description of the type of right that has been exploited by the licensee in providing the service to end users. A value in the RightsType Cell is mandatory if it applies to the resources that have been accessed. A value in the RightsType Cell s mandatory when it applies to the resources that are broadcast. | AVS: Rights Coverage
| C | MechanicalRight |
11 (up-dated) | TotalUsages
| The number of sales and/or usages of the releases and/or resources provided to all end users, during the reporting period, including any adjustments. Adjustments include, for example, file failures. The sales and/or usage data reported here is in respect of all releases and/or resources available across the whole of the licensee’s service that is the subject of the Summary Record. It is not just the releases and/or resources that embody musical works which to the knowledge of the licensee at the time of sending the DSR message are controlled by the RightsController or licensor, as determined by the bilateral agreement between the licensee and the licensor. This enables the licensor to calculate the market share of the total uses of the RightsController or licensor as the case may be. The value in the TotalUsages Cell shall not be provided pro-rated by the RightsTypePercentage . For example, even if a RightsType only attracts 25% of the royalties, 100% of TotalUsages shall be reported in this Cell. | Decimal | M | 2324 |
12 | AllocatedUsages
| The total number of usages allocated by the licensee, in respect of the AllocatedUsages in the relevant detailed Records, with reference to the values in the RightSharePercentage and RightsType Cells to the rights controller or licensor, as determined by the bilateral agreement between the licensee and the licensor. The precise mechanism for calculating the AllocatedUsages is determined by the bilateral agreement between the licensee and the licensor. | Decimals | O | 411.29 |
13 | NetRevenue
| The revenue generated by the licensee for the distribution of releases and/or resources and/or musical works. The detailed definition of NetRevenue is determined by the bilateral agreement between the licensee and the licensor or by applicable law or regulation, any of which may include financial adjustments, for example purchased file failures. | Decimal | M | 1220.06 |
14 | IndirectValue
| The revenue generated by the licensee that cannot be directly allocated to the use by end users of specific releases and/or resources and/or musical works. The exact definition of IndirectValue is determined by the bilateral agreement between the licensee and the licensor. A value in the IndirectValue Cell is mandatory if indirect revenues have been generated. This may include a value ascribed to a service for which no direct remuneration occurs. | Decimal | C | 120.81 |
15 | RightsController MarketShare
| The ratio in percent between the values in the TotalUsages and AllocatedUsages Cells for the rights controller or licensor, as determined by the bilateral agreement between the licensee and the licensor. | Decimal | O | 10.54 |
16 | CurrencyOf Reporting
| The currency in which the values in the NetRevenue and IndirectValue Cells are reported, using an ISO 4217 currency code. | AVS: CurrencyCode
| M | CZK |
17 | CurrencyOf Transaction
| The currency in which the end user paid the licensee for transactions relating to releases and/or resources, using an ISO 4217 currency code. | AVS: CurrencyCode
| O | USD |
18 | ExchangeRate
| The rate used to convert any revenue amounts from the currency in which the revenue was transacted into the currency in which it is being reported. A value in the ExchangeRate Cell is mandatory if two currencies have been reported. | Decimal | C | 1.205648 |
19 | RightsType Percentage
| The percentage of the revenue reported that is allocated to the rights controller or licensor, as determined by the bilateral agreement between the licensee and the licensor, by the licensee that relates to the value in the RightsType Cell. The RightsTypePercentage may only be provided if a RightsType is provided. For the avoidance of doubt, it is permissible to communicate a RightsType without a RightsTypePercentage . For example, even if a RightsType has a value in the RightsTypePercentage Cell of 25% of the revenue, the values in the Usages , Users , and NetRevenueCells shall still be 100% of the usages, users or net revenue. | Decimal | C | 10.00 |
20 | SubPeriod StartDate
| The start date of a reporting period which falls within the values in the ReportingPeriodStart Date and the ReportingPeriodEndDate Cells covered by the relevant SY Record using the ISO 8601 syntax of YYYY[-MM[-DD]]. A value in the SubPeriodStartDate Cell is mandatory if it is different from the value in the UsageStartDate Cell contained in the relevant HEAD Record. This enables the reporting of per-subscriber minima in a more granular form than for the overall reporting period. Values in the SubPeriodStartDate and SubPeriodEndDate Cells shall always be provided together. The value in the SubPeriodStartDate Cell shall not be earlier than the value in the UsageEndDate Cell contained in the relevant HEAD Record. | Date | C | 2014-12-01 |
21 | SubPeriodEndDate
| The end date of a reporting period which falls within the values in the ReportingPeriodStart Date and the ReportingPeriodEndDate Cells covered by the relevant SY Record using the ISO 8601 syntax YYYY[-MM[-DD]]. A value in the SubPeriodEndDate Cell is mandatory if it is different from the value in the UsageEndDate Cell contained in the relevant HEAD Record. This enables the reporting of per-subscriber minima in a more granular form than for the overall reporting period. Values in the SubPeriodStartDate and SubPeriodEndDate shall always be provided together. The value in the SubPeriodEndDate Cell shall not be later than the value in the UsageEndDate Cell contained in the relevant HEAD Record and, also, shall not be earlier than the value in the SubPeriodStartDate Cell. | Date | C | 2014-12-01 |
22 | ParentSummary RecordId
| The identifier of the summary Record that this summary Record provides details for, which shall be specific to the DSR message. A value in the ParentSummaryRecordId Cell is mandatory if summary records are being used to provide summary data in a hierarchical manner. | String | C | 1234 |
23 (new) | ExchangeRate Source
| The identity of the source of the ExchangeRate value in the ExchangeRate Cell. A value in the ExchangeRateSource is mandatory if there is a value in the ExchangeRate Cell. | String | C | http://currencyexchange.net |
24 (new) | DateOfCurrency Exchange
| The date and time on which the value in the ExchangeRate Cell was determined, using the ISO 8601 format of YYYY-MM-DDThh:mm:ssTZD. Whether or not a value is required in the DateOfCurrencyExchange Cell is determined by the bilateral agreement between the licensee and the licensor. | Datetime | C | 2014-12-14T10:05:00Z |
25 (new) | AllocatedRevenue
| The total amount of the revenue generated by the licensee, in respect of the AllocatedRevenue in the relevant detailed Records, that is allocated by the licensee with reference to the values in the RightSharePercentage and RightsType Cells to the rights controller or licensor, as determined by the bilateral agreement between the licensee and the licensor, in the CurrencyOfTransaction . The AllocatedRevenue is the basis of all further calculations. | Decimal | M | 104.23 |
26 (new) | TotalPlaybackDuration
| The total duration that all end users viewed or listened to the releases and/or resources during the reporting period. The total duration reported here relates to the duration of all playbacks of all releases and/or resources that embody musical works which to the knowledge of the licensee at the time of sending the DSR message are controlled by the rights controller or the licensor. The value In this Cell uses the ISO 8601:2004 PT[[hhH]mmM]ssS format, where lower case characters indicate variables and upper case characters are part of the string. For example, one hour, two minutes and three seconds would be PT1H2M3S). The seconds section ss may include fractions. For example, one minute and 30.5 seconds would be PT1M30.5S. | Duration | O | PT1H3M30.25S |