The Type of the Record; always to contain “HEAD”.

Fixed string

M

HEAD

The Version of the Message. This shall be in the form dsrf/xxx/yyy/zzz with 

• xxx being the version number of Part 1 (Architecture)
• yyy being the version number of Part 2 (Allowed Value Sets) and 
• zzz being the version number of Part 8 (Record Type Definitions) that is needed to ingest the Message. This document represents version 1.2. 

The specific values for the architecture is provided in each of the Parts defining a Profile for this standard.

dsrf/1.1.2/1.6/1.0 would therefore signal that the Message was created in accordance with the Architecture in version 1.1.2, the allowed value set of version 1.6 and the Record Type Record Type Definitions of version 1.0.

If the MessageVersion is provided as dsrf/30, Parts 1 and 2 are deemed to be in the initial version as published in 2016. This capability has been retained for backwards compatibility.

Fixed string

M

dsrf/1.1.2/1.6/1.0

The Identifier of the Profile used for the Message.

String

M

BasicAudioProfile

The Identifier of the Version of the Profile used for the Message. The value for this field is defined in the relevant Profile standard.

String

M

1.0

A string used to uniquely identify the Message. The MessageId shall be, in combination with the MessageSenderId, globally unique. Thus, a MessageSender shall never re-use a MessageId.

String

M

1234567890

The DateTime on which the Message was created (the only allowed format is ISO 8601:2004: YYYY-MM-DDThh:mm:ssTZD).

ISO datetime

M

2014-12-14T10:05:00Z

Sequence number of the file within the Flat File Sales Report Message. The first file shall be numbered “1”. The FileNumber must not be larger than NumberOfFiles

Integer

M

2

The number of files that the Sales Report is provided in.

Integer

M

3

The StartDate of the reporting Period covered by the Message (in ISO 8601:2004 format). This is a string with the syntax YYYY[-MM[-DD]].

ISO date

M

2014-12-01

The EndDate of the reporting Period covered by the Message (in ISO 8601:2004 format). This is a string with the syntax YYYY[-MM[-DD]].

ISO date

M

2014-12-01

The DDEX PartyId (DPID) of the MessageSender

DDEX Party ID

M

PADPIDA2008120501W

The Full Name of the MessageSender

String

M

Apple

The service name (e.g. a service tier) under which the SalesTransaction took place. The ServiceDescription may not contain space characters or underscores.

The ServiceDescription shall only be used if it aids the MessageRecipient in determining the sales context(s) of the Message.

The ServiceDesctiption is intended to be a human-readable expression of the totality of the services reported in the Message. For sales/usage reports covering one sales context (see Clause 6.5 in Part 1) this should be the same is being the same string used in the file name (see Clause 9.1 in Part 1) and the single Summary Record contained in the Message.

For sales reports covering multiple sale contexts, the ServiceDescription in the Header should be the same as on the file name and represent a human-readable summary of the sales contexts provided in the Summary Records.

String

C

PremiumService

The DDEX PartyId (DPID) of the MessageRecipient. This element is mandatory when the Sales Report Message is sent to one MessageRecipient and must not be included when the Sales Report Message is sent to more than one MessageRecipient.

DDEX Party ID

O

PADPIDA2007081601G

The Full Name of the MessageRecipient. This element is mandatory when the Sales Report Message is sent to one MessageRecipient and must not be included when the Sales Report Message is sent to more than one MessageRecipient.

String

O

SACEM

Content owners represented by the MessageRecipient. This only needs to be provided if there are more than one repertoires being administered by the MessageRecipient.

RepresentedRepertoire is of value only if the sales/usage report is sent to a collective rights management organisation.

Multiple strings

O

GEMA|PAECOL

The Type of the Record; always to contain “FOOT”.

Fixed string

M

FOOT

Number of data lines communicated in the file, including Header and Footer Records as well as empty Records in accordance with Clause 6.6.7 and commented-out Records in accordance with Clause 6.6.9.

Integer

M

109

Number of data lines communicated in the Sales Report Message, including Header and Footer Records as well as empty Records in accordance with Clause 6.6.7 and commented-out Records in accordance with Clause 6.6.9. For single-file reports the NumberOfLinesInReport is the same as NumberOfLinesInFile. In multi-file reports, NumberOfLinesInFile is smaller than NumberOfLinesInReport.

NumberOfLinesInReport is only mandatory in the last file of a Sales Report Message.

Integer

C

1234

