Finance Reports

Financial Transactions Reports - For Sellers

These Reports for Finances help you obtain financial information relevant to a seller's business. You can obtain financial events for a given order or date range without having to wait until a statement period closes.

Financial Transactions Report

Table name: amazon_source_data.sellercentral_financialtransactions

Seller Central Console Report: Link Download Frequency: Daily

Column Name	Data type	Description
account_name	String	Display Name
account_id	Integer	Intentwise Account ID
seller_id	String	Selling Partner ID
country_code	String	Country Code
transaction_id	String	The unique identifier for the transaction
transaction_type	String	The type of transaction
transaction_status	String	The status for the transaction
marketplace_id	String	Marketplace identifier of transaction
marketplace_name	String	Information about the marketplace where the transaction occurred
account_type	String	Account type of transaction
total_amount	Numeric	Total amount of transaction
currency_code	String	Currency Code
description	String	Describes the reasons for the transaction
posted_date	Date	The date and time when the transaction was posted
report_start_date	Date	Report Start Date
report_end_date	Date	Report End Date
download_date	Date	Download Date

Financial Transactions Item Level Breakdowns Report

Table name: amazon_source_data.sellercentral_financialtransactions_itemlevelbreakdowns Note: This table should be used along with sellercentral_financialtransactions. Use the transaction_id column for the join.

Seller Central Console Report: Link Download Frequency: Daily

Column Name	Data type	Description
account_name	String	Display Name
account_id	Integer	Intentwise Account ID
seller_id	String	Selling Partner ID
country_code	String	Country Code
transaction_id	String	The unique identifier for the transaction
breakdown_type	String	The type of charge
breakdown_amount	Numeric	The amount of the charge
breakdown_id	Integer	Break Down ID
parent_break_down_id	Integer	Parent Break Down ID
currency_code	String	Currency Code
item_id	Integer	Item ID
id	Integer	ID
report_start_date	Date	Report Start Date
report_end_date	Date	Report End Date
download_date	Date	Download Date

Financial Transactions Item Related Identifiers Report

Table name: amazon_source_data.sellercentral_financialtransactions_itemrelatedidentifiers Note: This table should be used along with sellercentral_financialtransactions. Use the transaction_id column for the join.

Seller Central Console Report: Link Download Frequency: Daily

Column Name	Data type	Description
account_name	String	Display Name
account_id	Integer	Intentwise Account ID
seller_id	String	Selling Partner ID
country_code	String	Country Code
currency_code	String	Currency Code
transaction_id	String	The unique identifier for the transaction
item_related_identifier_name	String	Enumerated set of related item identifier names for the item
item_related_identifier_value	String	Corresponding value of ItemRelatedIdentifierName
item_id	Integer	Item ID
id	Integer	ID
report_start_date	Date	Report Start Date
report_end_date	Date	Report End Date
download_date	Date	Download Date

Financial Transactions Items Report

Table name: amazon_source_data.sellercentral_financialtransactions_items Note: This table should be used along with sellercentral_financialtransactions. Use the transaction_id column for the join.

Seller Central Console Report: Link Download Frequency: Daily

Column Name	Data type	Description
account_name	String	Display Name
account_id	Integer	Intentwise Account ID
seller_id	String	Selling Partner ID
country_code	String	Country Code
id	Integer	ID
transaction_id	String	The unique identifier for the transaction
description	String	Describes the reasons for the transaction
total_amount	Numeric	Total Amount
currency_code	String	Currency Code
asin	String	Amazon Standard Identification Number (ASIN) of the item
quantity_shipped	Integer	Quantity of the item shipped
sku	String	Stock keeping unit (SKU) of the item
fulfillment_network	String	Fulfillment network of the item
context_type	String	Context Type
report_start_date	Date	Report Start Date
report_end_date	Date	Report End Date
download_date	Date	Download Date

Financial Transactions Transaction Level Breakdowns Report

Table name: amazon_source_data.sellercentral_financialtransactions_transactionlevelbreakdowns Note: This table should be used along with sellercentral_financialtransactions. Use the transaction_id column for the join.

Seller Central Console Report: Link Download Frequency: Daily

Column Name	Data type	Description
account_name	String	Display Name
account_id	Integer	Intentwise Account ID
seller_id	String	Selling Partner ID
country_code	String	Country Code
transaction_id	String	The unique identifier for the transaction
breakdown_type	String	The type of charge
breakdown_amount	Numeric	The amount of the charge
breakdown_id	Integer	Break Down ID
parent_break_down_id	Integer	Parent Break Down ID
currency_code	String	Currency Code
report_start_date	Date	Report Start Date
report_end_date	Date	Report End Date
download_date	Date	Download Date

Financial Transactions Transaction Related Identifiers Report

Table name: amazon_source_data.sellercentral_financialtransactions_transactionrelatedidentifiers Note: This table should be used along with sellercentral_financialtransactions. Use the transaction_id column for the join.

SSeller Central Console Report: Link Download Frequency: Daily

Column Name	Data type	Description
account_name	String	Display Name
account_id	Integer	Intentwise Account ID
seller_id	String	Selling Partner ID
country_code	String	Country Code
currency_code	String	Currency Code
transaction_id	String	The unique identifier for the transaction
related_identifier_name	String	Enumerated set of related item identifier names for the item
related_identifier_value	String	Corresponding value of RelatedIdentifierName
id	Integer	ID
report_start_date	Date	Report Start Date
report_end_date	Date	Report End Date
download_date	Date	Download Date