Cell Name | Field Definition | Data Type | M/O/C | Example |
---|
1 | RecordType
| The type of the Record which shall always to contain the value RD02.01 . | Fixed String | M | RD02.01
|
2 | AudioVisualResourceRevenueDetails RecordId
| The identifier of this audio-visual resource revenue details Record which shall be specific to the RevenueReport message. | String | M | LK13MC
|
3 | AllocatedPartySummaryRecordId
| The identifier of the allocated party summary Record to which this Record provides detail. | String | M | A13HG65
|
4 | AudioVisualType
| The type of audio-visual resource to which is determined by the nature of the content of the audio-visual resource. | AVS: AudioVisualType | M | Documentary
|
5 | RevenueAllocationType
| The functional nature of the audio-visual resource to which revenue has been allocated. | AVS: RevenueAllocationType | M | Episode
|
6 | ISAN
| An identifier of the audio-visual resource allocated in accordance with the International Standard Audio-visual Number as defined in ISO 15706. | String | O | 0000-0001-8947-0000-8-0000-0000-D
|
7 | EIDR
| An identifier of the audio-visual resource allocated in accordance with the Entertainment Identifier Registry. | String | O | 10.5240/F85A-E100-B068-5B8F-B1C8-T
|
8 | ProprietaryResourceId
| A proprietary identifier allocated by the music licensing company that is the sender of the message to the audio-visual resource to which the relevant revenue has been allocated. This is preceded by a namespace identifier in the syntax ns::id. Provision of a ProprietaryResourceId is mandatory if there is no ISAN or EIDR provided. | Multiple String::String | C | yourns::2343|myns::4534
|
9 | ResourceTitle
| The title of the resource to which the relevant revenue has been allocated. | String | M | Starring the Saint
|
10 | SeriesTitle
| The title of the series of which the audio-visual resource is a part. | String | O | The Saint
|
11 | SeasonNumber
| The number of the season of the series of which the audio-visual resource is a part. | Integer | O | 2
|
12 | EpisodeNumber
| The number indicating the order of the episodes within a season (if available) or series. | Integer | O | 2
|
13 | Genre
| The genre of the work. | String | O | Crime
|
14 | AudioVisualContributorName
| The name of a contributor to the audio-visual resource. This information is purely for the purpose of helping to identify the resource to which revenue has been allocated. This Cell does not specifying the party to whom revenue has been allocated for a contribution to the resource. The order of the individual data elements in AudioVisualContributorName and AudioVisualContributorRole Cells shall be the same so that the recipient is able to relate them correctly. | Multiple String | O | Roger Moore
|
15 | AudioVisualContributorRole
| The description of the roles(s) of the party (as communicated in the RS02.01 Record). The order of the individual data elements in the AudioVisualContributorName and AudioVisualContributorRole Cells shall be the same so that the recipient is able to relate them correctly. A value in this Cell is mandatory if an AudioVisualContributorName is provided. | Multiple AVS: ContributorRole | C | Actor
|
16 | AllocatedPartyContributionRole
| The description of the role(s) of the party (as communicated in the RS02.01 Record) to whom revenue has been allocated for a contribution to the resource. The order of the individual data elements in the AllocatedPartyContributionRole and AllocatedPartyContributionSharePercentage Cells shall be the same so that the recipient is able to relate them correctly. | Multiple AVS: ContributorRole | O | Actor|Director
|
17 | AllocatedParty Contribution SharePercentage
| The percentage of gross revenue allocated to the party (as communicated in the RS02.01 Record) in relation to the AllocatedPartyContributionRole for the resource with respect to the SummaryType (as communicated in the RS01.01 Record). A quarter share is represented by 25 (and not 0.25). The order of the individual data elements in AllocatedPartyContributionRole and AllocatedPartyContributionSharePercentage Cells shall be the same so that the recipient is able to relate them correctly. Values provided in this Cell shall be the sum of values in the AllocationSharePercentage Cell. | Multiple Decimal | O | 5.5|10
|
18 | AudioVisualProductionDate
| The date when the audio-visual resource was produced, in the ISO 8601 format: YYYY[-MM[-DD]]. | Date | O | 2014-12-31
|
19 | AudioVisualCreationDate
| The date when the audio-visual resource was created, in the ISO 8601 format: YYYY[-MM[-DD]]. | Date | O | 2014-12-31
|
20 | TerritoryOfRevenueGeneration
| The territory in which the revenue was generated. | AVS: AllTerritoryCode | M | DE
|
21 | UseType
| A type of usage that a licensee of the relevant music licensing company has made of the resource and for which the revenue has been generated. | Multiple AVS: UseType | O | Broadcast|Stream
|
22 | LicenseeName
| The name of the licensee of the relevant music licensing company whose output has generated the revenue. | String | O | BBC
|
23 | LicenseeId
| The PartyId of the licensee the relevant music licensing company. | PartyID | O | ISNI::0000000081266409
|
24 | UsageSourceName
| The name of the source of usage reporting that has been used to allocate revenue to the resource. | String | O | BBCOne
|
25 | UsageSourceId
| The PartyId of the UsageSource . | PartyID | O | ISNI::0000000081266409
|
26 | UsageStartDate
| The date of the start of the usage period to which the revenue which is the subject of the Record relates, in ISO 8601 format. This is a string with the syntax YYYY[-MM[-DD]]. | Date | M | 2014-12-31
|
27 | UsageEndDate
| The date of the end of the usage period to which the revenue which is the subject of the Record relates, in ISO 8601 format. This is a string with the syntax YYYY[-MM[-DD]]. | Date | M | 2014-12-31
|
28 | RecipientRevenueType
| A description of the type of revenue that indicates on behalf of whom the revenue was collected. | AVS: RecipientRevenueType | M | PerformerOnlyRevenue
|
29 | RevenueSourceType
| A type of revenue earned by the resource, according to the way the revenue is generated. | AVS: RevenueSourceType | M | PaymentFrom
UnclaimedRevenue
|
30 | RevenuePoolName
| A description of the type of licensee, whether a single licensee or multiple licensees, which forms the source of the revenue being allocated. | String | O | Small Webcasters
|
31 | BasisForRevenueAllocation
| A description of the nature of the data used to determine the distribution of revenue, for example a usage log or a full census. | AVS: BasisForRevenueAllocation | O | FullCensus
|
32 | UnitTypeForRevenueAllocation
| The basis applied to each unit of usage as part of the process of revenue allocation which is the subject of this Record. It is possible to have mixed types within a RevenueReport message. | AVS: UnitTypeForRevenueAllocation | O | Seconds
|
33 | UnitRate
| The rate applied to each unit of usage in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). | Decimal | O | 0.0905
|
34 | Usages
| The number of units of usage of the resource. | Decimal | O | 321.5
|
35 | AllocationSharePercentage
| The percentage of gross revenue allocated to the party (as communicated in the RS02.01 Record) in relation the resource with respect to the SummaryType (in the RS01.01 Record). The percentage relates to a record company's ownership share. A quarter share is represented by 25 (and not 0.25). This Cell is the sum of all AllocatedPartyContributionSharePercentages (if provided). This Cell is mandatory when the SummaryType is RightsController ). | Decimal | C | 33.33
|
36 | ReallocationFromNonQualifyingPerformance
| Revenue allocated to a performance which does not qualify for equitable remuneration and is re-allocated to the rights controller. | Decimal | O | 1.24
|
37 | CollectingMlcGrossAmount
| The gross amount of revenue collected by the collecting music licensing company's in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). This amount is the aggregate of all collecting music licensing company amounts in the relevant revenue details Records. | Decimal | O | 1152.24
|
38 | PayingMlcGrossAmount
| The gross amount of revenue being paid by the paying music licensing company's gross amount in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). This amount is the aggregate of all paying music licensing company amounts in the relevant revenue details Records. | Decimal | M | 1152.24
|
39 | CollectingMlcCommission
| The collecting music licensing company's amount of commission or administrative fee(s) in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). This amount is deducted from the CollectingMlcGrossAmount and is therefore a negative number. An adjustment to commission or administrative fee(s), which will be added to the CollectingMlcGrossAmount , can be expressed by using a positive number. | Decimal | O | -52.24
|
40 | PayingMlcCommission
| The paying music licensing company's amount of commission or administrative(s) fee in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). This amount is deducted from the PayingMlcGrossAmount and is therefore a negative number. An adjustment to commission or administrative fee(s), which will be added to the PayingMlcGrossAmount , can be expressed by using a positive number. | Decimal | O | -52.24
|
41 | CollectingMlcSocialCulturalDeduction
| The collecting music licensing company's social and cultural deduction amount in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). This amount is deducted from the CollectingMlcGrossAmount and is therefore a negative number. An adjustment to social and cultural deduction(s) to the CollectingMlcGrossAmount can be expressed by using a positive number. | Decimal | O | -4.16
|
42 | PayingMlcSocialCulturalDeduction
| The paying music licensing company's social and cultural deduction amount in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). This amount is deducted from the PayingMlcGrossAmount and is therefore a negative number. An adjustment to the social and cultural deduction(s) to the PayingMlcGrossAmount can be expressed by using a positive number. | Decimal | O | -4.16
|
43 | CollectingMlcAdministrationCostDeduction
| The collecting music licensing company's deduction for administration costs in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). This amount is deducted from the CollectingMlcGrossAmount and is therefore a negative number. An adjustment of the administrative costs to the CollectingMlcGrossAmount can be expressed by using a positive number. | Decimal | O | -2.16
|
44 | PayingMlcAdministrationCostDeduction
| The paying music licensing company's deduction for administration costs in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). This amount is deducted from the PayingMlcGrossAmount and is therefore a negative number. An adjustment to the administrative costs to the PayingMlcGrossAmount can be expressed by using a positive number. | Decimal | O | -2.16
|
45 | CollectingMlcOtherDeduction
| The collecting music licensing company's other deduction amounts in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). If several values are specified, the types of such values need to be provided in CollectingMlcOtherDeductionType Cell. The order of the individual data elements in CollectingMlcOtherDeduction and CollectingMlcOtherDeductionType Cells shall be the same so that the recipient is able to relate them correctly. These amounts are deducted from the CollectingMlcGrossAmount and are therefore negative numbers. An adjustment of the other deductions to the CollectingMlcGrossAmount can be expressed by using a positive number. | Multiple Decimal | O | -52.24|-72.66
|
46 | CollectingMlcOtherDeductionType
| The type of deductions specified in the CollectingMlcOtherDeduction Cell. This only needs to be provided if several values are given in CollectingMlcOtherDeduction Cell. The order of the individual data elements in CollectingMlcOtherDeduction and CollectingMlcOtherDeductionType Cells shall be the same so that the recipient is able to relate them correctly. A value in this Cell is mandatory if there is a value in the CollectingMlcOtherDeduction Cell. | Multiple String | C | TradeUnion|Culture
|
47 | PayingMlcOtherDeduction
| The paying music licensing company's other deduction amounts in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). If several values are specified, the types of such values need to be provided in PayingMlcOtherDeductionType Cell. The order of the individual data elements in PayingMlcOtherDeduction and PayingMlcOtherDeductionType Cells shall be the same so that the recipient is able to relate them correctly. These amounts are deducted from the PayingMlcGrossAmount and are therefore negative numbers. An adjustment of the other deductions to the PayingMlcGrossAmount can be expressed by using a positive number. | Multiple Decimal | O | -52.24|-72.66
|
48 | PayingMlcOtherDeductionType
| The type of deductions specified in the PayingMlcOtherDeduction Cell. This only needs to be provided if several values are given in the PayingMlcOtherDeduction Cell. The order of the individual data elements in PayingMlcOtherDeduction and PayingMlcOtherDeductionType Cells shall be the same so that the recipient is able to relate them correctly. A value in this Cell is mandatory if there is a value in the PayingMlcOtherDeductionType Cell. | Multiple String | C | TradeUnion|Culture
|
49 | CollectingMlcInterest
| The collecting music licensing company's interest amount in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). This amount is added to the CollectingMlcGrossAmount and is therefore a positive number. An adjustment, of the interest to the CollectingMlcGrossAmount can be expressed by using a negative number. | Decimal | O | 52.24
|
50 | PayingMlcInterest
| The paying music licensing company's interest amount in the CurrencyOfAccounting (as communicated in the relevant RS01.01Record). This amount is added to the PayingMlcGrossAmount and is therefore a positive number. An adjustment of the interest to the PayingMlcGrossAmount can be expressed by using a negative number. | Decimal | O | 52.24
|
51 | CollectingMlcWithholdingTax
| The collecting music licensing company's withholding tax amount for the total withholding tax in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). If there is one value in this Cell no value is given in the CollectingMlcWithholdingTaxType Cell. If there are one or more specific withholding taxes values in this Cell there must be one or more values CollectingMlcWithholdingTaxType Cell. If several values are specified in this Cell, it is mandatory to provide values in CollectingMlcWithholdingTaxType Cell. The order of the individual values in CollectingMlcWithholdingTax and CollectingMlcWithholdingTaxType shall be the same so that the recipient is able to relate them correctly. This amount is deducted from the CollectingMlcGrossAmount and is therefore a negative number. An adjustment of the withholding tax to the CollectingMlcGrossAmount can be expressed by using a positive number. | Multiple Decimal | O | -52.24|-42.5
|
52 | CollectingMlcWithholdingTaxType
| The type of withholding tax specified in the CollectingMlcWithholdingTax Cell. Values in this Cell only need to be provided if several values are given in CollectingMlcWithholdingTax Cell. If there is a single value in the CollectingMlcWithholdingTax Cell, no value shall be provided in the CollectingMlcWithholdingTaxType . The order of the individual values in the CollectingMlcWithholdingTax and CollectingMlcWithholdingTaxType Cells shall be the same so that the recipient is able to relate them correctly. | Multiple String | O | Interest|Royalty
|
53 | PayingMlcWithholdingTax
| The paying music licensing company's withholding tax amount for the total withholding tax in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). If there is one value in this Cell no value is given in the PayingMlcWithholdingTaxType Cell. If there are one or more specific withholding taxes values in this Cell there must be one or more values PayingMlcWithholdingTaxType Cell. If several values are specified in this Cell, it is mandatory to provide values in the PayingMlcWithholdingTaxType Cell and the order of the individual data elements in PayingMlcWithholdingTax and PayingMlcWithholdingTaxType Cells shall be the same so that the recipient is able to relate them correctly. This amount is deducted from the PayingMlcGrossAmount and is therefore a negative number. An adjustment of withholding tax to the PayingMlcGrossAmount amount, can be expressed by using a positive number. | Multiple Decimal | O | -42.5|-52.24
|
54 | PayingMlcWithholdingTaxType
| The type of withholding tax specified in the PayingMlcWithholdingTax Cell. This only needs to be provided if several values are given in PayingMlcWithholdingTax Cell. If there is a single value in the PayingMlcWithholdingTax Cell, no value shall be provided in the PayingMlcWithholdingTaxType . The order of the individual values in PayingMlcWithholdingTax and PayingMlcWithholdingTaxType Cells shall be the same so that the recipient is able to relate them correctly. | Multiple String | O | Interest|Royalty
|
55 | CollectingMlcVAT
| The VAT amount of the collecting music licensing company in the CurrencyOfAccounting (as communicated in the relevant RS01.01 Record). This amount is added to the CollectingMlcGrossAmount amount and is therefore a positive number. An adjustment of the VAT to the CollectingMlcGrossAmount can be expressed by using a negative number. | Decimal | O | 13.5
|
56 | PayingMlcVAT
| The VAT amount of the paying music licensing company in the CurrencyOfAccounting (communicated in the relevant RS01.01 Record). This amount is added to the PayingMlcGrossAmount and is therefore a positive number. An adjustment of the VAT to the PayingMlcGrossAmount amount, can be expressed by using a negative number. | Decimal | O | 13.5
|
57 | NetAmount
| The final amount of revenue due following all deductions and/or additions to the relevant music licensing company’s gross amount in the CurrencyOfAccounting (communicated in the relevant RS01.01 Record). | Decimal | O | 1152.24
|
58 | Comment
| A free-text description relating to the data in this RS02.01 Record. This Cell should not be populated with data that should be provided in an existing Cell of the Record. | String | O | |