Number of Records in accordance with the relevant profile. 

Integer

M

20

Number of Blocks of Records in the file in accordance with the relevant profile. 

Integer

M

10

Number of Blocks of Records in the Sales Report Message accordance with the relevant profile .

NumberOfBlocksInReport is only mandatory in the last file of a Sales Report Message.

Integer

C

65

The Type of the Record; always to contain “SY01.02”.

Fixed string

M

SY01.02

The Identifier (specific to the Message) of the Summary Record. This Identifier shall be used by Usage/Revenue/Sales Records to indicate to which Summary Record they provide details.

String

M

34

The Party that generated the sales/usages reported in this Sales/Usage Report.

DistributionChannel 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

The DDEX Party ID of the DistributionChannel.

DistributionChannelDPID shall be provided when essential to the commercial relationship being reported on.

DPID

C

DPIDA12345SDF

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

PayAsYouGoModel

The nature of a Service as used by a Consumer. This also allows the communication of Device Usages (that is, which type of device a consumer was using to access the Release/Resource) by using the appropriate use type “UseAsDevice”.

UseType must be provided when there is no UseType on the relevant detailed Record(s).

AVS

C

PermanentDownload

The Territory for which the Sale/Usage is reported.

AVS

M

DE

The service name (e.g. a service tier) under which the SalesTransaction took place. The ServiceDescription may not contain space characters or underscores.

ServiceDescription shall be provided if a Message Sender offers multiple services that need to be differentiated in this sales/usage report.

String

C

PremiumService

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.

Integer

M

123554

The number of subscribers to a Service.

Subscribers shall only be provided when the service is based on subscriptions.

Decimal

C

12345

The Currency in which the NetRevenue and IndirectValue are provided (represented by an ISO 4217 CurrencyCode).

AVS

M

CAD

The revenue generated by the DSP for the potential distribution of Releases or Resources, regardless of the Commercial Model or Use Type used, based on the bilateral agreement between Licensee and Licensor.

Decimal

M

223345.12

The revenue generated by the DSP that cannot directly be allocated to individual Releases or Resources, regardless of the Commercial Model or Use Type used, based on the bilateral agreement between Licensee and Licensor.

IndirectValue shall only be provided when indirect revenues were generated. This may include a value ascribed to a service for which no direct remuneration occurs.

Decimal

C

13424.50

The currency in which the Licensee generated the revenue (represented by an ISO 4217 CurrencyCode).

AVS

O

USD

The Exchange rate used to convert from the currency used for the transactions into the currency of reporting.

Decimal

O

1.205648

The Type of the Record; always to contain “SY02.03”

Fixed String

M

SY02.03

The Identifier (specific to the Message) of the Summary Record. This Identifier shall be used by Usage/Revenue/Sales Records to indicate to which Summary Record they provide details.

String

M

34

The Party that generated the sales/usages reported in this Sales/Usage Report.

DistributionChannel 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

The DDEX Party ID of the DistributionChannel.

DistributionChannelDPID shall be provided when essential to the commercial relationship being reported on.  

DPID

C

DPIDA12345SDF

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

AdvertisementSupportedMode

The nature of a Service as used by a Consumer. This also allows the communication of Device Usages (that is, which type of device a consumer was using to access the Release/Resource) by using the appropriate use type “UseAsDevice”.

UseType must be provided when there is no UseType on the relevant detailed Record(s).

AVS

C

Stream

The Territory for which the Sale/Usage is reported.

AVS

M

FR

The service name (e.g. a service tier) under which the SalesTransaction took place.  The ServiceDescription may not contain space characters or underscores. 

String

M

PremiumService

The number of Usages of the Release or Resource provided to Consumers, including any sales adjustments. Sales adjustments include e.g. file failures.

Integer

M

1234

The number of Users with whom the Release or Resource were transacted.

Integer

O

1234

