-
Notifications
You must be signed in to change notification settings - Fork 0
Column Definitions: Cargo Physical
Cargo are a physical distributor, meaning that they recieve LPs and CDs on a pallette from the pressing plant, and deal with warehousing and transport to get the items into shops (e.g. Rough Trade) and online stores (e.g. Norman Records).
Delivered as an .xlsx file
Naming convention:
LabelID_Year_Period
e.g. 123456_2023_Q1
(A) Period
The accounting period for each usage.
YYYY_Q1
(B) Catalogue No.
Every release has a catalogue number, in a format picked by the label. Usually there are some letters, followed by the number of the release in the label's catalogue, followed by letters to specify format or edition.
e.g.
BIFF001LP - Biff Records release number 1, on vinyl. BIFF001LPX - Biff Records release number 1, special edition vinyl. BIFF001CD - Biff Records release number 1, CD.
(C) Label
The name of the label.
e.g. BIFFRECS
(D) Label ID
A six digit number. The distributor's own ID for the label. The same as in the filename.
e.g. 123456
(E) Sold To
The retail outlet that ordered the records from the distributor.
e.g. Greg's Records & Tapes Bazaar Ltd
(F) Cinram V Sage V Cost
Values relate to the systems that the distributor users.
Known values:
Sage | Cinram | Cinram Storage Costs | Cinram Storage No Move | Cost
(G) Domestic v Export
Whether the record was sold in the territory of the distributor or exported overseas.
(H) Sale / Cost
Whether the value of the usage is an earning or a cost (usually associated with warehousing of physical stock)
(I) Type / Cost Reason
Whether the item was sold to a shop or another distributor = Store / Distributor
Value could also be an explanation of a cost. e.g. Shipping - DPD - 3rd Party
(J) Country
The country that the record was sold to.
e.g. UK | Germany
(K) Artist / Invoice Ref
The artist that made the record.
e.g. CRASH OF RHINOS
I presume that an Invoice Ref value would appear it Column H is a Cost.
(L) Title / More Info
The title of the record.
e.g. DISTAL
I presume that 'More Info' would be any other note relating to a cost.
(M) UPC on report
The Universal Product Code for the item.
(N) Format
The format of the item. A 2 letter code.
e.g. CD | VL
(O) Net Qty
How many of the items were moved from the distributor. Can also be a negative if an item was returned to the distributor from a store.
(P) Gross Value
The amount credited or debited from the account.
Format £12.34 for credit, (£12.34) for debit.
(Q) Cost
I've only seen this with a value when Column F is a Cost
(R) Storage Costs
The amount taken from the account for costs associated with warehousing of physical stock.
e.g. (£12.34)
(S) Distribution Fee
A decimal of the percentage that the label receives.
e.g. 0.8 = 80% of Gross value will be paid to the label.
(T) Net after fee
The amount that the label will receive = Gross value x Distribution Fee