A Glossary of the Fields Available in Sales Templates

This is a list of all of the fields available in your sales ingestion templates. The fields in this list will ingest your sales data to map sales 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 sales validation are marked with an asterisk (*). If any fields are not present in your sales files, they can be supplemented with Default Values, Copy Fields, Calculations, Target Cells, and Catalogue Overwrite Sales settings.

Barcode* - The UPC or EAN associated with the Release to which the sale is attributed. This field will map your sales to the Releases in your catalog. 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.

Cat No* - The Catalog Number associated with the Release to which the sale is attributed. This field will map your sales to the Releases in your catalog. 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.

Configuration* - The specific format of the product associated with the sale i.e., Download, CD, Stream, etc. These will be mapped to the Configuration values in your General Settings.

Contract Identifier - An identifier used to map sales directly to a specific contract at 100% participation. You should only use this field if you wish to map sales directly to a contract. Please do not match this field to a column if you don't have the intention to map sales lines directly to your Contract.

Description - Additional information describing the sale.

Distribution Channel* - The general sales description of the sale type i.e, Digital, Physical, Sync, etc.

Exchange Rate - The exchange rate used to convert from the Original Currency of the sale to your Home Currency. Exchange rates can be applied via the mapping manager or updated in bulk using the Bulk Update feature.

Gross Amount - The amount received by the source at the point of sale.

ISRC* - The International Standard Recording Code. This field is used to map sales 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. If this field ingests a value that matches an existing Catalog Number or Barcode on a release in your catalog, the sale will be mapped to that release.

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 specified Exchange Rate.

Per Unit Rate - The amount received per unit of sale. This figure will be used to calculate royalties that use the Unit Price basis in your contracts' terms.

Price Category - The Price Category associated with the sale. These values will be normalized to the Price Category values in your General Settings as part of the mapping process.

Release Artist - The artist associated with the Release to which the sale is attributed.

Release Title - The title of the Release to which the sale is attributed.

Retail Price - The price of the product at the point of sale. This figure will be used to calculate royalties that use the Retail Price basis in your contracts' terms.

Return Gross Amount - The amount refunded by the source for returns. This amount will be deducted from the Gross Amount to adjust the total Gross Amount for the sale. This field accounts for positive or negative values, i.e., positive values will be deducted, and negative values added to the Gross Amount.

Return Net Amount - The amount deducted from your Net Receipts for returns. This amount will be deducted from the Net Amount to adjust the total Net Amount for the sale. This field accounts for positive or negative values i.e., positive values will be deducted, and negative values added to the Net Amount.

Return Units - The number of returns for this sale. This figure will be deducted from the Units to adjust the total Units for the sale. This field accounts for positive or negative values i.e., positive values will be deducted, and negative values added to the Units.

Sale Date* - The date the sale took place. The Sale Date is useful for tracking sales activity.

Sale Price - The price of the sale. This figure will be used to calculate royalties that use the Sale Price basis in your contracts' terms.

Source - The Source of the sale. If you are using Source-specific sales terms in your contracts, this value will be referenced to determine the correct contract term and royalty rate for the sale. In this case, 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 sale occurred.

Track Artist - The Artist associated with the Track the sale is attributed to.

Track Title - The title of the Track the sale is attributed to.

Transaction Date* - The day the payment for the sales in this file were received by your label. The Transaction Date is useful for tracking cash flow for your business.

Units - The number of streams, downloads, or products sold.