The Currency in which the NetRevenue, AllocatedRevenue and AllocatedNetRevenue are provided (represented by an ISO 4217 CurrencyCode.

AVS

M

CAD

The revenue generated by the DSP for the distribution of Releases or Resources, regardless of the Commercial Model or Use Type used, based on the bilateral agreement between Licensee and Licensor.

Decimal

M

10545.12

Name of the RightsController that is believed by the MessageSender to control a RightShare of the Work

String

O

SACEM

PartyId of the RightsController that is believed by the MessageSender to control a RightShare of the Work

PartyId

O

ISNI::0000000081266409

The number of Usages allocated to the RightsController.

Multiple Decimals

O

411.29

The amount allocated to the MessageRecipient/RightsController for the usages reported.

This is sometimes called Amount Payable.

Multiple Decimals

O

20.45

Net Revenue generated that is to be allocated to the MessageRecipient/RightsController.

Decimal

O

781.73

A Type of Right which is covered.

AVS

O

MechanicalRight

A string categorising the content that has been used or distributed as agreed between sender and recipient.

String

M

Music

The currency in which the Licensee generated the revenue. (represented by an ISO 4217 CurrencyCode).

AVS

O

USD

The Exchange rate used to convert from the currency used for the transactions into the currency of reporting.

Decimal

O

1.205648

The percentage of how much of the revenue or royalties should be allocated to the RightsType communicated in Cell 18.

The RightsTypePercentage may only be provided if a RightsType is provided. For the avoidance of doubt, it is permissable to communicate a RightsType without a RightsTypePercentage.

 Cells 9 (Usages), 10 (Users) and 12 (NetRevenue) shall be provided not pro-rated by the RightsTypePercentage, i.e. if a RightsType only attracts 25% of the royalties, 100% of these values shall be reported in the respective Cells.

Decimal

C

10.00

The Type of the Record; always to contain “SY03.01”

Fixed string

M

SY03.01

The Identifier (specific to the Message) of the Summary Record. This Identifier shall be used by Usage/Revenue/Sales Records to indicate to which Summary Record they provide details.

String

M

34

The Party that generated the sales/usages reported in this Sales/Usage Report.

DistributionChannel 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

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.

DPID

C

DPIDA12345SDF

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

The nature of a Service as used by a Consumer. This also allows the communication of Device Usages (that is, which type of device a consumer was using to access the Release/Resource) by using the appropriate use type “UseAsDevice”.

UseType must be provided when there is no UseType on the relevant detailed Record(s).

AVS

C

Stream

The Territory for which the Sale/Usage is reported.

AVS

M

FR

The service name (e.g. a service tier) under which the SalesTransaction took place. The ServiceDescription may not contain space characters or underscores.

String

M

PremiumService

The number of Usages of the Release or Resource provided to Consumers, including any sales adjustments. Sales adjustments include e.g. file failures.

Integer

M

1234

The number of subscribers to a Service.

Decimal

M

1239867

The Currency in which the NetRevenue, ConsumerPaidUnitPrice, AllocatedRevenue and AllocatedNetRevenue are provided (represented by an ISO 4217 CurrencyCode).

AVS

M

CAD

The revenue generated by the DSP for the distribution of Releases or Resources, regardless of the Commercial Model or Use Type used, based on the bilateral agreement between Licensee and Licensor.

Decimal

M

10545.12

Name of the RightsController that is believed by the MessageSender to control a RightShare of the Work

String

O

SACEM

PartyId of the RightsController that is believed by the MessageSender to control a RightShare of the Work

PartyId

O

ISNI::0000000081266409

The number of Usages allocated to the RightsController.

The order of the individual figures reported inAllocatedUsages and AllocatedRevenue shall be the same so that the recipient is able to relate figures correctly.

Multiple Decimals

O

411.29

The amount allocated to the MessageRecipient/RightsController for the usages reported.

This is sometimes called Amount Payable.

The order of the individual figures reported in AllocatedUsages and AllocatedRevenue shall be the same so that the recipient is able to relate figures correctly.

Multiple Decimals

O

20.45

Net Revenue generated that is to be allocated to the MessageRecipient/RightsController.

Decimal

O

781.73

The ratio in percent between Usages and AllocatedUsages.

Decimal

O

18.25

The average price paid by the Subscribers

Decimal

M

6.62

The number of non-paying Subscribers (including Subscribers in a non-paying trial period).

Decimal

M

1239867

The currency in which the revenue has to be reported (represented by an ISO 4217 CurrencyCode).

AVS

O

USD

The Exchange rate used to convert from the currency used for the transactions into the currency of reporting.

Decimal

O

1.205648

The type of Subscriber

The Type of the Record; always to contain “SY04.02”

Fixed string

M

SY04.02

The Identifier (specific to the Message) of the Summary Record. This Identifier shall be used by Usage/Revenue/Sales Records to indicate to which Summary Record they provide details.

String

M

34

The Party that generated the sales/usages reported in this Sales/Usage Report.

DistributionChannel 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

The DDEX Party ID of the DistributionChannel.

DistributionChannelDPID shall be provided when essential to the commercial relationship being reported on.

DPID

C

DPIDA12345SDF

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

The nature of a Service as used by a Consumer. This also allows the communication of Device Usages (that is, which type of device a consumer was using to access the Release/Resource) by using the appropriate use type “UseAsDevice”.

UseType must be provided when there is no UseType on the relevant detailed Record(s).

AVS

C

Stream

The Territory for which the Sale/Usage is reported.

AVS

M

FR

The service name (e.g. a service tier) under which the SalesTransaction took place. The ServiceDescription may not contain space characters or underscores.

String

M

PremiumService

The type of Subscriber.

String

M

Student

The number of subscribers to a Service for each SubscriberType.

Decimal

M

1239867

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]].

