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
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 17 days 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: ()

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

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

Seller Central Console Report: ()

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

Settlement Report
Help
Settlement Report
Help
here
here