IAC - Source Data
  • Source Data Models
  • Data Models
    • Amazon Source Data
      • Sponsored Ads
        • Sponsored Products
        • Sponsored Brands
        • Sponsored Display
        • Sponsored Television
      • Amazon Marketing Stream
      • Seller Central
        • Replenishment Reports
        • Business Reports
        • Order Reports
        • Inventory Reports
        • Fulfillment By Amazon
        • Performance Reports
        • Settlement Reports
        • Returns Reports
        • Finance Reports
      • Vendor Central
      • Brand Analytics Reports
      • Content Product Listing
      • Share of Voice
      • Amazon Marketing Cloud
      • Amazon DSP
      • Others
    • Criteo Source Data
      • Sponsored Ads
    • Walmart Source Data
      • Sponsored Ads
      • Marketplace Reports
  • Instacart Source Data
    • Instacart Source Data
  • Tiktok Source Data
    • Sponsored Ads
Powered by GitBook
On this page
  • Settlement reports
  • Flat File Settlement Report
  • Flat File Settlement Report - V2

Was this helpful?

  1. Data Models
  2. Amazon Source Data
  3. Seller Central

Settlement Reports

PreviousPerformance ReportsNextReturns Reports

Last updated 1 month ago

Was this helpful?

Settlement reports

Flat File Settlement Report

Table name: sellercentral_settlement_report

Frequency: The most recent settlement data is downloaded every two days

Seller Central Console Report: Settlement Report (Help)

For details on data availability and refresh schedule, please click .

Column Name
Data type
Description

account_name

String

account_id

Integer

seller_id

String

country_code

String

currency_code

String

deposit_date

Timestamp

transaction_type

String

order_id

String

merchant_order_id

String

adjustment_id

String

shipment_id

String

marketplace_name

String

shipment_fee_type

String

shipment_fee_amount

Numeric

order_fee_type

String

order_fee_amount

Numeric

fulfillment_id

String

posted_date

Timestamp

order_item_code

String

merchant_order_item_id

String

merchant_adjustment_item_id

String

sku

String

quantity_purchased

Integer

price_type

String

price_amount

Numeric

item_related_fee_type

String

item_related_fee_amount

Numeric

misc_fee_amount

Numeric

other_fee_amount

Numeric

other_fee_reason_description

String

promotion_id

String

promotion_type

String

promotion_amount

Numeric

direct_payment_type

String

direct_payment_amount

Numeric

other_amount

Numeric

report_start_date

Date

report_end_date

Date

download_date

Date

Flat File Settlement Report - V2

Table name: sellercentral_settlement_report_v2

Frequency: The most recent settlement data is downloaded every two days

Note: Recommendation is to use V2, If both are enabled only V2 will be made available

Seller Central Console Report: Settlement Report (Help)

Column Name
Data type
Description (Refer help link above)

account_name

String

account_id

Integer

seller_id

String

country_code

String

currency_code

String

settlement_start_date

Timestamp

settlement_end_date

Timestamp

deposit_date

Timestamp

total_amount

String

transaction_type

String

order_id

String

merchant_order_id

String

adjustment_id

String

shipment_id

String

marketplace_name

String

amount_type

String

amount_description

String

amount

Numeric

fulfillment_id

String

posted_date

Date

posted_date_time

Timestamp

order_item_code

String

merchant_order_item_id

String

merchant_adjustment_item_id

String

sku

String

quantity_purchased

Integer

promotion_id

String

report_start_date

Date

report_end_date

Date

download_date

Date

For details on data availability and refresh schedule, please click .

here
here