ReportingSubperiodStartDate shall only be provided when they differ from the UsageStartDate and UsageEndDate in the message header Record. ReportingSubperiodStartDate and ReportingSubperiodEndDate shall always be provided together.

The ReportingSubperiodStartDate must not be earlier than than the UsageEndDate provided in the relevant header record.

Date

C

2014-12-01

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]].

ReportingSubperiodEndDate shall only be provided when they differ from the UsageStartDate and UsageEndDate in the message header Record. ReportingSubperiodStartDate and ReportingSubperiodEndDate shall always be provided together.

The ReportingSubPeriodEndDate must not be later than than the UsageEndDate provided in the relevant header record and must not be earlier than the ReportingSubPeriodStartDate

Date

C

2014-12-01

The number of Usages of the Release or Resource provided to Consumers, including any sales adjustments in the sub period. Sales adjustments include e.g. file failures.

UsagesInSubPeriod and UsagesInReportingPeriod are conditional depending on the commercial relationship between Message Sender and Message Recipient.

Integer

C

1234

The number of Usages of the Release or Resource provided to Consumers, including any sales adjustments in the overall reporting period. Sales adjustments include e.g. file failures.

UsagesInSubPeriod and UsagesInReportingPeriod are conditional depending on the commercial relationship between Message Sender and Message Recipient.

Integer

C

1234

Currency used to report Net Revenue, AllocatedNetRevenue and AllocatedRevenue (represented by an ISO 4217 CurrencyCode).

AVS

M

CAD

Currency in which the Licensee generated the revenue used for ConsumerPaidUnitPrice (represented by an ISO 4217 CurrencyCode).

AVS

O

USD

The Exchange rate used to convert from the currency used for the transactions into the currency of reporting.

Decimal

O

1.205648

The average price paid by the Subscribers.

To be provided based on bilateral agreements. 

Decimal

C

6.62

The revenue generated by the DSP for the distribution of Releases or Resources, regardless of the Commercial Model or Use Type used, based on the bilateral.

 agreement between Licensee and Licensor. Net Revenue of the DSP generated from the distribution of Releases or Resources, as well as sales of products based on Releases or Resources.

To be provided based on bilateral agreements. 

Decimal

C

10545.12

The percentage of musical content in the subscription service.

To be provided based on bilateral agreements. 

Decimal between 0 and 100

C

14.54

The Type of the Record; always to contain “SY05.03”

Fixed string

M

SY05.03

The Identifier (specific to the Message) of the Summary Record. This Identifier shall be used by Usage/Revenue/Sales Records to indicate to which Summary Record they provide details.

String

M

34

The Licensee on whose behalf the Sales/Usage has been generated.

String

C

MyCo

The DDEX Party ID of the DistributionChannel

DPID

C

DPIDA12345SDF

The Type of CommercialModel of the SalesTransaction. The CommercialModel indicates how a Consumer pays for a Service or Release.

AVS

M

SubscriptionModel

The nature of a Service, or a Release, as used by a Consumer.

UseType must be provided when there is no UseType on the relevant detailed Record(s).

AVS

C

Stream

The Territory for which the sale/transaction is reported.

AVS

M

FR

The service name (e.g. a service tier) under which the SalesTransaction took place. The ServiceDescription may not contain space characters or underscores.

String

C

PremiumService

Name of the RightsController that is believed by the MessageSender to control a RightShare of the Work

String

O

SACEM

PartyId of the RightsController that is believed by the MessageSender to control a RightShare of the Work

PartyId

O

ISNI::0000000081266409

Type of Right for which the Revenue and Usages applies

AVS

M

PerformingRight

The number of Usages generated by the Service.

Integer

C

2324

The number of Usages allocated to the RightsController.

