Cell Name | Field Definition | Data Type | M/O/C | Example |
---|
1 | RecordType
| The Type of the Record; always to contain RD02 . | Fixed String | M | RD02 |
2 | AudioVisualResourceRevenueDetailsRecordId
| The Identifier (specific to the message) of this Audio-visual Resource Revenue Details Record. | String | M | LK13MC |
3 | AllocatedPartySummaryRecordId
| The AllocatedPartySummaryRecordId of the Allocated Party Summary Record that this detailed record provides details to. | String | M | A13HG65 |
4 | AudioVisualType
| The type of the Resource with respect to its content. | AVS | M | Documentary |
5 | RevenueAllocationType
| The type of Entity for which revenue has been allocated. | AVS | M | Episode |
6 | ISAN
| The ISAN (International Standard Audiovisual Number as defined in ISO 15706) for the Resource. | String | O | 0000-0001-8947-0000-8-0000-0000-D |
7 | EIDR
| An Identifier of the Video assigned by the Entertainment Identifier Registry Association (EIDR). | String | O | 10.5240/F85A-E100-B068-5B8F-B1C8-T |
8 | ProprietaryResourceId
| The ProprietaryIdentifier of the Resource preceded by a namespace identifier in the syntax ns::id . This should be specified if no ISAN and no EIDR is given. | String::String | C | myns::4534 |
9 | ResourceTitle
| The ReferenceTitle of the Resource. | String | M | Starring the Saint |
10 | SeriesTitle
| The Title of a Series in which the Resource is included. | String | O | The Saint |
11 | SeasonNumber
| The number of a Season in which the Resource is included. | 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 Resource. | String | O | Crime |
14 | ContributorName
| The Name of a Contributor of the Resource. This information is purely for the purpose of helping to identify the Resource to which revenue was allocated, and is not specifying the party to whom revenue has been allocated for a contribution to the Resource. The order of the individual data elements in ContributorName and ContributorRole shall be the same so that the recipient is able to relate them correctly. | Multiple String | O | Roger Moore
|
15 | ContributorRole
| The Role of the Contributor. The order of the individual data elements in ContributorName and ContributorRole shall be the same so that the recipient is able to relate them correctly. | Multiple AVS | C | Actor |
16 | AllocatedPartyContributionRole
| The Role for which revenue was allocated to the party for a contribution to the Resource, using the ContributorRole allowed value set defined in Clause 8.4. The order of the individual data elements in AllocatedPartyContributionRole and AllocatedPartyContributionSharePercentage shall be the same so that the recipient is able to relate them correctly. | Multiple AVS | O | Actor|Director |
17 | AllocatedPartyContributionSharePercentage
| The percentage of gross revenue allocated to the Resource with respect to the SummaryType (in the RS01 Record) which is allocated to the AllocatedParty in relation to the AllocatedPartyContributionRole . A quarter share is represented by “25” (and not 0.25). The order of the individual data elements in AllocatedPartyContributionRole and AllocatedPartyContributionSharePercentage shall be the same so that the recipient is able to relate them correctly. Data elements in this cell shall sum up to the AllocationSharePercentage . | Multiple Decimal | O | 5.5|10[1] The example in this and cell 16 is for an AllocatedParty who gets 5.5% for acting and 10% for directing. The AllocatedParty , whose name is given in the Record Type RS02 , does not need to be credited for being an actor or a director in cells 14 and 15. |
18 | ProductionDate
| The date when the audio-visual resource was produced, in the ISO 8601 format: YYYY[-MM[-DD]]. | ISO Date | O | 1963 |
19 | CreationDate
| The date when the audio-visual resource was created, in the ISO 8601 format: YYYY[-MM[-DD]]. | ISO Date | O | 1963 |
20 | TerritoryOfRevenueGeneration
| The Territory in which the revenue was generated. | AVS | M | DE |
21 | UseType
| A type of usage that a Licensee has made of the Resource and for which the revenue was generated. | AVS | O | Broadcast |
22 | LicenseeName
| The Name of the company whose licensed output has generated the revenue. | String | O | BBC |
23 | LicenseeId
| The PartyId of the Licensee. | 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 StartDate of the usage Period covered by the Record (in ISO 8601 format). This is a string with the syntax YYYY[-MM[-DD]]. | ISO Date | M | 2014-12-01 |
27 | UsageEndDate
| The EndDate of the usage Period covered by the Record (in ISO 8601 format). This is a string with the syntax YYYY[-MM[-DD]]. | ISO Date | M | 2014-12-01 |
28 | RevenuePoolName
| The name of a collection of revenues (whether from a single licensee or multiple licensees) which is allocated. | String | O | Small Webcasters |
29 | BasisForRevenueAllocation
| The description of whether the distribution used a usage log, full census etc. | AVS | O | FullCensus |
30 | UnitTypeForRevenueAllocation
| The basis used for the current Record. It is possible to have mixed types within a report. | AVS | O | Seconds |
31 | UnitRate
| The rate applied to each Usage in the CurrencyOfAccounting (communicated in the relevant RS01 Record). | Decimal | O | 0.0905 |
32 | Usages
| The Number of units of usage of the Resource. | Decimal | O | 321.5 |
33 | AllocationSharePercentage
| Percentage of gross revenue allocated to the Resource with respect to the SummaryType (in the RS01 Record) which is allocated to the AllocatedParty (i.e. 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 conditionally mandatory for record companies (i.e. when the SummaryType is RightsController ). | Decimal | C | 33.33 |
34 | ReallocationFromNonQualifyingPerformance
| Revenue allocated to a performance which does not qualify for equitable remuneration and is re-allocated to the RightsController . | Decimal | O | 1.24 |
35 | CollectingMlcGrossAmount
| The Collecting Music Licensing Company's gross amount in the CurrencyOfAccounting (communicated in the relevant RS01 Record). | Decimal | O | 1152.24 |
36 | PayingMlcGrossAmount
| The Paying Music Licensing Company's gross amount in the CurrencyOfAccounting (communicated in the relevant RS01 Record). The sum of the gross amounts of all detailed records adds up to this. | Decimal | M | 1152.24 |
37 | CollectingMlcCommission
| The Collecting Music Licensing Company's commission amount or administrative fee in the CurrencyOfAccounting (communicated in the relevant RS01 Record). This amount is deducted from the gross amount and therefore a negative number. A refund, which will be added to the gross amount, can be expressed by using a positive number | Decimal | O | -52.24 |
38 | PayingMlcCommission
| The Paying Music Licensing Company's commission amount or administrative fee in the CurrencyOfAccounting (communicated in the relevant RS01 Record). This amount is deducted from the gross amount and therefore a negative number. A refund, which will be added to the gross amount, can be expressed by using a positive number. | Decimal | O | -52.24 |
39 | CollectingMlcOtherDeductions
| The Collecting Music Licensing Company's other deduction amounts in the CurrencyOfAccounting (communicated in the relevant RS01 Record). If several values are specified, the types need to be provided in CollectingMlcOtherDeductionTypes . The order of the individual data elements in CollectingMlcOtherDeductions and CollectingMlcOtherDeductionTypes shall be the same so that the recipient is able to relate them correctly. These amounts are deducted from the gross amount and therefore negative numbers. An addition to the gross amount can be expressed by using a positive number. | Multiple Decimals | O | -52.24|-72.66 |
40 | CollectingMlcOtherDeductionTypes
| The type of deductions specified in the CollectingMlcOtherDeductions . This only needs to be provided if several values are given in CollectingMlcOtherDeductions . The order of the individual data elements in CollectingMlcOtherDeductions and CollectingMlcOtherDeductionTypes shall be the same so that the recipient is able to relate them correctly. | Multiple String | O | TradeUnion|Culture |
41 | PayingMlcOtherDeductions
| The Paying Music Licensing Company's other deduction amounts in the CurrencyOfAccounting (communicated in the relevant RS01 Record). If several values are specified, the types need to be provided in PayingMlcOtherDeductionTypes . The order of the individual data elements in PayingMlcOtherDeductions and PayingMlcOtherDeductionTypes shall be the same so that the recipient is able to relate them correctly. These amounts are deducted from the gross amount and therefore negative numbers. An addition to the gross amount can be expressed by using a positive number. | Multiple Decimals | O | -52.24|-72.66 |
42 | PayingMlcOtherDeductionTypes
| The type of deductions specified in the PayingMlcOtherDeductions . This only needs to be provided if several values are given in PayingMlcOtherDeductions . The order of the individual data elements in PayingMlcOtherDeductions and PayingMlcOtherDeductionTypes shall be the same so that the recipient is able to relate them correctly. | Multiple String | O | TradeUnion|Culture |
43 | CollectingMlcInterest
| The Collecting Music Licensing Company's interest amount in the CurrencyOfAccounting (communicated in the relevant RS01 Record). This amount is added to the gross amount and therefore a positive number. A refund, which will be subtracted from the gross amount, can be expressed by using a negative number. | Decimal | O | 52.24 |
44 | PayingMlcInterest
| The Paying Music Licensing Company's interest amount in the CurrencyOfAccounting (communicated in the relevant RS01 Record). This amount is added to the gross amount and therefore a positive number. A refund, which will be subtracted from the gross amount, can be expressed by using a negative number. | Decimal | O | 52.24 |
45 | CollectingMlcWithholdingTax
| The Collecting Music Licensing Company's withholding tax amount in the CurrencyOfAccounting (communicated in the relevant RS01 Record). This amount is deducted from the gross amount and therefore a negative number. A refund, which will be added to the gross amount, can be expressed by using a positive number. | Decimal | O | -52.24 |
46 | PayingMlcWithholdingTax
| The Paying Music Licensing Company's withholding tax amount in the CurrencyOfAccounting (communicated in the relevant RS01 Record). This amount is deducted from the gross amount and therefore a negative number. A refund, which will be added to the gross amount, can be expressed by using a positive number. | Decimal | O | -52.24 |
47 | CollectingMlcVAT
| The VAT amount of the Collecting Music Licensing Company in the CurrencyOfAccounting (communicated in the relevant RS01 Record). This amount is added to the gross amount and therefore a positive number. A refund, which will be subtracted from the gross amount, can be expressed by using a negative number. | Decimal | O | 13.5 |
48 | PayingMlcVAT
| The VAT amount of the Paying Music Licensing Company in the CurrencyOfAccounting (communicated in the relevant RS01 Record). This amount is added to the gross amount and therefore a positive number. A refund, which will be subtracted from the gross amount, can be expressed by using a negative number. | Decimal | O | 13.5 |
49 | NetAmount
| The net amount in the CurrencyOfAccounting (communicated in the relevant RS01 Record). | Decimal | O | 1152.24 |