StatementType: state51

[richardbirkin]

Labels receive two .xlsx files via links in an email.

A detailed report, and a summary.

The detailed report is the one we want. It's a big one with lots of columns. The ones useful to us at this time are:

Earnings detail: B C D E F V W AD BR BS BT BU BV

Release/track meta data: G H I J K P Q R

More detail on each of the columns

A Licensor

The name of the copyright holder as listed in label submitted meta data

B Music Service

Where the usage occured

C Start

The start date of the usage. e.g. 01/05/2024

D End

The end date of the usage. e.g. 31/05/2024

E Rep Curr

The original currency that the usage was earned in.

F Conv Rate

The conversion rate used to convert E to the user's currency.

G Artist 1 (Track artist or only given)

H Artist 2 (Album artist or any additional)

I Album Title

J Track Title

K Product Title

L Vol

M Tr #

N Label

O Grid

P UPC

Q Cat No

R ISRC

S DMS id

T Other id

U Source

V Total Units

W S/R

X Trans Time

Y Country of Sale

Z Country of Consump.

AA EU

AB non-EU

AC Product Type

AD Usage Type

e.g. stream

AE Activity Type

AF Mechanicals Included

AG Discount Scheme

AH Trans.Costs %

AI MS %

AJ Label %

AK Sales Tax rate

AL Ret Curr

AM Unit Price

AN Total

AO Tax Unit

AP Tax Total

AQ Unit Net

AR Total Net

AS Mech Base

AT Mech Unit

AU Mech Total

AV Tot Net - Mech

AW Deduct 1

AX Deduct 2

AY Unit Rlty

AZ Share Base

BA MS share

BB Royalty

BC Ex Rate Ret-Rep

BD Unit Price

BE Total

BF Tax Unit

BG Tax Total

BH Unit Net

BI Total Net

BJ Mech Base

BK Mech Unit

BL Mech Total

BM Tot Net - Mech

BN Deduct 1

BO Deduct 2

BP Unit Rlty

BQ Share Base

BR Reporting Currency

BS Royalty

BT Royalty GBP

BU state51 commission

BV To Label

BW Row Audit ID