Multiple Decimal

O

411.29

The percentage of musical content in the subscription service.

Decimal

C

34.7687

The amount due to the RighsController for the Uses, Revenue or Sales.

Multiple Decimals

O

20.45

The amount allocated to the MessageRecipient/RightsController for the usages reported.

This is sometimes called Amount Payable.

Decimal

O

781.73

The ratio in percent between TotalUsages and AllocatedUsages

Decimal

O

18.25

Currency used to report AllocatedNetRevenueNetRevenue, and AllocatedRevenue (represented by an ISO 4217 CurrencyCode).

AVS

O

EUR

The currency in which the Licensee generated the revenue Currency used for ConsumerPaidUnitPrice (represented by an ISO 4217 CurrencyCode).

AVS

O

CHF

The Exchange rate used to convert from the currency used for the transactions into the currency of reporting.

Decimal

O

1.23

This Cell is not to be used.

Start of the SubPeriod, the meaning of which is agreed between Sender and Recipient.

Date

O

2015-01-01

End of the SubPeriod, the meaning of which is agreed between Sender and Recipient.

Date

O

2015-10-01

A string categorising the content that has been used or distributed as agreed between sender and recipient.

String

M

Music

The percentage of how much of the revenue or royalties should be allocated to the RightsType communicated in Cell 11.

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.

 Cell 12 (TotalUsages) shall be provided not pro-rated by the RightsTypePercentage, i.e. if a RightsType only attracts 25% of the royalties, 100% of this value shall be reported in Cell 12.

Decimal

C

10.00

The Identifier (specific to the Message) of the Summary Record that this Summary Record provides details for.

ParentSummaryRecordId shall only be provided if Summary records are used to provide summary information in a hierarchical manner.

String

C

1234

The Type of the Record; always to contain “SY06.02”

Fixed string

M

SY06.02

The Identifier (specific to the Message) of the Summary Record.

This Identifier shall be used by Usage/Revenue/Sales Records to indicate to which Summary Record they provide details.

String

M

7

The Party that generated the sales/usages reported in this Sales/Usage Report.

DistributionChannel 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

The DDEX Party ID of the DistributionChannel

DistributionChannelDPID is mandatory when available to the MessageSender. This field is important for MessageRecipients for their processing and would ideally be mandatory in this Standard. However, as there are rare cases where licensees genuinely do not have this information, DDEX has decided to mark these Cells as “Conditional”.

DPID

C

DPIDA12345SDF

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

PayAsYouGoModel

The nature of a Service as used by a Consumer. This also allows the communication of Device Usages (that is, which type of device a consumer was using to access the Release/Resource) by using the appropriate use type “UseAsDevice”.

UseType must be provided when there is no UseType on the relevant detailed Record(s).

AVS

C

PermanentDownload

The Territory for which the Sale/Usage is reported.

AVS

M

DE

The service name (e.g. a service tier) under which the SalesTransaction took place. The ServiceDescription may not contain space characters or underscores.

String

M

Purchase

The number of Usages of the Release or Resource provided to Consumers, including any sales adjustments. Sales adjustments include e.g. file failures.

Integer

M

123554

The number of subscribers to a Service.

Subscribers shall only be provided when the service is based on subscriptions.

Decimal

C

123445

The Currency in which the NetRevenue and IndirectValue are provided (represented by an ISO 4217 CurrencyCode).

AVS

M

CAD

Total number of Releases reported in the Message

Integer

O

64

The revenue generated by the DSP for the distribution of Releases or Resources, regardless of the Commercial Model or Use Type used, based on the bilateral agreement between Licensee and Licensor.

Decimal

O

223345.12

The revenue generated by the DSP that cannot directly be allocated to individual Releases or Resources, regardless of the Commercial Model or Use Type used, based on the bilateral agreement between Licensee and Licensor.

IndirectValue shall only be provided when indirect revenues were generated.

Decimal

C

13424.50

Flag of whether the service offers previews.

Note, this is independent from whether any previews were accessed by Consumers.

Boolean

O

true

Currency used for consumer-based financial information (represented by an ISO 4217 CurrencyCode).

AVS

O

EUR

The Exchange rate used to convert from the currency used for the transactions into the currency of reporting.

Decimal

O

1234

The total duration that the Release or Resource has been accessed by consumers.

ISO Duration

M

PT135H

The Type of the Record; always to contain “SY07.01”

Fixed String

M

SY07.01

