The Amazon Settlement Settlements Missing Orders report displays all settlements which do not have a corresponding order in the Order section.
Column Headings & Field Mappings
Column
|
Table
|
Data Field
|
Type
|
Description
|
Settle ID
|
Settles
|
SettleID
|
Data
|
Settlement ID
|
Start
|
Settles
|
StartDate
|
Data
|
Start Date for the settlement period
|
End
|
Settles
|
EndDate
|
|
End Date for the settlement period
|
Deposit
|
Settles
|
DepDate
|
Data
|
Deposit Date for the settlement
|
Date
|
SettlesOrd
|
TransDate
|
Data
|
Transaction Date
|
Order ID
|
SettlesOrd
|
OrderID
|
Data
|
Amazon Order ID
|
Qty Sold
|
SettlesOrd
|
QtySold
|
Data
|
Number of Units Sold
|
Sales
|
SettlesOrd
|
SalesAmt
|
Data
|
Product Sales
|
Taxes
|
SettlesOrd
|
SalesTax
|
Data
|
Sales Tax
|
Ship Fee
|
SettlesOrd
|
SalesShip
|
Data
|
Shipping Fee collected from the Buyer
|
Other
|
SettlesOrd
|
SalesOth
|
Data
|
Other Sales Revenue
|
Revenue
|
SettlesOrd
|
SalesRev
|
Data
|
Total Sales Revenue
|
Sales Fees
|
SettlesOrd
|
SalesFees
|
Data
|
Total Sales Fees
|
Promo Fees
|
SettlesOrd
|
PromoFees
|
Data
|
Total Promotion Fees
|
Ship Fees
|
SettlesOrd
|
ShipFees
|
Data
|
Total Ship Fees
|
Oth Fees
|
SettlesOrd
|
OthFees
|
Data
|
Total Other Fees
|
Fees
|
|
Proprietary Algorithm
|
Calculated
|
Total of Fees
|
Sales Net
|
SettlesOrd
|
SalesNet
|
Data
|
Net Revenue after Fees are subtracted
|
Fulfill
|
|
Proprietary Algorithm
|
Calculated
|
Fulfillment Channel
|
Description
|
SettlesOrd
|
FulfillType
|
Data
|
Fulfillment Type
|
Market
|
Settles
|
MarketID
|
Data
|
Sales Channel
|
|