Magazines & Newspapers report

Provider

CHAR(5)

Up to 5 Characters

The service provider in your reports (typically Apple).

Provider Country

CHAR(2)

Up to 2 Characters

The service provider country code (typically US).

SKU

VARCHAR(100)

Up to 100 Characters

The product identifier provided by you during app setup.

Developer

VARCHAR(4000)

Up to 4000 Characters

Provided by you during the initial account setup.

Title

VARCHAR(600)

Up to 600 Characters

Provided by you during app setup.

Version

VARCHAR(100)

Up to 100 Characters

Provided by you during app setup.

Product Type Identifier

VARCHAR(20)

Up to 20 Characters

Defines the type of transaction (for example, initial download, update, and so on). For more information, visit Product type identifiers.

Units

DECIMAL(18,2)

Up to 18 Characters

The aggregated number of units.

Developer Proceeds (per unit)

DECIMAL(18,2)

Up to 18 Characters

The proceeds for each item delivered.

Customer Currency

CHAR(3)

Up to 3 Characters

Three-character ISO code indicating the customer’s currency. For more information, visit Financial Report Regions and Currencies.

Country Code

CHAR(2)

Up to 2 Characters

Two-character ISO country code indicating the App Store country or region for the purchase. For more information, visit Financial Report Regions and Currencies.

Currency of Proceeds

CHAR(3)

Up to 3 Characters

The currency in which your proceeds are earned. For more information, visit Currency codes.

Apple Identifier

DECIMAL(18,0)

Up to 18 Characters

The Apple ID for your app.

Customer Price

DECIMAL(18,2)

Up to 18 Characters

Retail Price displayed on the App Store and charged to the customer.

Promo Code

VARCHAR(10)

Up to 10 Characters

If the transaction was part of a promotion, this field will contain a value. This field is empty for non-promotional items. For more information, visit Promotional codes.

Parent Identifier

VARCHAR(100)

Up to 100 Characters

In-App Purchases will show the SKU of the associated app.

Subscription

VARCHAR(10)

Up to 10 Characters

Defines whether an auto-renewable subscription is new or a renewal.

Period

VARCHAR(30)

Up to 30 Characters

Defines the duration of an auto-renewable subscription purchase. Values include: 7 days, 1 month, 2 months, 3 months, 6 months, and 1 year.

Download Date (PT)

TIMESTAMP(0)

Date in MM/DD/YYYY

The download date.

Customer Identifier

DECIMAL(18,0)

Up to 18 Characters

The customer identification.

Report Date (Local)

DATE

Date in MM/DD/YYYY

The date of the report. The date and time is always local.

Sales/Return

CHAR(1)

Up to 1 Character

Can be S or R. R is a refund and not a reversal.

Category

VARCHAR(50)

Up to 50 Characters

Indicates the category of the app, such as Games.

CMB

VARCHAR(5)

Up to 5 Characters

Credits for Magazine & Newspaper apps that are part of a “completed” app bundle purchase will show a value of “CMB-C.” Otherwise, this field is blank.

Preserved Pricing

VARCHAR(3)

Up to 3 Characters

For Renew events, if the price is preserved then this field equals “Yes.” Otherwise it is blank.

Proceeds Reason

VARCHAR(20)

Up to 20 Characters

If a subscription has been active for more than a year then you receive 85% of the customer price, minus applicable taxes, and this field equals “Rate After One Year.” Otherwise, you receive 70% and the field is blank.

Client

VARCHAR(30)

Up to 30 Characters

If the subscription was purchased from News then this field equals “News.” Otherwise, it is blank.

Device

VARCHAR(10)

Up to 10 Characters

Type of device used for purchase or redownload: iPhone, iPad, Apple TV, iPod touch, or Desktop.

Supported Platforms

VARCHAR(12)

Up to 12 Characters

List of platforms that your app supports: iOS, tvOS, iOS and tvOS, or macOS.