The Identifier (specific to the Message) of the Summary Record. This Identifier shall be used by Usage/Revenue/Sales Records to indicate to which Summary Record they provide details.

String

M

44

The Party that generated the sales/usages reported in this Sales/Usage Report.

DistributionChannel 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

The DDEX Party ID of the DistributionChannel.

DistributionChannelDPID shall be provided when applicable in the relevant business relationship.

DPID

C

DPIDA12345SDF

The Type of CommercialModel of the SalesTransaction. The CommercialModel defines how a Consumer has paid for access to a Service or Release/Resource.

AVS

O

PayAsYouGoModel

The nature of a Service as used by a Consumer. This also allows the communication of Device Usages (that is, which type of device a consumer was using to access the Release/Resource) by using the appropriate use type “UseAsDevice”.

UseType shall be provided when applicable in the relevant business relationship.

AVS

C

Download

The Territory for which the Royalty is reported.

AVS

M

DE

The RightsType for which the Royalty is reported.

AVS

M

MechanicalRight

The service name (e.g. a service tier) under which the SalesTransaction took place. The ServiceDescription may not contain space characters or underscores.

String

O

PremiumService

The number of Usages of the Release or Resource provided to Consumers, including any sales adjustments. Sales adjustments include e.g. file failures.

Integer

M

1909

The number of Users with whom the Release or Resource were transacted.

Integer

O

323

The Currency in which the NetRevenue, AllocatedRevenue and AllocatedNetRevenue are provided (represented by an ISO 4217 CurrencyCode.

AVS

M

EUR

The revenue generated by the DSP for the distribution of Releases or Resources, regardless of the Commercial Model or Use Type used, based on the bilateral agreement between Licensee and Licensor.

Decimal

C

1009.21

Name of the RightsController that is believed by the MessageSender to control a RightShare of the Work

String

O

TestCompany

PartyId of the RightsController that is believed by the MessageSender to control a RightShare of the Work

PartyId

O

DPIDA12345SDF

The number of Usages allocated to the RightsController.

Multiple Decimals

O

123.2

The amount allocated to the MessageRecipient/RightsController for the usages reported.

This is sometimes called Amount Payable.

Decimal

M

234.12

Net Revenue generated that is to be allocated to the MessageRecipient/RightsController.

Decimal

M

12.99

Currency used for consumer-based financial information (represented by an ISO 4217 CurrencyCode).

AVS

O

EUR

The Exchange rate used to convert from the currency used for the transactions into the currency of reporting.

Decimal

O

1234 

The percentage of how much of the revenue or royalties should be allocated to the RightsType communicated in Cell 8.

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.

Cells 10 (TotalUsages), 11 (Users) and 13 (NetRevenue) shall be provided not pro-rated by the RightsTypePercentage, i.e. if a RightsType only attracts 25% of the royalties, 100% of these values shall be reported in the respective Cells.

Decimal

C

10.00

The Type of the Record; always to contain “SY09.01”

Fixed String

M

SY09.01

The Identifier (specific to the Message) of the Summary Record. This Identifier shall be used by Usage/Revenue/Sales Records to indicate to which Rights Controller they provide details.

String

M

123

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

AdvertisementSupportedModel

The nature of a Service, or a Release, as used by a Consumer.

UseType must be provided when there is no UseType on the relevant detailed Record(s).

AVS

C

Stream

The Territory for which the Sale/Usage is reported.

AVS

M

DE

The service name (e.g. a service tier) under which the SalesTransaction took place. The ServiceDescription may not contain space characters or underscores.

ServiceDescription shall be provided when essential to the commercial relationship being reported on.

String

C

PremiumService

This Cell is not to be used.

Name of the RightsController that is believed by the MessageSender to control a RightShare of the Work

String

O

SACEM

PartyId of the RightsController that is believed by the MessageSender to control a RightShare of the Work

PartyID

O

ISNI::0000000081266409

The right utilised as a result of the way in which the Consumer accessed the Resource.

A RightsType shall be provided when it applies to the accessed Resource.

AVS

C

MechanicalRight

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.

TotalUsages shall be provided when essential to the commercial relationship being reported on.

TotalUsages shall be provided not pro-rated by the RightsTypePercentage, i.e. if a RightsType only attracts 25% of the royalties, 100% of this value shall be reported in that Cell.

Decimal

C

1066.45

The number of Usages allocated to the RightsController.

Decimal

O

135.23

The revenue generated by the DSP for the distribution of Releases or Resources, regardless of the Commercial Model or Use Type used, based on the bilateral agreement between Licensee and Licensor.

Decimal

M

1220.06

The revenue generated by the DSP that cannot directly be allocated to individual Releases or Resources, regardless of the Commercial Model or Use Type used, based on the bilateral agreement between Licensee and Licensor.

IndirectValue shall only be provided when indirect revenues were generated.

Decimal

C

120.81

The ratio in percent between TotalUsages and AllocatedUsages

Decimal

O

10.54

The Currency in which the NetRevenue and IndirectValue are provided (represented by an ISO 4217 CurrencyCode).

AVS

M

CZK

The currency in which the Licensee generated the revenue. Currency used for consumer-based financial information (represented by an ISO 4217 CurrencyCode).

AVS

O

EUR

The Exchange rate used to convert from the currency used for the transactions into the currency of reporting.

Decimal

O

1234

The percentage of how much of the revenue or royalties should be allocated to the RightsType communicated in Cell 18.

The RightsTypePercentage may only be provided if a RightsType is provided. For the avoidance of doubt, it is permissable to communicate a RightsType without a RightsTypePercentage.

Decimal

C

10.00

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]].

