The Amazon Settlement Transaction Summary by Item report displays all transactions related to orders, refunds, and other transactions as itemized by Amazon in your settlement report. You can review every single line item for all transactions related to settlements via this report.
•The report provides a detailed view of transaction for revenues, fees, and charges from your Amazon Settlements.
•It displays each line item for all transactions related to orders, refunds, and other charges for the date period and options selected.
•Its Designed to provide transparency and detailed insight into your revenues, fees and charges from those Settlements.
•The report is available in both Standard and Enterprise Editions
Click here to view the video for the Transaction Summary by Item report
Column Headings & Field Mappings
Column
|
Table
|
Data Field
|
Type
|
Description
|
Settle ID
|
Settles
|
SettleID
|
Data
|
Settlement ID
|
Deposit
|
Settles
|
DepDate
|
Data
|
Deposit Date
|
Trans Date
|
SettlesOrdDetail/SettlesAdjDetail
|
TransDate
|
Data
|
Transaction Date
|
Order ID
|
SettlesOrdDetail/SettlesAdjDetail
|
OrderID
|
Data
|
Amazon Order ID
|
Item ID
|
SettlesOrdDetail/SettlesAdjDetail
|
OrderItemID
|
Data
|
Amazon Order Item ID
|
Product SKU
|
SettlesOrdDetail/SettlesAdjDetail
|
ProdSKU
|
Data
|
Product SKU
|
Product Name
|
Prods
|
ProdName
|
Data
|
Product Name
|
Trans Type
|
SettlesOrdDetail/SettlesAdjDetail
|
TransType
|
Data
|
Transaction Type
|
Trans Desc
|
SettlesOrdDetail/SettlesAdjDetail
|
TransDesc
|
Data
|
Transaction Description
|
Trans Amt
|
SettlesOrdDetail/SettlesAdjDetail
|
TransAmt
|
Data
|
Transaction Amount
|
Fulfill
|
|
Proprietary Algorithm
|
Calculated
|
Fulfillment Channel
|
Type
|
SettlesOrdDetail/SettlesAdjDetail
|
OrderDetType
|
Data
|
Transaction Type
|
|
Screen Shot
