Column

Table

Data Field

Type

Description

Product SKU

SettlesOrdSKU

ProdSKU

Data

Product SKU

Product Name

Prods

ProdName

Data

Product Name

Settle ID

Settles

SettleID

Data

Settlement ID

Deposit

Settles

DepDate

Data

Deposit Date for the settlement

Date

SettlesOrdSKU

TransDate

Data

Transaction Date

Order ID

SettlesOrdSKU

OrderID

Data

Amazon Order ID

Item ID

SettlesOrdSKU

OrderItemID

Data

Amazon Order Item ID

Qty Sold

SettlesOrdSKU

QtySold

Data

Number of Units Sold

Sales

SettlesOrdSKU

SalesAmt

Data

Product Sales

Taxes

SettlesOrdSKU

SalesTax

Data

Sales Tax

Ship Fee

SettlesOrdSKU

SalesShip

Data

Shipping Fee collected from the Buyer

Other

SettlesOrdSKU

SalesOth

Data

Other Sales Revenue

Revenue

SettlesOrdSKU

SalesRev

Data

Total Sales Revenue

Sales Fees

SettlesOrdSKU

SalesFees

Data

Total Sales Fees

Promo Fees

SettlesOrdSKU

PromoFees

Data

Total Promotion Fees

Ship Fees

SettlesOrdSKU

ShipFees

Data

Total Ship Fees

Oth Fees

SettlesOrdSKU

OthFees

Data

Total Other Fees

Fees

Proprietary Algorithm

Calculated

Total of Fees

Fees %

Proprietary Algorithm

Calculated

Percentage of Fees Paid

Sales Net

SettlesOrdSKU

SalesNet

Data

Net Revenue after Fees are subtracted

GM

Proprietary Algorithm

Calculated

Total Gross Margin (GM)

GM %

Proprietary Algorithm

Calculated

Total Gross Margin Percent (GM %)

Fulfill

SettlesOrdSKU

FulfillType

Data

Fulfillment Channel

Description

Proprietary Algorithm

Calculated

Fulfillment Channel Description

Ship Service

Orders

ShipService

Data

Ship Service

State

Orders

ShipState

Data

Ship State

Country

Orders

ShipCtry

Data

Ship Country

Category

ProdsCat

CatName

Data

Category Name

Brand

ProdsBrnd

BrndName

Data

Brand Name

Supplier SKU

Prods

SuppSKU

Data

Supplier SKU

Supplier

Supps

SuppName

Data

Supplier Name

Market

Proprietary Algorithm

Calculated

Market Name