SubPeriodStartDate shall only be provided when they differ from the UsageStartDate and UsageEndDate in the message header Record. SubPeriodStartDate and SubPeriodEndDate shall always be provided together.

The SubPeriodStartDate must not be earlier than the UsageEndDate provided in the relevant header record.

Date

C

2014-12-01

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]].

SubPeriodEndDate shall only be provided when they differ from the UsageStartDate and UsageEndDate in the message header Record. SubPeriodStartDate and SubPeriodEndDate shall always be provided together.

The SubPeriodEndDate must not be later than than the UsageEndDate provided in the relevant header record and must not be earlier than the SubPeriodStartDate

Date

C

2014-12-01

The Identifier (specific to the Message) of the Summary Record that this Summary Record provides details for.

ParentSummaryRecordId shall only be provided if Summary records are used to provide summary information in a hierarchical manner.

String

C

1234

The Type of the Record, always to contain “SY10.01”

Fixed String

M

SY10.01

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

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

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

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

The nature of a Service as used by a Consumer. This also allows the communication of Device Usages (that is, which type of device a consumer was using to access the Release/Resource) by using the appropriate use type “UseAsDevice”.

UseType must be provided when there is no UseType on the relevant detailed Record(s).

AVS

C

PermanentDownload

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

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

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

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

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

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

The Territory for which the Sale/Usage is reported.

AVS

M

US

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 

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 

Information on the quality of the Resources/Releases involved in the consumer transaction.

String

O

UpgradeToHiResMusic

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

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

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

Percentage of music usage on a service.

Decimal

M

66.66

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

The Currency in which the SalesTransactions are accounted (represented by an ISO 4217 CurrencyCode).

AVS

M

EUR

The rate used to convert from the CurrencyOfTransaction to the CurrencyOfAccounting

Decimal

M

1. 009

The source of the ExchangeRate.

String

C

http://currencyexchange.net

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

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

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

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

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

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

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

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

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

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

The amount allocated to the MessageRecipient/RightsController for the Usages reported in the CurrencyOfTransaction.

Decimal

M

76153.65

The amount allocated to the MessageRecipient/RightsController for the Usages reported in the CurrencyOfAccounting.

Decimal

M

76153.65

Net Revenue generated that is to be allocated to the MessageRecipient/RightsController in the CurrencyOfTransaction.

Decimal

M

153.65

Net Revenue generated that is to be allocated to the MessageRecipient/RightsController in the CurrencyOfAccounting.

Decimal

M

153.65

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

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

Price for one subscription generated by the DSP in the CurrencyOfAccounting.

Decimal

M

7.35

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

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

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

The total amount of all allocated amounts in the CurrencyOfTransaction, including the UsageIndependentFeeInCurrencyOfTransaction, reported in this Record.

Decimal

M

555.654

The total amount of all allocated amounts in the CurrencyOfAccounting, including the UsageIndependentFeeInCurrencyOfAccounting, reported in this Record.

Decimal

M

555.654

The Type of the Record; always to contain “SY11.01”.

Fixed string

M

SY11.01

The Identifier (specific to the Message) of the Summary Record. This Identifier shall be used by Usage/Revenu e/Sales Records to indicate to which Summary Record they provide details. 

String

M

34

The Party that generated the sales/usages reported in this Sales/Usage Report.

