Skip to content

Column Definitions: Cargo Distribution

Jump to bottom
richardbirkin edited this page Jun 25, 2023 · 5 revisions

Context

A label user recieves a summary documents and a ZIP file with loads of CSVs in.

  1. AccountName-artists.csv

Product Artist | Currency | Sale Net Receipts | Reported Royalty

  1. AccountName-assets.csv

Asset Title | Asset Version | Asset Artist | Asset ISRC | Asset Duration | Product Title | Product Version | Product Artist | Product UPC | Product Catalog Number | Product Label | Currency | Sale Net Receipts | Reported Royalty

  1. AccountName-countries.csv

Territory | Currency | Sale Net Receipts | Reported Royalty

  1. AccountName-labels.csv

Label Name | Currency | Sale Net Receipts | Reported Royalty

  1. AccountName-products.csv

Product Title | Product Version | Product Artist | Product UPC | Product Catalog Number | Product Label | Currency | Sale Net Receipts | Reported Royalty

  1. AccountName-royalty_extended.csv

Royalty ID | Asset ISRC | Asset Title | Asset Version | Asset Artist | Asset Duration | Sale net receipts calculation | Sale net receipts | Contract deal term | Contract Reference | Reported Royalty | Asset/Product | Territory | Quantity | Sale Type | Sale User Type | Sale Start date | Sale End date | Sale Store Name | DSP | Royalty Calculation Base | Product Reference | Asset Reference | Product Share | Asset Share | Exchange Rate | Currency | Product Title | Product Artist | Product UPC | Product Catalog Number | Product Label | Report Run ID | Report ID | Sale ID | Statement Run ID | Statement Run Name

  1. AccountName-stores.csv

Sale Store Name | DSP | Currency | Sale Net Receipts | Reported Royalty

Conclusion

It looks like royalty_extended.csv (#6) is the Master file with all the data from the other files. TrackShift would make the other files redundant anyway as they are just contextually linked data in a new sheet.

Definitions

(Column A) Royalty ID

Number. Assuming this is the ID from the Cargo system as a whole, as they're not even nearly sequential for a single label.

(B) Asset ISRC

(C) Asset Title

(D) Asset Version

(E) Asset Artist

(F) Asset Duration

(G) Sale net receipts calculation

(H) Sale net receipts

(I) Contract deal term

(J) Contract Reference

(K) Reported Royalty

(L) Asset/Product

(M) Territory

(N) Quantity

(O) Sale Type

(P) Sale User Type

(Q) Sale Start date

(R) Sale End date

(S) Sale Store Name

(T) DSP

(U) Royalty Calculation Base

(V) Product Reference

(W) Asset Reference

(X) Product Share

(Y) Asset Share

(Z) Exchange Rate

(AA) Currency

(AB) Product Title

(AC) Product Artist

(AD) Product UPC

(AE) Product Catalog Number

(AF) Product Label

(AG) Report Run ID

(AH) Report ID

(AI) Sale ID

(AJ) Statement Run ID

(AK) Statement Run Name

Clone this wiki locally