A Glossary of the Fields Available in Income Templates
This is a list of all of the fields available in your income ingestion templates. The fields in this list will ingest your income data to map income to your catalog, normalize the metadata to the values in your General Settings, and ingest the necessary figures for royalty calculation.
The values that are necessary for income validation are marked with an asterisk (*). If any fields are not present in your income files, they can be supplemented with Default Values, Copy Fields, Calculations, and Target Cells settings.
An Identifier, ISWC, Tunecode, Song Code, or Contract Identifier is required for each income line to be allocated to a contract. Contract Identifier should only be used when you need to allocate income directly to a contract. Income cannot be allocated to contracts via the Participation Rates on Tracks and Releases.
Barcode - If the income is associated with a recording, this is the UPC or EAN associated with the Release to which the income is attributed. If this value does not already exist on a release in your catalog, this value will be added as an alias to a Release as part of the mapping process. Income cannot be distributed to contracts through the participation rates on Releases in our publishing platform.
Cat No - If the income is associated with a recording, this is the Catalog Number associated with the Release to which the income is attributed. If this value does not already exist on a release in your catalog, this value will be added as an alias to a Release as part of the mapping process. Income cannot be distributed to contracts through the participation rates on Releases in our publishing platform.
Channel* - The general category of income, e.g., Performance, Mechanical, Sync, etc.
Composers - The composers of the Work to which the income is attributed.
Configuration* - The specific format of the income, e.g., Download, CD, Radio, Television, etc.
Contract Identifier - An identifier used to map income directly to a specific contract at 100% participation. Please only use this field if you wish to map income directly to a contract. If you do not have this intention, then please do not use the Contract identifier field in your Template.
Date From - The beginning date of performance or broadcast.
Date To - The ending date of the performance or broadcast.
Description - Additional information describing the sale.
Duration - The duration of the performance or broadcast.
Episode - The title of the Episode in which the work was performed or broadcast.
Exchange Rate - The exchange rate used to convert from the Original Currency of the income to your Home Currency. Exchange Rates can be entered via the Mapping Manager or updated in bulk using the Bulk Update feature.
Gross Amount - The amount of income received by the source.
ISRC - If the income is associated with a recording, this identifier will attribute the income to a specific Track in your catalog. If this value does not exist on a track in your catalog, it will be added as an alias to a Track as part of the mapping process. Income cannot be distributed to contracts through the participation rates on Tracks in our publishing platform.
ISWC - The International Standard Work Code associated with the Work. This value can be used to map income to a Work in your catalog, and if it does not already exist in your catalog, it will be created as a Society Identifier on the Work to which it is attributed during the mapping process.
Identifier - The Identifier used by the source to associate income with a Work. This value can be used to map income to a Work in your catalog, and if it does not already exist in your catalog, it will be created as a Society Identifier on the Work to which it is attributed during the mapping process.
Ignore - A header used to indicate columns that can be ignored. It can be used multiple times, and will not affect the sales ingestion process.
Net Amount* - The payment amount you have received from the source.
Original Currency* - The currency of the Net Amount in this file. This currency will be converted to your Home Currency with the Exchange Rate.
Party 1, 2, 3... - These fields can be used to ingest multiple Publisher or Composer names associated with the Work to which the income is attributed. These fields are referenced on the Unmapped page and should be used to assist in mapping Society Identifiers.
Positive/Negative - Some statement formats will indicate whether an amount is a credit or debit using a specific indicator. This field can be used to map those indicators and correctly convert the amount to positive or negative.
Production - The Production associated with the broadcast or performance.
Release Artist - The artist associated with the Release the income is attributed to.
Release Title - The title of the Release to which the income is attributed.
Sale Date* - The date the sale or performance took place.
Share Percentage - The share of income associated with the work paid to you by the Source.
Song Code - This value can be used to map income to a Work in your catalog. It will not be created as a Society Identifier if mapped to a work; instead, Curve will concatenate the Work Title and Party fields to create a unique mappable value and assign it as a Society Identifier.
Source* - The Source of the sale. If using Source-specific sales terms or Specific Participation Rates in your contracts, this value will be referenced to determine the royalty rate or participation rate. This value should be normalized to the values in your General Settings.
Sub Source - The proximate Source of the sale.
Temp 1, 2, 3... - Temporary values can be used as intermediary variables in the calculations on your template. These values are not stored in your sales data.
Territory* - The Territory in which the income originated.
Track Artist - The Artist associated with the Track to which the income is attributed.
Track Title - The title of the Track to which the income is attributed.
Transaction Date* - The day the income in this file was received by your publisher. Transaction Date is useful for tracking cashflow for your business.
Tunecode - This value can be used to map income to a Work in your catalog, and if it does not already exist in your catalog, it will be created as a Society Identifier on the Work to which it is attributed during the mapping process.
Units - The number of streams, downloads, or performances.
Work Title - The title of the Work to which the income is attributed.