DistributionChannel 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

The DDEX Party ID of the DistributionChannel.

DistributionChannelDPID shall be provided when essential to the commercial relationship being reported on.

DPID

C

DPIDA12345SDF

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

PayAsYouGoModel

The nature of a Service as used by a Consumer. This also allows the communication of Device Usages (that is, which type of device a consumer was using to access the Release/Resource) by using the appropriate use type “UseAsDevice”.

UseType must be provided when there is no UseType on the relevant detailed Record(s).

AVS

C

PermanentDownload

The Territory for which the prospective Sale/Usage is reported.

AVS

M

DE

The service name (e.g. a service tier) under which the SalesTransaction took place. The ServiceDescription may not contain space characters or underscores.

ServiceDescription shall be provided when essential to the commercial relationship being reported on.

String

C

PremiumService

The sum of the number of the UsageForPrioritisaiton in reference ML01 Records.

UsageForPrioritisaiton has to be provided if such information is available, based on bilateral agreements. This information is intended to aid the Message Recipient to prioritise handling the information provided in the report.

Integer

C

400

The Type of the Record; always to contain “RE01.02”

Fixed string

M

RE01.02

The Identifier (specific to the Message) of the Block that this Record belongs to. All Records in a single Block shall have the same BlockId

String

M

7

The Identifier (specific to the Block) of the Record, that allows other Records to reference this Record. Within a Block, the ReleaseReference shall be unique across all Release Records. In the interest of keeping sales/usage reports as compact as possible, the ReleaseReference should typically be a short string, e.g. "1", "2", ...

String

M

15

The ProprietaryIdentifier of the Release assigned by the MessageSender

String

M

12345678

The ProprietaryIdentifier of the Release preceded by a namespace identifier in the syntax ns::id

Multiple String::String

O

myns::4534|ns2::4345

The catalogue number of the Release assigned by the issuing record company

String

O

123456

The ICPN used as proxy for identification of the Release. An ICPN comprises 12 or 13 digits, depending on whether it is an EAN (13) or a UPC (12). 14 character ICPNs are also permitted.

ReleaseICPN is mandatory when available to the MessageSender. This field is important for MessageRecipients for their processing and would ideally be mandatory in this Standard. However, as there are rare cases where licensees genuinely do not have this information, DDEX has decided to mark these Cells as “Conditional”.

String

C

12345678904321

The Name to be used by a DSP when presenting Artist details of the Release to a Consumer.

ReleaseDisplayArtistName shall be provided if available.

String

C

The Beatles

The PartyId of the  DisplayArtist

PartyID

O

ISNI::0000000081266409

The ReferenceTitle of the Release

String

M

Beatles for Sale

A Descriptor which is supplementary to, but not contained within, a ReleaseTitle

String

O

Live Version

The form in which a ReleaseCreator anticipates offering the Release to Consumers.

AVS

O

Album

The Name of the Label for the Release.

String

O

Apple Records

The PLine for the Release

String

O

℗1970 Apple Records

The Name of the company that provided the Release information to the MessageSender.

If the Licensee generated the data provided in this record, the DataProviderName shall contain the Name of the Licensee.

String

O

UMG

The date when the Release was first made available, whether for physical or electronic/online distribution.

ISO Date

O

1969-08-26

The Type of the Record; always to contain “RE02”.

Fixed string

M

RE02

The Identifier (specific to the Message) of the Block that this Record belongs to. All Records in a single Block shall have the same BlockId

String

M

7

The Identifier (specific to the Block) of the Record, that allows other Records to reference this Record. Within a Block, the ReleaseReference shall be unique across all Release Records. In the interest of keeping sales/usage reports as compact as possible, the ReleaseReference should typically be a short string, e.g. "1", "2", ...

String

M

15

The ProprietaryIdentifier of the Sub-Release assigned by the MessageSender. This ProprietaryIdentifier should be a globally unique identifier for the Sub-Release and not the globally unique identifier for the Head Releases that this Sub-Release has been taken from.

String

M

12345678

The ProprietaryIdentifier of the Sub-Release preceded by a namespace identifier in the syntax ns::i. This ProprietaryIdentifier should be a globally unique identifier for the Sub-Release and not the globally unique identifier for the Head Releases that this Sub-Release has been taken from.

Multiple String::String

O

myns::4534|ns2::4345

List of ResourceReferences of the Resources (reported in the same Block) that make up the Sub-Release

Multiple String